Merton TruckCompany

Merton TruckCompany - Total Profit (before fixed overhead)...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Total Profit (before fixed overhead) $11,000,000 Model 101 Model 102 Selling price $39,000 $38,000 Direct materials $24,000 $20,000 Direct labor $4,000 $4,500 Variable overhead $8,000 $8,500 Profit (before fix overhead) $3,000 $5,000 Units to manufacture 2000 1000 Resource Availability LHS RHS Engine assembly 1 2 4000 <= 4000 Metal stamping 2 2 6000 <= 6000 Model 101 assembly 2 4000 <= 5000 Model 102 assembly 3 3000 <= 4500
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Merton TruckCompany.xlsx]Model Report Created: 12/28/2007 11:11:11 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 Units to manufacture Model 101 2000 0 3000 2000 500 $C$11 Units to manufacture Model 102 1000 0 5000 1000 2000 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$14 Engine assembly 4000 2000 4000 500 500 $D$15 Metal stamping 6000 500 6000 500 1000 $D$16 Model 101 assembly 4000 0 5000 1.00E+030 1000 $D$17 Model 102 assembly 3000 0 4500 1.00E+030 1500
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/04/2011 for the course BUSI 410 at UNC.

Page1 / 4

Merton TruckCompany - Total Profit (before fixed overhead)...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online