Question: !please solve these using excel formulas! Question Set 3. A bakery has a production target of 1000 units of donuts, bread and muffins each in

!please solve these using excel formulas!

Question Set 3. A bakery has a production target of 1000 units of donuts, bread and muffins each in a month. The baker spent $7,800 on setting up the bakery, which could be accounted as the fixed cost. The production cost and selling price for the items is listed in the table below. For this question set, use the following formulas and information:

[Total Cost] = [Production] x [Variable Unit Cost] + [Fixed Costs]

[Total Revenue] = [Production] x [Unit Revenue]

[Total Profit] = [Total Revenue] [Total Cost]

[Break Even Point] = [Fixed Cost] / ([Unit Revenue]-[Unit Variable Cost])

Item

Unit Cost

Unit Revenue

Donut

1.3

2.35

Bread

2.4

2.7

Muffin

2.1

3.35

1. Calculate Total profit for the bakery in a month, given they bake 1000 units each of all 3 products

2. Create a data table (as demonstrated during lab exercise 2), to show the change in Total profit corresponding to change in Production from 2000 to 3500 units with increments of 100. You must use a data table structure to receive credit for this problem.

3. Create a scatter chart that displays the variable total profit (and no other variables) as a function of Production. At low production quantities, total profit may be negative but should still be displayed. Label your chart axes appropriately.

4. What is the break-even point? (The Production for which the Total profit is zero)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!