Ch13Ex5 - En de Fo Trans_agg Page 2 Total Cost 0 Trans_agg...

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

View Full Document Right Arrow Icon
Trans_agg Page 1 CHAPTER 13: Example 5 Aggregate (Production) Planning as a Transportation Model Cost per unit Regular time 40  Overtime cost 50  Subcontract cost 70  Holding cost Data COSTS March April Beginning inventory March reg time 40  42  March overtime 50  52  March subcontracting 70  72  April reg time 999999  40  April overtime 999999  50  April subcontracting 999999  70  May reg time 999999  999999  May overtime 999999  999999  May subcontracting 999999  999999  Demand 800  1000  Production Quantities March April Beginning inventory 0 0 March reg time 0 0 March overtime 0 0 March subcontracting 0 0 April reg time 0 0 April overtime 0 0 April subcontracting 0 0 May reg time 0 0 May overtime 0 0 May subcontracting 0 0 Column Total 0 0  
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

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

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

Unformatted text preview: En de Fo Trans_agg Page 2 Total Cost 0 Trans_agg Page 3 May Excess CaCapacity 4 6 100 44 0 700 54 0 50 74 0 150 42 0 700 52 0 50 72 0 150 40 0 700 50 0 50 70 0 130 750 230 2550 \ 2780 May Excess CaRow Total nter production costs at top. The transportation table will be automatically filled in. Enter capacities and emands in the table. Go to DATA Tab on the ribbon, click on Solver in Data Analysis Group then click SOLVE. or problems, see Help, Solver. Trans_agg Page 4...
View Full Document

This note was uploaded on 11/24/2010 for the course QUANT DSCI taught by Professor B during the Fall '10 term at Fairleigh Dickinson.

Page1 / 4

Ch13Ex5 - En de Fo Trans_agg Page 2 Total Cost 0 Trans_agg...

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