Question: PLEASE POST ALL CALCULATIONS IN EXCEL FORMAT (using formulas etc). PLEASE POST AN ANSWER OF HOW ITS SUPPOSED TO LOOK IN EXCEL A small oil

PLEASE POST ALL CALCULATIONS IN EXCEL FORMAT (using formulas etc). PLEASE POST AN ANSWER OF HOW ITS SUPPOSED TO LOOK IN EXCEL

A small oil change shop uses an average of 80 litres of 5W40 synthetic oil per day. Usage tends to be normally distributed with a standard deviation of 8 litres per day. Lead time is four days, and the desired service level is 92 percent.

What amount of safety stock is appropriate under each of these conditions:

(i) Oil is reordered every 45 days.

(ii) A fixed order size of 2400 litres is used.

PLEASE POST AN ANSWER that is in EXCELL and excel file to my email;

grandjambe_chrissy@outlook.com

OF HOW ITS SUPPOSED TO LOOK IN EXCEL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please provide the calculations on excel or word file along with the solution Research paper on Apple INC. The paper should be approximately 7 - 10 pages (12 - font, double-spaced) in length. Proper...

AutoSave OFF AC 321 Int I - SU20 - Comprehensive Problem- Hammon(2) View Home Insert Draw Page Layout Formulas Data Review Insert WE DX Delete Format Calibri (Body) 11AA 29 29 General G Paste BIU E...

Please answer the questions. CVP Case with Mixed Costs Morrison Corporation is a small company that sells digital thermometers and other supplies to hospitals in the Phoenix, AZ area. The company...

Please look at the attached files for questions. It should be done in excel sheet using formulas. Time period is 5 days. thank you STEP #1: Template for Income Statement, Balance Sheet & Ratios. [PDF...

Physics 350 - Free Fall Objective Determine g (the size of the acceleration due to gravity) at American River College. Theory In the lecture videos, I claimed that the size of the acceleration given...

Processing steps for 18 questions are required. Thanks so much for help! Queensland University of Technology QUT Business School School of Accountancy AYB 219 Taxation Law HandiTax Group Project...

this assignment is regarding return the tax of a client by using handy taxassignment. can anyone help me to complete the income section of this assignment, just write the solution in a pdf file?I...

I need help with this project. I have attached all of the instructions and relevant information. The final draft is due August 20th. Course Project: A Financial Statement Analysis A Comparative...

(Questions from Lecture Note and ?Wall Street Journal? Articles) - Discussion Board Activity I need to read the following Lecture Note that I uploaded and some ?Wall Street Journal? articles, and...

please help me to find the answer for part 1, part3 and part4 Queensland University of Technology QUT Business School School of Accountancy AYB 339 Accountancy Capstone Integrated Case Study Semester...

In retrospect, what should have been the Federal Reserves monetary policy during the 2008 financial crisis?

What is the base sequence in the original DNA strand on which the mRNA sequence in Problem 28.9 was made? CUU-AUG-GCU-UGG-CCC-UAA

Financial risks are associated with the purchase of a home. True False

RVX engages in the manufacturing, distribution and sales of automobiles. You have been asked to discuss the liquidity of RVX. Using all the necessary tools (Hint: Trend, structure, ratio, other),...