HW2 - #12 The Beaver Creek Pottery Company Products: A...

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

View Full Document Right Arrow Icon
#12 The Beaver Creek Pottery Company Products: A B Profit per uni 9 7 Resources Resources: Usage onstrainvailablLeft over Line 1 12 4 60 <= 60 0 Line 2 4 8 40 <= 40 0 Production: A= 4 B= 3 Profit = 57 #34Boats Z ### 205 190 Constraints Usage ConstrRequiLeft 1 10 15 8 0 <= 610 610 2 1 -3 0 0 <= 0 0 3 ### ### ### 0 >= 0 0 4 0 1 -1 0 >= 0 0 5 1 1 1 0 >= 0 0 #42 Milk OwnLocaNational Cost Pe### 0.83 0.69 Constraints Usage ConstrRequiLeft Capacit 1 1 1 64 <= 324 260 Nationa -1 -1 1 50 >= 0 -50 Nationa -3 0 1 45 >= 0 -45 Local D 0 1 0 3 <= 120 117 Own 54 x 1 x 2 x 3
Background image of page 1

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

View Full DocumentRight Arrow Icon
Local ### Nationa### Max Z 253.8 #10 Boats BasSki Speed Cost Pe### ### ### Constraints Usage ConstrRequiLeft Req (Ba 1 0 0 0 >= 70 70 Req (Sk 0 1 0 0 >= 50 50 Req (Sp 0 0 1 0 >= 50 50 Demand 1 0 0 0 <= 120 120 Deamnd 0 1 0 0 <= 120 120 Demand 0 0 1 0 <= 120 120 Break-E### ### ### 0 "=" ### ### Bass 70 Ski ### Speed ### Cost 2925284.55 #14Amount### 0.25 0.32 0.22 0.2 0.24 Constraints Ore 1 2 3 4 5 6 Usage ConReqLeft A ### 0.43 0.17 0.2 0 0.12 29.2 >=### ### B ### 0.1 0 0.12 0.24 0.18 18.6 <=### ### C ### 0.25 0 0 0.1 0.16 1.6 <=### ### D ### 0.07 0.53 0.18 0.31 0.25 27.7 <=### ### D' ### 0.07 0.53 0.18 0.31 0.25 27.7 >=### ### 1-impur 0.6 0.85 0.7 0.5 0.65 0.71 77.1 "=" 1 ###
Background image of page 2
Ore 1 0 Ore 2 ### Ore 3 ### Ore 4 ### Ore 5 ### Ore 6 0 Min Z 0.4
Background image of page 3

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

View Full DocumentRight Arrow Icon
The Beaver Creek Pottery Company Products: A B Profit per unit: 9 7 Resources Resources: Usage Constraint Available Left over Line 1 12 4 60 <= 60 0 Line 2 4 8 40 <= 40 0 Production: A= 4 B= 3 Profit = 57 Microsoft Excel 12.0 Answer Report Worksheet: [Chapter 3 Number 12.xlsx]Sheet1 Report Created: 2/16/2011 5:16:32 PM Target Cell (Max) Cell Name Original Value
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/23/2011 for the course MARKETING 3104 at Virginia Tech.

Page1 / 12

HW2 - #12 The Beaver Creek Pottery Company Products: A...

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

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