Question

In: Accounting

The corporation you work for has asked for a summary and report of the future projections...

The corporation you work for has asked for a summary and report of the future projections for the next 5 years. With the help of your CFO, you have put together the following preliminary budget figures based on last year's numbers for a planned production and sales level of 4,000 units per year:

Building depreciation

$200,000/yr.

Machine operators

$100,000/yr.

Management staff

$400,000/yr.

Direct materials

$4,000,000/yr.

Other expenses that seem to vary based on production levels

$3,000,000/yr.

Other expenses that don't seem to vary

$1,300,000/yr.

Selling price per unit

$5,000/unit

Utilities:

This category is difficult to analyze; a part of it is related to the building's heat and light, whereas a part of it is used in the manufacturing process itself. You have the following data to which you will apply the high–low method:

  • When there is no production, utility costs are $20,000/month
  • When production levels reached 4,000 units/month, utility costs totaled $40,000/month

You are planning for the future and working on a report based on data from last year's actual performance. You are going to calculate various figures, including the contribution margin per unit, contribution margin ratio, breakeven level in dollars, and breakeven level in units to answer some important questions regarding your data.

Using only the data from last year's actual performance, create an Excel report that answers the questions below, showing all calculations. After completing your Excel computations, in Microsoft Word, write a professional memo to the executive committee analyzing the calculations from your report. Within the memo, give your opinion based upon the numbers as to whether production seems to be budgeted properly, and whether the corporation can make an adequate profit above breakeven levels. Please explain your rationale, and include answers to the following:

  • Which costs would be considered mixed (e.g., semi-variable or semi-fixed)?
  • Ignoring utility costs altogether, compute the contribution margin per unit, in dollars and in percentage, and the breakeven level of sales.
  • Ignoring utility costs altogether, if instead of breaking even, the firm wants to make $10,000/month profit, answer the following:
    • How many units must be sold each month?
    • To how many sales dollars is this unit volume equivalent?
  • In year 2, the CEO plans to add $300,000/yr. expenses in added administrative salaried headcount. Ignoring utility costs altogether, how many additional units must be sold just to pay for this added expense?
  • Show ALL calculations.

Solutions

Expert Solution

Solution :

Which of these 8 cost categories would be considered variable, and which fixed, and explain why?
Which costs would be considered mixed (i.e., semi-variable or semi-fixed)?
Variable Costs
Machine Operators, direct materials and other expenses that seem to vary based on production levels because these costs vary as the production increases or decreases
Fixed Costs
Building Depreciation, Management staff and other expenses that don’t seem to vary because these costs are constant and would be incurred even if there is no production
Semi - Variable
Utilities are semi variable because partly they are variable and partly fixed
compute the contribution margin per unit, in dollars and in percentage and the breakeven level of sales?
Per Unit In Dollars %
Sales per unit 5000 20000000 10000.00%
Less : Variable Costs
Direct Materials (4000000/4000) 1000 4000000 20.00%
Machine Operators 100000/4000 25 100000 0.50%
Other Expenses (3000000/4000) 750 3000000 15.00%
Contribution Margin Per unit 3225 12900000 64.50%
Breakeven level of Sales(Units) = Fixed Costs/Contribution margin per unit
(200000+400000+1300000)/3225
589.1473
Breakeven level of Sales(Dollars) = Fixed Costs/Contribution Ratio
(200000+400000+1300000)/64.50%
2945736
Ignoring utility costs altogether, if instead of breaking even, the firm wants to make $10,000/month profit, answer the following:
How many units must be sold each month?
No of Units To be Sold = (Fixed Costs + Target Profit)/(Contribution per unit)
Fixed Costs per month = (200000+400000+1300000)/12 158333.333
No of Units to be sold (158333.33+10000)/3225
52.19638
No of Units to be Sold per month 52
Dollar Equivalent of Units Sold (52*5000) 260981.91
the CEO plans to add $300,000/yr. expense in added administrative salaried headcount. Ignoring utility costs altogether, how many additional units must be sold just to pay for this added expense?
Additional Units to be sold to recover $ 300000/yr 300000/3225
93.023256
Additional Units to be sold would be 93

____________________________________________________

Please upvote. Your upvote is extramly precious to me.Please upvote. Thank you so much. Please consider my efforts and request????‍♀️


Related Solutions

You are asked to work as an astrobiologist in the distant future. On Neptune’s moon Triton,...
You are asked to work as an astrobiologist in the distant future. On Neptune’s moon Triton, you find a species of terrifying and giant crustacean-like aliens that appear to live in completely isolated populations within the nitrogen ice valleys on the surface. As a famed xenobiologist that specializes in population genetics, you decide to compare and contrast two of these isolated populations. Specifically, you are interested in the locus terror​​, which comprises three alleles T1, T2, and T3. Using state...
You have been asked to provide an accurate and up-to-date profit and loss report on work...
You have been asked to provide an accurate and up-to-date profit and loss report on work in process for a particular job. What data might you draw on? What reports might you need to access? How would you ensure that the information you provide is error free and comprehensive
COOP work term report ideas or topics and brief summary for a student working in a...
COOP work term report ideas or topics and brief summary for a student working in a govt organization cooperative education..
The president of the company you work for has asked you to evaluate the proposed acquisition...
The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. The equipment's basic price is $80,000, and it would cost another $16,000 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $33,700. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481. Use of the equipment...
The president of the company you work for has asked you to evaluate the proposed acquisition...
The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. It will be a 4-year project. The equipment’s basic price is $70,000, and it would cost another $15,000 to modify it for special use by your firm. Use of the equipment would require an increase in net operating working capital (spare parts inventory) of $4,000. The machine would have no effect on revenues, but it...
The president of the company you work for has asked you to evaluate the proposed acquisition...
The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. The equipment's basic price is $67,000, and it would cost another $17,500 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $30,300. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481. Use of the equipment...
The president of the company you work for has asked you to evaluate the proposed acquisition...
The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. The equipment's basic price is $79,000, and it would cost another $20,000 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $29,900. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481. Use of the equipment...
The president of the company you work for has asked you to evaluate the proposed acquisition...
The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. The equipment's basic price is $200,000, and it would cost another $50,000 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $90,000. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481. Use of the equipment...
The president of the company you work for has asked you to evaluate the proposed acquisition...
The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. The equipment’s basic price is $85,000, and it would cost another $12,000 to install it for special use by your firm. The chromatograph falls into the MACRS 3-year class, and the MACRS rates are 0.3333, 0.4445, 0.1481, and 0.0741. The firm would keep the machine for its entire useful life (that is 4 years), and...
The president of the company you work for has asked you to evaluate the proposed acquisition...
The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. The equipment's basic price is $160,000, and it would cost another $24,000 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $72,000. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481. Use of the equipment...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT