Question

In: Accounting

Phoenix-based CompTronics manufactures audio speakers for desktop computers. The following data relate to the period just...

Phoenix-based CompTronics 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,608,000 Variable costs 902,000 Fixed costs 2,250,000 Management is considering relocating its manufacturing facilities to northern Mexico to reduce costs. Variable costs are expected to average $18.00 per set; annual fixed costs are anticipated to be $1,988,000. (In the following requirements, ignore income taxes.) Required:

1. Calculate the company’s current income and determine the level of dollar sales needed to double that figure, assuming that manufacturing operations remain in the United States. (Do not round intermediate calculations and round your final answers to nearest whole dollar.)

2. Determine the break-even point in speaker sets if operations are shifted to Mexico. (Do not round intermediate calculations and round your final answer up to nearest whole number.)

3. Assume that management desires to achieve the Mexican break-even point; however, operations will remain in the United States.

a. If variable costs remain constant, by how much must fixed costs change? (Round your final answer to nearest whole dollar.)

b. If fixed costs remain constant, by how much must unit variable cost change? (Do not round intermediate calculations and round your final answer to 2 decimal places.)

Solutions

Expert Solution

Working:

Sale price per unit = 3608000/44000 = $ 82

Variable cost per unit = 902000/44000 = $ 20.5

(1) Current income = Sales - Variable cost - Fixed cost

= 3608000 - 902000 - 2250000

= $ 456,000

Contribution per unit = Sale price per unit - Variable cost per unit

= 82 - 20.5

= $ 61.5

Desired profit = 2 x current income

= 2 x 456000

= $ 912,000

units to be sold to achieve that desired profit = ( Fixed cost + Desired profit)/ Contribution per unit

= (2250000 + 912000)/ 61.5

= 51414.63 i.e 51415 units approximately

Level of dollar sales needed to double the current income= units to be sold to achieve desired profit x sale price per unit

= 51415 x 82

= $ 4,216,030

(2) If operations are shifted to mexico

Sale price per unit = $ 82

Variable cost per unit = $ 18

Contribution per unit = Sale price per unit - Variable cost per unit = 82 - 18 = $ 64

Fixed cost = $ 1,988,000

Break even point = Fixed cost/ Contribution per unit

= 1988000/64

= 31062.5 i.e 31063 approximately  

(3) Management wants to achieve Mexican break even point while staying in US

(a) variable costs remain constant, by how much must fixed costs change:

Lets take fixed cost as X

Break even point of Mexico = Fixed cost / Contribution per unit

31063 = X / 64

X = 31063 x 64

Therefore X i.e fixed cost = $ 1,988,032

Current fixed cost = $ 2250000

Change in fixed cost (i.e reduction in fixed cost = Current fixed cost - Fixed cost at Mexican break even point at US

= 2250000 - 1988032

=$ 261,968

(b) If fixed costs remain constant, by how much must unit variable cost change

Let X be the required variable cost per unit

Break even point of Mexico = Fixed cost / Contribution per unit

31063 = 2250000/ (82 - X)

(82 - X) = 2250000/31063

(82 - X) = 72.43

X = 82 - 72.43

Therefore X (i.e Variable cost per unit) = $ 9.57

Current Variable cost = $ 20.5

Change in variable cost per unit(i.e required reduction) = 20.5 - 9.57 = $10.93 per unit


Related Solutions

Houston-based Advanced Electronics manufactures audio speakers for desktop computers. The following data relate to the period...
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,696,000 Variable costs 924,000 Fixed costs 2,250,000 Management is considering relocating its manufacturing facilities to northern Mexico to reduce costs. Variable costs are expected to average $18.00 per set; annual fixed costs are anticipated to be $1,988,000. (In the following requirements, ignore income taxes.) Required: 1. Calculate the company’s current income...
Houston-based Advanced Electronics manufactures audio speakers for desktop computers. The following data relate to the period...
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 41,000 speaker sets: Sales $ 3,280,000 Variable costs 820,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,990,000. (In the following requirements, ignore income taxes.) Required: 1. Calculate the company’s current income...
Houston-based Advanced Electronics manufactures audio speakers for desktop computers. The following data relate to the period...
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,608,000 Variable costs 902,000 Fixed costs 2,250,000 Management is considering relocating its manufacturing facilities to northern Mexico to reduce costs. Variable costs are expected to average $16.00 per set; annual fixed costs are anticipated to be $1,988,000. (In the following requirements, ignore income taxes.) Required: 1. Calculate the company’s current income...
Houston-based Advanced Electronics manufactures audio speakers for desktop computers. The following data relate to the period...
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: Calculate the company’s current income and...
Houston-based Advanced Electronics manufactures audio speakers for desktop computers. The following data relate to the period...
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 41,000 speaker sets: Sales $ 3,362,000 Variable costs 840,500 Fixed costs 2,310,000 Management is considering relocating its manufacturing facilities to northern Mexico to reduce costs. Variable costs are expected to average $18.00 per set; annual fixed costs are anticipated to be $1,994,000. (In the following requirements, ignore income taxes.) Required: Calculate the company’s current income and...
Houston-based Advanced Electronics manufactures audio speakers for desktop computers. The following data relate to the period...
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 42,000 speaker sets: Sales $ 3,444,000 Variable costs 861,000 Fixed costs 2,250,000 Management is considering relocating its manufacturing facilities to northern Mexico to reduce costs. Variable costs are expected to average $18.00 per set; annual fixed costs are anticipated to be $1,986,000. (In the following requirements, ignore income taxes.) Required: Calculate the company’s current income and...
Houston-based Advanced Electronics manufactures audio speakers for desktop computers. The following data relate to the period...
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 40,000 speaker sets: Sales $ 3,360,000 Variable costs 840,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: Calculate the company’s current income and...
Houston-based Advanced Electronics manufactures audio speakers for desktop computers. The following data relate to the period...
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 43,000 speaker sets: Sales $ 3,526,000 Variable costs 881,500 Fixed costs 2,310,000 Management is considering relocating its manufacturing facilities to northern Mexico to reduce costs. Variable costs are expected to average $18.00 per set; annual fixed costs are anticipated to be $1,988,000. (In the following requirements, ignore income taxes.) Required: Calculate the company’s current income and...
Harmony Audio Company manufactures two models of speakers, DL and XL. Based on the following production...
Harmony Audio Company manufactures two models of speakers, DL and XL. Based on the following production and sales data for September 2016, prepare (a) a sales budget and (b) a production budget. DL XL Estimated inventory (units), September 1 253 70 Desired inventory (units), September 30 291 61 Expected sales volume (units): East Region 3,500 3,900 West Region 4,800 4,200 Unit sales price $100 $225 a. Prepare a sales budget. Harmony Audio Company Sales Budget For the Month Ending September...
Sales and Production Budgets Ultimate Audio Company manufactures two models of speakers, U500 and S1000. Based...
Sales and Production Budgets Ultimate Audio Company manufactures two models of speakers, U500 and S1000. Based on the following production and sales data for June. U500 S1000 Estimated inventory (units), June 1 284      83 Desired inventory (units), June 30 327 72 Expected sales volume (units): Northeast Region 3,800 3,350 Southwest Region 5,550 6,250 Unit sales price $110 $215 a. Prepare a sales budget. Enter all amounts as positive numbers. ULTIMATE AUDIO COMPANY Sales Budget For the Month Ending June...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT