1. Using the data provided here for problem 1. Calculate the following:6 7 8 | 9WeekDemand1| 2 3 4 52554 2333 4678 4525 2243 2988 2301 3777 3245 2122 2987 2487 256710111213a. Average weekly demand.b. Target inventory for 98% Inventory Service Level for this period if you get replenishedwith new inventory every two weeks.Formulas used:a.b.

As we can see, that weekly demand is not the same in all weeks. Hence, variable demand case.

Answered: 1. Using the data provided here for…

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

please solve all questions
What is the average demand and standard deviation of demand during the protextion interval? the target inventory ? the order quantity ?
2
If the company in #8 uses exponential smoothing (smoothing factor = .6) and the forecast for the year is the figure they use for EOQ calculations, calculate the EOQ using the following information: The cost of ordering and carrying cost % are the same as #7 Cost of ordering: $25 Carrying costs: 45% Starting with 2018, Forecast the 2020 demand using exponential smoothing and then use that forecast as the annual demand. year sales 2017 1,000,000 2018 1,200,000 2019 2,000,000 2020
Economic Order Quantity and Reorder PointFind the economic order quantity and the reorder point, givenAnnual demand ( D )= 1, 000 unitsAverage daily demand ( d¯ ) = 1, 000 ∕365ordering cost ( S ) = $5 per orde rHolding cost ( H ) = $1.25 per unit per yearLead time ( L ) = 5 daysCost per unit ( C ) =$12.50What quantity should be ordered?
2.)Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 If the owner of Birka Styles & Co is an optimist, how many lots should the manager order?
3. A restaurant serves an average of 623 desert (leche flan) servings every week. The manager places an order of 1,000 servings every time she calls the supplier. Record shows that ordering cost per order is PhP30, and the holding cost per serving per year is PhP5.00. a. What is the current annual inventory costs incurred by the restaurant. b. If EOQ is used, what will be the inventory cost incurred by the restaurant each year? c. What order quantity would you recommend for the restaurant? Why?
10. Mention and describe what each of the 4 types of approaches to demand analysis discussed in class consists of.
UNCERTAIN DEMAND Lead time demand for an item averages 100 units, with a standard deviation of 30. The order quantity is 200 units. Management desires that 99 percent of all demand be met from stock. a) What is the optimal order point? b) Suppose management wanted a 98 percent service level; what would be optimal order point be c)Suppose management wanted 90 service level. Compute the optimal order point
PLEASE ANSWER BOTH QUESTIONS without excel a) Using a weighted moving average with three periods, determine the demand for period 13. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively b) Find the MAD, MSE and MAPE
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $47 Jan. 11 Aug. 13 20 units at $48 Nov. 30 $564 960 735 Avaliable for sale $2,259 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-sout (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost Inventory Purchase Purchase 15 units at $49 47 units 1,284 X
Primo Pots and Pans Company enters month 1 with 100 units in inventory and demand forecasts of 600 for month 1, 800 for month 2, and 1,200 for month 3. It elects to adopt a chase demand production strategy for this three-month period. How many units will it produce in month 2? a. 800 b. 733 c. 600 d. 700

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