In: Accounting
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.
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 SolutionsEastern 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
Latest Questions
ADVERTISEMENT
|