Use a separate excel spreadsheet to answer each of the 6 questions using the data provided. Also, provide a detailed description of the steps taken while working the problems. Lastly, explain why the numbers obtained resembled those expected.
1. For the next eight week period, a supplier will deliver orders of the same quantity every Monday morning. The customer’s daily demand will be constant at 200 units over this period and there is no initial inventory. Plan what the order quantity should be such that the fill rate is 100% and the average inventory is minimized. For this and all the questions to follow, the weekly average inventory formula is
= MAX(0,IF(end.inv>=0,(beg.inv.+end.inv)/2,(beg.inv.)2/(2X(beg.inv+end.inv.))
2. Same questions as in question 1., but now the supplier delivers orders every Monday and Friday morning, and the order quantity is the same on both days for the entire period.
3. Orders are delivered by trucks with capacity of 1200 units. One truck delivery costs $800 irrespective of the load. Alternatively, units can be shipped by courier at a cost of $2 each. A combination of the two types of delivery is also acceptable. Average inventory comes at a cost of $3 per average unit held in storage for the entire period. The fill rate is kept at 100%. Should the customer receive deliveries on Monday, or on Monday and Friday? Should the $3 increase or decrease for the two options to become indifferent? Why?
4. The supplier starts the eight-week period again with an initial inventory of 200 units, and receives orders of 1350 units every Monday and Friday morning. The daily demand is still constant at 400 units. The holding and transportation costs are still identical. Units are sold to the customer’s customers at $100 apiece. Compare the profits of the following two models. In the first, stockouts result in lost sales. In the second, stockouts result in backlogs, each with a penalty cost for the customer of $10.
5. Compare the fill rate and cycle service level of the two models in question 4. Then provide a variable quantity ordering policy that improves both profits, fill rate and cycle service level. In the model, the fill rate should be calculated as the ratio between the on-time sales and the total sales or demand, in order to avoid complicated formulas with the backlogs.
6. Suppose demand varies normally with mean 400 units and standard deviation 25 units. Using the ordering policy of question 1., provide the fill rate as an average of 20 simulations. Then raise the standard deviation to 100 and provide the new fill rate as an average of 20 simulations. Then, increase the beginning inventory of the period by the appropriate safety inventory level that guarantees an average fill rate similar to that when the standard deviation was 25 units. The formula for a random normal demand is =MAX(0,NORM.INV(RAND(),mean,st.dev.))
Place your order now for a similar paper and have exceptional work written by our team of experts to guarantee you A Results
Why Choose US :
6+ years experience on custom writing
80% Return Client
Urgent 2 Hrs Delivery
Your Privacy Guaranteed
Unlimited Free Revisions
