In: Accounting
Houston-based Advanced Electronics manufactures audio speakers for desktop computers. The following data relate to the period just ended when the company produced and sold 44,000 speaker sets:
| Sales | $ | 3,520,000 | |
| Variable costs | 880,000 | ||
| Fixed costs | 2,310,000 | ||
Management is considering relocating its manufacturing facilities to northern Mexico to reduce costs. Variable costs are expected to average $20.00 per set; annual fixed costs are anticipated to be $1,986,000. (In the following requirements, ignore income taxes.)
Required:
| Total | PU | |||
| Req 1 | Sales | 3,520,000 | 80.00 | |
| Less: Variable Costs | 880,000 | 20.00 | ||
| Contribution Margin | 2,640,000 | 60.00 | ||
| Less: Fixed Cost | 2,310,000 | |||
| Net Income | 330,000 | |||
| Contribution Margin Ratio | 75.00% | (60/80) | ||
| Target income(Double) | 660,000 | |||
| Add: Fixed Cost | 2,310,000 | |||
| Required Contribution margin | 2,970,000 | |||
| Contribution Margin Ratio | 75.00% | |||
| Required Dollars Sales | 3,960,000 | |||
| Req 2 | Sales | 80.00 | ||
| Less: Variable Costs | 20.00 | |||
| Contribution Margin | 60.00 | |||
| Contribution Margin Ratio | 75.00% | |||
| Fixed Cost | 1,986,000 | |||
| Contribution Margin Ratio | 75.00% | |||
| Required Dollars Sales-Break Even | 2,648,000 | |||
| Req 3 | Contribution Margin At Mexican Point | 1,986,000 | (2648000*75%) | |
| Less: Fixed Cost at USA | 2,310,000 | |||
| Fixed Cost must Reduce by | - 324,000 | |||
| Req 4 | Sales at Break Even Point | 2,648,000 | (2648000*75%) | |
| Less: Required Contribution-Fixed Cost | 2,310,000 | |||
| Balance is Variable Cost | 338,000 | |||
| PU Variable Cost | 33,100 | |||
| Variable Cost Revised | 10.21 | |||
| Existing PU VC | 20.00 | |||
| Reduction Required | 9.79 | |||
| Req 5 | USA | Mexico | ||
| Sales | 3,520,000 | 3,520,000 | ||
| Less: Variable Costs | 880,000 | 880,000 | ||
| Contribution Margin | 2,640,000 | 2,640,000 | ||
| Less: Fixed Cost | 2,310,000 | 1,986,000 | ||
| Net Income | 330,000 | 654,000 | ||
| Increase in Net Income | 324,000 | |||