chapter5 - Shipping Costs(dollars per unit Factory Location...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Shipping Costs (dollars per unit) Factory Location Spokane Peoria Yakima Newark Concord Albany $5.00 $4.50 $11.00 $2.50 $3.00 1000 Billings $3.00 $7.50 $4.00 $9.00 $7.00 2000 Charlotte $8.00 $5.00 $9.00 $4.00 $6.00 1500 Denver $4.00 $6.00 $7.00 $5.00 $6.00 3000 1000 2000 3000 1000 1000 Production Plan Factory Location Spokane Peoria Yakima Newark Concord Albany 100 200 100 100 100 600 Billings 100 100 300 100 100 700 Charlotte 100 100 100 400 100 800 Denver 100 100 100 100 50 450 400 500 600 700 350 $13,800.00 Warehouse Location Demand (units) Factory Production Capacity Warehouse Location Total units sent Total Produced Transport Cost schedule problem Page 2 mon tue wed thu fri sat sun total Number of people starting 4 3 5 10 9 4 2 37 Number of people workin 29 22 18 24 31 31 30 >= >= >= >= >= >= >= Number of people neede 14 13 11 9 14 18 18 Shipping Costs (dollars per unit) Production Plan Factory Location Spokane Peoria Yakima Newark Concord Total Albany 100 200 100 100 100 600 Billings 100 100 300 100 100 700 Charlotte 100 100 100 400 100 800 Denver 100 100 100 100 50 450 400 500 600 700 350 2550 Cost $2,000.00 $2,750.00 $3,900.00 $3,250.00 $1,900.00 $13,800.00 Warehouse Location Total Produced schedule problem (expanded) Page 4 mon tue wed thu fri sat sun total Number of people starting 4 3 5 10 9 4 2 37 Number of people workin 29 22 18 24 31 31 30 >= >= >= >= >= >= >= Number of people neede 14 13 11 9 14 18 18 Pay per FTE $80 $80 $80 $80 $80 $120 $150 Labor Cost $2,320 $1,760 $1,440 $1,920 $2,480 $3,720 $4,500 $18,140 x y z values 5 5 8 coefficients actual constraint 1 4 2 2 46 <= 20 constraint 2 2 11 5 105 >= 30 constraint 3 1 2 1 23 <= 25 objective 3 2 6 73 maximize exam 1 exam 2 exam 3 final weights 20% 20% 20% 40% scores weighted average student 1 76 76 98 49 69.6 student 2 98 66 75 49 67.4 student 3 97 71 94 54 74 student 4 93 81 98 91 90.8 student 5 70 76 66 53 63.6 student 6 90 80 98 65 79.6 student 7 70 75 76 73 73.4 student 8 80 96 77 40 66.6 student 9 80 88 65 29 58.2 student 10 71 74 79 66 71.2 AVERAGE 71.44 Hiring Cost $600 Firing Cost $900 Monthly Salary $2,000 500 January February March April 5 13 3 43 #workers hired 10 40 10 #workers fired 2 10 3 # working that month 13 3 43 50 6500 1500 21500 25000 >= >= >= >= #units needed 12000 30000 10000 20000 Total Hiring cost $6,000 $0 $24,000 $6,000 $36,000 Firing cost $1,800 $9,000 $0 $2,700 $13,500 Payroll cost $26,000 $6,000 $86,000 $100,000 $218,000 Total $33,800 $15,000 $110,000 $108,700 $267,500 Data per worker # units produced per month workforce analysis #workers at end of previous month production analysis # units that can be produced by workforce Cost Analysis Kona Columbian Chickory total blend proportions 10%...
View Full Document

This note was uploaded on 06/08/2008 for the course MTH 245 taught by Professor Pratt during the Spring '07 term at Linn Benton Community College.

Page1 / 29

chapter5 - Shipping Costs(dollars per unit Factory Location...

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

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