Question Details

[solution] » On the Question 4 tab of your spreadsheet, answer the following, showing your work 4) Suppose a...

Brief item decscription

Step-by-step solution file


Item details:

On the Question 4 tab of your spreadsheet, answer the following, showing your work 4) Suppose a...
More:On the Question 4 tab of your spreadsheet, answer the following, showing your work 4) Suppose a primary spare parts supplier offers to reduce your lead-time from 3 weeks to 2 weeks if you pay $300.00 per part vs. the current price of $250.00. You find that your demand for this part is normally distributed, with a mean of 1250 parts per week and a standard deviation of 300. Your annual inventory carrying cost rate is 25%. Your customers specify 98% cycle service levels for spares in the purchase contracts. Will your safety stock inventory carrying cost increase or decrease? By how much? Please show your work on the Question 4 tab (40 points) Weekly Demand 1250 Std dev 300 CSL 98% Current lead time 3 weeks Proposed lead time 2 weeks Current price $250.00 Proposed price $300.00 Annual Carrying Cost % 25% Additional Requirements Other Requirements: Supply Chain Management Document Preview: 1250 300 0.98 3 2 250 300 0.25 On the Question 4 tab of your spreadsheet, answer the following, showing your work 4) Suppose a primary spare parts supplier offers to reduce your lead-time from 3 weeks to 2 weeks if you pay $300.00 per part vs. the current price of $250.00. You find that your demand for this part is normally distributed, with a mean of 1250 parts per week and a standard deviation of 300. Your annual inventory carrying cost rate is 25%. Your customers specify 98% cycle service levels for spares in the purchase contracts. Will your safety stock inventory carrying cost increase or decrease? By how much? Please show your work on the Question 4 tab ( 40 points ) Weekly Demand Std dev CSL Current lead time weeks Proposed lead time Current price Proposed price Annual Carrying Cost %

 







About this question:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Feb 21, 2020

PRICE: $24

Solution~000189748950.zip (18.37 KB)

Buy this answer for only: $24

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.
SiteLock

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now