As the Management Accounting representative you have provided the Strategic Management Committee with the following breakdown of revenues and costs for the Star Wars Toothbrush product line for the just completed 2017 calendar year:
The Return on Total Assets (ROTA) for the Star Wars Electronic Toothbrush for the 2017 year was 17.25%. This is below the required ROTA of the Empire Group of 20%. If the product continues to trade at current levels it will be deemed as unviable and discontinued.The Australasian Marketing Division of the Empire Group believes that Research and Development advances from within the world-wide Empire Group could improve sales of the Star Wars toothbrush product and its profitability outlook. Developments in digital electronics means that the company will have the capacity to include a feature where the character-based Star Wars toothbrush will be able to digitally record a name and then include it in a replayed sound bite every time the toothbrush is activated. It is planned that the toothbrush will play an adaption of a famous Star Wars catch-phrase from each character, Rey, Kylo Ren, and Darth Vader. For example, the Darth Vader version will broadcast “Luke, I am your toothbrush” every time it starts up. Purchasers will have the option of recording a different name to replace Luke with their own name if they wish. Initial engineering indicates that by making savings in packaging and other materials the underlying prime, manufacturing and logistic costs of the toothbrush will not change from its current $12.75 per unit.The Marketing Division have carried out some initial market research and believe that this added feature will make a big difference to consumers and will potentially increase unit sales by 30% in the first year. To achieve this sales increase Marketing advises that it is imperative that the product improvement is advertised effectively and have suggested that a marketing rebate of $0.80 per unit be paid to retailers which they must spend on direct promotion of the improved product.The Chair of the Strategic Management Committee has reviewed the marketing proposal and advised that even after allowing for the 30% sales increase, the increase in costs represented by the extra $0.80 in marketing rebates means that the products ROTA will fall to below 15% and will be well below the Empire Group required ROTA of 20%. The CEO argues that if this occurs the previously successful Star Wars Electronic Toothbrush product line may have to be discontinued.You are aware that following the recent drop in sales the Star Wars Electronic Toothbrush factory is operating at only 40% of its practical manufacturing capacity. You are also aware that whilst the Electronic Toothbrush product’s Prime Costs are 100% Variable, other Manufacturing Costs and Logistic Costs are made up of 90% Fixed costs and 10% Variable costs.You ask if you can be given time to prepare a report for the Strategic Management Committee on the Management Accounting cost and profit implications of the changes proposed by Marketing and R&D based on the budgeted costs and increases in both sales and production.Required:(i)Using Excel prepare a ‘before and after’ budget comparative analysis of the revenues and costs of the Empire Group’s Star Wars Electronic Toothbrush product line. The analysis should incorporate the 30% predicted sales increase and the added $0.80 per unit Marketing Rebate. Ensure you include in your analysis any impact of the budgeted production increase on other per unit manufacturing and logistics costs.(10 marks)(ii)Allowing for the change in sales volumes use Excel to calculate the expected impact of the drop in sales on the per unit product costs on our competitor Death Star Manufacturing.It can be assumed that the 90% Fixed to 10% Variable manufacturing and logistic cost break-down will hold consistently across the industry (including for competitor Death Star Manufacturing). Assume that 75% of the predicted unit sales increase of the Star Wars Electronic Toothbrush will be made at the expense of the unit sales of their main competitor Death Star Manufacturing (meaning Death Star Manufacturing unit sales will fall by 75% of the Star Wars Electronic Toothbrush sales increase). Assume that the Empire Group and Death Star Manufacturing have identical manufacturing and logistics cost structures at the commencement of the 2018 calendar year.(5 marks)(iii)Prepare a brief report (maximum 300 words) for the Strategic Management Committee outlining the key points of your findings. Include some discussion on:a.the likely impact of the changes on the cost and profit structure of Star Wars Electronic Toothbrush (derived from your answer to (i)).b.the likely impact of the changes on the cost and profit structure of Death Star Manufacturing (derived from your answer to (ii)).
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here