Reference no: EM133554372
Assignment: Management Accounting
Wen Ltd manufactures setup boxes.
The budgeted data for the next year are as follows:
Minimum expected sales volume: 50,000 boxes. The maximum capacity is 100,000 boxes
Selling price: $27 per box
Variable selling costs: 5% of sales revenue.
Direct materials: $5.70 per box,
Direct variable labour costs: $6 per box,
Variable manufacturing overhead costs: $5.85 per box Fixed manufacturing costs: $90,000
Fixed selling, general and administration costs: $234,000
New Proposal:
The company is considering the following proposal, both changes expected to be made at the same time at the beginning of the next year if the management approves it:
Changes to costs made in the new proposal:
1) The variable direct labour costs of $6 per box for the production operators is proposed to be changed to fixed monthly wages, and the total fixed direct labour costs is estimated at $330,000 next year, and
2) The current variable 5% sales commissions are proposed to be replaced with a fixed allowance that will be included in fixed monthly salaries of the sales personnel. This will increase total fixed sales salaries by $80,000 next year.
Task
I. Calculate each the following before the new proposal:
1. Break-even point in units and sales value.
2. Sales units and sales value required to achieve the target profit after tax of $170,150. Tax rate: 17%.
3. Profit at 50,000 boxes.
4. Operating leverage at 50,000 boxes.
5. Margin of safety in units, dollars and % if the budgeted sales is 50,000 boxes.
II. At which level of sales will the management of the company be indifferent to the existing and new proposal? In other words, what is the sales volume that will result in the same costs and profit with or without the proposed changes?
III. Advise the management of the company on whether the proposed changes should be made, with reasons supporting your recommendations. Include in your answers, the calculation of the revised breakeven point in units and dollars after the change and compare them to before the changes are proposed.
IV. If the new proposal was adopted and selling price is reduced by 20% to increase the sales volume to 90,000 boxes, will this strategy of increasing sales be viable? Calculate the profits and advise the management.