Sir, I would appreciate if you could do it in Excel. Thank you.

Question 8 (20 marks] Cinderella Incorporated is currently producing three lines of dresses. The data on each dress is as follows: -LE M ORANGE Selling price {(1% g $12 Variable expenses Direct materials 24 15 .. 9 Labour and overhead 25L a E . 4_2_ Contribution margin gag & :2; Contribution margin ratio 23 & _Q/g The same material is used in each dress. The material costs are $3 per yard, with a maximum of 5000 yards available each month. Demand for the dresses is very strong with demands for 300 Blue: 1000 Pink and 500 Orange. I Required: A) Can we meet the current demand of all dresses? 8) In which order would you accept orders and at what amounts? C) How much would you be willing to pay for extra yardage in order to complete demand 100%? D) Give two other alternatives for the company to meet demand