Question: Please show the calculations. (in Excel file format using Excel formulas) In a class example, we determined safety inventory given a desired fill rate. The

Please show the calculations. (in Excel file format using Excel formulas)

In a class example, we determined safety inventory given a desired fill rate. The example included: ROP = 6000 units, D = 2500 units per week, op = 500 units per week, L = 2 weeks and Q = 10,000 units. We calculated DL = D*L = 5000 units of average demand during lead time and OL-VL(O) = 707 units of standard deviation of demand during lead time. To determine the amount of safety inventory needed to obtain a fill rate of 97.5%, we calculated ESC and used GOALSEEK in Excel. Use GOALSEEK to answer the following questions. Show all calculations and submit your Excel file. a) How much safety inventory would be needed if the desired fill rate is 98%? b) How much safety inventory would be needed if the desired fill rate is 98.5%? c) How much safety inventory would be needed if the desired fill rate is 99%? d) How much safety inventory would be needed if the desired fill rate is 99.5%? e) How much safety inventory would be needed if the desired fill rate is 99.9%

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 show the calculations. (in Excel file format using Excel formulas) Weekly demand for avocados at the Guac Shop is normally distributed with a mean of 2500 and a standard deviation of 650. The...

Background:You are the Inventory Manager for Pour Decisions, a local microbrewery in Fort Collins. The owner, Ray, is counting on you to determine the ideal inventory management strategy to meet the...

Fancy Millwork has a factory that produces custom kitchen cabinets. It has multiple product lines. Materials and labor for the cabinets are determined by each job. To simplify the assignment, we will...

Can you please help with lesson 5.1 and 5.2 file is attached FNCE 300/ECON 300: Assignment 2 Due: After completion of Lesson 8. Marks: 100 Credit Weight: 20% of final grade. Prepare your responses to...

T&J manufacturing has a factory that produces custom kitchen cabinets. It has multiple product lines. Materials and labor for the cabinets are determined by each job. To simplify the assignment, we...

Classic Cabinets has a factory that produces custom kitchen cabinets. It has multiple product lines. Materials and labor for the cabinets are determined by each job. To simplify the assignment, we...

Hi ptyer, Thanks for your help would it be possible to answer questions 1,2 & 7 in Excel showing the calculations? Classic Cabinets has a factory that produces custom kitchen cabinets. It has...

Classic Cabinets has a factory that produces custom kitchen cabinets. It has multiple product lines. Materials and labor for the cabinets are determined by each job. To simplify the assignment, we...

Only need the excel section completed. I will do the written report stuff. Model is the format I want it complete in. Thanks Date 6/1/2010 7/1/2010 8/1/2010 9/1/2010 10/1/2010 11/1/2010 12/1/2010...

Jessica Company was engaged by a large client in September Year 1. The parties contracted for consulting services valued at $2,400,000. In Year 1, 70% of this amount had been paid to Jessica while...

You were recently hired as the assistant treasurer for Victor, Inc. Yesterday, the treasurer was injured in a bicycle accident and is now hospitalized, unconscious. Your boss, Mr. Fernandes, just...

What are the Tax Rules when a Partnership Interest is Liquidated? According to Smalley ( 2 0 1 9 ) , there are a number of potential tax consequences of a partnership that accountants ( and their...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...