Question

In: Accounting

Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales...

Eastern Chemical Company produces three products. The operating results of the current year are:

Product Sales Quantity Target Price Actual Price Difference
A 1,900.00 $ 302.00 $ 303.00 $ 1.00
B 9,500.00 314.60 272.60 (42.00 )
C 950.00 219.50 327.00 $ 107.50

The firm sets the target price of each product at 150% of the product’s total manufacturing cost. It appears that the firm was able to sell Product C at a much higher price than the target price of the product and lost money on Product B. Tom Watson, CEO, wants to promote Product C much more aggressively and phase out Product B. He believes that the information suggests that Product C has the greatest potential among the firm’s three products because the actual selling price of Product C was almost 50% higher than the target price, while the firm was forced to sell Product B at a price below the target price.

Both the budgeted and actual factory overhead for the current year are $867,200. The actual units sold for each product also are the same as the budgeted units. The firm uses direct labor dollars to assign manufacturing overhead costs. The direct materials and direct labor costs per unit for each product are:

Product A Product B Product C
Direct materials $ 67.00 $ 131.40 $ 82.00
Direct labor 37.00 29.00 19.00
Total prime cost $ 104.00 $ 160.40 $ 101.00

The controller noticed that not all products consumed factory overhead similarly. Upon further investigation, she identified the following usage of factory overhead during the year:

Product A Product B Product C Total Overhead
Number of setups 4 7 5 $ 8,200
Weight of direct materials (pounds) 417 267 367 209,000
Waste and hazardous disposals 42 62 47 475,000
Quality inspections 47 52 52 92,000
Utilities (machine hours) 3,800 8,700 1,900 83,000
Total $ 867,200

Required:

1. Determine the manufacturing cost per unit for each of the products using the volume-based method.

2. What is the least profitable and the most profitable product under both the current and the ABC systems?

3. What is the new target price for each product based on 150% of the new costs under the ABC system? Compare this price with the actual selling price.

Solutions

Expert Solution

A B C
Product Sales Quantity 1900 9500 950
Selling Price( Currently Sale at) 303 272.6 327
Target Selling Price 302 314.6 219.5
Difference 1 -42 107.5
Manufacturing Overhead 867200 $
A B C
Direct Material 67 131.4 82
Direct Labour 37 29 19
Total PC 104 160.4 101
Allocation of Manufatcuring Overhead as per Volume BASed cost Method:
Allocation Rate = Manufacturing OH / Direct Labur Hours
A B C
Product Sales Quantity 1900 9500 950
Direct Labour 37 29 19
Direct Labour Hours 70300 275500 18050
Allocation Rate = 867200 / 363850 = 2.38339
1 Manufacturing Cost
A B C
Product Sales Quantity 1900 9500 950
Direct Material 127300 1248300 77900
Direct Labour Hours 70300 275500 18050
Mfr. OH 167552 656624 43020
Total Cost 365152 2180424 138970
Per Unit 192 230 146
Target Price 288 344 219
Selling Price 303 273 327
Difference 15 -72 108
Ranking II III I
2 Ranking iN Volume Cost Method
A B C
Ranking in Old Sysytme II III I
Ranking in ABC II I III
3 Under ABC System
A B C
Product Sales Quantity 1900 9500 950
Direct Material 127300 1248300 77900
Direct Labour Hours 70300 275500 18050
Mfr OH 267632 333544 266025
Total Cost 465232 1857344 361975
Per Unit 245 196 381
Target Price 367 293 572
Selling Price 303 272.6 327
Difference -64 -21 -245

Related Solutions

Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales Quantity Target Price Actual Price Difference A 1,550.00 $ 295.00 $ 296.00 $ 1.00 B 7,750.00 307.60 265.60 (42.00 ) C 775.00 212.50 320.00 $ 107.50 The firm sets the target price of each product at 150% of the product’s total manufacturing cost. It appears that the firm was able to sell Product C at a much higher price than the target price of...
This Company produces a single product. Sales for the current year are 25,000 units. Relevant data:...
This Company produces a single product. Sales for the current year are 25,000 units. Relevant data: Selling price/unit 130 Variable cost/unit 80 Fixed costs 1,300,000 a) What is their net income for the current year? b) Compute their breakeven point in sales units. c) Marketing Director believes that unit sales would increase by 20% if the price were cut by 10%. Should they take this action? Explain. d) Production Manager is considering outsourcing the production of some parts. This would...
Wallaby Company produces a single product. Sales for the current year are 25,000 units. Relevant data:...
Wallaby Company produces a single product. Sales for the current year are 25,000 units. Relevant data: Selling price/unit 130 Variable cost/unit 80 Fixed costs 1,300,000 a) What is Wallaby's net income for the current year? b) Compute Wallaby's breakeven point in sales units. c) Marketing Director believes that unit sales would increase by 20% if the price were cut by 10%. Should Wallaby take this action? Explain. d) Production Manager is considering outsourcing the production of some parts. This would...
A chemical engineer is investigating the effect of process operating temperature on product yield.The study results...
A chemical engineer is investigating the effect of process operating temperature on product yield.The study results in the following data: Temperature Yield 100 59.63 110 72.28 120 70.98 130 74.35 140 88.23 150 100.28 160 106.41 170 113.01 180 113.71 190 124.07 You can use Minitab to answer the following questions. However, you should be able to calculate the slope and intercept of the least squares regression model by hand, which requires only the means and standard deviations of X...
A chemical engineer is investigating the effect of process operating temperature on product yield.The study results...
A chemical engineer is investigating the effect of process operating temperature on product yield.The study results in the following data: Temperature Yield 100 61.07 110 66.01 120 79.28 130 75.04 140 80.30 150 97.95 160 98.17 170 110.07 180 121.28 190 118.21 You can use Minitab to answer the following questions. However, you should be able to calculate the slope and intercept of the least squares regression model by hand, which requires only the means and standard deviations of X...
A chemical company produces a special industrial chemical that is a blend of three chemical ingredients....
A chemical company produces a special industrial chemical that is a blend of three chemical ingredients. The beginning-year cost per pound, the ending-year cost per pound, and the blend proportions follow. (Round your answers to the nearest integer.) Cost per Pound ($) Ingredient Beginning Ending Quantity (pounds) per 100 Pounds of Product A 1.50 3.45 25 B 8.75 9.90 10 C 0.99 0.90 70 (a) Compute the price relatives for the three ingredients. Item Price Relative A B C (b)...
ABC Company produces Product X, Product Y, and Product Z. All three products require processing on...
ABC Company produces Product X, Product Y, and Product Z. All three products require processing on specialized finishing machines. The capacity of these machines is 2,130 hours per month. ABC Company wants to determine the product mix that should be achieved to meet the high demand for each product and provide the maximum profit. Following is information about each product: Product X Product Y Product Z Selling price $ 149 $ 121 $ 35 Variable costs 104 60 27 Machine...
Multiple-Product Analysis, Changes in Sales Mix, Sales to Earn Target Operating Income Basu Company produces two...
Multiple-Product Analysis, Changes in Sales Mix, Sales to Earn Target Operating Income Basu Company produces two types of sleds for playing in the snow: basic sled and aerosled. The projected income for the coming year, segmented by product line, follows: Basic Sled Aerosled Total Sales $3,000,000 $2,400,000 $5,400,000 Total variable cost 1,000,000 1,000,000 2,000,000 Contribution margin $2,000,000 $1,400,000 $3,400,000 Direct fixed cost 778,000 650,000 1,428,000 Product margin $1,222,000 $750,000 $1,972,000 Common fixed cost 198,900 Operating income $1,773,100 The selling prices...
The Mullins Company finished their sales projections for the coming year. The company produces one product....
The Mullins Company finished their sales projections for the coming year. The company produces one product. Part of next year's sales projections are as follows. Projected Sales in Units July 150,000 August 170,000 September 164,000 October 180,000 November 205,000 The budget committee has also completed the following information on inventories. Raw Materials Ending Balance, June, 25,000 lbs Desired ending levels (monthly 5% of next month's production needs) Work-In-Progress None Finished Goods Inventory Ending Balance, June, 14,000 units Desired ending levels:...
Eire Products is a speciality lubricants company. The Lake plant produces a single product in three...
Eire Products is a speciality lubricants company. The Lake plant produces a single product in three departments: filtering, blending, and packaging. Additional materials are added in the blending process when units are 50 to 55 % complete with respect to conversion. Information for operations in June in the Blending process appear as follows: Work in Process on June 1 consists of 10,400 barrels with the following costs Amount Degree of Completion Filtering costs transferred in $10,960 100% Costs added in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT