Explore BrainMass
Share

Calculate Car Manufacturing Plant Problem

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

See the attached file.
Calculate Car Manufacturing Plant Problem

? Calculate the overhead allocation rate (i.e. burden rate) for each of the model years 1988 through 1990.
1987 1988 1989 1990
Sales
Fuel Tanks 70,278 75,196 79,816 83,535
Manifolds 79,459 84,776 89,323 93,120
Doors 41,845 45,174 47,199 49,887
Muffler/Exhausts 62,986 66,266 0 0
Oil Pans 75,586 79,658 0 0
Total 330,154 351,071 216,338 226,542

Direct Material
Fuel Tanks 15,125 15,756 16,312 16,996
Manifolds 31,696 33,016 34,392 35,725
Doors 14,886 15,506 16,252 16,825
Muffler/Exhausts 28,440 29,525 0 0
Oil Pans 32,218 33,560 0 0
Total 122,365 127,363 66,956 14,102

Direct Labor
Fuel Tanks 4,169 4,238 4,415 4,599
Manifolds 5,886 6,027 6,278 6,540
Doors 2,621 2,731 2,844 2,963
Muffler/Exhausts 5,635 5,766 0 0
Oil Pans 6,371 6,532 0 0
Total 24,682 25,294 13,537 14,102

Overhead by Account Number
1000 7,713 7,806 5,572 5,679
1500 6,743 6,824 5,883 5,928
2000 3,642 3,794 2,031 2,115
3000 2,428 2,529 1,354 1,410
4000 8,817 8,888 7360 7,410
5000 24,181 24,460 20,063 20,274
8000 5,964 5,946 3,744 3,744
9000 6,708 6,771 5,948 5,987
11000 5,089 5,011 3,150 3,030
12000 26,936 28,077 15,027 15,683
14000 9,733 9784 8,025 8,110
Total 107,954 109,890 78,157 79,393
Factory Profit 75,153 88,524 57,688 63,501

? Consider two products in the same product line. Below is their budgeted selling price and costs.
Product 1 Product 2
Expected selling price $ 62 $54
Direct material cost 16 27
Direct Labor cost 6 3

Calculate the expected gross margin as a % of selling price on each product based on the 1988 and 1990 model year budgets, assuming selling price and material and labor cost do not change from standard.

© BrainMass Inc. brainmass.com October 25, 2018, 3:59 am ad1c9bdddf
https://brainmass.com/business/management-accounting/calculate-car-manufacturing-plant-problem-362134

Attachments

Solution Preview

Please find tutorial and help for car manufacturing plant in the attached file.

Running Head: CAR MANUFACTURING PLANT

Car Manufacturing Plant

Answer 1
Calculation of Overhead Allocation Rate
The overhead allocation rate can be calculated by the following formula.
= Overhead cost/Allocation base
Two types of allocation bases are used for calculating overhead allocation rate that are as follow.
• Direct material cost
• Direct labor cost
The total overhead cost, direct material cost, and direct labor cost are shown in the following table.
Year 1988 1989 1990
Overhead Cost 109890 78157 79393
Direct Material Cost 127363 66956 69546
Direct Labor Cost 25294 13537 14102

Overhead ...

Solution Summary

The solution calculates car manufacturing plant problems.

$2.19
See Also This Related BrainMass Solution

Accounting Investment Projections

1. K Inc is looking at setting up a new manufacturing plant in Chicago. The company bought land 6 years ago for $7million in anticipation of using it as a warehouse and distribution site, but the company has decided to rent facilities elsewhere. The land would net $9.8 million if It were sold today. The company now wants to build its new manufacturing plant on this land; the plan will cost $21million to build and the site requires $850,000 worth of grading before it is suitable for construction. What is the proper cash flow amount to use as the initial investment in fixed assets when evaluating this project? Why?
2. A proposed new investment has projected sales of $825,000. Variable costs are 55% of sales, and fixed costs are $187,150; depreciation is $91,000. Prepare a pro forma income statement assuming a tax rate of 35%. What is the projected net income?
3. Consider the following income statement: Fill in the missing numbers and then calculate the OFC. What is the depreciation tax shield?
Sales $643,800
Costs 345,300
Depriciation 96,000
EBIT ?
Taxes (35%) ?
Net Income ?

4. Consider an asset that costs $780,000 and is depreciated straight line to zero over its 8 year tax life. The asset is to be used in a 5 year project; at the end of the project ; at the end of the project, the asset can be sold for $135,000. If the relevant tax rate is 35%, what is the after-tax cash flow from the sale of this asset?
5. C co. is considering a new 3 year expansion project that requires an initial fixed asset investment of $2.1 Million. The fixed asset will be depreciated straight line zero over its 3 year tax life, after which time it will be worthless. The project is estimated to generate $2,150,000 in annual sales, with costs of $1,140,000. If the tax rate is 35%, what is the OCF for this project?
6. In the previous problem, suppose the required return on the project is 14%. What's the project's NPV?
7. Auto Trans. Has the following estimates for its new gear assembly project: Price=$1070 per unit, variable cost=$290 per unit, fixed cost=4.8Million, quantity=70,000 units. Suppose the company believes all of its estimates are accurate only to within +- 15%. What values should the co. use for the 4 variables given here when it performs its best case scenario analysis? What about the worst case scenario?
8. For the company in the previous problem, suppose the management is most concerned about the impact of its price estimate on the projects profitability. How could you address this concern for Auto Trans.? Describe how you would calculate your answer. What values would you use for the other forecast variables?

View Full Posting Details