11 Cut Copy Format Painter Calibri BI AA -A Wrap Test Mergea Center - D E 99 0 4 O E EEE $ -% Conditional Formats In forme L M N O P Q R 5 TU Hired L aid-Off Workers O1 nentory Stockout Subcontra Production Demand Lap t ory Ovem Labor os recured 2002 200 red $0 3 3 3 Laid-Off Reg Time Of SO SR.000 $40,000 SO S40,960 SO S O 940 960 So $0 $40,960 $0 $0 $40,960 $0 $0 $40,960 $0 $1,000 $245,760 Inventory Stockout Subcontra Material SO $25,600 SO $25,600 SO $25,600 $0 $25,600 $25,600 so $25,600 SO $153,600 3 3 3 SO $0 3 Cost $407,360.00 Sheet1 Sheet2 os and press ENTER chose Paste Type here to search DELL Conditional formats rer Delete format ter Select- M N O P 0 eriod Hired taid Off Workers OT w entory Stockout Subcontra Production Demand 510 640 2560 2560 2560 2560 2560 2560 1500 3000 3.200 3800 2.200 2.200 r etor So $0 $0 $0 SO SO 18 taid of Reg Time OT $8,000 $10,000 O $40.960 $0 $40,960 SO S40 550 SO S40,960 SO S40,960 S8,000 $245,760 inventory Stockout Subcontra Material SO SO $35.500 SO $0 $25,600 So So SO $25.600 SO $0 $25,600 $0 So $25.600 SO S25,600 $0 SO $153,600 8 8 8 8 3 SO al Cost $407.160.00 Sheet1 Sheet2 mation and press ENTER or choose Type here to search DOLL LB C D E F J K L M N O P Period Hired Laid-Off Workers OT Inventory Stockout Subcontra Production Demand Workforce Capacity inventory Overtime 1,960 440 -640 2560 2560 2560 2560 2560 2560 1,600 3,000 3,200 3,800 2.200 2,200 640 640 640 640 640 640 -1,240 360 360 O Period Hired $0 $0 $0 Laid-Off Reg Time OT $0 $8,000 $40,960 $0 $0 $40,960 $0 $0 $40,960 $0 $0 $40,960 $0 $40,960 $0 $0 $40,960 So $8,000 $245,760 Inventory Stockout Subcontra Material $25,600 $25,600 $0 $25,600 $25,600 $25,600 $25,600 SO $153,600 Total Cost $407,360.00 | Sheet1 Sheet2 1 destination and press ENTER or choose Paste Type here to search o te OEM AutoSum - D as Cell - Styles E E ! Insert Delete Format 47 O Sort & Find & Filter Select Ideas Sensit Clear Cells Editing Ideas Sensiti Item time Material cost 640 640 640 640 640 Inventory holding cost Marginal cost of stockout/backlog Hiring and training costs Layoff cost Labor hours required Initial inventory Available days Regular time available Regular time cost Overtime cost Cost of subcontracting Overtime available Cost $10 /unit $2 /unit/month | $5 /unit/month $300 worker $500 /worker 4 /unit | 1000 units 20 /month 8 hours/day $4 /hour $6 /hour $30 /unit 10 worker/month 640 11 Cut Copy Format Painter Calibri BI AA -A Wrap Test Mergea Center - D E 99 0 4 O E EEE $ -% Conditional Formats In forme L M N O P Q R 5 TU Hired L aid-Off Workers O1 nentory Stockout Subcontra Production Demand Lap t ory Ovem Labor os recured 2002 200 red $0 3 3 3 Laid-Off Reg Time Of SO SR.000 $40,000 SO S40,960 SO S O 940 960 So $0 $40,960 $0 $0 $40,960 $0 $0 $40,960 $0 $1,000 $245,760 Inventory Stockout Subcontra Material SO $25,600 SO $25,600 SO $25,600 $0 $25,600 $25,600 so $25,600 SO $153,600 3 3 3 SO $0 3 Cost $407,360.00 Sheet1 Sheet2 os and press ENTER chose Paste Type here to search DELL Conditional formats rer Delete format ter Select- M N O P 0 eriod Hired taid Off Workers OT w entory Stockout Subcontra Production Demand 510 640 2560 2560 2560 2560 2560 2560 1500 3000 3.200 3800 2.200 2.200 r etor So $0 $0 $0 SO SO 18 taid of Reg Time OT $8,000 $10,000 O $40.960 $0 $40,960 SO S40 550 SO S40,960 SO S40,960 S8,000 $245,760 inventory Stockout Subcontra Material SO SO $35.500 SO $0 $25,600 So So SO $25.600 SO $0 $25,600 $0 So $25.600 SO S25,600 $0 SO $153,600 8 8 8 8 3 SO al Cost $407.160.00 Sheet1 Sheet2 mation and press ENTER or choose Type here to search DOLL LB C D E F J K L M N O P Period Hired Laid-Off Workers OT Inventory Stockout Subcontra Production Demand Workforce Capacity inventory Overtime 1,960 440 -640 2560 2560 2560 2560 2560 2560 1,600 3,000 3,200 3,800 2.200 2,200 640 640 640 640 640 640 -1,240 360 360 O Period Hired $0 $0 $0 Laid-Off Reg Time OT $0 $8,000 $40,960 $0 $0 $40,960 $0 $0 $40,960 $0 $0 $40,960 $0 $40,960 $0 $0 $40,960 So $8,000 $245,760 Inventory Stockout Subcontra Material $25,600 $25,600 $0 $25,600 $25,600 $25,600 $25,600 SO $153,600 Total Cost $407,360.00 | Sheet1 Sheet2 1 destination and press ENTER or choose Paste Type here to search o te OEM AutoSum - D as Cell - Styles E E ! Insert Delete Format 47 O Sort & Find & Filter Select Ideas Sensit Clear Cells Editing Ideas Sensiti Item time Material cost 640 640 640 640 640 Inventory holding cost Marginal cost of stockout/backlog Hiring and training costs Layoff cost Labor hours required Initial inventory Available days Regular time available Regular time cost Overtime cost Cost of subcontracting Overtime available Cost $10 /unit $2 /unit/month | $5 /unit/month $300 worker $500 /worker 4 /unit | 1000 units 20 /month 8 hours/day $4 /hour $6 /hour $30 /unit 10 worker/month 640