Part 2: In this part, production of muffins doesnt necessarily match the demand.

If more muffins are produced than demanded, excess or leftover will occur. If less muffins are produced than demanded, loss of sale will occur. For every leftover Muffin, MTG is able to resale the Muffins for $1 each. For each unit of unmet demand, you estimated a loss of sale cost of $2 each.

The demand for the next 12 weeks are estimated below. Modify your worksheet to include the possible resale revenue and loss of sales cost. Use the spreadsheet to answer the following questions.

Week	Predicted Demand
1	700
2	1200
3	500
4	1150
5	1000
6	950
7	1300
8	800
9	1050
10	950
11	1200
12	1150

1. If they produce 1,000 units per week, what is the average weekly profit? How many weeks did they have loss of sales?

2. If they produce 900 units per week, what is the average weekly profit? How many weeks did they have loss of sales?

3. What if they produce 1,100 units per week? What is the average weekly profit? How many weeks did they have loss of sales?

4. Out of the three production quantities, 900, 1,000, and 1,100, which one is the best and why?

No 2 Inse Delete Tomat 0 $3.5 4 Price per unit 5 VC per unit 6 TFC lettver Supply(howi uch you piodued Quanlily Sold Lost of Sales D Quantity Sold Resale Loss of Sales per un $2,030.0 $1.00 $2.00 10 Production 1100 12 Profit Calculation Loss of Sales Cost EstimatedSales Loss of 13 Weeks DemandQaiy eoer Salesev Sales Rev Resale Total Rev TVc TFC TC Profit 700 1200 500 1150 1000 950 1300 800 1050 950 1200 1150 700 1100 500 1100 1000 950 1100 800 1050 950 1100 1100 0 $2,450.00 $400.00 $2,850.00 $825,00 $2,030.00 $0.00 $2,855,00 -$5.00 100 $3,850.00 $100.00 $3,750.00 $825,00 $2,030.00 $200.00 $3,055,00$695.00 0 $1,750.00 $600,00 $2,350.00 $825,00 $2,030.00 $0.00 $2,855.00 -$505.00 50 $3,850.00 $50.00 $3,800.00 $825.00 $2,030.00 $100.00 $2,955.00$845.00 0 $3,500.00 $100.00 $3,600.00 $825.00 $2,030.00 $0.00 $2,855.00 $745.00 03,325.00 $150.00 $3,475.00 $825.00 $2,030.00$0.00 $2,855.00 $620.00 200 $3,850.00 $200.00 $3,650.00 $825.00 $2,030.00 $400.00 $3,255.00$395.00 0 $2,800.00 $300.00 $3,100.00 $825.00 $2,030.00 $0.00 $2,855.00 $245.00 0 $3,675.00 $50.00 $3,725.00 $825.00 $2,030.00$0.00 $2,855.00 $870.00 0 $3,325.00 $150.00 $3,A75.00 $825.00 $2,030.00$0.00 $2,855.00 $620.00 100 $3,850.00 $100.00 $3,750.00 $825.002,030.00$200.00 $3,055.00 $695.00 50 $3,850.00 .0 $3,800.00 $825.00 $2,030.0000.0 $2,955.00 $845.00 400 -100 600 15 100 150 200 300 21 150 24 25 100 12 No 2 Inse Delete Tomat 0 $3.5 4 Price per unit 5 VC per unit 6 TFC lettver Supply(howi uch you piodued Quanlily Sold Lost of Sales D Quantity Sold Resale Loss of Sales per un $2,030.0 $1.00 $2.00 10 Production 1100 12 Profit Calculation Loss of Sales Cost EstimatedSales Loss of 13 Weeks DemandQaiy eoer Salesev Sales Rev Resale Total Rev TVc TFC TC Profit 700 1200 500 1150 1000 950 1300 800 1050 950 1200 1150 700 1100 500 1100 1000 950 1100 800 1050 950 1100 1100 0 $2,450.00 $400.00 $2,850.00 $825,00 $2,030.00 $0.00 $2,855,00 -$5.00 100 $3,850.00 $100.00 $3,750.00 $825,00 $2,030.00 $200.00 $3,055,00$695.00 0 $1,750.00 $600,00 $2,350.00 $825,00 $2,030.00 $0.00 $2,855.00 -$505.00 50 $3,850.00 $50.00 $3,800.00 $825.00 $2,030.00 $100.00 $2,955.00$845.00 0 $3,500.00 $100.00 $3,600.00 $825.00 $2,030.00 $0.00 $2,855.00 $745.00 03,325.00 $150.00 $3,475.00 $825.00 $2,030.00$0.00 $2,855.00 $620.00 200 $3,850.00 $200.00 $3,650.00 $825.00 $2,030.00 $400.00 $3,255.00$395.00 0 $2,800.00 $300.00 $3,100.00 $825.00 $2,030.00 $0.00 $2,855.00 $245.00 0 $3,675.00 $50.00 $3,725.00 $825.00 $2,030.00$0.00 $2,855.00 $870.00 0 $3,325.00 $150.00 $3,A75.00 $825.00 $2,030.00$0.00 $2,855.00 $620.00 100 $3,850.00 $100.00 $3,750.00 $825.002,030.00$200.00 $3,055.00 $695.00 50 $3,850.00 .0 $3,800.00 $825.00 $2,030.0000.0 $2,955.00 $845.00 400 -100 600 15 100 150 200 300 21 150 24 25 100 12