witte - J. Quasney Lab 8-2 Witte Lawn Equipment Mower...

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

View Full Document Right Arrow Icon
J. Quasney Lab 8-2 Witte Lawn Equipment Mower Production Planning Witte Lawn Equipment Mower Production Planning Hours of Labor per Unit 38 47 52 Value of Material per Unit $128 $213 $543 Units to Manufacture 20 20 65 Total Hours for the Week 760 940 3,380 Total Value of Material for the Week $2,560 $4,250 $35,295 Electric Lawn Mower Power Lawn Mower Riding Garden Tractor
Background image of page 1

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

View Full DocumentRight Arrow Icon
J. Quasney Lab 8-2 Witte Lawn Equipment Mower Production Planning 73 $650 Totals 17 122 1,241 6,321 $11,050 $53,155 Riding Lawn Tractor
Background image of page 2
Microsoft Excel 14.0 Answer Report Worksheet: [Witte Lawn Equipment.xlsx]Mower Production Planning Report Created: 5/12/2011 10:29:18 AM Objective Cell (Max) Cell Name Original Value Final Value $F$8 Units to Manufacture Totals 0 120 Variable Cells Cell Name Original Value Final Value Integer $B$8 Units to Manufacture Electric Lawn Mower 0 20 Integer $C$8 Units to Manufacture Power Lawn Mower 0 20 Integer $D$8 Units to Manufacture Riding Garden Tractor 0 65 Integer $E$8 Units to Manufacture Riding Lawn Tractor
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

witte - J. Quasney Lab 8-2 Witte Lawn Equipment Mower...

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

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