Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

According to answers picture fill in the blanks. A candle vendor can keep at most 80 candles in the inventory and reviews the inventory at

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

According to answers picture fill in the blanks.

A candle vendor can keep at most 80 candles in the inventory and reviews the inventory at the end of every three days. The vendor places an order if the ending inventory is at most 20 candles at the end of each cycle such that the maximum inventory capacity is reached. The demand for candles depends on the power outages and the probability distributions of the demand on days when there is a power outage and days without a power outage are given in Table 1 below. Table 1: Demand Probability Distribution Power Outage (0) No Outage (NO) Demand 10 0 0.4 20 0.3 0.3 30 0.4 0.2 40 0.2 0.1 50 0.1 0 The lead time, that is the time between placing an order and the time the order is received, is randomly distributed between 1 day and 4 days with the probability distribution given in Table 2 below. Table 2: Lead Time Probability Distribution Lead Time (Days) Probability 1 0.25 2. 0.30 3 0.35 4 0.10 (a) Given the random digits in Table 3 below, generate four random lead time values using the lead time probability distribution. Fill in the empty column of the table with these lead time values. This list of random lead times should be used one by one in the given order when this inventory system is simulated. Table 3: Random Lead Times Order Index Random Digits Lead Time (Days) 24 1st 2nd 55 3rd 91 4th 78 (b) Assume that the vendor has 60 candles at the beginning of the first simulated day, backorders are allowed (shortages will be met once enough units are available, therefore, it is possible to order more than the inventory holding capacity of 80 candles), and there are no backorders at the beginning. Simulate this system for three cycles using the table below. In the "Beginning Inventory" and "Ending Inventory" columns, you can enter negative values as well as positive values or zero. In the "Shortage Quantity" column, for each day, report the shortage quantity of the specific day only, not the cumulative shortage values, as a non-negative value. Random Digits Beginning Shortage Cycle Day Power Demand Ending Inventory for Demand Inventory Quantity 1 1 NO 28 2 NO 74 3 O 17 2 4 O 80 5 O 55 6 NO 67 3 7 O 96 00 O 25 9 NO 90 (c) Answer the following two questions based on the simulation above. 1) What is the average amount of shortage per day over the simulation period? ANSWER: (ii) What is the average number of units ordered per cycle? ANSWER: (ii) What is the total lead time demand over the simulation period? ANSWER: Answers 10 20 30 40 50 60 70 80 90 100 0 -10 || -20 -30 -40 -50 || -60 -70 || -80 1 | 2 || 3 || 4 210 | 220 || 230 || 240 | 40 50 60 70 | 110 || 120 || 130 || 140 | 250 || 260 || 270 | 280 A candle vendor can keep at most 80 candles in the inventory and reviews the inventory at the end of every three days. The vendor places an order if the ending inventory is at most 20 candles at the end of each cycle such that the maximum inventory capacity is reached. The demand for candles depends on the power outages and the probability distributions of the demand on days when there is a power outage and days without a power outage are given in Table 1 below. Table 1: Demand Probability Distribution Power Outage (0) No Outage (NO) Demand 10 0 0.4 20 0.3 0.3 30 0.4 0.2 40 0.2 0.1 50 0.1 0 The lead time, that is the time between placing an order and the time the order is received, is randomly distributed between 1 day and 4 days with the probability distribution given in Table 2 below. Table 2: Lead Time Probability Distribution Lead Time (Days) Probability 1 0.25 2. 0.30 3 0.35 4 0.10 (a) Given the random digits in Table 3 below, generate four random lead time values using the lead time probability distribution. Fill in the empty column of the table with these lead time values. This list of random lead times should be used one by one in the given order when this inventory system is simulated. Table 3: Random Lead Times Order Index Random Digits Lead Time (Days) 24 1st 2nd 55 3rd 91 4th 78 (b) Assume that the vendor has 60 candles at the beginning of the first simulated day, backorders are allowed (shortages will be met once enough units are available, therefore, it is possible to order more than the inventory holding capacity of 80 candles), and there are no backorders at the beginning. Simulate this system for three cycles using the table below. In the "Beginning Inventory" and "Ending Inventory" columns, you can enter negative values as well as positive values or zero. In the "Shortage Quantity" column, for each day, report the shortage quantity of the specific day only, not the cumulative shortage values, as a non-negative value. Random Digits Beginning Shortage Cycle Day Power Demand Ending Inventory for Demand Inventory Quantity 1 1 NO 28 2 NO 74 3 O 17 2 4 O 80 5 O 55 6 NO 67 3 7 O 96 00 O 25 9 NO 90 (c) Answer the following two questions based on the simulation above. 1) What is the average amount of shortage per day over the simulation period? ANSWER: (ii) What is the average number of units ordered per cycle? ANSWER: (ii) What is the total lead time demand over the simulation period? ANSWER: Answers 10 20 30 40 50 60 70 80 90 100 0 -10 || -20 -30 -40 -50 || -60 -70 || -80 1 | 2 || 3 || 4 210 | 220 || 230 || 240 | 40 50 60 70 | 110 || 120 || 130 || 140 | 250 || 260 || 270 | 280

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inventory Best Practices

Authors: Steven M. Bragg

2nd Edition

1118000749, 9781118000748

More Books

Students also viewed these Accounting questions