question #5Same 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 boxcosts the retailer $10, and the inventory holding cost is 25% per year.Under the current order quantity of 5,000 boxes and current reorder point of 4,200 boxes, what would be the order-up-to level S that the retailer should use as a baseline tocalculate how much inventory to order when conducting a periodic review?Numeric Response1500f4*****LAf540%f64-0C+&7< Prev.門fgKAA*85 of 5DIIhpf10DDI9NextfiWf12.insertprt sc+11(←deletebackspacehomenumlockend1:24 PM11/15/2022pg up question #4Same 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 boxcosts the retailer $10, and the inventory holding cost is 25% per year. Assume 50 weeks in a year.Given the problem parameters, what is the optimal order quantity the retailer should order?Numeric Response2040f4f5f604-f74+< PrevPfgfg94 of 5hpf10Next >MODDIf11Wf12.insertprt scdeletehome4x Dend1:25 PM11/15/2022pg u

Answered: Image /qna-images/answer/9d20b0e7-78f3-40b2-a4ff-12f3323579d0.jpg

Answered: at a retailer is normally distributed…

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 #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
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 L. Houts Plastics Charlotte Inventory Levels Avg. Value Inventory (units) ($/unit) Dollar Volume % of Dollar Volume 1289 360 3.75 2347 300 4.00 1,200 37.58 2349 120 2.50 300 9.40 2363 60 1.50 2394 60 1.75 105 3.29 2395 30 1.75 6782 20 1.15 23 0.72 7844 12 2.05 25 0.77 8210 8 2.00 8310 7 2.00 14 9111 6 3.00 18 0.44 0.56 3,193 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item number 1289 should be…
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 L. Houts Plastics Charlotte Inventory Levels Avg. Value Inventory (units) ($/unit) Dollar Volume % of Dollar Volume 1289 420 3.50 1470 2347 300 4.00 1,200 36.05 2349 120 2.50 300 9.01 2363 65 1.50 98 2394 60 1.75 105 3.15 2395 25 2.25 56 6782 7844 12 8210 10 8310 9111 22076 1.15 23 0.69 2.05 25 0.74 2.00 20 2.00 14 0.42 3.00 18 0.54 3,328
Micro-Electronics Warehouse Headset and Webcam Sale Item Type Reg. Price After Savings Price BuddyChat 200 Headset $34.72 $24.40 BuddyChat 300 Headset $41.27 $34.91 BuddyCam HD Webcam $83.54 $61.46 You have decided to purchase the headset with the greatest markdown percent and the BuddyCam HD webcam in order to take advantage of an "Extra $15 Rebate" offer when you purchase both. What is the markdown percent on your total purchase including the rebate?
Demand (D) 85 tablets/week Working weeks per year 52 weeks Unit holding cost per year (H) $6 Order cost (S) $44/order Standard deviation of weekly demand (sd) 15 tablets Lead time (L) 2 weeks Desired cycle service level 95% If the pharmacist uses the continuous review (Q) system to control the inventory of the drug, what would be the order quantity and reorder point?
Explore the concept of Vendor-Managed Inventory (VMI) and its synergy with the Wilson approach.
question #3 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. With a safety stock of 300 boxes, what is the approximate service level (round to two decimals)? Numeric Response 84.13 * f5 10 f6 0 4- ♫+ fg C fil W f12. insert prt sc + 11 Ə ← delete backspace home num lock 4x D end 1:23 PM 11/15/2022 pg up
Discuss why is it not necessary to include product cost in the EQQ model, but the quantity inventory system, discount model requires this information ?
7. Explain why it is not necessary to include product cost (price or price times quantity) in the EOQ model, but the quantity inventory system. discount model requires this information.
3. Fortnex is a company that assembles small household appliances including coffee makers, toasters, and food mixers. The parent company of Fortnex has been concerned about the rising product cost of the finished products, which has led to reduced profit margins. One of the demands of the parent company has been to review the inventory management practices of Fortnex. Two areas which Fortnex is currently investigating are economic order quantity EOQ and ABC analysis. Perform the following. (i) At present the company purchases copper wire for a certain appliance under economic order quantities based on the information given in Table 3-1. The supplier of copper wire is proposing a discount of 5% of unit price if Fortnex purchases in lot sizes of 1000 kg. rather than the calculated EOQ. Determine if Fortnex should take advantage of the price discount. Justify your response. For a particular series of referenced products, the number of units used a year, and the unit cost are as shown in…
Why do the basic EOQ model variations not include theprice of an item?
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 individual dollar volumes to two decimal places. Also round percentage of dollar volume to two decimal places.) L. Houts Plastics Charlotte Inventory Levels Item Code Avg. Inventory (units) Value ($/unit) Dollar % of Dollar Volume Volume 1289 360 4.00 2347 300 4.00 1,200 36.20 2349 120 2.50 300 9.05 2363 75 1,50 2394 60 1.75 105 3.17 2395 35 2.00 6782 20 1.15 23 0.69 7844 12 2.05 24.6 0.74 8210 5 1.60 8310 7 2.00 14 0.42 9111 3.00 18 0.54 3,315.1 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item number…

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

at a retailer is normally distributed with a mean of 1,000 ba O boxes. The order quantity to the supplier is fixed at 5,000- he inventory holding cost is 25% per year. antity of 5,000 boxes and current reorder point of 4,200 boz ory to order when conducting a periodic review?