3. Fly-R-Us cargo plane transportation company has hired you as their Operations Research Analyst, and here is your chance to show them you are worth keeping. cargo, namely, front, center, and back. These compartments have capacity limits on both weight The company owns several cargo airplanes; each cargo plane has three compartments for storing and space, as summarized in Table 1. Compartments Front Center Back Table 1: Table of Capacities Weight Capacity (Tons) Space Capacity (Cubic Feet) Furthermore, the weight of the cargo in the respective compartment must be the same proportion of that compartment's weight capacity to maintain the balance of the airplane. Cargo Types There are four types of cargo and their available amounts (in weights), that have been offered to Fly- R-Us for shipment on an upcoming flight as space is available. Table 2 gives the details on the available amounts of the four types of cargo, the cargoes' attributes, and their unit profits. Package Chest 12 18 10 Table 2: Table of available cargo and their attributes Volume Amount Offered (Weight in Tons) (Cubic feet per ton) 13. 400 700 500 600 Box Crate 7,000 9,000 5,000 16 20 25 Profit $ per ton 290 400 320 360 Any portion of these cargoes can be accepted. The objective is to determine how much (if any) of each cargo should be accepted and how to distribute each cargo among the compartments of a cargo plane, to maximize total profit for the flight.

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...
icon
Related questions
Question
100%
3. Fly-R-Us cargo plane transportation company has hired you as their Operations Research
Analyst, and here is your chance to show them you are worth keeping.
cargo, namely, front, center, and back. These compartments have capacity limits on both weight
The company owns several cargo airplanes; each cargo plane has three compartments for storing
and space, as summarized in Table 1.
Compartments
Front
Center
Back
Table 1: Table of Capacities
Weight Capacity (Tons) Space Capacity (Cubic Feet)
Furthermore, the weight of the cargo in the respective compartment must be the same proportion of
that compartment's weight capacity to maintain the balance of the airplane.
Cargo Types
12
18
10
offered to Fly-
R-Us for shipment on an upcoming flight as space is available. Table 2 gives the details on the
available amounts of the four types of cargo, the cargoes' attributes, and their unit profits.
Package
Chest
Box
Crate
Table 2: Table of available cargo and their attributes
Amount Offered
(Weight in Tons)
13
16
20
25
7,000
9,000
5.000
Volume
(Cubic feet per ton)
400
700
500
600
Profit S per ton
290
400
320
360
Any portion of these cargoes can be accepted. The objective is to determine how much (if any) of
each cargo should be accepted and how to distribute each cargo among the compartments of a cargo
plane, to maximize total profit for the flight.
Transcribed Image Text:3. Fly-R-Us cargo plane transportation company has hired you as their Operations Research Analyst, and here is your chance to show them you are worth keeping. cargo, namely, front, center, and back. These compartments have capacity limits on both weight The company owns several cargo airplanes; each cargo plane has three compartments for storing and space, as summarized in Table 1. Compartments Front Center Back Table 1: Table of Capacities Weight Capacity (Tons) Space Capacity (Cubic Feet) Furthermore, the weight of the cargo in the respective compartment must be the same proportion of that compartment's weight capacity to maintain the balance of the airplane. Cargo Types 12 18 10 offered to Fly- R-Us for shipment on an upcoming flight as space is available. Table 2 gives the details on the available amounts of the four types of cargo, the cargoes' attributes, and their unit profits. Package Chest Box Crate Table 2: Table of available cargo and their attributes Amount Offered (Weight in Tons) 13 16 20 25 7,000 9,000 5.000 Volume (Cubic feet per ton) 400 700 500 600 Profit S per ton 290 400 320 360 Any portion of these cargoes can be accepted. The objective is to determine how much (if any) of each cargo should be accepted and how to distribute each cargo among the compartments of a cargo plane, to maximize total profit for the flight.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 5 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.