Question: 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

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 552.0 and a Quantity Demanded of 694.0?

Annual Calendar Sales
Cost per Calendar $ 5.95
Retail Price per Calendar $ 14.95
Refund per Calendar $ 1.95
Order Quantity 680
Quantity Demanded 600
Leftovers 80 '=IF(Order Quantity> Quantity Demanded,Order Quantity - Quantity Demanded,0)
Revenue
Sales $ 8,970.00 '=MIN(Order Quantity, Quantity Demanded)*Retail Price per Unit
Refund $ 156.00 '=Leftovers * Refund per Calendar
Total Revenue $ 9,126.00 '= Sales + Refund
Total Cost $ 4,046.00 '=Order Quantity * Cost per Calendar
Profit $ 5,080.00 '= Total Revenue - Total Cost

Your Answer:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!