Answered step by step
Verified Expert Solution
Question
1 Approved Answer
EXHIBIT 4 SAMPLE PRODUCT DATA Alloy Conversion Die Steel: Die Steel High Steel Roller Chipper Knife Round Bar M/C Coil Production (lbs) 239,340 1,040,772 1,206,650
EXHIBIT 4 SAMPLE PRODUCT DATA Alloy Conversion Die Steel: Die Steel High Steel Roller Chipper Knife Round Bar M/C Coil Production (lbs) 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 lbs 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 Rolling 0.10 0.15 0.33 0.09 0.03 Finishing 0.06 0.02 0.07 0.08 0.05 skus 156 237 209 86 51 orders 479 2,082 1,609 1,675 506 Revenue 1,105,748 1,602,788 2,461,565 6,228,844 5,896,186 Materials 258,487 0 289,596 1,406,513 3,998,272 Labor 138,817 145,708 675,724 1,205,583 354,277 Melting Depreciation Maintenance Utilities Refining Depreciation Maintenance Utilities Molding & Breakdown Depreciation Maintenance UtilitiesULIIILIGS Molding & Breakdown Depreciation Maintenance Utilities Rolling Depreciation Maintenance Utilities Finishing Depreciation Maintenance Utilities Batch-Level Costs Matl Handling&Setup Order Processing Production planning Product-Level cost Technical Support Facility Level Cost Gen & Admin ABC CONTRIBUTION ($) ABC PROFIT ($) Per pound profit
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started