Ch. 12 HW Using the spreadsheet above, write the Excel equation that is simulating demand in cell C12. The equation must reference cell locations and it may, or may not, need dollar signs. Using the spreadsheet above, write the Excel equation that is simulating unit variable costs in cell B12. The equation must reference cell locations and it may, or may not, need dollar signs, TEHTI Using the spreadsheet above, write the Excel equation that is simulating tire mileage in cell B9. The equation must reference cell locations and it may, or may not need dollar signs. Ch. 12 HW Using the spreadsheet above, write the Excel equation that is simulating demand in cell C12. The equation must reference cell locations and it may, or may not, need dollar signs. Using the spreadsheet above, write the Excel equation that is simulating unit variable costs in cell B12. The equation must reference cell locations and it may, or may not need dollar signs. PERE Using the spreadsheet above, write the Excel equation that is simulating tire mileage in cell B9. The equation must reference cell locations and it may, or may not, need dollar signs. IH Insert Page Layout Formula Data Review View Home H528 1 Madeira Manufacturing Company 3 Unit Selling Price 4 Fixed Cost $50 $30,000 6 Variable Cost (Uniform Distribution) 7 Smallest Value 8 Largest Value $16 Demand (Normal Distribution) Mean 1,200 Standard Deviation 3001 $24 10 Simulation Trial Unit Variable Cost $20.82 $21.60 $23.32 $23.95 Demand 1,130 1,006 1,754 1,704 Profit $2,984.92 -$1,429.17 $16,802.47 $14,382.10 Summary Statistics Mean Profit Standard Deviation Minimum Profit Maximum Profit Number of Losses Probability of Loss $6,472 $9,443 -$20,854 $35,850 133 518 519 520 0.266) Ready IHNE Home H528 Insert Page Layout Formulas Data Review View 1 Madeira Manufacturing Company 3 Unit Selling Price 4 Fixed Cost $50 $30,000 6 Variable Cost (Uniform Distribution) 7 Smallest Value 8 Largest Value $16 $24 Demand (Normal Distribution) Mean 1,2001 Standard Deviation 300 10 Simulation Trial 13 Unit Variable Cost $20.82 $21.60 $23.32 $23.95 Demand 1,130 1,006 1,754 1,704 Profit $2,984.92 -$1,429.17 $16,802.47 $14,382.10 Summary Statistics Mean Profit Standard Deviation Minimum Profit Maximum Profit Number of Losses Probability of Loss $6,472 $9,443 -$20,854 $35,850 133 518 519 520 0.266 4. She Sheet het 145