Use an excel data table to answer the questions.

A Bakery sells cupcakes and donuts. They have provided you the following information.

-Their monthly rent is $8,000.

-They spend $450 a month for advertising.

-They employee 2 employees that work a total of 100 hours a month at a rate of $15 per hour.

-They sell 2,500 cupcakes per month. The price to produce the cupcakes is $.75 each. Their current selling price is $2.50 each.

-They sell 3,000 donuts a month. The production cost of the donut is $.35 each. The current selling price is $1.50 per donut.

-They are currently not making a profit. The target profit is $2000 per month.

-The bakery has the capacity to produce 3,000 cupcakes per month and 4,000 donuts per month. They also believe that the maximum that they can charge for a cupcake is $3.50 and the most they can sell a donut for is $2.50. They also expect that their unit production costs will remain the same.

You build formulas to identify the total costs, total revenue, and profit.

You decide to build a data table to review the potential profit at various selling prices of the cupcakes and donuts. You want to examine the selling price of the cupcakes starting at $2.00 with increments of $.25 up to $4.00. Also, you want to examine the selling price the donuts starting at $1.00 with increments of $.25 up to $3.00.

Please show how to do this with a data table in Excel!

1. What are the sales prices for cupcakes and donuts that will allow them to break even?
2. What will the bakery need to charge for the cupcakes and donuts to make the target profit?
3. If they continue to charge the current price for cupcakes, how much will they need to sell their donuts to make a profit?
4. If they continue to charge the current price for donuts, how much will they need to sell their cupcakes to make a profit?
5. What would their profit be if they can sell their cupcakes and donuts at the maximum price that they believe that they can sell their products?