2. Airlines accept requests for package shipments on its flights based on the estimated storage remaining...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. Airlines accept requests for package shipments on its flights based on the estimated storage remaining after accounting for the storage taken up by its passengers. For an upcoming flight from Denver to Frankfurt, the estimated capacity remaining in each of storage areas is shown in the following table STORAGE AREA FORWARD CENTER LEFT CENTER RIGHT REAR WEIGHT CAPACITY (KG) 10,000 8,000 9,000 12,000 VOLUME CAPACITY (CUBIC METER) 320 400 250 480 The following shipment requests from three different companies can be accepted. COMPANY 1 2 3 MAXIMUM AMOUNT (KG) 15,000 15,000 16,000 VOLUME PER KG (CUBIC METER) PROFIT PER KG ($) 0.07 7 0.05 5 0.12 11 Shipment requests can be put into any storage area. To achieve balance, however, the shipment weight of the forward storage must be within 10% of the weight in the rear storage area and the shipment weight in the center left and center must be within 5% of the weight in the center right storage area. In addition, the total weight in center storage areas must be between 35% and 65% of the total shipment accepted. d) Formulate a Linear Program that can be used to determine which shipment requests to accept to maximize profit. Clearly specify the decision variables, objective function, and constraints e) Create a spreadsheet model for this problem and solve it using Solver. f) What is the optimal solution? 2. Airlines accept requests for package shipments on its flights based on the estimated storage remaining after accounting for the storage taken up by its passengers. For an upcoming flight from Denver to Frankfurt, the estimated capacity remaining in each of storage areas is shown in the following table STORAGE AREA FORWARD CENTER LEFT CENTER RIGHT REAR WEIGHT CAPACITY (KG) 10,000 8,000 9,000 12,000 VOLUME CAPACITY (CUBIC METER) 320 400 250 480 The following shipment requests from three different companies can be accepted. COMPANY 1 2 3 MAXIMUM AMOUNT (KG) 15,000 15,000 16,000 VOLUME PER KG (CUBIC METER) PROFIT PER KG ($) 0.07 7 0.05 5 0.12 11 Shipment requests can be put into any storage area. To achieve balance, however, the shipment weight of the forward storage must be within 10% of the weight in the rear storage area and the shipment weight in the center left and center must be within 5% of the weight in the center right storage area. In addition, the total weight in center storage areas must be between 35% and 65% of the total shipment accepted. d) Formulate a Linear Program that can be used to determine which shipment requests to accept to maximize profit. Clearly specify the decision variables, objective function, and constraints e) Create a spreadsheet model for this problem and solve it using Solver. f) What is the optimal solution?
Expert Answer:
Answer rating: 100% (QA)
d Linear Program Formulation Decision Variables Let Xij represent the amount of shipment from company i allocated to storage area j where i 1 2 3 comp... View the full answer
Related Book For
Operations Management Processes And Supply Chains
ISBN: 9781292409863
13th Global Edition
Authors: Lee Krajewski, Naresh Malhotra, Larry Ritzman
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Economists are difficult to understand. They claim that they can put a monetary value on premature death, but not on human life. They also claim that they can value ecosystem services (such as a...
-
Presented below is information from the statements of owner's equity for Kerkan Consulting for the first three years of operation. Determine the missing amounts: 2015 2016 2017 $ 0 $68,000 (c) J....
-
Think of any decision you recently made. Would you characterize it as programmed or nonprogrammed? Highly certain or highly uncertain? Top-down or empowered? Explain your answers.
-
Redesign the VOCs adsorber of Example 9.15 for a breakthrough time of \(4.0 \mathrm{~h}\). The pressure drop through the bed [calculated using the Ergun equation (2-95)] should not exceed \(1.0...
-
The road system around the hotel complex on International Drive (node 1) to Disney World (node 11) in Orlando, Florida, is shown in the network of Figure. The numbers by the nodes represent the...
-
Consider the inverse demand function below for a market with 2 dominant firms: P=600-3(Q 1 +Q 2 ) Assume that both firms have identical marginal costs: $300, yet one of them, Firm 1, is the leader...
-
The advent of the world wide web (www) has grossly transformed the information retrieval process, especially with the use of web search engines. a. Compare classic information retrieval with web...
-
Which inventory valuation method assumes that the cost of the latest items purchased is the first to be recognized as cost of goods sold?
-
ABC cement industry comes across some essential raw materials which was previously imported from foreign countries due to the current financial crises in our country. Before the owner took a bitter...
-
What is Records Management? Who is responsible for managing records complying with legislative and regulatory requirements. ?
-
An estimate of the order cost is $18 per order (see spreadsheet below). show the math that justifies this estimate and explain your answer. An estimate of inventory carrying (holding) cost is 27% of...
-
Amounts of the assets and liabilities of Mike Associates Inc., as of December 3 1 , 2 0 2 0 , are given as follows. Also included are revenue and expense figures for the year ended on that date (...
-
On January 2, 2020, Sherlock, Inc. acquired 100% of the voting shares of Holmes Company. Sherlock will maintain Holmes as a wholly-owned subsidiary with its own legal and accounting identity. The...
-
Find the area of the surface generated by revolving the para- metric curve x = cos 1, y = sin? 1 (0 < I sa/2) about the y-axis.
-
Acadia Logistics anticipates that it will need more distribution center space to accommodate what it believes will be a significant increase in demand for its final-mile services. Acadia could either...
-
Swell Productions is sponsoring an outdoor conclave for owners of collectible and classic Fords. The concession stand in the T-Bird area will sell clothing such as T-shirts and official Thunderbird...
-
The operations manager for Superfast Airlines at Chicagos OHare Airport noticed an increase in the number of delayed flight departures. She brainstormed possible causes with her staff; Aircraft late...
-
Why is gifting an important estate planning tool? Why are assets that grow in value recommended as gifts?
-
Following his death in 2012, Zane Wulster's gross taxable estate was valued at $3,300,000. He has made a total of $200,000 of gifts that exceeded the annual gift tax exclusion. a. What is the amount...
-
Explain how the portable estate exemption, resulting from the 2010 Tax Relief Act, altered estate planning using family trusts.
Study smarter with the SolutionInn App