Can you check my work and tell me why I am not getting the answer $9100? Model Inc. has to transport 100 bags of Type A bags, 100 bags of Type B bags, and 100 bags of Type C bags. They can hire Truck and Mini vans. Each truck can carry 10 bags of Type A bags, 20 bags of Type B bags, and 10 bags of Type C bags. On the other hand, each minivan can carry 20 bags of Type A bags, 5 bags of Type B bags, and 10 bags of Type C bags. Each truck's rental cost is $1000, and each minivan's rental cost is $850. There are only 5 truck drivers available to drive the trucks(Hint: It means the number of trucks should be less than or equal to 5). If Model Inc wants to minimize the transportation cost, how many trucks and vans should they rent? (Possible Answer: $9100) Data A B C COST TRUCK 10 20 10 $ 1,000.00 MINIVAN 20 5 10 $ 850.00 Model Decision Variables # of TRUCK 0 x MINIVAN 0 y Objective Function min cost $ $ - =SUMPRODUCT(F4:F5,D12:D13) Constraints LS Relation RS [Name] = E12 0 LTE 0 [NN X] = E13 0 LTE 0 [NN Y] =SUMPRODUCT(D4:D5,E12:E13) 0 GTE 100 [A BAGS] =SUMPRODUCT(E4:E5,E12:E13) 0 GTE 100 [B BAGS] =SUMPRODUCT(F4:F5,E12:E13) 0 GTE 100 [C BAGS] = E12 0 LTE 5 [MAX TRUCK DRIVERS]
Can you check my work and tell me why I am not getting the answer $9100? Model Inc. has to transport 100 bags of Type A bags, 100 bags of Type B bags, and 100 bags of Type C bags. They can hire Truck and Mini vans. Each truck can carry 10 bags of Type A bags, 20 bags of Type B bags, and 10 bags of Type C bags. On the other hand, each minivan can carry 20 bags of Type A bags, 5 bags of Type B bags, and 10 bags of Type C bags. Each truck's rental cost is $1000, and each minivan's rental cost is $850. There are only 5 truck drivers available to drive the trucks(Hint: It means the number of trucks should be less than or equal to 5). If Model Inc wants to minimize the transportation cost, how many trucks and vans should they rent? (Possible Answer: $9100) Data A B C COST TRUCK 10 20 10 $ 1,000.00 MINIVAN 20 5 10 $ 850.00 Model Decision Variables # of TRUCK 0 x MINIVAN 0 y Objective Function min cost $ $ - =SUMPRODUCT(F4:F5,D12:D13) Constraints LS Relation RS [Name] = E12 0 LTE 0 [NN X] = E13 0 LTE 0 [NN Y] =SUMPRODUCT(D4:D5,E12:E13) 0 GTE 100 [A BAGS] =SUMPRODUCT(E4:E5,E12:E13) 0 GTE 100 [B BAGS] =SUMPRODUCT(F4:F5,E12:E13) 0 GTE 100 [C BAGS] = E12 0 LTE 5 [MAX TRUCK DRIVERS]
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Can you check my work and tell me why I am not getting the answer $9100?
- Model Inc. has to transport 100 bags of Type A
bags, 100 bags of Type B bags, and 100 bags
of Type C bags. They can hire Truck and Mini
vans. Each truck can carry 10 bags of Type A
bags, 20 bags of Type B bags, and 10 bags of
Type C bags. On the other hand, each minivan
can carry 20 bags of Type A bags, 5 bags of
Type B bags, and 10 bags of Type C bags. Each
truck's rental cost is $1000, and each
minivan's rental cost is $850. There are only 5
truck drivers available to drive the trucks(Hint:
It means the number of trucks should be less
than or equal to 5). If Model Inc wants to
minimize the transportation cost, how many
trucks and vans should they rent? (Possible
Answer: $9100)
| Data | ||||||||
| A | B | C | COST | |||||
| TRUCK | 10 | 20 | 10 | $ 1,000.00 | ||||
| MINIVAN | 20 | 5 | 10 | $ 850.00 | ||||
| Model | ||||||||
| Decision Variables | ||||||||
| # of | ||||||||
| TRUCK | 0 | x | ||||||
| MINIVAN | 0 | y | ||||||
| Objective Function | ||||||||
| min cost $ | $ - | =SUMPRODUCT(F4:F5,D12:D13) | ||||||
| Constraints | ||||||||
| LS | Relation | RS | [Name] | |||||
| = E12 | 0 | LTE | 0 | [NN X] | ||||
| = E13 | 0 | LTE | 0 | [NN Y] | ||||
| =SUMPRODUCT(D4:D5,E12:E13) | 0 | GTE | 100 | [A BAGS] | ||||
| =SUMPRODUCT(E4:E5,E12:E13) | 0 | GTE | 100 | [B BAGS] | ||||
| =SUMPRODUCT(F4:F5,E12:E13) | 0 | GTE | 100 | [C BAGS] | ||||
| = E12 | 0 | LTE | 5 | [MAX TRUCK DRIVERS] | ||||
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.