Question
Fast Auto Service (FAS) is a shop that sells car tires, and is evaluating its inventory policy. Currently, FAS is calculating the amount of inventory
Fast Auto Service (FAS) is a shop that sells car tires, and is evaluating its inventory policy. Currently, FAS is calculating the amount of inventory when the store is closed. If the inventory is less than 80, then he immediately orders back to the supplier for 150 tires, and the tires ordered will arrive 2 days later when the shop closes (2 days sales are purely dependent on existing inventory). The following is the tire request data for the last 50 days.
FAS's initial inventory is 150 tires. Do a sales simulation for 20 days with the random number below.
Question: a. What is the average demand for tires for 20 days? Can all requests be fulfilled? What is the average sales? b. What is the average inventory? What is the average stock-out (out of stock)? c. If the purchase price of a tire is $500 with a margin of 20%, and the inventory cost is $20 per unit per day, what is the total profit for those 20 days?
Hint: In the event of a stock-out, the company will lose the opportunity to make a profit.
Day 1 2 3 4 5 6 7 8 9 10 RN 0,17 0,14 0,68 0,36 0,99 0,33 0,14 0,55 0,44 0,07 Day 11 12 13 14 15 16 17 18 19 20 RN 0,37 0,46 0,29 0,73 0,57 0,2 0,35 0,91 0,06 0,28Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started