Question: Do the following problem. Show your work. You can either use MS Excel. A car rental agency uses 1000 boxes of staples a year. The

Do the following problem. Show your work. You can either use MS Excel.

A car rental agency uses 1000 boxes of staples a year. The boxes cost $6 each. It costs $9 to order staples, and it costs $0.50 to hold a box of staples in inventory for one year.

(a) At the present time the car rental company is ordering 200 boxes per order. What is the total inventory cost for this order quantity?

(b) How many boxes of staples should the car rental company order each time they need staples, to minimize their combined ordering and holding costs for staples (economic order quantity)?

(c) Suppose that the company is open 250 days per year with lead time (LT) of 2 days to get an order. What would the reorder point (ROP) be without consideration for safety stock or service level?

(d) If you wanted a safety stock (SS) of 10 boxes, what would be the reorder point?

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!

Do the following problem. Show your work. You can either use MS Excel. A car rental agency uses 1000 boxes of staples a year. The boxes cost $6 each. It costs $9 to order staples, and it costs $0.50...

Focusing attention on the most important problem areas is referred to as: 2 points O quality assurance O cause-and-effect analysis O O O O O O brainstorming quality circles O Pareto analysis 2 points...

Multiple Choice Questions: A car rental agency uses 96 boxes of staples a year. The boxes cost $4 each. It costs $10 to order staples, and carrying costs are $0.80 per box on an annual basis. [Answer...

False or True? Why? 1. Which item to order and with which supplier the order should be placed are the two fundamental issues in inventory management. 2. Variability in demand and/or lead time can be...

This will need to be hand graded, so ignore whatever grading it shows. Some parts of the questions like the last porte than others, but Canvas cannot handle this. Please do not use dolor signs (5) in...

Time Value of Money: Single Cash Flows Introduction Time value of money (TVM) is the foundation of mathematical finance. This assignment is designed to show you how the TVM concept can be applied to...

Questions: 1. Using Bryson's power vs. interest criteria identify Coler's "player" stakeholders 2. What are the key factors in Coler's political environment that influence his decision-making? 3....

BHD 30 Using Excel to Solve Cost Accounting Problem Data Cost of Motor Car 11,000 Trade-in price after 3 years or 60,000 kilometres is expected to be 3,000 Maintenance - 6-monthly service costing 120...

Type the answer in the template, and all information in the case profile. Cost Accounting Approaches: The Lean Success Case Author: Bassima Hout Online Pub Date: January 04, 2017 | Original Pub....

Mahmood al-Fahdui Importers Limited (MFIL) of Vancouver has 30 million common shares outstanding at a market value of $7.80 per share on March 31, 2010. On April 1, 2010, MFIL issued one right for...

2) In the following single-phase lossless overhead line with ZA=200 92, VA=3108 m/s and LA=20km is connected to a single-phase lossless cable with ZB-100 2 and VA-2108 m/s and LB=10km. At the sending...

Which of the following types of erepheins is requensible for dete integrity? fural erginase: belif erginee: meshanical ergines: civil enginees

Note: This problem is for the 2018 tax year. Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social...