Dairy company SG is producing milk at a fixed rate of 5,000 gallons/hour. The total customer order over a day is 100,000 gallons of milk. This demand is distributed evenly from 8:00 am to 6:00 pm. If there is no milk available, customers will wait until enough is produced to satisfy your orders. The company starts to produce at 8 am with 25,000 gallons in finished goods inventory. In the end, after that all the demand has been met, the plant continues producing until the stock of products finished is restored to 25,000 gallons. When answering the following questions, please address the trucks / milk as a continuous flow process. Start by drawing a graphic indicating how much milk is in stock and how much milk is “on hold” throughout the day. a) At what time of day will customers have to wait for their orders to be filled? b) At what time will customers stop waiting? c) Suppose the milk is collected in trucks with a capacity of 1,250 gallons each. What is the maximum number of trucks waiting?

Dairy company SG is producing milk at a fixed rate of 5,000 gallons/hour. The total customer order over a day is 100,000 gallons of milk. This demand is distributed evenly from 8:00 am to 6:00 pm. If there is no milk available, customers will wait until enough is produced to satisfy your orders. The company starts to produce at 8 am with 25,000 gallons in finished goods inventory. In the end, after that all the demand has been met, the plant continues producing until the stock of products finished is restored to 25,000 gallons. When answering the following questions, please address the trucks / milk as a continuous flow process. Start by drawing a graphic indicating how much milk is in stock and how much milk is “on hold” throughout the day. a) At what time of day will customers have to wait for their orders to be filled? b) At what time will customers stop waiting? c) Suppose the milk is collected in trucks with a capacity of 1,250 gallons each. What is the maximum number of trucks waiting?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section2.5: Ordering With Quantity Discounts And Demand Uncertainty

Problem 5P

See similar textbooks

Similar questions

Jays Office Supplies sells Printers, which it orders from Brands mart Inc in . Because of shipping and handling costs, each order must be for 5 printers. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 Printers. It costs $50 to place an order. It costs the company $500 in lost sales when a customer asks for a Printer and the warehouse is out of stock. It costs $100 to keep each Printer stored in the warehouse. If a customer cannot purchase a Printer when it is requested, the customer will not wait until one comes in but will go to a competitor. The following probability distribution for demand for Printer has been determined: Questions 1.Simulate CWD 's ordering and sales policy for 20 weeks 2. Compute the average cost of the policy PLEASE NOTE I SENT THIS IN ALREADY BUT I REALIZED I LEFT OUT SOME VITAL INFORMATION AND AGAIN THIS IS NOT FROM ANOTHER SITE.
An Soda company sells about 400 gallons of its highly demanded beverage each week. The estimated cost to store as well maintain one gallon of this product is $0.50 per week. Each time the Soda company places an order from its supplier, the following costs are incurred, independent of the size of the order: a $300 delivery fee, $50 unloading and storage, and a $60 transaction fee. Once an order is placed, it arrives exactly 2 work days later. The Soda company, supplier, and delivery carrier all operate 7 days per week. Question: What is the optimal (s,Q) policy?
An automotive warehouse stocks a variety of parts that are sold at neighborhoodstores. One particular part, a popular brand of oil filter, is purchased by thewarehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based on warehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based ona 28 percent annual interest rate.The monthly demand for the filter follows a normal distribution with mean280 and standard deviation 77. Order lead time is assumed to be five months.Assume that if a filter is demanded when the warehouse is out of stock, then thedemand is back-ordered, and the cost assessed for each back-ordered demand is$12.80. Determine the following quantities:a. The optimal values of the order quantity and the reorder level.b. The average annual cost of holding, setup, and stock-out associated…
A retailer uses the order-up-to model to manage inventory of an item in a store. The leadtime for replenishments is four weeks and it can place orders weekly. Weekly demand isPoisson with mean 0.10 unit. Its order-up-to level is five and unfilled demand is backordered. What is the coefficient of variation of its orders?
Charlie’s Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops every four weeks to take orders. Because the orders are shipped directly from Italy, they take three weeks to arrive. Charlie’s Pizza uses an average of 150 pounds of pepperoni each week, with a standard deviation of 30 pounds. Charlie’s prides itself on offering only the best quality ingredientsand a high level of service, so it wants to ensure a 98 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 500 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would you order? (Answer in Appendix D)
A small grocery store sells fresh produce, which it obtains from a local farmer. During the strawberry season, demand for fresh strawberries can be reasonably approximated using a normal distribution with a mean of 40 quarts per day and a standard deviation of 6 quarts per day. Excess costsrun 35 cents per quart. The grocer orders 49 quarts per day.a. What is the implied cost of shortage per quart?
The following data pertains to Slide Corp.’s: (use 360 days/year) Slide Corp.’s payment to suppliers Slide Corp.’s collection from customers Processing Delay 4 days Processing Delay 2 days Clearing Delay 1 day Clearing Delay 24 hours Mail time 1 week Mail time 4 days Slide Corp.’s daily collection average P1,800 while average daily payment is P2,700. How much is the average daily disbursement float? How much is the average daily collection float? How much is the net float? If the cash can be readily invested in instrument earning 6%, how much is the daily cost of collection float?
CWD Electronics sells Televisions (TV), which it orders from the USA. Because of shipping and handling costs, each order must be for 5TVs. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 TVs. It costs $50 to place anorder. It costs the company $500 in lost sales when a customer asks for a TV and the warehouse is out of stock. It costs $100 to keep each TV stored in the warehouse. If a customer cannot purchase a TV when it is requested, the customer will not wait until one comes in but will go to a competitor.The following probability distribution for demand for TV has been and the time required to receive an order once it is placed (lead time) has the following probability distribution: (Attached) The company has 3 TVs in stock. Orders are always received at the beginning of the week.Note that a lead time of 2 weeks imply that an order placed in week one will arrive in week 4. The time required to receive an order…
This type of problem can be recognized when an order interval is given (e.g.,inventory is ordered every 10 days) along with the demand rate, lead time, and quantity on hand atorder time. A lab orders a number of chemicals from the same supplier every 30 days. Lead time is five days.The assistant manager of the lab must determine how much of one of these chemicals to order. Acheck of stock revealed that eleven 25-milliliter (ml) jars are on hand. Daily usage of the chemical isapproximately normal with a mean of 15.2 ml per day and a standard deviation of 1.6 ml per day. Thedesired service level for this chemical is 95 percent.a. How many jars of the chemical should be ordered?b. What is the average amount of safety stock of the chemical?
A well-known coffee shop sells about 300 gallons of its most popular product each week. The estimated cost to store and maintain one gallon of product is $0.50 per week. Each time the coffee shop places an order from its supplier, the following costs are incurred, independent of the size of the order: a $200 delivery fee, $30 unloading and storage, and a $70 transaction fee. Once an order is placed, it arrives exactly 3 work days later. The coffee shop, supplier, and delivery service all operate 7 days per week. a.) What is the optimal (s,Q) policy? b.) What would the (s,Q) policy be if orders were only placed on Fridays with the objective being to cover the demand with no shortages?
A small grocery store sells fresh produce, which it obtains from a local farmer. During the strawberry season, demand for fresh strawberries can be reasonably approximated using a normal distribution with a mean of 40 quarts per day and a standard deviation of 6 quarts per day. Excess costsrun 35 cents per quart. The grocer orders 49 quarts per day.a. What is the implied cost of shortage per quart?b. Why might this be a reasonable figure?
A company extracts oil from canola seeds. Demand for canola oil is constant throughout the year at the rate of 72,000 cans. The holding cost is $0.50 per can per year. The cost involved in the machine set-up is $100 per set-up. The production capacity of the machine is 300 cans per day.The year has 365 days. Determine the following: a. The optimal production run quantityb.The maximum inventoryC.The total minimum annual inventory costsD.The optimal number of production runs per yearE.The length of the production run