7. Determine the unit costs and total unit cost for the crankshaft if 10,000 units were pro- duced (a recording error was made and 10,000 were made instead of 8,000) and compare the results (costs and profits) to the 8,000 total and unit costs of Tables 3.4 and 3.5. Assume all other values remain the same as in Tables 3.3, 3.4, and 3.5. Table 3.3: Cost data for overhead evaluations for an automotive metal casting facility Casting Products Produced Crank- Rear Exhaust Total # of Total OH OH Rate Piston shaft Axel Manifold Activity Cost - $ ($/unit) 120 300 200 380 1,000 56,000 56 200 350 450 400 1,400 56,000 40 2,000 4,000 2,000 2,000 10,000 500,000 50 Overhead Item/ Cost Driver Activity # of Purchase Orders Orders Material Handling # of Moves Depreciation # of Machine Expense Hours # of Machine Utility Costs Hours Factory Expenses Administrtive Expenses Total Expenses 2,000 4,000 2,000 2,000 10,000 40,000 500,000 400,000 1,552,000 Table 3.4: Unit cost determination Piston Total # of Total OH OH Rate Activity Cost - $ (S/unit) 40 13,000 10,000 520,000 40,000 Casting Products Produced Crank- Rear Exhaust Production Data shaft Axel Manifold Production Units 38,000 8,000 6,700 34,000 Selling Price: $/unit 10 13275 23 Direct Labor: hours 1,000 5,000 2,000 5,000 Utility Cost: Machine hours 2,000 4,000 2,000 2,000 Direct Unit Costs and Overhead Activities Directly Related to Products Crank- Rear Exhaust Production Costs Piston shaft Axel Manifold Direct Materials S/unit 4.000 32.000 19.000 6.000 Direct Labor $/unit 1.053 25.000 11.940 5.882 Purchase OH $/unit 0.177 2.100 1.672 0.626 Material Handling $/unit 0.211 1.750 2.687 0.471 Depreciation Expenses S/unit 2.632 25.000 14.925 2.941 Machine Utility $/unit 0.211 2.000 1.194 0.235 Total Direct Costs $/unit 8.284 87.850 51.418 16.155 Table 3.5: Total product cost using different time basis Direct Labor Hour Basis for Factory and Administrative Overhead Unit Costs Piston Crank-shaft Rear Axel Exhaust Manifold Total Direct Costs $/unit 8.284 87.850 51.418 16.155 Factory OH $/unit 1.012 24.038 11.481 5.656 Adminisstrative OH $/unit 0.810 19.231 9.185 4.525 Total Product Cost $/unit 10.106 131.119 72.084 26.336 Selling Price $/unit 10.000 132.000 75.000 23.000 Product Profit/Loss $/unit -0.106 0.881 2.916 -3.336 Machine Hour OH Basis for Factory and Administrative Overhead Unit Costs Piston C rank-shaft Rear Axel Exhaust Manifold, Total Direct Costs $/unit 8.284 87.850 51.418 16.155 Factory OH $/unit 2.632 25.000 14.925 2.941 Adminisstrative OH $/unit 2.105 20.000 11.940 2.353 Total Product Cost $/unit 13.021 1 32.850 78.284 21.449 Selling Price $/unit 10.000 132.000 75.000 23.000 Product Profit/Loss $/unit -3.021 -0.850 -3.284 1.551 Total of Machine plus Labor Hour OH Basis for Factory and Administrative Overhead Unit Costs Piston Crank-shaft Rear Axel Exhaust Manifold Total Direct Costs 8.284 87.850 51.418 16.155 Factory OH $/unit 1.716 24.457 12.979 4.476 Administrative OH $/unit 1.373 19.565 10.383 3.581 Total Product Cost $/unit 11.373 131.872 74.779 24.212 Selling Price $/unit 10.000 132.000 75.000 23.000 Product Profit/Loss $/unit -1.373 0.128 0.221 -1.212