Question: Please answer both questions because I posted them separately and no body answered. thanks Question 5 (1 point) The following is a deterministic model for


Please answer both questions because I posted them separately and no body answered. thanks
Question 5 (1 point) The following is a deterministic model for Leah's calendar profit projections. Implement this deterministic model as a basis for a Monte Carlo Simulation. What is the profit that you would realize for a Oder Quantity of 637.0 and a Quantity Demanded of 615.0? (Input your answer in dollars and cents.) Annual Calendar Sales $ 5.95 Cost per Calendar Retail Price per Calendar $ Refund per Calendar $ 14.95 1.95 680 Order Quantity Quantity Demanded 600 Leftovers 80=IF(Order Quantity> Quantity De Revenue $ Sales Refund Total Revenue $ $ 8,970.00 =MIN(Order Quantity, Quantity D 156.00 =Leftovers * Refund per Calenda 9,126.00 = Sales + Refund $ Total Cost Profit 4,046.00 =Order Quantity * Cost per Caler 5,080.00 = Total Revenue - Profit $ Your Answer: Question 6 (1 point) Test, once again, this deterministic model for the situation where quantity demanded is more than quantity ordered. What is the profit that you would realize for a Order Quantity of 634.0 and a Quantity Demanded of 667.0? Annual Calendar Sales 5.95 Cost per Calendar $ Retail Price per Calendar $ Refund per Calendar $ 14.95 1.95 680 Order Quantity Quantity Demanded 600 Leftovers 80=IF(Order Quantity> Quantity De Revenue $ Sales Refund Total Revenue $ 8,970.00 =MIN(Order Quantity, Quantity D 156.00 =Leftovers * Refund per Calenda 9,126.00 = Sales + Refund $ $ Total Cost Profit 4,046.00 =Order Quantity * Cost per Caler 5,080.00 = Total Revenue - Profit $ YourStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
