FOR ALL OF THESE QUESTIONS, YOU MUST USE MICROSOFT EXCEL AND EXCEL FORMULAS TO S
ID: 3181024 • Letter: F
Question
FOR ALL OF THESE QUESTIONS, YOU MUST USE MICROSOFT EXCEL AND EXCEL FORMULAS TO SOLVE:
X6.1 Given an initial stock level of 1000 units and a daily usage rate of 20 units, calculate the length of time before a stockout.
X6.2 Given an initial stock level of 3000 units, a daily usage rate of 50 units and a current stock level of 1000 units, calculate the length of time that the production process has been operating.
X6.3 Given that the current stock level is 4000 units, that 6000 units were initially ordered and that the process has been operating for 10 days, calculate the daily rate of usage.
X6.4 Given that a stockout occurred after 25 days when the daily usage rate was 50 units, calculate the initial order quantity.
X6.5 A producer orders inventory from a supplier who can start delivery in 5 days time at a rate of 50 units per day. Daily usage of the item is 20 units and the producer has decided to order 800 units. Calculate the re-order time and the re-order stock level.
X6.6 A producer has to re-order stock after 20 days. Given that the initial order level was 1000 units, that the daily usage and replenishments rates were 20 and 40 units respectively, calculate the lead time implied.
X6.7 A firm's re-order stock level is known to be 100 units. The initial order level was 1000 units, the daily replenishment rate was 50 units and the lead time was 5 days. Calulate the implied daily usage rate.
X6.8 An order quanity of 2000 units is used up at a rate of 50 units per day. The item is replenished at a daily rate of 40 units with a lead time of 7 days. Calculate the re-order stock level.
X6.9 A production run of 250,000 units requires use of an inventory item that is available immediately and in full. The cost of the item is £80, the order costs are £4 and the holding cost is 10% of the value of the item. Determine the EOQ.
X6.10 Using the given values from Exercise X6.9, calculate the change in the EOQ that would result from a 10% increase in the ordering cost of the inventory item.
X6.11 With the original values given in Exercise X6.9, if it had been the purchase cost of the item that had increased by 10%, what is the new EOQ value?
X6.14 Repeat Exercise X6.9 using the worksheet developed in Figure 6.8
X6.15 Repeat Exercise X6.10 using the worksheet developed in Figure 6.8
X6.16 Repeat Exercise X6.11 using the worksheet developed in Figure 6.8
Figure 6.8 1 Unit ordering cost:co 0.15 2 Unit holding cost:Q 1.6 3 unit cost of stock:c 4 Demand Trial value for EOQ 5 Economic order Quantity EoQ 6 Total holding cost 600 7 Total ordering cost B3 B4. 9600 8 Total purchase cost 10224 9 Total cost 10 Solver Parameters Set Target Cel Equal To: o Max Min value of 0 By Changing Cels: 16 Subject to the Constraints: Options 17 $8$5 0 Add Reset Al DeleteExplanation / Answer
1. Length of time before stockout = 1000/20 = 50 days
2. No of days since operating = (3000-1000)/50 = 40 days
3. Daily usage = (6000 - 4000)/10 = 200 units per day
4. Initial quantity = 25*50 = 1250 units
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.