GiuliaAnalysis.xlsx - Forge Cost/Month Units Produced...

This preview shows page 1 - 5 out of 5 pages.

Case Information Forge Cost/Month 9,000 Units Produced 1,000 Cost/Unit 9.00 Material Cost/Unit 1.45 Utility Costs Units Cost High 1300 1962 Low 1000 1908 Difference 300 54 Variable Cost/Unit 0.18 Fixed Cost/Unit 1728 Supplies Supplies Cost 110 # of Units 1,000 Supplies Cost/Unit 0.11 Plant Labor Cost # of Laborers 6 Labor Cost/Year per Laborer 57,500 Total Labor Cost/Year 345,000.00 Capacity/year 48,000 Labor Cost/Unit 7.19 Admin Costs Cost/month 600 Annual Cost 7200 Occupancy Cost/year 33,000 Depreciation Cost/year 14,355 Acquisition Cost 100,000
Description Current Sales Projected Sales Dedicated Order Outsource or In-House Outsource Outsource In-House Period (months) 12 12 12 Sales Units/month 1,000 4,000 4,000 Yearly Sales 12,000 48,000 48,000 Price / Unit 11.00 10.50 10.50 Sales Value : 132,000 504,000 504,000 Variable costs: Forging Cost 108,000 432,000 Material Cost 17,400 69,600 69,600 Utility Cost 8,640 Supplies 5,280 Total variable costs 125,400 501,600 83,520 Total variable cost/Unit 10.45 10.45 1.74 Contribution margin 6,600 2,400 420,480 CM % of Sales 5.0% 0.5% 83.4% CM / Unit 0.55 0.05 8.76 Fixed Cost : Labor Cost 345,000 Occupancy Cost 33,000 Depreciation Cost 14,355 Utility - Fixed Cost / Year 20,736 Administration Cost/Year 7,200 Total Fixed costs 0 0 420,291 Total Fixed cost/Unit 0.00

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture