Question Set $3.$ A bakery has a production target of $1000$ units of pancakes, waffles and cakes

each in a month. The owners spent $$10,200$ 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$])$

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

products $(3$pts$)$

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 $3700$ units with increments of

You must use a data table structure to receive credit for this problem. $(6$pts$)$

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. $(3$pts$)$

What is the break$-$even point? $($The Production for which the Total profit is zero$)(2$ pts $)$