Homework Assignment #5 – Inventory Control Models

Subject: Business / Accounting
Question
Homework Assignment #5 – Inventory Control Models

After you have submitted your answers in the Assignment #_ Submission Link, upload the Excel
file containing your answers and calculations into the Home Work #_ Supporting Documentation
Submission link prior to the due date and time.
NOTE: UNLESS EXPRESSLY STATED CARRY YOUR ANSWERS TO TWO (2) DECIMAL PLACES. Scenario 1. A wholesale distributor stocks and sells low flow toilets to contractors for use in commercial office buildings. The estimated annual demand for the toilets is 4,925 units. The estimated average demand per day is 19 units. The purchase cost from the toilet manufacturer is $138.00 per unit. The lead­time for a new order is 6 days. The ordering cost is $85.00 per order.
The average holding cost per unit per year is $4.14. The distributor has traditionally ordered 210
units each time they placed an order. Based upon using the distributor’s current ordering model: (5 points each for a total of 25 points)
Question 1: What is the average number of units in inventory based upon ordering 210 units each
time an order is placed? (5 points)
Question 2: How many orders per year will be necessary based upon ordering 210 units each time an order is placed? Round your answer to two decimals. (5 points)
Question 3: What is the average dollar value of inventory based upon ordering 210 units each time an order is placed? (5 points)
Question 4: What is the total annual cost (Purchase Cost + Ordering Cost + Holding Cost) based upon ordering 210 units each time an order is placed? (5 points)
Question 5: What is the optimal reorder point based upon ordering 210 units each time an order is placed? (5 points) Scenario 2. The president of the wholesale distributor has recently heard about the EOQ model and is interested in learning whether or not using this model would allow the company to reduce its annual costs by optimizing the number of orders placed each year and the number of toilets purchased in each order. The estimated annual demand for the toilets, estimated average demand
per day, purchase cost from the toilet manufacturer per unit, lead time for a new order, ordering cost per order and average holding cost per unit per year remain the same as stated in Scenario #1 for the current ordering model. Based upon using the EOQ model (with instantaneous receipt): (5 points each for a total of 30 points)
Question 6: What is the economic order quantity (EOQ) that will minimize inventory costs? (5 points)
Question 7: How many orders per year will be necessary based upon using the EOQ? (5 points)
Question 8: What is the average number of units in inventory based upon ordering using the EOQ? (5 points)
Question 9: What is the average dollar value of inventory based upon ordering using the EOQ? (5 points)
Question 10: What is the total annual cost (Purchase Cost + Ordering Cost + Holding Cost) based upon using the EOQ? (5 points)
Question 11: What is the optimal reorder point based upon using the EOQ? (5 points)
Scenario 3. The wholesale distributor has traditionally relied upon an instantaneous receipt model in which the material associated with each order is received in a single batch. The toilet manufacturer has suggested to the president of the wholesale distributor that he might want to consider agreeing to accept receipt of ordered material incrementally over a period of time rather
than in a single batch as a means for reducing total annual costs. The toilet manufacturer has advised that his factory’s daily production rate is 34 toilets and the set­up cost for each production run is $330. The estimated annual demand for the toilets, estimated average demand per day, purchase cost from the toilet manufacturer per unit, lead time for a new order, ordering cost per order and average holding cost per unit per year remain the same as stated in the scenario for the current ordering model. Based upon using the EOQ model without instantaneous receipt (a.k.a., production run model): (5 points each for a total of 35 points)
Question 12: What is the optimal order quantity without instantaneous receipt? (5 points)
Question 13: What is the maximum number of units in inventory without instantaneous receipt? (5 points)
Question 14: What is the average number of units in inventory without instantaneous receipt? (5 points) Question 15: What is the average dollar value of inventory without instantaneous receipt? (5 points)
Question 16: What is the total annual cost (i.e., Purchase Cost + Ordering Cost + Holding Cost) without instantaneous receipt? (5 points)
Question 17: What is the optimal reorder point without instantaneous receipt? (5 points)
Question 18: How many set­ups per year will be necessary without instantaneous receipt? (5 points)
Scenario 4. The toilet manufacturer has proposed a quantity discount schedule for toilets as reflected in the following table for consideration by the president of the wholesale distributor as a means to potentially reduce his total annual costs.
Discount Number
1
2
3 Quantity Ordered
0 to 1,000
1,001 to 2,000
2,001 and over Unit Cost Discount
0%
12.25%
17.25% The estimated annual demand for the toilets, estimated average demand per day, purchase cost from the toilet manufacturer per unit, lead time for a new order, ordering cost per order and average holding cost per unit per year remain the same as stated in the scenario for the current ordering model. Based upon using the quantity discount model: (10 points each for a total of 20 points)
Question 19: What order quantity will allow the wholesale distributor to minimize total annual inventory costs (Purchase Cost + Ordering Cost + Holding Cost) by taking advantage of the proposed discount pricing? (10 points)
Question 20: What is the total annual cost (Purchase Cost + Ordering Cost + Holding Cost) based upon taking advantage of the proposed discount pricing? (10 points)
Scenario 5. The president of the wholesale distributor is concerned about the possibility of stockouts causing a loss of customer confidence and loyalty and is interested in maintaining safety stock in inventory to prevent potential stockouts. Based upon using the safety stock models: (10 points each for a total of 30 points)
Question 21: Assuming demand is normally distributed with a mean of 19 units and a standard deviation of 4 units, and a constant lead time of 6 days, what is the reorder point necessary to
provide a 98% level of service? (10 points)
Question 22: Assuming demand is constant at 19 units per day, and lead time is normally distributed with a mean of 6 days and a standard deviation of 3 days, what is the reorder point necessary to provide a 98% level of service? (10 points) Question 23: Assuming that demand is normally distributed with a mean of 19 units and a standard deviation of 4 units, and lead­time is normally distributed with a mean of 6 days and
a standard deviation of 3 days, what is the reorder point necessary to provide a 98% level of service? (10 points)

https://applewriters.com/place-order/

We can do it for you