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/he/they 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. 4)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 $11 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 Quantity i 18.00 Selling price per unit Revenue Subtract: Variable Costs Equals: Contribution Margi Subtract: Fixed Costs Equals: Operating Profit Operating Profit % (based on revenue) Contribution Margin % 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% 46.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. Using Contribution Margin % Total (5) Total (3) Variable Costs S 198.00 Plus : Fixed Costs 5 83.50 Equals: Total Costs 3 281.50 Determine Revenue S 521.09 Units sold (per year) s 18.00 Sales Price per unit 5 28.95 Question 5 Required: Prove that your calculation in Q 4 is correct. Complete the grey boxes. | Using Contribution Margin % Proof: Total (5) Total (5) Revenue 3 521.09 Subtract: Variable Costs S 198.00 Equals: Contribution Margin S 323.09 Subtract: Fixed Costs 5 83.50 Operating Profit 5 239.59 Operating Profit % 45.98% 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). 1) How much additional operating profit (in percentage) will be required from the Sustainable Deluxe Boxes to meet the same percentage as the Standard Boxe: are generating, given the percentage that can currently be achieved on Sustainable Deluxe Boxes Required profit 45.98% 46.81%|See Question 1 Subtract: Existing profit 32.01% 52.17%|5ee Q 1abaove Equals: Difference in additional profit required 13.97% -5.36%