The table below provides demand data for 11 days (days 10-20 for the current year) for one product for the next 4 questions. The previous order was for 300 units at the end of day 9. The lead time is a constant two days. At the beginning of day 10 the inventory level is 450 units. Orders are made at the end of a day. Suppose inventory is managed with a reorder point system where Q=300 and the reorder point is 250. Day Demand Inventory 10 120 11 150 12 120 13 100 14 80 15 80 16 60 17 60 18 60 19 40 20 80 1) When is the next order? end of day ________ 2) How large is the next order? ________ 3) When is the subsequent order (after that above)? end of day _______ 4) How large is that order? _________

The table below provides demand data for 11 days (days 10-20 for the current year) for one product for the next 4 questions. The previous order was for 300 units at the end of day 9. The lead time is a constant two days. At the beginning of day 10 the inventory level is 450 units. Orders are made at the end of a day. Suppose inventory is managed with a reorder point system where Q=300 and the reorder point is 250. Day Demand Inventory 10 120 11 150 12 120 13 100 14 80 15 80 16 60 17 60 18 60 19 40 20 80 1) When is the next order? end of day ____ 2) How large is the next order? 3) When is the subsequent order (after that above)? end of day _ 4) How large is that order? _______

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 15P

See similar textbooks

Similar questions

Fixed-order-interval. 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. Use Formula 13–16 to find the optimal order size.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?
In Lecture 5 we extended the newsvendor solution to the infinite horizon problem when there is no order lead time. Now suppose that the order lead time is L periods throughout the infinite horizon: if an order is placed at the beginning of period t, it arrives at the beginning of period t+L. Can we still extend the newsvendor solution to the infinite horizon problem in the case of backordering? Why or why not? Would your answer change in the case of lost sales? Why or why or not? I WANT LONG AND CLEAR EXPLANATION NOT AN 1 SENTENCE!!!!!!
The table below provides demand data for 6 weeks (weeks 31-36 for the current year) for one product. Inventory is managed with a periodic review system where T = 5 weeks and M = 280. The previous order was for 120 units at the end of week 28. The lead time is a constant 4 weeks. At the beginning of week 31 the inventory level is 130 units. Orders are made at the end of a week. 1. When is the next order? end of week __________ 2. How large is the next order? ___________ Week Demand Inventory 31 30 32 40 33 45 34 30 35 30 36 30
For a given store, demand in Week 5 is 375, and on-hand inventory at the end of Week 4 is 450. If the manufacturing lead time for this particular item is two weeks, which of the following statements will be true? a. The order release for Week 2 will be 450b. The order release for Week 3 will be 0c. The order release for Week 3 will be 375d. The order release for Week 4 will be 0
A manager receives a forecast for next year. Demand is projected to be 600 units for the first half of the year and 920 units for the second half. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order. a.Assuming that monthly demand will be level during each of the six-month periods covered by the forecast (e.g., 100 per month for each of the first six months), determine an order size that will minimize the sum of ordering and carrying costs for each of the six-month periods. (Round your answers to the nearest whole number.) Period Order Size 1 – 6 months?_____units 7 – 12 months?_____units b.If the vendor is willing to offer a discount of $10 per order for ordering in multiples of 50 units (e.g., 50, 100, 150), would you advise the manager to take advantage of the offer in either period? If so, what order size would you recommend? (Round intermediate calculations to 2 decimal places.) Period Order Size 1 – 6 months?____ units 7 – 12 months?____…
A book shop is planning to order calendars for sale starting in October. Only one order is placed. The calendars cost $1.50 and the shop sells them for $3 each. At the end of December, the shop reduces the calendar price to $1 and can sell all the surplus calendars at this price. The October-to-December demand can be approximated by a normal distribution with = 500 calendars and = 120 calendars.1. What inventory model should be used to determine the order quantity to maximize the total expected proÖt? Why?2. What is the optimal service level?3. How many calendars should the shop order so as to maximize the total expected proÖt?
A distribution center (DC) in Wisconsin stocks Sony plasma TV sets. The center receives its inventory from a mega warehouse in Kansas with a lead time (L) of 5 days. The DC uses a reorder point (R) of 300 sets and afixed order quantity (Q) of 250 sets. The current on-hand inventory (OH) at the end of Day 1 is 400 sets, there are no scheduled receipts (SR), and there are no backorders (BO). Assume that all demands and receipts occur at the end of the day. The inventory position is compared to the reorder point after demands and receipts are accounted for. If necessary, an order is placed and the inventory position is updated. Given the demand schedule in the table below, determine when to order using a (Q) system
Daily demand for a product is 10 units with a standard deviation of 3 units. The review period is 30 days, and lead time is 14 days. Management has set a policy of satisfying 98 percent of demand from items in stock. At the beginning of this review period, there are 150 units in inventory.How many units should be ordered?
You were asked to assist with optimising the stock ordering and holding process for a company that sells car batteries. As part of the process, you need to decide the optimal order size to minimise associated costs. You are given the following information: • The batteries cost R400 each. • Sales volumes are constant at 600 batteries per month. • The lead time from order to delivery is 14 days. • It costs R360 for every order to be processed. It is calculated that it costs R5 to store a battery per month. 4) Calculate the optimal total costs.
The materials manager of a tire manfacturer must predict periodically place order for a key chemical one of the raw materials used in manufacturing uses the chemical at a rate of 300lbs each week and the lead time of delivery is 4 days. Assume that the manufacturing operation runs 5 days a week. At what point should the chemical be reorderedd a. when 1200lbs are remaining b. where 0lbs are remaining c. where 375lbs are remaining d. when 240lbs are rem
Leather-All produces a line of handmade leather products. At the present time, the company is producing only belts, handbags, and attache cases. The predicted demand for these three types of items over a six-month planning horizon is as follows: Month No. of Belts Handbags Attache CasesWorking days1 22 2500 1250 2402 20 2800 680 3803 19 2000 1625 1104 24 3400 745 755 21 3000 835 1266 17 1600 375 45 The belts require an average of two hours to produce, the handbags three hours, and the attache cases six hours; all the workers have the skill to work on any item. Leather-All has 46 employees who each have a share in the firm and cannot be fired. There are an additional 30 locals that are available and can be hired for short periods at a higher cost. Regular employees earn $8.50 per hour on regular time, and $14.00 per hour on overtime. Regular time comprises a seven-hour workday and the regular employees will work as much overtime as is available. The additional workers are hired for…
The Chisokone Company located in Chimwemwe manufactures typewriters called AK4 model Z. The company has an average total inventory of K15, 000,000 and places 12,000 orders every year. Order details are as follows:Purchase department expenses……………………………..K400, 000Stores warehouse personnel salary……………………......K400, 000Obsolescence, spoilage, etc…………………………………K120, 000Floor space charge related to stores activities…………….K260, 000Cost of collecting materials…………………………………..K60, 000Cost of receiving materials…………………………………...K70, 000Cost of Inspection……………………………………………..K100, 000Cost of material handling for warehousing activities………K300, 000Cost of bill payment……………………………………………K170, 000Interest…………………………………………………………..11.5%Insurance charges………………………………………………1.9%The company wants to buy a certain component, whose cost is K24 each and the annual requirement is 34,560 units. Calculate the following:i. The cost of carrying inventory as a percentage of inventory ii. The carrying cost as a…