Question 12Simulate the following inventory replenishment problem for 20 weeks.You will have to use the Excel program to simulate. Demand is uniformlydistributed between 20 and 30 units. Additional Data are given below.Inventory Cost/Week = $ 1.00Shortage Cost/Week = $ 2.00Lead Time = 2 weeks%3DBeginning Stock on Hand (SOH) = 0%3DSupply in Week 1 = 21 units%3!Supply in Week 2= 22 unitsWhat is the total shortage cost at the end of 20 weeks if the order size inevery week is 20 units?tionThe demand for the next 20 weeks is given belowationWeek 1 2Demand 21 224103021272823292125Week11 121314151716181920CO Supply in Week 1 = 21 units!3!Supply in Week 2 = 22 unitsWhat is the total shortage cost at the end of 20 weeks if the order size inevery week is 20 units?The demand for the next 20 weeks is given belowWeek1 2410Demand 21 223021272823292125Week11 121314151617181920Demand 22 282829272624272321O $0.00O $ 40.00O $ 990.00O $ 1980.00O None of the above

Given- Inventory Cost/Week = $ 1.00Shortage Cost/Week = $ 2.00Lead Time = 2 weeksBeginning Stock…

Answered: Simulate the following inventory…

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

Formulate the strong duality theorem and show its application to the following LP problem. Hint: find the dual of this given primal LP problem and solve both problems using graphical (geometrical) approach. Analyze the obtained solutions in terms of the strong duality theorem. Please show all work, this is an ungraded review question from lecture.
A company is planning for its financing needs and uses the basic fixed-order quantity inventory model. Which of the following is the total cost (TC) of the inventory given an annual demand of 10,000, setup cost of $32, a holding cost per unit per year of $4, an EOQ of 400 units, and a cost per unit of inventory of $150?
The seasonal demand for a particular product is given below: Period 1 2 3 4 5 6 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 following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity Please do fast .. ASAP.. fast
A company orders 100 units of a raw material every time its inventory level drops to 50 units. The lead time for the delivery of the raw material is 5 days. Currently, the inventory level is at 80 units. Assuming constant demand, calculate the reorder point for the raw material.
Suppose you have been employed by Kam Steels Corporation as a financial manager. You want to change old inventory ordering system to the just-in-time inventory method. The shareholders and the CEO of the firm would like to know how the new would operate and the benefits and disadvantages of the just-in-time inventory method. By providing a high-quality argument, please explain how the new would operate and its benefits and disadvantages to the shareholders and the CEO of the firm.
Kaniri Global Imports (a retail store) sells artisan greeting cards. The owners search for localartists from around the world from whom to buy their greeting card inventory. The followinginformation is available to you for this problem:Demand/Sales = 110 cases of cards per yearOrdering or Setup Cost = $25 per orderCarrying Charge = 18% per yearUnit Cost = $150 per caseAnswer the following questions and be sure to show your computations. You can use whateversymbol you need for square root, if typing in Word.1. How many cases should be ordered at a time? (This number will be the EOQ). Computeto two decimal places. In reality they would round, but for this problem keep the twodecimal places.2. How many times should Kaniri order in a year? Do not answer in terms of how manydays or months, but rather how many times per year. Round your answer up to the nexthighest whole number.3. Answer all three:a. What is the annual cost of ordering the cards?b. What is the annual cost of carrying the…
Items purchased from a vendor cost $250 each, and the forecast for next year’s demand is 2,000 units. The optimal order size is 100. The firm operates 52 weeks next year and lead time is 3 weeks. It costs $5 every time an order is placed for more units, and the storage cost is $2 per unit per year. What is the number of orders per year? a.35 b.20 c.22 d.25 e.5
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every two weeks. Data for both products are as follows: ITEM TEGDIW WIDGET Annual demand 7,000 10,000 Holding cost (% of item cost) 30 % 30 % Setup or order cost $ 190.00 $ 10.00 Lead time 7 weeks 2 week Safety stock 45 units 9 units Item cost $ 5 $ 6 a. What is the reorder quantity and reorder point for Tegdiws? (Round your answers to the nearest whole number.) b. What is the inventory control system for Widgets? (Round your answer to the nearest whole number.) Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer…

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