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? ___________

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? _

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter3: Introduction To Optimization Modeling

Section3.8: A Multiperiod Production Model

Problem 22P

See similar textbooks

Similar questions

Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days
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? _________
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based ond. Which lot-sizing method resulted in the lowest cost for the 12 periods?
A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .99. The order interval is 12 days, and lead time is 4 days. Average demand for one item is 63 units per day, and the standard deviation of demand is 6 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table. Cycle On Hand 1 38 2 10 3 93 Determine the order quantities for cycles 1, 2, and 3: (Round your answers to the nearest whole number) Cycle Units 1 1019 Numeric ResponseEdit Unavailable. 1019 incorrect. 2 1047 Numeric ResponseEdit Unavailable. 1047 incorrect. 3 964 Numeric ResponseEdit Unavailable. 964 incorrect.
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based ona. Silver–Meal.
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…
A company wants to develop a level production plan. The beginning inventory is zero. Demand for the next four periods is given in what follows. What production rate per period will give a zero inventory at the end of period 4? When and in what quantities will back orders occur? What level production rate per period will avoid back orders? What will be the ending inventory in period 4? Period 1 2 3 4 Total Forecast demand 9 5 9 9 Planned production Planned inventory 0
Max the Tailor is going to sell custom suits. He was able to rent a garage from his Uncle Ed for $2,000 a month, which includes utilities, and he already owns the equipment he needs. He anticipates being able to sell his suits for $500 each. The raw materials (fabric, buttons, zippers, thread, etc.) will cost an average of $75 for each suit, and he plans to spend $25 per suit to advertise them. Assuming these are all the costs and revenues, what will be Max’s monthly break-even point in units? Does this seem like a reasonable amount for him to produce and sell every month? Please show your calculations.
[item no. 11] In a single period inventory model, the demand is assumed to follow a normal distribution. The value of ML/(ML+MP) is 0.6. The company used marginal analysis with the normal distribution to determine the optimal stocking level X*. If the mean demand is 100, then X* a. is less than 100 b. is equal to 100 c. cannot be determined from the information given d. is greater than 100
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?____…
Please complete the sup part: e,f and g. 1.B&H needs to decide how to manage its inventory of cameras. The demand for cameras at B&H is 200 cameras per week. Each time that B&H places an order for a new shipment of cameras, it must pay $80 in fixed processing fees. A camera costs B&H $60 to purchase. The cost for B&H to hold a camera in its store for one week is $4. Assume that the lead time for the delivery of a camera is 0 weeks.a. Suppose that B&H places orders for cameras in quantities of 50 cameras at a time and places a new order for cameras each time that it runs out. Draw a graph showing the number of cameras that B&H has on-hand in inventory at each point in time up until the time when it places its fourth-order. Label the points in time at which B&H places a new order. Assume that B&H places its first order for 50 cameras on day 0.b. Suppose again that B&H places orders for 50 cameras at a time. What will be B&H’s average holding…
The Hawkins Supply Company is currently faced with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates.The company would like to reduce the double and sometimes triple handling of items. How can this goal be achieved? Are there alternative solutions which might also be effective?