Better Yet Dishware | |||||
a) | |||||
Particulars | 4 Place serving set of Dishware | Box of 8 Mugs | Total | ||
Existing Overheads | 9,000,000.00 | 2,700,000.00 | 11,700,000.00 | ||
Increase in costs of overheads (gone up by the cost of machine) | 2,500,000.00 | ||||
Total revised overhead cost | 14,200,000.00 | ||||
Note: It is assumed that cost of running the machine $ 250,000 per year is included in the total revised overhead cost, and is not in addition to the costs above. | |||||
b) | |||||
Particulars | 4 Place serving set of Dishware | Box of 8 Mugs | Total | ||
1 | Earlier Labour Cost | 1,500,000.00 | 450,000.00 | 1,950,000.00 | |
2 | Rate/hour | $15 | $15 | ||
3 | Total Labour hours | 100,000.00 | 30,000.00 | ||
4 | Total Labour Cost (Revised) | 1,500,000.00 | 60,000.00 | 1,560,000.00 | |
5 | Rate/hour (Revised) | $15 | $15 | ||
6 | Labour Hours Used (4/5) | 100,000.00 | 4,000.00 | 104,000.00 | |
7 | Total Overheads | 14,200,000.00 | |||
8 | Allocation based on Labour Cost = Total Overheads/Total labour cost * Departmental labour cost | 13,653,846.15 | 546,153.85 | 14,200,000.00 | |
9 | Material Costs | 30,000,000.00 | 10,800,000.00 | 40,800,000.00 | |
10 | Labor | 1,500,000.00 | 60,000.00 | ||
11 | Total Cost (8+9+10) | 45,153,846.15 | 11,406,153.85 | ||
12 | No. of units produced | 2,500,000.00 | 1,200,000.00 | ||
13 | Cost per unit sale (11/12) | 18.06 | 9.51 | ||
c) | |||||
Particulars | 4 Place serving set of Dishware | Box of 8 Mugs | Total | ||
1 | Total Overheads | 14,200,000.00 | |||
2 | Existing Overheads charged to Dishware department | 9,000,000.00 | 9,000,000.00 | ||
3 | Balance to be charged to Mug | 5,200,000.00 | 5,200,000.00 | ||
4 | Overhead cost allocation | 9,000,000.00 | 5,200,000.00 | 14,200,000.00 | |
5 | Labour Cost | 1,500,000.00 | 60,000.00 | 1,560,000.00 | |
6 | Labour Hours @ $15/hr | 100,000.00 | 4,000.00 | ||
7 | Overhead Rate - Using Labor rate | $ 90/ Labour Hour | $ 1300/Labour Hour | ||
8 | Machine Hours | 4,000.00 | 6,000.00 | ||
9 | Overhead Rate - Using Machine Hour | $ 2250/Machine Hour | $ 866.67/Machine Hour | ||
Therefore, Overhead Rates are - | |||||
For Dishware department - $ 90 / Labor Hour | |||||
For Mug Department - $ 866.67 / Machine Hour | |||||
d) New product cost are as follows: - As caculated in b) above. | |||||
Dishware | 18.06 | ||||
Mugs | 9.51 | ||||
Two distinct overhead allocation methods for two different departments is a better idea. Because, Dishware department is still labor intensive and mug making department has become machine intensive after bringing in new machine. Therefore, new approach would be better for allocation of overheads. | |||||
e) After purchasing new machine effects on costs and total costs: | |||||
Particulars | 4 Place serving set of Dishware | Box of 8 Mugs | Total | ||
1 | No. of units produced | 2,500,000.00 | 1,200,000.00 | ||
2 | Old cost per unit | 16.20 | 11.63 | ||
3 | New Cost per unit | 18.06 | 9.51 | ||
4 | Savings / (increase) in cost p.u. | (1.86) | 2.12 | ||
5 | Savings / (increase) in Total | (4,653,846.15) | 2,549,846.15 | (2,104,000.00) | |
Therefore, after implementation of new machine although cost per unit of Mug has come down from 11.63 to 9.51, but overall cost of company of making all products has increased by 2,104,000. Therefore, decision of buying new machine has gone wrong. |
ATES. Better Yet Dishware aditional retail out- corating the dishes is e costs of making CASE 6.2 PLANT-WIDE VS....
Tableau DA 4-3: Mini-Case, Computing and assigning costs using ABC LOP3 wants to assign overhead costs to its two different models to better understand the profitability of each model. The Tableau Dashboard provides data for our analysis Estimated Overhead Costs by Estimated Direct Labor Hours & Machine Hours by Department Estimated Overhead Costs by Estimated Direct Labor Hours & Department Machine Hours by Department 150,000 hrs 125,000 hrs 100,000 hrs Finishing o lo 75,000 hrs Assembly Assembly Department Finishing: $3,000,000...
E. Preproduction costs. 14. Products that are in the process of being manufactured but are not yet complete are called A. Raw materials inventory. B. Conversion costs. C. Cost of goods sold. D. Goods in process inventory. E. Finished goods inventory. 15. The three major cost components of a manufactured product are: A. Marketing, selling, and administrative costs. B. Indirect labor, indirect materials, and miscellaneous factory expenses. C. Direct materials, direct labor, and factory overhead. D. Differential costs, opportunity costs,...
TufStuff, Inc., sells a wide range of drums, bins, boxes, and other containers that are used in the chemical Industry. One of the company's products is a heavy-duty corrosion-resistant metal drum, called the WVD drum, used to store toxic wastes. Production is constrained by the capacity of an automated welding machine that is used to make precision welds. A total of 2.380 hours of welding time is available annually on the machine. Because each drum requires 0.4 hours of welding...
TufStuff, Inc., sells a wide range of drums, bins, boxes, and other containers that are used in the chemical Industry. One of the company's products is a heavy-duty corrosion-resistant metal drum, called the WVD drum, used to store toxic wastes. Production is constrained by the capacity of an automated welding machine that is used to make precision welds. A total of 2.380 hours of welding time is available annually on the machine. Because each drum requires 0.4 hours of welding...
O pronu ve reported for 2017. in custom patios. The patios are 15-3A Case Inc. is a construction company specializing in custom patios. constructed of concrete, brick, fiberglass, and lumber, dependingu berglass, and lumber denending upon customer preres ence. On June 1, 2017, the general ledger for Case Inc, contains the com Raw Materials Inventory Work in Process Inventory $4.200 $5,540 Manufacturing Overhead Applied Manufacturing Overhead Incurred ase Inc. contains the following data. $32,640 ufacturing Overhead Incurred $31,650 Subsidiary data...
P15-3A Case Inc. is a construction company specializing in custom patios. The patio constructed of concrete, brick, fiberglass, and lumber, depending upon customer preter ence. On June 1, 2017, the general ledger for Case Inc. contains the following data. Raw Materials Inventory $4,200 Manufacturing Overhead Applied Work in Process Inventory $5,540 Manufacturing Overhead Incurred $31,050 $32,640 Subsidiary data for Work in Process Inventory on June 1 are as follows. Cost Element Direct materials 00000 Direct labor Manufacturing overhead Job Cost...
California Circuits Company (3C) manufactures a variety of components. Its Valley plant specializes in two electronic components used in circuit boards. These components serve the same function and perform equally well. The difference in the two products is the raw material. The XL-D chip is the older of the two components and is made with a metal that requires a wash prior to assembly. Originally, the plant released the wastewater directly into a local river. Several years ago, the company...
TufStuff, Inc., sells a wide range of drums, bins, boxes, and other containers that are used in the chemical industry. One of the company's products is a heavy-duty corrosion-resistant metal drum, called the WVD drum, used to store toxic wastes. Production is constrained by the capacity of an automated welding machine that is used to make precision welds. A total of 2,380 hours of welding time is available annually on the machine. Because each drum requires 0.4 hours of welding...
TufStuff, Inc., sells a wide range of drums, bins, boxes, and other containers that are used in the chemical industry. One of the company’s products is a heavy-duty corrosion-resistant metal drum, called the WVD drum, used to store toxic wastes. Production is constrained by the capacity of an automated welding machine that is used to make precision welds. A total of 2,140 hours of welding time is available annually on the machine. Because each drum requires 0.4 hours of welding...
TufStuff, Inc., sells a wide range of drums, bins, boxes, and other containers that are used in the chemical industry. One of the company’s products is a heavy-duty corrosion-resistant metal drum, called the WVD drum, used to store toxic wastes. Production is constrained by the capacity of an automated welding machine that is used to make precision welds. A total of 2,420 hours of welding time is available annually on the machine. Because each drum requires 0.4 hours of welding...