I need assistance in how to solve the below problem.
Hayes Electronics assumes with certainty that the ordering cost is $450 per order and the inventory carrying cost is $170 per unit per year. However, the inventory model parameters are frequently only estimates that are subject to some degree of uncertainty.
Consider four cases of variation in the model parameters as follows:
(a) both ordering cost and carrying cost are 10% less than originally estimated.
(b) both ordering cost and carrying cost are 10% higher than originally estimated,
(c) ordering cost is 10% higher and carrying cost is 10% lower than originally estimated,
(d) ordering cost is 10% lower and carrying cost is 10% higher than originally estimated. Determine the optimal order quantity and total inventory cost for each of the four cases.
Prepare a table with values from all four cases and compare the sensitivity of the model solution to changes in parameter values.© BrainMass Inc. brainmass.com October 10, 2019, 2:24 am ad1c9bdddf
See the attached EXCEL file for all details. Thanks
D=Annual Demand 1,200.00 units
Ch=Annual Carrying Cost $170.00 per unit per year
Co=Order Cost $450.00 per order
EOQ = ...
This posting shows how to compare the sensitivity of the model solution to changes in parameter values.