With your personal finances taken care of, you feel prepared to open your flower shop. You secure a small business loan for $60,000. You want to spend $30,000 of that loan renovating the space for your shop and $15,000 on equipment needed to store the flowers and create arrangements. Rent will be $700 per month or $4,200 for the first six months the shop is open and utilities will be approximately $76 per month or $456 for the first six months. You also want to spend $2,000 on flowers and supplies to stock the shop for the first month and $600 per month for the next five months to restock flowers and greenery. a) Create a budget for the shop’s opening with this information.

b) Looking at these numbers in the spreadsheet starts to get a little overwhelming. You want to be able to look quickly at a chart and have a good idea of how much of your loan will be used in the first month of opening the business. What type of graph or chart would work best for this?

c) Create the graph or chart that will best show how you spent your loan in the first month of opening the business.