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

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
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?
10. Mention and describe what each of the 4 types of approaches to demand analysis discussed in class consists of.
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
PS Garden Variety Flower Shop uses 930 clay pots a month. The pots are purchased at $3.90 each. Annual carrying costs per pot are estimated to be 10 percent of cost, and ordering costs are $10 per order. The manager has been using an order size of 2,000 flower pots. a. What additional annual cost is the shop incurring by staying with this order size? (Round your optimal order quantity to the nearest whole number. Round all other intermediate calculations and your final answer to 2 decimal places.) Additional annual cost b.Other than cost savings, what benefit would using the optimal order quantity yield (relative to the order size of 2,000)? (Use the rounded order quantity from Part a. Round your final answer to the nearest whole percent.) About % of the storage space would be needed. Check my
16. Cheryl Hunter is responsible for maintaining adequate hospital supplies atfictional St. Thomas Hospital. The demand and lead times for syringes are assumedto be constant. During the past year, the daily demand for syringes was 80 units, andthe lead time from the supplier was 4 days. What is the reorder point?
The seasonal demand for a particular product is given below: Period 12 3 4 56 Demand 300 450 100 450 450 100 The fixed parameters are: Fixed Cost $8 Unit Production Cost $1 Holding Cost $1.3 Calculate total ordering cost using the following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity
Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal distribution with a mean of 24 gallons per week and a standard deviation of 3.5 gallons per week. The new manager desires a service level of 90 percent. Lead time is two days, and the dairy is open seven days a week. (Hint: Work in terms of weeks.)Use Table B and Table B1. a-1. If an ROP model is used, what ROP would be consistent with the desired service level? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) ROP gallons a-2. How many days of supply are on hand at the ROP, assuming average demand? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Days b-1. If a fixed-interval model is used instead of an ROP model, what order size would be needed for the 90 percent service level with an order interval of 7 days and a supply of 8 gallons on hand at the order time? (Do not round intermediate…

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