Question 1 The sustainability manager is concerned about the long term sustainability implications of Deluxe Boxes on the environment and suggests changing to sustainable materials for the production of a Sustainable Deluxe Box. If the company switches the current quantity of Deluxe Boxes sold, to Sustainable Deluxe Boxes, there will be some cost implications. 1)The Sustainable Deluxe Boxes could be made cheaper, and the sustainability manager believes that the company could sell the Sustainable Deluxe Boxes for 523 per box and end up making substantially higher profit than they ever did on the Deluxe Boxes. Based on knowledge of price elasticity of demand s/hefthey suggest that it may in time even result in much higher sales volumes. The marketing manager believes that a lower selling price will also entice current Deluxe Box customers to accept the switch over to the Sustainable Deluxe Box. 2)The new Sustainable Deluxe Boxes will still attract 60% of the fixed costs allocated to the old Deluxe Box under the ABC method used in tab 3. 3)The number of boxes sold will not currently be affected by this new selling price, as this is a very select group of customers for LGI. A)The Standard Box costs and revenue will remain the same as that calculated under the ABC method 5}In order to help overall profit, the variable costs per sustainable Deluxe box will be reduced to 511 per box vice the original $20 per box. Required (complete the grey spaces) 1)Determine the profit and profit percentage for the Standard and Sustainable Deluxe Boxes Standard Boxes Sustainable Deluxe Boxes Total Quantity 108.00 18.00 126.00 Selling price per unit S 18.80 | 5 23.00 | 5 41.80 Revenue S 2,030.40 | 414.00 | 2,444.40 Subtract: Variable Costs 3 1,080.00 | 5 198.00 | 1,279.00 Equals: Contribution Margin S 950.40 | 316.00 | & 1,166.40 Subtract: Fixed Costs 5 16.84 | 5 B83.50 | 5 100.34 Equals: Operating Profit S 933.56 | 5 132.50 | 1,066.06 Operating Profit % (based on revenue) 45.98% 32.01% 43.61% Contribution Margin % 46.81% 52.17% 47.71% Question 2 The CEO is not convinced and still thinks that no form of a Deluxe Box, sustainable or not should be produced. The CEO indicates that consideration of the production of a Sustainable Deluxe Boxes will only be considered if it can achieve at least the same operating profit percentage for the Sustainable Deluxe Boxes as the operating profit percentage indicated under the ABC costing method for Standard Boxes (See Tab 3) . Required (Complete the grey spaces). Using Operating Profit % Using Gross Profit % Required profit 45.98% 46.81%|See Question 1 Subtract: Existing profit 32.01% 52.17%|See Q 1 above Equals: Difference in additional profit reguired 13.97% -5.36% Question 3 Required: Work out the percentage that the company should mark up on the costs of Sustainable Deluxe Boxes to achieve the same profit % as for the Standard boxes. (Complete the grey spaces Using Operating Profit % Using Gross Profit % Revenue % 100.00% 100.00% Subtract: Required Operating Profit 45.98% 16.81% Equals: Cost % 54.02% 53.19% Question 4 Assume the company can still sell the same quantity of the Sustainable Deluxe Boxes as for the Deluxe Boxes Required (Complete the grey spaces) Use the percentage calculated in Question 3 to determine at which price the company should sell the Sustainable Deluxe Boxes to reach the same profit percentage as for the Standard Boxes. Question 4 Assume the company can still sell the same quantity of the Sustainable Deluxe Boxes as for the Deluxe Boxes Required (Complete the grey spaces) Use the percentage calculated in Question 3 to determine at which price the company should sell the Sustainable Deluxe Boxes to reach the same profit percentage as for the Standard Boxes. Using Contribution Margin % Total () Total (8) Variable Costs 5 198.00 | Slove this Plus : Fixed Costs S 83.50 | Slove this Equals: Total Costs S 281.50 | Slove this Determine Revenue 5 521.09 | Slove this Units sold (per year) S 18.00 | slove this Sales Price per unit 5 28.95 | slove this Question 5 Required: Prove that your calculation in Q 4 is correct. Complete the grey boxes. Using Contribution Margin % Proof: Total (5) Total (8) Revenue 5 521.09 | slove this Subtract: Variable Costs S 198.00 | slove this Equals: Contribution Margin S 323.09 | slove this Subtract: Fixed Costs S 83.50 | slove this Operating Profit S 239.59 | slove this Operating Profit % 45.98%| slove this