ISE 410 hw 3

ISE 410 hw 3 - Total cost= $681,250.00 3c) period beginning...

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

View Full Document Right Arrow Icon
3a) initial inventory= 50 inventory cost= 25 backorder cost= 50 production cost= 500 Present capacity= 110 capacity change cost= 125 period beginning Production Demand end backorders inventory inventory 1 50 103 50 103 0 2 103 103 60 146 0 3 146 103 55 194 0 4 194 103 100 197 0 5 197 103 50 250 0 6 250 103 45 308 0 7 308 103 40 371 0 8 371 103 70 404 0 9 404 103 95 412 0 10 412 103 260 255 0 11 255 103 240 118 0 12 118 103 210 11 0 sum 1236 1275 2769 Production cost= $618,000.00 =C23*500 Inventory cost= $69,225.00 =E23*25 Change in capacity cost= $875.00 =D6*(D5-C11) Total cost= $688,100.00 3b) period beginning Production Demand end backorders inventory inventory
Background image of page 1

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

View Full DocumentRight Arrow Icon
1 50 0 50 0 0 2 0 60 60 0 0 3 0 55 55 0 0 4 0 100 100 0 0 5 0 50 50 0 0 6 0 45 45 0 0 7 0 40 40 0 0 8 0 70 70 0 0 9 0 95 95 0 0 10 0 260 260 0 0 11 0 240 240 0 0 12 0 210 210 0 0 sum 1225 1275 Production cost= $612,500.00 =C66*500 Change in capacity cost= $68,750.00 =125*((110-0)+(60-0)+(60-55)+(100-55)+(100-50 (50-45)+(45-40)+(70-40)+(95-70)+(260-95)+(260 +(240-210))
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
Background image of page 5

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

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

Unformatted text preview: Total cost= $681,250.00 3c) period beginning Production Demand end backorders capacity inventory inventory change 1 50 53 50 53 57 2 53 53 60 46 3 46 53 55 44 4 44 53 100 3 5 53 50 6 53 45 8 7 8 53 40 21 8 21 53 70 4 9 4 171 95 80 118 10 80 210 260 30 39 11 30 210 240 12 210 210 sum 1225 1275 286 3 214 Production cost= $612,500.00 =C112*500 Change in capacity cost= $26,750.00 =G112*125 Inventory cost= $7,150.00 =E112*25 Backorder cost $150.00 =G112*50 Total cost= $646,550.00 0)+ 0-240)...
View Full Document

This note was uploaded on 02/12/2010 for the course ISE 410 at USC.

Page1 / 6

ISE 410 hw 3 - Total cost= $681,250.00 3c) period beginning...

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

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