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

(2-b) A firm's demand in the next four quarters is forecast to be 400, 600, 800, and 700 units. Given that beginning inventory is 600, desired ending inventory in quarter 4 is 300, inventory holding cost is $6 per unit per quarter, and production cost is $50 per unit, calculate the cost of a level production plan.
A hospital must order the drug Porapill from DaisyDrug Company. It costs $500 to place an order and $30 toreview the hospital’s inventory of the drug. Annual demandfor the drug is N(10,000, 640,000), and it costs $5 to holdone unit in inventory for one year. Orders arrive one monthafter being placed. Assume that all shortages are backlogged.a Estimate R and the number of orders per year thatshould be placed.b Using the answer in part (a), determine the optimal(R, S) inventory policy. Assume that the shortage costper unit of the drug is $100.
I need assistance to solve the following problem in Operations Analysis. 2) A coffee store is experiencing sales of 280 pounds of coffee beans per year. The supplier charges the store $2.40 per pound, and the paperwork and labor costs incurred by the store in placing an order total $45 per order. Holding costs are based on 20% interest rate per annum. a) What is the optimal order size (write down the model name, its parameters and formula)? b) What is the time between order placements (include the formula)? c) What is the average annual holding cost (include the formula)? d) If the lead time is 3 weeks, what is the reorder level based on inventory on hand (include the formula)?
Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Period Regular Time Overtime Subcontract Demand Forecast 1 30 15 5 40 2 30 15 5 45 3 30 20 5 50 Initial inventory 20 units Regular-time cost per unit $100 Overtime cost per unit $160 Subcontract cost per unit $200 Carrying cost per unit per month $4 Assume that the initial inventory has no holding cost in the first period and backorders are not permitted. Part 2 Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is $enter your response here (enter your response as a whole number).
1. 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 chocolate-covered shrimp in some boxes so that "You never know what you'll get." Quarterly demand (in boxes of chocolates) for the last three years is shown in the table below: b. If the expected sales for chocolates are 14,400 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. (Round all intermediate calculations to two decimal places.) The first quarter forecast is what? boxes of chocolates. (Enter your response rounded to the nearest whole number.)
1) What is the total demand of an enterprise with an economic order quantity of 1,500 units, a cost of 11.250 TL for each order, and 75 TL for one unit of inventory?a) 20,000b) 17,500c) 7,500d) 12,500f) 2,500 2) What is the total inventory cost of this business?a) 200,000b) 239,000c) 185,250d) 168,750e) 218,500
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days
A steel workshop of PT Mental Baja produces leaf springs for cars. theyhave a demand forecast for the next 6 months as anext:i. January 446 units (production time 20 days)ii. February 600 units (production time 18 days)iii. March 700 units (production time 20 days)iv. April 900 units (production time 20 days)v. May 650 units (production time 20 days)vi. June 550 units (production time 20 days) The following are some important information to be the basis for doingcalculation of production costs as follows:i. Inventory cost $4 per unitii. Subcontractor fee $15 per unitiii. Workers cost $10 per hour or $80 per dayiv. Production time per unit 1.6 hours Tasks and questionsa. Assuming that the number of units that can be produced is 35 units per dayand 1 person can make 7 units, make an estimated cost by usingConstant Workforce approach. b. Assuming that internal processing is carried out usingcapacitors of daily production are the lowest for 6 months and constant,calculate estimated…
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,600 June 2,200 March 1,800 July 1,800 April 1,800 August 1,400 Her operations manager is considering a new plan, which begins in January with 200units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. Part 2 requirement= The average monthly demand (Enter your response as a whole number.)
A mail-order house uses 17,460 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of Boxes Price per Box 1,000 to 1,999 $1.25 2,000 to 4,999 1.20 5,000 to 9,999 1.15 10,000 or more 1.10 a. Determine the optimal order quantity. b. Determine the number of orders per year.
The table below provides demand data for 6 weeks (weeks 31-36 for the current year) for one product. Inventory is managed with a periodic review system where T = 5 weeks and M = 280. The previous order was for 120 units at the end of week 28. The lead time is a constant 4 weeks. At the beginning of week 31 the inventory level is 130 units. Orders are made at the end of a week. 1. When is the next order? end of week __________ 2. How large is the next order? ___________ Week Demand Inventory 31 30 32 40 33 45 34 30 35 30 36 30
Bell Computers purchases integrated chips at $350per chip. The holding cost is $35 per unit per year, the orderingcost is $120 per order, and sales are steady, at 400 per month. Thecompany's supplier, Rich Blue Chip Manufacturing, Inc., decidesto offer price concessions in order to attract larger orders. Theprice structure is shown in the table. a) What is the optimal order quantity and the minimum annualcost for Bell Computers to order, purchase, and hold theseintegrated chips?b) Bell Computers wishes to use a 10% holding cost rather thanthe fixed $35 holding cost in (a). What is the optimal orderquantity, and what is the optimal annual cost?

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