List all assumptions you got directly from the question description in order to complete (a) - (c).
Fantastic news! We've Found the answer you've been seeking!
Question:
List all assumptions you got directly from the question description in order to
complete (a) - (c). List and justify all additional assumptions you needed to make. I have attached the answers of (a) - (c) along with the questions. Please answer it from mathematics viewpoints correctly.
Transcribed Image Text:
1. Paul Bergey is in charge of loading cargo ships for International Cargo Company (ICC) at the port in Brisbane. Paul is preparing a loading plan for an ICC freighter destined for US. An agriculture cargos dealer wants to transport the following cargo products aboard this ship. Paul learned that this ship has space to take 480,000 cubic feet of cargo, and also has a cargo weight limit of 13,000 tons. Paul can elect to load any of the available cargos shown in the table below. Cargo 1234 4 Amount Available (tons) 4800 5000 1200 1700 Volume per Ton of the cargo (cubic feet) X₂ ≤ 5000 X3 ≤ 1200 40 35 Paul plans to solve the following optimization problem: Maximize 70 X₁ + 50 X₂ +60 X3 + 80 X4 Subject to: X4 ≤ 1700 X₁, X2, X3, X4 20 60 55 X₁ + X₂ + X3 + X4 ≤ 13,000 40 X₁ + 35 X₂ + 60 X3 + 55 X₁ ≤ 480,000 X₁ ≤ 4800 Profit per Ton (S) 70 50 60 80 Where X₁, X₁, X3, and X₁ represent the amount (tons) to load to the ship for Cargos 1, 2, 3 and 4, respectively. (a) (10 marks) Solve this Linear Programming problem in Excel using Solver and report the results. (b) (5 marks) Present a table showing how sensitive Paul's loading strategy is to the profit per ton for each type of cargo. Which cargo's profit per ton is the loading strategy most sensitive to? Why? (c) (5 marks) How much of each type of cargo should Paul accept, if the profit per ton for Cargo 1 decreases to $52? Why? 1. Paul Bergey is in charge of loading cargo ships for International Cargo Company (ICC) at the port in Brisbane. Paul is preparing a loading plan for an ICC freighter destined for US. An agriculture cargos dealer wants to transport the following cargo products aboard this ship. Paul learned that this ship has space to take 480,000 cubic feet of cargo, and also has a cargo weight limit of 13,000 tons. Paul can elect to load any of the available cargos shown in the table below. Cargo 1234 4 Amount Available (tons) 4800 5000 1200 1700 Volume per Ton of the cargo (cubic feet) X₂ ≤ 5000 X3 ≤ 1200 40 35 Paul plans to solve the following optimization problem: Maximize 70 X₁ + 50 X₂ +60 X3 + 80 X4 Subject to: X4 ≤ 1700 X₁, X2, X3, X4 20 60 55 X₁ + X₂ + X3 + X4 ≤ 13,000 40 X₁ + 35 X₂ + 60 X3 + 55 X₁ ≤ 480,000 X₁ ≤ 4800 Profit per Ton (S) 70 50 60 80 Where X₁, X₁, X3, and X₁ represent the amount (tons) to load to the ship for Cargos 1, 2, 3 and 4, respectively. (a) (10 marks) Solve this Linear Programming problem in Excel using Solver and report the results. (b) (5 marks) Present a table showing how sensitive Paul's loading strategy is to the profit per ton for each type of cargo. Which cargo's profit per ton is the loading strategy most sensitive to? Why? (c) (5 marks) How much of each type of cargo should Paul accept, if the profit per ton for Cargo 1 decreases to $52? Why?
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these general management questions
-
Paul Bergey is in charge of loading cargo ships for International Cargo Company (ICC) at the port in Newport News, Virginia. Paul is preparing a loading plan for an ICC freighter destined for Ghana....
-
Paul Bergey is in charge of loading cargo ships for International Cargo Company (ICC) at the port in Newport News, Virginia. Paul is preparing a loading plan for an ICC freighter destined for Ghana....
-
Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for...
-
The comparative balance sheets for 2018 and 2017 and the income statement for 2018 are given below for Arduous Company. Additional information from Arduous's accounting records is provided also....
-
After a 5-for-1 stock split, Strasburg Company paid a dividend of $0.75 per new share, which represents a 9% increase over last years pre-split dividend. What was last years dividend per share?
-
For a given data set of IQ scores, if you increase the width of the bins, the number of bins decreases. Decide whether the statement make sense or not? Explain clearly.
-
What is net cash flow from investing activities? (a) $14,000 (b) ($14,000) (c) $21,000 (d) ($16,000) The following information is available for Jacquis Jewelry and Gift Store: Net income Depreciation...
-
Kroger Co.??s 2009 financial statements contained the following data (in millions). InstructionsCompute these values:(a) Working capital. (b) Currentratio. Current assets Total assets Current...
-
What mechanisms are employed to manage and mitigate conflicts of interest among stakeholders with competing agendas or prioritie ?
-
In 2012, George wright started the Old Oregon Wood Store to man-ufacture Old Oregon tables. Each table is carefully constructed by hand using the highest- quality oak. Old Oregon tables can support...
-
The following information is for Questions 4 and 5 During the year, X Company produced and sold 66,900 units of one of its products. The following is the related revenue and cost information: Revenue...
-
Gleam Company has a line of successful dental products that are sold in retail outlets across the country. These products include toothpastes, flosses, and rinses. The financial managers of Gleam are...
-
George and Claire are married and have 4 children. If they elect gift splitting, what is the maximum amount of total gifts they can make to their children (without using a 529 plan) in 2023 and have...
-
Mineral oil with given sp.gr 0.96 flows-up through an inclined pipe of uniform diameter 220mm with a mean velocity of 1.2 m/s. The pressure at the datum of the pipe is measured as 30 N/cm2 with a...
-
Analyze the factors influencing enterprise value and elucidate their impact on organizational valuation.
-
How do both financial and managerial accounting each benefit a company and its stakeholders? If you were a non-accountant stakeholder in a company, how would a basic knowledge of each benefit you?...
-
A total of 80 (36 male) participants were recruited at the University of Canterbury (51 participants) and from the general population (29 participants). Participants from the general public were...
-
Heineken N.V., a global brewer based in the Netherlands, reports the following balance sheet accounts for the year ended December 31, 2016 (euros in millions). Prepare the balance sheet for this...
-
Describe systems analysis and the major activities that occur during this phase of the systems development life cycle.
-
Change the time horizon in Problem and Exercise 5-35 to three years and redo the analysis. Problem and Exercise 5-35. Consider your use of a PC at either home or work and list tangible benefits from...
-
Visit an organization that has installed a LAN. Explore the following questions. a. Inventory all application programs that are delivered to client PCs using a file server architecture. How many...
-
Locate three to five articles about problems experienced by individuals or families who failed to develop estate plans or to identify responsible parties in the event of physical or mental...
-
Conduct an online estate planning article search on current and future estate tax law changes. Write a brief summary of recommendations from the articles showing how future changes in the tax code...
-
So-hyun }oo, and her husband KJ, Each own assets valued at$3,000,000. lfKJ dies in 2012 and leaves all of his assets to So-hyun, without the use of a trust arrangement, how much of his estate will be...
Study smarter with the SolutionInn App