The Metropolitan Bus Company (MBC) purchases diesel fuel from American Petroleum Supply. In addition to the fuel cost, American Petroleum Supply charges MBC $225 per order to cover the expenses ofdelivering and transferring the fuel to MBC's storage tanks. The lead time for a new shipment from American Petroleum is 10 days; the cost of holding a gallon of fuel in the storage tanks is $0.03 per month, or$0.36 per year; and annual fuel usage is 180,000 gallons. MBC buses operate 288 days a year.(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 17,500 gallons. Should MBC consider expanding the capacity of its storage tanks?The maximum inventory is(d) What is the reorder point (in gallons)?gallonsMBC ---Select---to expand its storage tanks.

Part (b) Order frequency:Number of orders per year = AD/Q= 180,000/15,000= 12 orders per yearSo,…

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

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 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 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 the Motorboat dealership in part (a) above dealing in costly motorboats follows 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 Motorboat dealership believe that the shortage cost due to waiting for the motorboat is $2,000 per unit short per month. The demand is seen to be Poisson 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.
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…
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.
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…
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.
Jack Ltd is a market leader in the manufacture of apple juice. They operate areorder level system of inventory management, and the following information isavailable for green apples:Average usage 800 per dayMinimum usage 540 per dayMaximum usage 1260 per dayLead time for replenishment 16-20 dayReorder quantity 19,500 applesRequired: iii Calculate the minimum (buffer) inventory level
Jack Ltd is a market leader in the manufacture of apple juice. They operate areorder level system of inventory management, and the following information isavailable for green apples:Average usage 800 per dayMinimum usage 540 per dayMaximum usage 1260 per dayLead time for replenishment 16-20 dayReorder quantity 19,500 applesRequired:ii Calculate the maximum level of inventory
The Rainwater Brewery produces Rainwater Light Beer, which it stores in barrels in its warehouse and supplies to its distributors on demand. The demand for Rainwater is 1,500 barrels of beer per day (365 days per year). The brewery can produce 2,000 barrels of Rainwater per day. It costs $6,500 to set up a production run for Rainwater. Once it is brewed, the beer is stored in a refrigerated warehouse at an annual cost of $50 per barrel. Determine the economic order quantity and the minimum total annual inventory cost.
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?

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