SSame 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.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 Response13#t772.8f4SELOR69$f5%t6 4-A♫+&fg< Prev.KAA*DII2 of 5hpf10DDINext >12 $f11f12.Winsertprt scdeletebackspacehomenum4x Dend1:211/15/pg 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 boxcosts 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 Response84.13*3f4SERVDA$4f5%5J-06♫+&7f8< Prev.KAA*8DII3 of 5hpf10DDIDNext >f11E日本Wf12.insertprt sc+←deletebackspacehomenumlock4x Dend1:26 PM11/15/2022pg up

The term “safety stock” has been used to describe inventory that is held in reserve for a variety of…

Answered: s, fixed order cost per order is $100,…

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

ESTRELLA is a bike retailer located in the outskirts of Bacolod City. ESTRELLA purchases bikes from STORAGEHUB in orders of 250 bikes which is the current economic order quantity. STORAGEHUB is now offering the following bulk discounts to its customers: Price 0% discount on orders less than 499 P3,500 10% discount on orders above 500 units - 999 3,150 15% discount on orders above 1,000 units 2,975 ESTRELLA is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision: Annual demand is 5000 units Ordering cost is $100 per order Annual holding cost is 25% QTY SETUP HOLDING PROODUCT COST TOTAL COST Q1 25423.73 25812.5 what is the product cost what is the total cost Q2 3000 198437.5 what is…
ESTRELLA is a bike retailer located in the outskirts of Bacolod City. ESTRELLA purchases bikes from STORAGEHUB in orders of 250 bikes which is the current economic order quantity. STORAGEHUB is now offering the following bulk discounts to its customers: Price 0% discount on orders less than 499 P3,500 10% discount on orders above 500 units - 999 3,150 15% discount on orders above 1,000 units 2,975 ESTRELLA is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision: Annual demand is 5000 units Ordering cost is $100 per order Annual holding cost is 25% How much is the EOQ for each quantity discount? How much should be the EOQ?
Native Customs sells two popular styles of hand-sewn footwear: a sandal and a moccasin. The cost to make a pair of sandals is $18, and the cost to make a pair of moccasins is $24. The demand for these two items is sensitive to the price, and historical data indicate that the monthly demands are given by S = 360 − 9P1 and M = 400 − 20P2, where S = demand for sandals (in pairs), M = demand for moccasins (in pairs), P1 = price for a pair of sandals, and P2 = price for a pair of moccasins. To remain competitive, Native Customs must limit the price (per pair) to no more than $60 and $75 for its sandals and moccasins, respectively. Formulate this nonlinear programming problem to find the optimal production quantities and prices for sandals and moccasins that maximize total monthly profit.
BIKO is a bike retailer located in the outskirts of Paris. BIKO purchases bikes from PMX in orders of 250 bikes which is the current economic order quantity. PMX is now offering the following bulk discounts to its customers: 2% discount on orders above 200 units 4% discount on orders above 500 units 6% discount on orders above 600 units BIKO is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision: Annual demand is 5000 units Ordering cost is $100 per order Annual holding cost is comprised of the following: 5% insurance premium for the average inventory held during the year calculated using the net purchase price Warehousing cost of $6 per unit Purchase price is $200 per unit before discount (Hint: We need to compare the total inventory cost of the order quantities at the various discount levels with that of the economic order quantity)
Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, “That’s life.” On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolatecovered shrimp in some boxes so that “You never know what you’ll get.” Quarterly demand (in boxes of chocolates) for the last 3 years follows: Quarter Year 1 Year 2 Year 3 1 2 3 4 3,000 1,700 900 4,400 3,300 2,100 1,500 5,100 3,502 2,448 1,768 5,882 Total 10,000 12,000 13,600 a. Use intuition and judgment to estimate quarterly demand for the fourth year.b. If the expected sales for chocolates are 14,800 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. Are any of the quarterly forecasts different from what you thought you would get in part (a)?
Weekly demand for printers at a store is normally distributed with a mean of 250 and a standard deviation of 96. The store manager continuously monitors inventory and currently orders 14400 printers each time the inventory drops to 1,000printers. The supply lead time is normally distributed with a mean of 2 weeks and a standard deviation of 1.5 weeks. a.How much safety inventory should this store carry if it wants to provide a CSL of 95%? b.How does the required safety inventory change as the standard deviation of lead time is reduced from 1.5 weeks to zero in intervals of 0.5 weeks? c.What fill rate does the store achieve?
Calculate the annual economic order quantity from the information provided below. INFORMATIONGM Electronics expects to sell 800 alarm systems each month of 2022 at R4 000 each. The cost price of eachalarm system is R2 000. The inventory holding cost of an alarm system is 1% of the unit cost price. The cost ofplacing an order for the alarm systems is estimated at R60.
A retailer carries 10,000 items in its store. During the week, there is some demand for 6000 of the items. Among those, there are 100 products for which all of the demand was not satisfied and 400 products for which only some of demand was satisfied. a. What is their in-stock probability for this week?b. What is their stockout probability for this week?
Quantity to OrderDaily demand for a product is 10 units, with a standard deviation of 3 units. The review period is 30 days, and the 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?
A company plans to consume 700 pieces annually of a particular component. Past records indicate that its purchasing department spent $12,500 for placing 15,000 purchase orders. The average inventory was valued at $50,000 and the total storage cost was $7,500, which included wages, rent, taxes, insurance etc. related to store department. The company borrows capital at 10 per cent a year. If the cost of the component is Rs. 12 and lot size is 10, determine the; Storage expenses/year Capital cost /year Total cost/year
Production Quantity Model A stew production facility sells the stew in an adjoining store. Demand for the stew is 32 gallons per day. Both the store and production facility operate 310 days per year. The company can produce 128 gallons per day. It costs $1200 to set up a production run. The stew is stored at an annual cost of $20 per gallon. The company wants to use the optimal order quantity. (Round the order quantity to an integer value) What is the maximum inventory level? How many production runs will be required each year? What is the total annual carrying cost? If the store places an order to the production facility for 1000 gallons of stew (not necessarily the economic order quantity), how many gallons of stew will be sold during the order receipt period?
The Farmer’s Wife is a country store specializing in knickknacks suitable for a farm-house décor. One item experiencing a considerable buying frenzy is a miniature Holstein cow. Average weekly demand is 30 cows, with a standard deviation of 5 cows. The cost to place a replenishment order is $15 and the holding cost is $0.75/cow/year. The supplier, however, is inChina. The lead time for new orders is 8 weeks, with a standard deviation of 2 weeks. The Farmer’s Wife, which is open only 50 weeks a year, wants to develop a continuous review inventory system for this item with a cycle-service level of 90 percent.a. Specify the continuous review system for the cows. Explain how it would work in practice.b. What is the total annual cost for the system you developed?

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

s, fixed order cost per order is $100, each =), what should be the safety stock value?