Question: EXHIBIT 6 ABC COST POOLS Activity Driver Driver Vol Amount ($) Melting - Dep melt m/c min 5,145,632 2,139,865 Melting- Main melt m/c min 5,145,632

EXHIBIT 6 ABC COST POOLS Activity Driver Driver Vol Amount ($) Melting - Dep melt m/c min 5,145,632 2,139,865 Melting- Main melt m/c min 5,145,632 975,130 Melting - Util melt m/c min 5,145,632 2,036,477 Refining - Dep ref m/c min 5,691,042 1,711,892 Refining - main ref m/c min 5,691,042 780,104 Refining - Util ref m/c min 5,691,042 1,745,551 Molding - Dep mold m/c min 4,226,965 427,973 Molding - Main mold m/c min 4,226,965 390,052 Molding - Util mold m/c min 4,226,965 290,925 Rolling - Dep roll m/c min 8,258,382 2,995,811 Rolling - Main roll m/c min 8,258,382 975,130 Rolling - Util roll m/c min 8,258,382 872,776 Finishing - Dep fin m/c min 4,057,311 1,283,919 Finishing - Main fin m/c min 4,057,311 780, 104 Finishing - Util fin m/c min 4,057,311 872,776 Gen & Admin Pounds 50,299,420 5,400,955 Matl Handing & Set up Orders 57,147 4,936,068 Order Process Orders 57,147 3,953,709 Prod planning Orders 57,147 3,339,500 Tech Support skus 6,642 5,766,579A B C D E EXHIBIT 4 SAMPLE PRODUCT DATA Alloy Conversion Die Steel: Die Steel High Steel Roller Chipper Knife Round Bar M/C Coil Production (Ibs) 239,340 1,040,772 1,206, 650 3,348,841 1,265,276 # SKUs 156 237 209 86 51 # Orders 479 2,082 1,609 1,675 506 Avg Order Size 250 250 375 1,000 1,250 Avg Ibs per SKU 770 2,201 2,887 19,470 12,405 Bill of materials (Ibs/lb of output) Steel Scrap 1.00 0.00 1.00 1.00 1.00 Alloys 0.01 0.00 0.01 0.01 0.01 M/c time (min/lb; crew=1) Melting (EAC) 0.20 0.00 0.09 0.09 0.09 Refining (VOD) 0.21 0.00 0.10 0.10 0.10 Molding/breakdown (ingot/PPF) 0.12 0.00 0.07 0.08 0.07 Rolling (CRM) 0.10 0.15 0.33 0.09 0.03 Finishing (Multiple) 0.06 0.02 0.07 0.08 0.05 Total Time 0.69 0.17 0.66 0.44 0.34TOTAL Alloy-Condition Conversion: Die Steel: Die Steel: High Speed Round Roller Wire Chipper Round bar M/C Coil Quantity 239,340 1,040,772 1, 206, 650 3,348,841 1,265,276 Melting 0.20 0.00 0.09 0.09 0.09 Refining 0.21 0.00 0.10 0. 10 0.10 Molding 0. 12 0.00 0.07 0.08 0.07 9 Rolling 0.10 0.15 0.33 0.09 0.03 Finishing 0.06 0.02 0.07 0.08 0.05 11 skus 156 237 209 86 51 12 orders 479 2,082 1,609 1,675 506 13 14 15 Revenue 1, 105, 748 1,602, 788 2,461, 565 6,228,844 5,896, 186 16 Materials 258, 487 0 289,596 1,406,513 3,998,272 17 Labor 138,817 145,708 675,724 1,205,583 354,277 18 19 Melting 20 Depreciation 1 Maintenance 22 Utilities 23 Refining 25 Depreciation 26 Maintenance 27 Utilities 28 29 Molding & Breakdown 30 Depreciation 31 Maintenance 32 Utilities 33 34 Rolling 35 Depreciation 36 Maintenance 37 Utilities 38 39 Finishing 40 Depreciation 41 Maintenance 42 Utilities 43 44 Batch-Level Costs 45 Matl Handling&Setup 46 Order Processing Production planning 48 49 Product-Level cost Technical Support 51 Facility Level Cost 53 Gen & Admin 54 55 ABC CONTRIBUTION ($) 56 ABC PROFIT ($) Per pound profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Compute profits for the five sample products under ABC. a. First, use the current production volume and number of orders and SKUs from Exhibit 4 to calculate total ABC profits for each product. b....

I need assistance calculating cost pool and cost driver rate. If needed and can provide the full assignment Milestone 2 - Steps 4 - 6 The ABC cost analysis is worth 25 points Step 4: Satisfied that...

Can I have some help with the attached? This involves knowledge of cost strategies and activity based costing. Clark, Long, Winters and Smith. partner total hours worked total billable hours Budgeted...

1. Based on the interviews and data in the case, define the fundamental activities for Midwest Office Products. (What does Wilbur Smith say are the basics of the business?) 2. Define the relevant...

Classic Pen Company: Developing an ABC Model The Classic Pen Company Case Jane Dempsey, controller of the Classic Pen Company, was concerned about the recent financial trends in operating results....

No, I attached all the questions....they are all just questions to be answered....doesn't matter the limit of pages..just so long as you answer the questions that I attached.... EXERCISE 6-12....

Question 10-12 JOB COSTING AND ACTIVITY-BASED COSTING (16 marks) Required: 10. Calculate the total cost of Job 104 and Job 105 using the current system. (4 marks) 11. Calculate the total cost of Job...

Question 2 JOB COSTING AND ACTIVITY-BASED COSTING (16 MARKS) Little Hands Limited manufactures wooden toys. The company currently allocates overhead based on direct labour hours. Total budgeted...

Please answer the following: 1) Compute the cost of a regular and special meal using the new overhead pools and cost drivers. What explains the differences between these costs and the ones in Exhibit...

Web-R-Us, a website design company, the manager had decided to increase the price of Webs-R-Us services by 35% If Webs-R-Us has a price elasticity of demand at 0.50, we can expected the number of...

Complete Keith's tax return including all required schedules and forms using prince edward island as province, using the fillable forms package. Taxpayers Information Taxpayer #1 Name: Keith Dox...

Contour plowing and strip farming And terracing are \ _ \ _ \ _ \ _ \ _ . soil conservations practices architectural endeavors Soil development actions planning the land for businesses

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....