Considering the above, mathematically formulate the freight loading plan for the Noyina as an LP model. Implement the formulation in Excel following the goals and guidelines for good spreadsheet design and solve using solver. Generate the answer and sensitivity reports.

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%

Considering the above, mathematically formulate the freight loading plan for the Noyina as an LP model. Implement the formulation in Excel following the goals and guidelines for good spreadsheet design and solve using solver. Generate the answer and sensitivity reports. Then answer the following questions in Section B assuming each question as independent of the other questions unless explicitly referred to.

Case I: AAD Supply Operations
The Australian Antarctic Division (AAD) manages and delivers Australia's Antarctic Program. Three
year-round research stations, Casey, Davis, and Mawson are maintained in Antarctica to run scientific
and logistical operations together with a station at the sub-Antarctic Macquarie Island. Each year the
AAD charters ships and vessels for resupply and transport operations to these station bases.
https://www.antarctica.gov.au/about-us/
In the current season Southern Lights Logistics (SLL) operates an ice strengthened cargo ship the
"Noyina" for resupply operations and critical cargo delivery for the AAD.
Dave Ellis is managing cargo operations of the Noyina in its current resupply voyage at the Port of
Hobart in Tasmania. The AAD wants to transport four cargo types (C1 - C4) in relation to the four
classified categories "General Cargo", "Dangerous Goods", "Scientific Support" and "Personal Effects"
respectively aboard the vessel as follows.
Cargo Type
|૪૪૪૪
Amount Available
(tons)
4800
2500
1200
1700
Cargo Type
C1
C2
C3
C4
If the vessel departs the port of Hobart on time as scheduled, Southern Lights Logistics (SLL) can
achieve the following profit margins over the four cargo types. However, any delay will affect these
values on the order of 10% reduction in profit per day that the vessel is delayed due to associated
costs. Dave is confident that the ship can depart with one day delay due to an ongoing maintenance
issue.
Volume per ton (cubic
feet)
50
35
70
65
Profit per ton ($)
75
55
65
85
Dave is preparing the loading plan and can decide to load any amount or all the available cargo for
AAD. However, the Noyina has the following capacity restrictions in relation to its four cargo holds.
Transcribed Image Text:Case I: AAD Supply Operations The Australian Antarctic Division (AAD) manages and delivers Australia's Antarctic Program. Three year-round research stations, Casey, Davis, and Mawson are maintained in Antarctica to run scientific and logistical operations together with a station at the sub-Antarctic Macquarie Island. Each year the AAD charters ships and vessels for resupply and transport operations to these station bases. https://www.antarctica.gov.au/about-us/ In the current season Southern Lights Logistics (SLL) operates an ice strengthened cargo ship the "Noyina" for resupply operations and critical cargo delivery for the AAD. Dave Ellis is managing cargo operations of the Noyina in its current resupply voyage at the Port of Hobart in Tasmania. The AAD wants to transport four cargo types (C1 - C4) in relation to the four classified categories "General Cargo", "Dangerous Goods", "Scientific Support" and "Personal Effects" respectively aboard the vessel as follows. Cargo Type |૪૪૪૪ Amount Available (tons) 4800 2500 1200 1700 Cargo Type C1 C2 C3 C4 If the vessel departs the port of Hobart on time as scheduled, Southern Lights Logistics (SLL) can achieve the following profit margins over the four cargo types. However, any delay will affect these values on the order of 10% reduction in profit per day that the vessel is delayed due to associated costs. Dave is confident that the ship can depart with one day delay due to an ongoing maintenance issue. Volume per ton (cubic feet) 50 35 70 65 Profit per ton ($) 75 55 65 85 Dave is preparing the loading plan and can decide to load any amount or all the available cargo for AAD. However, the Noyina has the following capacity restrictions in relation to its four cargo holds.
Cargo Hold
Forward Hold
Center (Port) Hold
Center (Starboard) Hold
Rear Hold
Weight Capacity (tons)
3000
3000
3000
4000
Volume Capacity (cubic feet)
170,000
100,000
105,000
180,000
More than one AAD cargo type can be transported in the same hold. However, balance considerations
have enforced the following conditions to be applied.
Forward cargo hold weight must be within 15% of the rear cargo hold weight. The center cargo holds
must cumulatively hold between 45% to 55% of the total weight that is freighted on board the vessel.
Transcribed Image Text:Cargo Hold Forward Hold Center (Port) Hold Center (Starboard) Hold Rear Hold Weight Capacity (tons) 3000 3000 3000 4000 Volume Capacity (cubic feet) 170,000 100,000 105,000 180,000 More than one AAD cargo type can be transported in the same hold. However, balance considerations have enforced the following conditions to be applied. Forward cargo hold weight must be within 15% of the rear cargo hold weight. The center cargo holds must cumulatively hold between 45% to 55% of the total weight that is freighted on board the vessel.
Expert Solution
steps

Step by step

Solved in 2 steps with 5 images

Blurred answer
Similar questions
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.