Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Enviro Recyclers has processing plants in Maine and Connecticut. Both plants use recycled glass to produce jars that are used in food canning by a

Enviro Recyclers has processing plants in Maine and Connecticut. Both plants use recycled glass to produce jars that are used in food canning by a variety of processors. The jars sell for $20 per unit. Budgeted revenues and costs for the year ending Dec 31 2011 are:

2016 Segment Margin Budget

Maine

Connecticut

Total

Sales Units

110,000

200,000

310,000

Sales $

$2,200,000

$4,000,000

6,200,000

Variable production costs:

Direct material

550,000

1,000,000

1,550,000

Direct labor

660,000

1,000,000

1,660,000

Variable Factory overhead

440,000

700,000

1,140,000

Total

1,650,000

2,700,000

4,350,000

Contribution Margin

550,000

1,300,000

1,850,000

Direct/Traceable Fixed Costs:

Fixed factory overhead

700,000

900,000

1,600,000

Fixed regional promotion costs

100,000

100,000

200,000

Total Fixed Cost

800,000

1,000,000

1,800,000

Segment Margin

(250,000)

300,000

50,000

Fixed regional promotional costs are discretionary advertising costs needed to obtain budgeted sales levels.

Because of the budgeted operating loss, Enviro is considering the possibility of ceasing operations at its Maine plant. If Enviro ceases operations at its Maine plant, all fixed factory overhead costs would be eliminated.

Enviro is considering the following three alternative plans:

PLAN A: Expand Maine's operations from its budgeted 110,000 units to a budgeted 170,000 units. It is believed that this can be accomplished by increasing Maine's fixed regional promotional expenditures by $120,000.

PLAN B: Close the Maine plant and expand Connecticut's operations from the current budgeted 200,000 units to 310,000 units in order to fill Maine's budgeted production of 110,000 units. The Connecticut Plants Fixed Factory Overhead will increase by $50,000 to cover this additional production.

The Maine region would continue to incur promotional costs in order to sell the 110,000 units. All sales and costs would be budgeted through the Connecticut plant.

PLAN C: Close the Maine plant and enter into a long-term contract with a competitor to serve the Maine region's customers. This competitor would pay Enviro a royalty of $2.50 per unit for the 110,000 units that Maine would have sold. Enviro would continue to incur fixed regional promotional costs to maintain sales of 110,000 units in the Maine region.

Requirements

Break Even: Using the 2016 Budget ONLY, determine the number of units that must be produced and sold by the Maine plant to cover all of the costs per the budget above (i.e. break even). Use the amounts from the budget above to do this Break Even calculation. Do not consider the effects of implementing Plans A, B, and C.

***Show your calculations

Hint Compute Sales Price per unit & Variable Cost per unit to determine Per Unit Contribution Margin (Sales price per unit Variable cost per unit = Contribution Margin per unit).

Then use the Break Even formula (Total Fixed Cost / Contribution Margin per Unit Break Even Unit Sales) to compute break even units

2) Plan A: Prepare a Segmented income statement for each plant and in total in the same format as the budget above from the implementation of Plan A. Use the same level of detail for variable and fixed costs per above (i.e. itemize by type).

Plan A-C Hint

Hint compute variable costs per unit for each variable cost type. Do for each plant using 2016 budget. Apply these rates to new unit sales per Plan assumptions. Compute fixed costs per Plan assumptions.

Compute sales price per unit using 2016 budget. Apply these rates to new unit sales per Plan assumptions to calc new sales $.

3) Plan B: Prepare a contribution margin budgeted income statement for the company which now includes only the Connecticut Plant from the implementation of Plan B. Use the same level of detail for variable and fixed costs per above (i.e. itemize by type).

Hint - Make sure to budget for total company regional promotion costs (the Maine plant is gone but the costs are not!)

4) Plan C: Prepare a contribution margin budgeted income statement for the company which now includes only the Connecticut Plant from the implementation of Plan C. Use the same level of detail for variable and fixed costs per above (i.e. itemize by type).

Hint The sales units will be 200,000. The revenue from the royalty is a separate revenue line and does not impact sales units or costs.

Hint - Fixed Factory overhead will go back to $900,000 as the Conn. Plant is back at a 200,000 sales level.

Hint make sure to use the units Maine would have sold when computing royalty revenue

Hint - Make sure to budget for total company regional promotion office costs (the Maine plant is gone but the costs are not!)

Briefly discuss the advantages and disadvantages of each plan considering qualitative factors and recommend a course of action.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Project Management A Structured Approach

Authors: Frederick Harrison, Dennis Lock

4th Edition

1138270636, 978-1138270633

More Books

Students also viewed these Accounting questions

Question

6. What are some of the advantages and disadvantages of ESOPs?

Answered: 1 week ago