Fig3-31 - C7:H7>=C11:H11 C7:H7<=C12:H12 C9:H9>=C14:H14 C9:H9<=C15:H15 begin inventory 2750 5750 4750 2750 1500 2000 units produced 4000

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

View Full Document Right Arrow Icon
Production Report Page 1 M o n t h 1 2 3 4 5 6 Beginning Inventory 2,750 1,750 -2,750 -8,750 -14,250 -17,750 Units Produced 0 0 0 0 0 0 Units Demanded 1,000 4,500 6,000 5,500 3,500 4,000 Ending Inventory 1,750 -2,750 -8,750 -14,250 -17,750 -21,750 Minimum Production 2,000 1,750 2,000 2,250 2,000 1,750 Maximum Production 4,000 3,500 4,000 4,500 4,000 3,500 Minimum Inventory 1,500 1,500 1,500 1,500 1,500 1,500 Maximum Inventory 6,000 6,000 6,000 6,000 6,000 6,000 Unit Production Cost $240 $250 $265 $285 $280 $260 Unit Carrying Cost 1.5% $3.60 $3.75 $3.98 $4.28 $4.20 $3.90 Monthly Production Cost $0 $0 $0 $0 $0 $0 Monthly Carrying Cost $8,100 -$1,875 -$22,856 -$49,163 -$67,200 -$77,025 Total Cost -$210,019 Minimize: By Changi Subject t Upton Manufacturing
Background image of page 1

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

View Full DocumentRight Arrow Icon
Production Report Page 2 : H23 ing: C7:H7 to:
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: C7:H7>=C11:H11 C7:H7<=C12:H12 C9:H9>=C14:H14 C9:H9<=C15:H15 begin inventory 2750 5750 4750 2750 1500 2000 units produced 4000 3500 4000 4250 4000 3500 units demanded 1000 4500 6000 5500 3500 4000 end inventory 5750 4750 2750 1500 2000 1500 min production 2000 1750 2000 2250 2000 1750 max production 4000 3500 4000 4500 4000 3500 min inventory 1500 1500 1500 1500 1500 1500 max inventory 6000 6000 6000 6000 6000 6000 unit production 240 250 265 285 280 260 0.02 3.6 3.75 3.98 4.28 4.2 3.9 monthly production 960000 875000 1060000 1211250 1120000 910000 monthly inventory 15300 19687.5 14906.25 9084.37 7350 6825 ###...
View Full Document

This note was uploaded on 09/13/2009 for the course ENGINEERIN 0130661848 taught by Professor Nel during the Spring '09 term at Stellenbosch University-South Africa.

Page1 / 3

Fig3-31 - C7:H7>=C11:H11 C7:H7<=C12:H12 C9:H9>=C14:H14 C9:H9<=C15:H15 begin inventory 2750 5750 4750 2750 1500 2000 units produced 4000

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