Help with Optimization and Decision Support Modeling for Business HW2

profileRedhand
M3-1_PracticeProblems_Ch3_Solution.xlsx
Home>Business & Finance homework help>Operations Management homework help>Help with Optimization and Decision Support Modeling for Business HW2

Ch3_Prob1

Cargo 1 Cargo 2 Cargo 3 Cargo 4
Volume (cf/ton) 500 700 600 400
Profit (per ton) $320 $400 $360 $290
Cargo Total Weight Total Volume
Placement (tons) Cargo 1 Cargo 2 Cargo 3 Cargo 4 Weight Capacity Volume Capacity
Front 0 7.333 0 4.667 12 <= 12 7,000 <= 7,000
Center 12.9999999994 1.667 0 3.333 17.9999999999 <= 18 9,000 <= 9,000
Back 0 0 5.0000000001 4.9999999998 9.9999999999 <= 10 5,000 <= 5,000
Total 12.9999999994 9.0000000003 5.0000000001 13
<= <= <= <= Total Profit
Available (tons) 20 16 25 13 $13,330
Percentage of Front Capacity 100% = 100% Percentage of Middle Capacity
Percentage of Front Capacity 100% = 100% Percentage of Back Capacity

Ch3_Prob2

Month Covered by Lease? Total Space
Month of Lease: 1 1 1 1 1 2 2 2 2 3 3 3 4 4 5 Leased Required
Length of Lease: 1 2 3 4 5 1 2 3 4 1 2 3 1 2 1 (sq. ft.) (sq. ft.)
Month 1 1 1 1 1 1 30,000 >= 30,000
Month 2 1 1 1 1 1 1 1 1 30,000 >= 20,000
Month 3 1 1 1 1 1 1 1 1 1 40,000 >= 40,000
Month 4 1 1 1 1 1 1 1 1 30,000 >= 10,000
Month 5 1 1 1 1 1 50,000 >= 50,000
Cost of Lease $65 $100 $135 $160 $190 $65 $100 $135 $160 $65 $100 $135 $65 $100 $65
(per sq. ft.)
Total Cost
Lease (sq. ft.) 0 0 0 0 30,000 0 0 0 0 10,000 0 0 0 0 20,000 $7,650,000

Ch3_Prob3

Men's Women's Children's
Gross Profit $8 $10 $6
(per glove)
Full Time Part Time
Labor Cost (per hour) $13 $10
Hours worked per week 40 20
Labor Cost (per week) $520 $200
Resource Usage Resource Resource
per Unit of Activity Used Available
Material (sq. ft.) 2 1.5 1 4960 <= 5000
Labor (minutes) 30 45 40 74400 <= 74,400
Men's Women's Children's
Production (per week) 2480 0 0
Gross Profit $19,840
Full Time Part Time Labor Cost $15,400
Employees 25 12 Net Profit $4,440
>=
Minimum Full Time 20
2
Full Time 25 >= 24 Times Part-Time

Ch3_Prob4

AED Production and Distribution
Unit
Shipping Production Range Name Cells
Cost (per unit) Warehouse 1 Warehouse 2 Warehouse 3 Cost MonthlyCapacity H11:H12
Plant A $22 $14 $30 $600 MonthlyDemand C15:E15
Plant B $16 $20 $24 $625 OverallCost H18
UnitShippingCost C5:E6
Total TotalProductionCost H16
Units Shipped Monthly TotalShippedOut F11:F12
Shipped Warehouse 1 Warehouse 2 Warehouse 3 Out Capacity TotalShippingCost H17
Plant A 40 60 0 100 <= 100 TotalToWarehouse C13:E13
Plant B 40 0 70 110 <= 120 UnitProductionCost H5:H6
Total to Warehouse 80 60 70 UnitsShipped C11:E12
= = =
Monthly Demand 80 60 70
Total Production Cost $128,750
Total Shipping Cost $4,040
Overall Cost $132,790

Ch3_Prob5

Distance (miles) Distribution Center
1 2 3 4
1 800 1,300 400 700
Plant 2 1,100 1,400 600 1,000
3 600 1,200 800 900
Fixed Cost $100
Cost per Mile $0.50
Unit Cost Distribution Center
1 2 3 4
1 $500 $750 $300 $450
Plant 2 $650 $800 $400 $600
3 $400 $700 $500 $550
Shipments Distribution Center
1 2 3 4 Total Shipped Supply
1 0 0 2 10 12 = 12
Plant 2 0 9 7.9999999997 0 16.9999999997 = 17
3 10 1 0 0 11 = 11
Total Received 10 10 9.9999999997 10
= = = = Total Cost
Demand 10 10 10 10 $20,200

Ch3_Prob6

Unit Profit Customer
1 2 3 4
1 $800 $700 $500 $200
Plant 2 $500 $200 $100 $300
3 $600 $400 $300 $500
Shipments Customer
1 2 3 4 Total Shipped Supply
1 0 60.0000000001 0 0 60.0000000001 = 60
Plant 2 40 0 0 40.0000000001 80.0000000001 = 80
3 0 0 20 20.0000000008 40.0000000008 = 40
Total Received 40 60.0000000001 20 60.0000000009
= = >= Total Cost
Commitment 40 60 20 $90,000

Ch3_Prob7

Unit Cost Job
1 2 3
A $5 $7 $4
Person B $3 $6 $5
C $2 $3 $4
Assignments Job Total
1 2 3 Assignments Supply
A 0 0 1 1 = 1
Person B 1 0 0 1 = 1
C 0 1 0 1 = 1
Total Assigned 1 1 1
= = = Total Cost
Demand 1 1 1 $10

Ch3_Prob8

Bidding for Classes
Management Operations Range Name Cells
Points Science Finance Management Marketing Assignment C18:F27
George 60 10 10 20 Capacity C30:F30
Fred 20 20 40 20 ClassesToTake I18:I27
Ann 45 45 5 5 Points C5:F14
Eric 50 20 5 25 StudentPoints K18:K27
Susan 30 30 30 10 TotalClasses G18:G27
Liz 50 50 0 0 TotalInClass C28:F28
Ed 70 20 10 0 TotalPoints I29
David 25 25 35 15
Tony 35 15 35 15
Jennifer 60 10 10 20
Management Operations Total Classes Student
Assignment Science Finance Management Marketing Classes to Take Points
George 1 0 0 1 2 = 2 80
Fred 0 0 1 1 2 = 2 60
Ann 1 1 0 0 2 = 2 90
Eric 0 1 0 1 2 = 2 45
Susan 0 1 1 0 2 = 2 60
Liz 1 1 0 0 2 = 2 100
Ed 1 0 1 0 2 = 2 80
David 0 1 1 0 2 = 2 60
Tony 0 0 1 1 2 = 2 50
Jennifer 1 0 0 1 2 = 2 80
Total in Class 5 5 5 5
<= <= <= <= Total Points 705
Capacity 5 5 5 5