The Metropolitan Bus Company (MBC) purchases diesel fuel from American Petroleum Supply. In addition to the fuel cost,American Petroleum Supply charges MBC $200 per order to cover the expenses of delivering and transferring the fuel to MBC'sstorage tanks. The lead time for a new shipment from American Petroleum is 10 days; the cost of holding a gallon of fuel in thestorage tanks is $0.04 per month, or $0.48 per year; and annual fuel usage is 120,000 gallons. MBC buses operate 300 days ayear.(a) What is the optimal order quantity for MBC?(b) How frequently should MBC order to replenish the gasoline supply?---Select-- per ---Select---(c) The MBC storage tanks have a capacity of 12,500 gallons. Should MBC consider expanding the capacity of its storage tanks?The maximum inventory isto expand its storage tanks.(d) What is the reorder point (in gallons)?gallonsMBC --Select---

Inventory management is the aspect of production management of an organization including storing,…

Answered: The Metropolitan Bus Company (MBC)…

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

K Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 30 units and is valued at $100 per unit. Inbound shipments from vendor 1 will average 300 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 490 units with an average lead time of 1 week. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is $39,000. (Enter your response as a whole number.) b. The average aggregate inventory value of the product if Ruby-Star used vendor 2 exclusively is $ 39,500. (Enter your response as a whole number.) c. How would your analysis change if average weekly demand increased to 60 units per week? The average aggregate inventory value of the product if Ruby-Star used vendor 1…
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 30 units and is valued at $100 per unit. Inbound shipments from vendor 1 will average 300 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 490 units with an average lead time of 1 week. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is $39,000. (Enter your response as a whole number.) b. The average aggregate inventory value of the product if Ruby-Star used vendor 2 exclusively is $ (Enter your response as a whole number.)
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 60 units and is valued at $60 per unit. Inbound shipments from vendor 1 will average 370 units with an average lead time (including ordering delays and transit time) of 5 weeks. Inbound shipments from vendor 2 will average 520 units with an average lead time of 1 week. Ruby-Star operates 52 weeks per year; it carries a 5-week supply of inventory as safety stock and no anticipation inventory. a. What would be the average aggregate inventory value of this product if Ruby-Star used vendor 1 exclusively?b. What would be the average aggregate inventory value of this product if Ruby-Star used vendor 2 exclusively?c. How would your analysis change if average weekly demand increased to 100 units per week?
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 30 units and is valued at $60 per unit. Inbound shipments from vendor 1 will average 330 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 450 units with an average lead time of 3 weeks. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. A. the average aggregate inventory value of the product if ruby star used vendor 1 exclusively is $_____ (enter your response as a whole number) B. the average aggregate inventory value of the product if ruby sta used vendor 2 exclusively is $______ (enter your response as a whole number) C. how would your analysis change if average weekly demand increased to 140 units per week? the average aggregate inventory value of the product if ruby star used vendor 1…
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 50 units and is valued at $75 per unit. Inbound shipments from vendor 1 will average 350 units with an average lead time (including ordering delays and transit time) of 2 weeks. Inbound shipments from vendor 2 will average 500 units with an average lead time of 1 week. Ruby-Star operates 52 weeks per year; it carries a 2-week supply of inventory as safety stock and no anticipation inventory.a. What would be the average aggregate inventory value of this product if Ruby-Star used vendor 1 exclusively?b. What would be the average aggregate inventory value of this product if Ruby-Star used vendor 2 exclusively?c. How would your analysis change if average weekly demand increased to 100 units per week?
Suppose a Motorboat dealership is dealing in costly motorboats that follow the policy of carrying a few units in stock and ordering for replenishment as soon as a motorboat is sold from the stock. The unit cost of the motorboat is $60,000 and the holding or carrying cost is $5,000 per unit per year. The management of the Motorboat dealership believes that the shortage cost due to waiting for the motorboat is $2,000 per unit short per month. The demand is seen to be Poison distributed with an average rate of 2 units per month and the replenishment lead time can be considered to be exponential with a mean of one month Considering the system as an M/M/s queuing system, find the optimal stock to be carried which can minimize the sum total of carrying and shortage costs.
The Uptown Kiln is an importer of ceramics from overseas. It has arranged to purchase a particular type of ceramic pottery from a Korean artisan. The artisan makes the pottery in 120-unit batches and will ship only that exact number of units. The transportation and handling cost of a shipment is $7,600 (not including the unit cost). The Uptown Kiln estimates its annual demand to be 900 units. What storage and handling cost per unit does it need to achieve in order to minimize its inventory cost?
Craftwood Furniture Company is a U.S.–based furniture manufacturer that offshored all of its actual manufacturing operations to China about a decade ago. It set up a distribution center in Hong Kong, from which the company ships its items to the United States on container ships. The company learned early on that it could not rely on local Chinese freight forwarders to arrange for sufficient containers for the company’s shipments, so it contracted to purchase containers from a Taiwanese manufacturer and then sell them to shipping companies at the U.S. ports the containers are shipped to. Craftwood needs 715 containers each year. It costs $265 to hold a container at its distribution center, and it costs $6,000 to process and receive an order for the containers. The cost of not having sufficient containers and delaying a shipment is $14,000 per container. Determine the optimal order size, minimum total annual inventory cost, and maximum shortage level.
Copper Kettle Catering (CKC) is a full-service catering company that provides services ranging from box lunches for picnics or luncheon meetings to large wedding, dinner, or office parties. Established as a lunch delivery service for offices in 1972 by Wayne and Janet Williams, CKC has grown to be one of the largest catering businesses in Raleigh, North Carolina. The Williams’s divide customer demand into two categories: deliver only and deliver and serve. The deliver-only side of the business delivers boxed meals consisting of a sandwich, salad, dessert, and fruit. The menu for this service is limited to six sandwich selections, three salads or potato chips, and a brownie or fruit bar. Grapes and an orange slice are included with every meal, and iced tea can be ordered to accompany the meals. The overall level of demand for this service throughout the year is fairly constant, although the mix of menu items delivered varies. The planning horizon for this segment of the business is…
Daily demand for a type of sandwich sold at DoorRed Cafe (DRC) is normally distributed with a mean of 65 and a standard deviation of 27. DRC orders the sandwiches from a wholesaler (everyday morning before 5:30 AM) at a wholesale price of $4 per sandwich and sells them at a retail price of $7 per sandwich. Pursuant to the contract between DRC and its wholesaler, the transportation cost is currently borne by the wholesaler. The wholesaler does not take back any unsold sandwiches. However, DRC can sell any unsold inventory at a discounted price of $3 after 5:00 PM every day. d) Now suppose that the contract between DRC and its wholesaler expires and pursuant to the new contract, if DRC orders more than 56 sandwiches (anything more than or equal to 57), the transportation cost is no longer borne by the wholesaler and DRC will have to pay $30 for transportation. If DRC orders less than or equal to 56, the transportation cost for DRC is still zero. What is DRC’s optimal order quantity for…
An oil refinery buys crude oil on a long-term supply contract for $22.50 per barrel.When shipments of crude oil are made to the refinery, they arrive at the rate of10,000 barrels per day. The refinery uses the oil at a rate of 5,000 barrels per dayand plans to purchase 500,000 barrels of crude oil next year. If the carrying cost is25percent of acquisition cost per unit per year and the ordering cost is $7,500 perorder:a. What is the EOQ for the crude oil?b. What is the TSC at EOQ?c. How many days of production are supported by each order of crude oil?d. How much storage capacity is needed for the crude oil?
The University Bookstore at Tech stocks the required textbook for Management Science 2405. The demand for this text is 1,200 copies per year. The cost of placing an order is $350, and the annual carrying cost is $2.75 per book. If a student requests the book and it is not in stock, the student will likely go to the privately owned Tech Bookstore. It is likely that the student will not buy books at the University Bookstore in the future; thus the shortage cost to the University Bookstore is estimated to be $45 per book. Determine the optimal order size, the maximum shortage level, and the total inventory cost.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS