100%(6)6 out of 6 people found this document helpful
This preview shows page 1 - 2 out of 2 pages.
you plan to make 1000 Muffins and cups of coffee regardless of demand. For every excess Muffin made, MTG is able to resale the Muffins and coffee for $1/Muffin and Coffee. You Predict that the loss of Sale for a Muffin and Coffee is $3.50MonthDemandMonthDemandJanuary700July1300Febuary1200August800March500September1050April1150October950May1000November1200June950December11509.What is the profit for each month with the varying demand?
10.How many months are predicted to yield a positive profit? Only 1 month is predicted to yield positive profit.Loadyour finished Excel sheet with both graphs to icollege in the assignment folder for Exercise 2.