Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

FAS's initial inventory is 150 tires. Do a sales simulation for 20 days with the random number below.

image text in transcribed

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,28

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

Step: 3

blur-text-image

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

Computer Accounting With QuickBooks 2021

Authors: Donna Kay

20th Edition

1264069197, 9781264069194

More Books

Students also viewed these Accounting questions

Question

2. What appeals processes are open to this person?

Answered: 1 week ago

Question

4. How would you deal with the store manager?

Answered: 1 week ago