HW#4.2010W.sol.markers

HW#4.2010W.sol.markers - A B C D E F G H 1 Question 1 2...

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

View Full Document Right Arrow Icon
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 ABC D EFGH Question 1 Winston SMA 3.32 Input Data Week1 Week2 Week3 I1 I2 !3 Beg Inv = 5 Demand 20 10 15 Production Costs 13.00 $ 14.00 $ 15.00 $ Inventory Costs 2.00 $ 2.00 $ 2.00 $ Production available to meet this weeks demand 50% 2 marks Action Plan Week1 Week2 Week3 Production 30 10 0 1 mark 5 marks On hand after Prod 35 25 15 (headings) Avail to meet demand 20 20 15 >= >= >= 3 marks Demand 20 10 15 Ending Inventory 15 15 0 1 mark Total Cost Week1 Week2 Week3 Total Production 390.00 $ 140.00 $ - $ 530.00 $ Inventory 30.00 $ 30.00 $ - $ 60.00 $ 3 marks 590.00 $ 5 marks 5 marks Target Cell: G33 Changing Cells: D20:F20 Constraints: D23:F23 >= D25:F25 Optimal Solution: Produce: 30 items in Week 1 10 items in Week 2 0 items in Week 3 This sheet is worth 25 marks . See attached for additional marking information 2 marks if they only show G30:G33 for the Total Cost -2 marks if printed in Landscape orientation
Background image of page 1

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

View Full DocumentRight Arrow Icon
Question 1 Marking Guide: * This sheet is worth 25 marks for the Excel model * In addition to the marks shown above: *
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.

Page1 / 4

HW#4.2010W.sol.markers - A B C D E F G H 1 Question 1 2...

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