Question: Using the Economic Order Quantity Model and the data below please find the reorder point to support service levels of 90%, 80% and 75%. Also

Using the Economic Order Quantity Model and the data below please find the reorder point to support service levels of 90%, 80% and 75%.

Also please send screen shot of spreadsheet Thank you!

Data

Annual Demand Rate 15000

Ordering Cost $200

Unit Cost $22

Carrying Charge Rate 0.2

Model

Order Quantity 1167.74921352

Annual Demand Rate 15000

Ordering Cost $200

Order Cost $2,569.04

Carrying Charge Rate 0.2

Unit Cost $22

Inventory Cost $2,569.05

Total Cost $5,138.09

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!

Q:

3. In the economic order quantity model discussed in this chapter, find the reorder point to support service levels of 90%, 80%, and 75%.

Q:

Q3.Short-term financing i n smartselectimage PlS open \fBillabong (BBG.AX) Analysis By Dr Jennifer Harrison Source: Bloomberg, as cited in Greenblat, E. 2013, 'Billabong adrift without chief...

Q:

Group: PERON A+ PERSON B +PERSON C 1- Introduction 2- Literature a. Definition of operation management b. Definition of operation strategy and why it is important c. Components of operations strategy...

Q:

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

Q:

financial SUBDOMAINS: 325.4 COMMUNICATING EFFECTIVELY IN ORGANIZATIONS 326.1 MANAGING INTERNAL COST & CONTROLLING FINANCES 326.2 MANAGING CAPITAL & FINANCIAL ASSETS 326.4 MANAGING ENTERPRISE RISK &...

Q:

Hw #5 Answer the following problems * Show ALL WORKI 3(A-D),4,19,20 31 cation for these Unit Cost Uni Cost 20 4. Por, 5100, E130 Find Moden this Story The intable context menu and me from Ny Time...

Q:

Business Event Analysis: Complete the following table based on the specified NBD event. Receive Shipment (From Supplier) Trigger(s) (also indicate type) Collected Data (originates as input for event)...

Q:

Question 1 (Network design optimization). [20 points] ABC Limited Corp. has won contracts to supply a high-tech product to customers in Asia, North America, Europe, and South America. The company has...

Q:

Case Analysis read the two cases below words :500 The topic of this paper is Operations Management and Value creation: Lessons from cases. Summarize both cases (Roche and Atlantic Animal Hosptial)...

Q:

Question number 6 and onwards Economic order quantity: The ideal amount of inventory that will be ordered with each replenishment cycle to minimize inventory related costs e.g., holding costs,...

Q:

Calculate the pH and percent ionization of a 0.80 M HNO2 solution.

Q:

Firm ABC wants to purchase a new machine for a two-year project. The machine costs $100,000 and generates positive after-tax cash flows of $65,000 at the end of each of the next two years. The...

Q:

Corporate Accumulations ( LO 1 1 . 8 ) Which of the following statements regarding personal holding companies is false? a . A personal holding company operates a business which is a hobby for its...

Q:

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...