Determine the Safety Stock and Re-order Point given the fluctuating demand and lead time conditions as shown in the table below:PeriodeDemand (unit) Lead Time (hari)121032185231703419225221262012719828173591652101804111952121904 Periode12Demand (unit) Lead Time (hari)21031852345678991703192222120119817316510180111952225242121904

PeriodeDemand (unit)Lead Time…

Answered: Periode 1 2 Demand (unit) Lead Time…

Periode 1 2 Demand (unit) Lead Time (hari) 210 3 185 2 34567899 170 3 192 2 221 201 198 173 165 10 180 11 195 22 25242 12 190 4

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

Question 29 Which one of the following methods will be most suitable for managing dependent demand? Q-model ABC Analysis P-model The single-period model Material Requirements Planning
question #2 Same problem statement: Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier, with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each box costs the retailer $10, and the inventory holding cost is 25% per year. If the retailer wants to achieve a 99% service level (use the z-value with one decimal, as in Table 13.4 on page 400 of the textbook), what should be the safety stock value? Numeric Response 772.8 SHARE f5 f6 4- f7 ♫+ fg fil W f12. insert prt sc delete home @ 0 end 1:23 PM 11/15/2022 pg L
List the different types of inventory.
Briefly explain the costs associated with EOQ model. If production cost goes up, what is the impact on the EOQ quantity?
Problem 13-16 The McDonald's fast-food restaurant on campus sells an average of 4,800 quarter-pound hamburgers each week. Hamburger patties are resupplied twice a week, and on average the store has 465 pounds of hamburger in stock. Assume that the hamburger patties cost $3 a pound and there are 52 weeks in a year. a. What is the inventory turnover for the hamburger patties? (Round your answer to 2 decimal places.) Inventory turnover per year b. On average, how many days of supply are on hand? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Average days of supply
How would these factors affect an EOQ analysis?(1) The use of just-in-time procedures.
03) Halifax Souvenir Company currently orders 500 units four times each year. Each order costs $12 and each unit costs $1.20 per year to carry. On average, it takes 5 days to receive an order from the supplier. The company operates 250 days per year. Required: 1. What is the EOQ? 2. Calculate total annual inventory cost under EOQ. 3. What is the current inventory cost? 4. What is the re-order point?
TOPIC : Inventory Systems for Independent Demand
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the ← table below: How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places) Item Code Avg. Inventory (units) 1289 2347 2349 2363 2394 2395 L. Houts Plastics Charlotte Inventory Levels Value Dollar Volume (S/unit) 3.50 6782 7844 8210 8310 9111 360 300 120 65 60 25 222216 20 10 7 4.00 2.50 1.80 1.75 2.25 1.15 2.05 1.60 2.00 3.00 1,200 300 105 23 25 14 18 3,134 % of Dollar Volume 38.29 9.57 3.35 0.73 0.78 0.45 0.57
What is safety stock for?
Need in Detail (No AI)
Question: What level of safety stock should be maintained? Please show the solution. Thank you