The marketing manager suggested that to improve EBITDA and increase sales volume, the Sustainable Deluxe Box should
Question:
The marketing manager suggested that to improve EBITDA and increase sales volume, the Sustainable Deluxe Box should be sold at the same margin as the Standard Box. Base your answers on the calculations performed in Sheet 4 ( tab 4) to indicate how much Largo will need to charge for the Sustainable Deluxe Box. Indicate how many Sustainable Deluxe Boxes the company will have to sell at the new price to break even. Discuss whether changing the price is a viable option for Largo. Provide evidence from the Excel workbook, Tab 4.
2. If Largo Global Inc. is unable to sell the Sustainable Deluxe Box for more than $27.10, discuss possible alternatives. Doing the same thing LGI is already doing is not an option; you must suggest how to improve EBITDA.
Discuss the facts that should be considered in determining whether manufacturing the Boxes in-house could lead to a price reduction. No calculations are required for Question 5
Question 1 The sustainability manager is concerned about the long term sustainability implications of Deluxe boxes on the environment and suggest changing to sustainable materials for the production of a Sustainable Deluxe Box. If the company switches to their current quantity of Deluxe Boxes sold to Sustainable Deluxe Boxes there will be some cost implications. The Sustainable Deluxe Boxes could be made cheaper, and the sustianability manager believes that the company could bring down the selling price to $15 per box which would entice current Deluxe Box customers to accept the switch over. The new Sustainable Deluxe Boxes will attract 60% of total fixed costs calculated for the Deluxe Boxes under the ABC method. The number of boxes sold will not be affected by this new selling price, as the company will in future have to do marketing to sell more boxes at the lower price. Calculate the new Gross profit and profit percentage. Complete the grey spaces Quantity Sellin price per unit Sales VC Contribution Fixed Costs Profit GP % Question 2 Required profit Less: Existing profit Equals: Difference in additional profit required Sales Less Required GP% Equals: Mark up percentage on cost Variable Costs Fixed Cost Total Costs Sales Units sold Sales Price per unit Standard Boxes Sustainable Deluxe 108.00 Fixed Costs Net Profit Profit % $ $ S Selling price Less: Variable costs Contribution S Fixed Costs S S Breakeven Quantity BreakEven Value The manager is concerned about the massive reduction in profit from the Sustainable Deluxe Boxes but realizes that because of the change in materials, they will no longer be able to charge the price of $18 per box. The manager wants to achieve at least the same profit percentage for the deluxe boxes as they have on standard boxes. How much additional profit are they requiring? Complete the grey spaces. $ Question 3 Work out the percentage that they should mark up on the costs to achieve the same profit % as for the standard boxes. Complete the grey spaces S $ $ S 18.80 $ 2,030.40 1,080.00 950.40 Question 4 Use the percentage calculated in Question 3 to determine how much the company should charge per product to reach the same profit percentage as for the standard boxes. Assume the company can still sell the same quantity of the Sustainable Deluxe Boxes as for the Deluxe Boxes. Complete the grey spaces Totals $ 16.84 S 933.56 45.98% $ S S S 45.98% See Tab 3 2.41% See Q 1 above 43.57% S Question 5 Prove that your calculation in Q4 is correct. Complete the grey boxes. Proof: Per Unit Total $ Sales Less VC S Contribution $ %6 100% 45.98% 54.02% 180.00 83.50 263.50 487.77 18 27.10 18.00 15.00 270.00 $ 180.00 90.00 $ 83.50 $ 6.50 $ 487.77 S 180.00 307.77 83.50 224.27 45.98% 2.41% Question 5 The marketing manger is concerned that the change could havea significant impact on sales as ciustomers may see the sustaiable boxes as an inferiror product for which they still have to pay only a little bit less than the orginal price of the Deluxe Boxes. How many boxes would the company have to sell to break even on the new Sustainabale Deluxe Boxes based on the new selling price? Complete the grey boxes. $ Totals 27.10 10.00 17.10 100.34 Total 5.87 159.02 126.00 2,300.40 1,260.00 1,040.40 27.10 10 17.10 100.34 940.06 40.87% Question 1 The sustainability manager is concerned about the long term sustainability implications of Deluxe boxes on the environment and suggest changing to sustainable materials for the production of a Sustainable Deluxe Box. If the company switches to their current quantity of Deluxe Boxes sold to Sustainable Deluxe Boxes there will be some cost implications. The Sustainable Deluxe Boxes could be made cheaper, and the sustianability manager believes that the company could bring down the selling price to $15 per box which would entice current Deluxe Box customers to accept the switch over. The new Sustainable Deluxe Boxes will attract 60% of total fixed costs calculated for the Deluxe Boxes under the ABC method. The number of boxes sold will not be affected by this new selling price, as the company will in future have to do marketing to sell more boxes at the lower price. Calculate the new Gross profit and profit percentage. Complete the grey spaces Quantity Sellin price per unit Sales VC Contribution Fixed Costs Profit GP % Question 2 Required profit Less: Existing profit Equals: Difference in additional profit required Sales Less Required GP% Equals: Mark up percentage on cost Variable Costs Fixed Cost Total Costs Sales Units sold Sales Price per unit Standard Boxes Sustainable Deluxe 108.00 Fixed Costs Net Profit Profit % $ $ S Selling price Less: Variable costs Contribution S Fixed Costs S S Breakeven Quantity BreakEven Value The manager is concerned about the massive reduction in profit from the Sustainable Deluxe Boxes but realizes that because of the change in materials, they will no longer be able to charge the price of $18 per box. The manager wants to achieve at least the same profit percentage for the deluxe boxes as they have on standard boxes. How much additional profit are they requiring? Complete the grey spaces. $ Question 3 Work out the percentage that they should mark up on the costs to achieve the same profit % as for the standard boxes. Complete the grey spaces S $ $ S 18.80 $ 2,030.40 1,080.00 950.40 Question 4 Use the percentage calculated in Question 3 to determine how much the company should charge per product to reach the same profit percentage as for the standard boxes. Assume the company can still sell the same quantity of the Sustainable Deluxe Boxes as for the Deluxe Boxes. Complete the grey spaces Totals $ 16.84 S 933.56 45.98% $ S S S 45.98% See Tab 3 2.41% See Q 1 above 43.57% S Question 5 Prove that your calculation in Q4 is correct. Complete the grey boxes. Proof: Per Unit Total $ Sales Less VC S Contribution $ %6 100% 45.98% 54.02% 180.00 83.50 263.50 487.77 18 27.10 18.00 15.00 270.00 $ 180.00 90.00 $ 83.50 $ 6.50 $ 487.77 S 180.00 307.77 83.50 224.27 45.98% 2.41% Question 5 The marketing manger is concerned that the change could havea significant impact on sales as ciustomers may see the sustaiable boxes as an inferiror product for which they still have to pay only a little bit less than the orginal price of the Deluxe Boxes. How many boxes would the company have to sell to break even on the new Sustainabale Deluxe Boxes based on the new selling price? Complete the grey boxes. $ Totals 27.10 10.00 17.10 100.34 Total 5.87 159.02 126.00 2,300.40 1,260.00 1,040.40 27.10 10 17.10 100.34 940.06 40.87%
Expert Answer:
Question 1 The suggestion to align the pricing of the Sustainable Deluxe Box with the Standard Box based on calculations in Tab 4 indicates that Largo would need to set the price for the Sustainable D... View the full answer
Management Accounting
ISBN: 9780730369387
4th Edition
Authors: Leslie G. Eldenburg, Albie Brooks, Judy Oliver, Gillian Vesty, Rodney Dormer, Vijaya Murthy, Nick Pawsey
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
State the SQL code for the following statements 1. Retrieve the salary of every employee 2. Retrieve the total number of employees in the company. 3. Retrieve the total number of employees in the...
-
Red Zeppelin Corporation follows a strict residual dividend policy. Its debt-equity ratio is 2.5. a. If earnings for the year are $190,000, what is the maximum amount of capital spending possible...
-
Historically, which types of investments have had the highest average returns and which have been the most volatile from year to year?
-
Write advantages and disadvantages of Vapor Compression Cycle over Air Refrigeration Cycle.
-
Calculate the utility levels of each portfolio of Problem 10 for an investor with A= 2. What do you conclude? Consider historical data showing that the average annual rate of return on the S&P 500...
-
Study Problem 9-8 (algo) Table A below shows abbreviated balance sheets for the central bank in the country of Beckland and B shows tables for its whole" commercial banking system. The target reserve...
-
Figure 2 shows the support structure for a suspended apparatus in a laboratory. The apparatus is hung from the 1/4" A36 plate that is welded to the 3/8" plate using E70XX electrodes. Assuming that...
-
Susan's 5-year-old Hyundai Santa Fe requires repairs estimated at $3,000 to make it roadworthy again. Her friend, Julie, suggested that she should buy a 5-year-old used Toyota Rav4 instead for $3,000...
-
Using the Moderna 2022 annual report Moderna-2022-Annual-ReportvF.pdf (q4cdn.com)Are, big data being used in the above industry? A) How is big data used in clinical trials, vaccine development,...
-
A. Compare your data run results for Genetic Drift in Procedure II part B to the results of the class as a whole. What population changes are possible? B. Are there any cases of extreme changes in...
-
Based on the IHRM analysis, the following recommendations are made to improve the effectiveness of Pfizer's performance management practices in the global context ( explain 1-5 in detail ) : 1....
-
1. Explain some key features and process of ER/IR in Germany and in Japan 2. what are the roles of trade unions in Germany and Japan respectively 3. what are some of the roles of state in Germany and...
-
How can technology, particularly AI bs integrated into parts of Workplace Health and Safety Management System (WHSMS) in its different phases to achieve "safety culture"? construction industry and...
-
LL Flaunteroy was recently hired by Premier Asphalt as a controller. He was formerly employed by Top Notch CPA LLC. Top Notch performs an annual audit to ensure Premier is playing by the rules and...
-
Annual dividends of ATTA Corp grew from $0.96 in 2005 to $1.76 in 2017. What was the annual growth rate?
-
Why do the accounting standards require absorption costing for financial reporting?
-
Refer to the information in exercise 16.23. The following cost reduction suggestions were made by the kaizen costing team. Direct materials suppliers agreed to cost reductions of $4.50 for direct...
-
Energy plays an important role in improving peoples lifestyles. In Australia, our energy consumption is growing and is forecasted to increase by 50 per cent over the next 15 years. The available...
-
Sheds Ahead Ltd produces outdoor sheds for domestic use. The manager in charge of production has been asked to prepare a production budget, a direct materials budget and a direct labour budget for...
-
Gasmania Pty Ltd produces patio heaters for household use. The following information has been gathered so that a production budget, a direct materials budget and a direct labour budget for part of...
-
Sami Stitches Ltd produces two types of sewing machines, a standard model and a deluxe model. The budgeted factory overhead costs for the production operation during 2020 are as follows. Production...
Study smarter with the SolutionInn App