A local aviator is considering opening up a new air cargo company. In order to be profitable, she estimates that she needs to have a daily shipping capacity of 80,000 cu. ft. Two types of planes have been approved for use at the local airstrip (these planes are described in detail below). Please note that the second model of aircraft requires two pilots per FAA rules. There are 40 pilots available and airport hangers for at most 38 aircraft. Your goal is to help the aviator minimize the costs for operating at least 80,000 cu. ft. of cargo. | Aircraft Name Hodson Cruiser Cost of Aircraft Capacity (cu. ft.) Pilots needed 2,200 $20,000 Whitaker Jumbo Jet $45,000 5.400 2 A) Solve the problem and report on the optimal number of each aircraft to purchase. B) Assume that the aircraft must be purchased in equal amounts (e.g., 4 Hodson Cruisers and 4 Whitaker Jumbo Jets). What is the minimum number of each plan to purchase that would minimize costs under this new constraint?

A local aviator is considering opening up a new air cargo company. In order to be profitable, she estimates that she needs to have a daily shipping capacity of 80,000 cu. ft. Two types of planes have been approved for use at the local airstrip (these planes are described in detail below). Please note that the second model of aircraft requires two pilots per FAA rules. There are 40 pilots available and airport hangers for at most 38 aircraft. Your goal is to help the aviator minimize the costs for operating at least 80,000 cu. ft. of cargo. | Aircraft Name Hodson Cruiser Cost of Aircraft Capacity (cu. ft.) Pilots needed 2,200 $20,000 Whitaker Jumbo Jet $45,000 5.400 2 A) Solve the problem and report on the optimal number of each aircraft to purchase. B) Assume that the aircraft must be purchased in equal amounts (e.g., 4 Hodson Cruisers and 4 Whitaker Jumbo Jets). What is the minimum number of each plan to purchase that would minimize costs under this new constraint?

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...

See similar textbooks

Similar questions

2. Metropolitan Manila has four incinerator sites for processing solid waste. There are five garbage collection areas within the metropolis. The city wants to determine the least-cost method of disposing of its trash. Each incinerator is characterized by an operating cost for processing each ton of waste and also a cost for transporting each ton of waste is summarized in the table below: Collection Incinerator Site Area 1 2 3 4 50 120 110 60 B 100 55 90 70 60 40 80 65 90 75 85 110 80 100 95 65 Incinerator sites 1 and 2 have a weekly capacity of 6,000 tons each, site 3 has a capacity of 8,000 tons and site 4 has a capacity of 10,000 tons. There are 4,000 tons of waste generated at area A, 8,000 tons at area B and 5,000 tons each at areas C and D, each week. A total of 25,000 tons of waste each week are generated from all five areas.
Describe some of the methods used to schedule service systems and summarise some of the particular problems found in service systems.
What type of impact can a winter storms have on logistics?
Describe the types of data that are commonly used in conventional logistics measurement systems.
The Logistics Scoreboard
Delivering on "direct to consumer" (DTC) in the consumer product goods industry, explain the logistics challenges faced with DTC and do DTC benefits outweigh the risks?
Dr. Vicki Belya is traveling from Yangoon to Los Angeles. She needs to change planes in Bangkok and board another airline’s flight in Tokyo. However, the ariline she is flying does not have interline agreements. Provide a basic explanation of what she can expect at every point of her journey.
What are the technology usage areas in logistics management? What kind of technology-based development is expected in warehouse management, road, sea, rail and air transportation in the future? Explain with examples.
Define logistics strategy and explain why it is needed.
Transportation: how do the product packaging and handling considerations influence the distribution process in the food industry(dairy) product as it moves throughout the distribution chain?
Subject/lesson: Logistics and Supply Chain Management