Question: Please show all calculations clearly, if you use excel please show the formulas used. 4. Recently, Valles Galactic Industries has had a breakthrough of success

Please show all calculations clearly, if you use

Please show all calculations clearly, if you use excel please show the formulas used.

4. Recently, Valles Galactic Industries has had a breakthrough of success with their VaRapido electric car. Production, at the moment, seems overwhelmed. You are asked to look at some data that has been collected. One study revealed the following for one specific part: Number of Demands/day Probability 0 .08 1 .37 2 .19 3 .14 4 .22 The VaRapido will be updated next year so the part is expected to have a 400 day existence. The part costs $2500 when bought now or $6000 during the 400 day period. Holding costs are based on interest rate of 8%. If the parts are not used, they can be scrapped at 15% of purchase price. How many parts should be bought in advance

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!