Question: USING EXCEL PLEASE - As the logistics representative on a manufacturers sales team, you have been asked to quantify the benefits that can be sold

USING EXCEL PLEASE - As the logistics representative on a manufacturers sales team, you have been asked to quantify the benefits that can be sold to a customer using more consistent service and transportation. The customer wants 99 percent case availability from its distribution centers that are resupplied from the manufacturer. The average daily demand in cases from the customers DC is 1,500 units with a standard deviation of 250. Historically, the replenishment performance cycle has been 10 days with a standard deviation of 4 days. The customer has traditionally used a 20 percent inventory carrying cost, and the average value of each case is $30. The customer orders weekly an order quantity of 7,000 units.

a.What is the average inventory and annual carrying cost for the current situation?

b.What is the average inventory and carrying cost impact of reducing the manufacturers performance cycle variation by 2 days?

c.How does reducing the performance cycle variation by 2 days compare with reducing the average performance cycle length by 2 days in terms of average inventory and inventory carrying cost?

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!

How will the COVID-19 pandemic alter business and society relationships? Identify and discuss some of the major effects and impacts.

26) Chronotronics produces two models of clock radios, the X-100 and the X-250 deluxe. Both products are currently packaged in a single-wall corrugation. Through close observation, the firm has...

Question 3 1 pts 3. As the logistics representative on a manufacturer's sales team, you have been asked to quantify the benefits that can be sold to a customer using more consistent service and...

As the logistics representative on a manufacturers sales team, you have been asked to quantify the benefits that can be sold to a customer using more consistent service and transportation. The...

Question 3 1 pts 3. As the logistics representative on a manufacturer's sales team, you have been asked to quantify the benefits that can be sold to a customer using more consistent service and...

As the logistics representative on a manufacturer's sales team, you have been asked to quantify the benefits that can be sold to a customer using more consistent service and transportation. The...

As the logistics representative on a manufacturer's sales team, you have been asked to quantify the benets that can be sold to a customer using more consistent service and transportation. The...

As the logistics representative on a manufacturer sales team, you have been asked to quantify the benefits that can be sold to customer using more consistent service and transportation. The customer...

CHAPTER 11 Content Marketing: Publishing Articles, White Papers, and E-Books This chapter will discuss several of content marketing, these types of conventional publishing methods, which publications...

Hiring Decision Activity In this activity, you are asked to make a hiring decision for ABC Company. Imagine that you are a sales manager for ABC. You need to hire a new sales representative to join...

The search for god at Harvard, by Ari Goldman. Just need some help figuring these out I never had to search. In what way does Goldmans statement, for the most part, reflect American Religious...

1.What is main purpose of accounting? 2.Why accounting is important in your life?

Analytical review is the evidence collection method that Group of answer choices considers the relationships and trends among information to detect items that should be investigated further. examines...

Product Line T t | Fl P k 0 a our anca e Wheat Cereal Company MIX Sales 95 550,000 $ 200,000 $ 300,000 $ 50,000 Materials, labour, and other 293,000 -90,000 183,000 20,000 Sales commissions -55,000...