Explore BrainMass
Share

Explore BrainMass

    Sensitivity of inventory model parameters- Hayes Electronics

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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
    https://brainmass.com/business/purchases-inventory-and-cogs/sensitivity-of-inventory-model-parameters-hayes-electronics-376187

    Solution Preview

    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 = ...

    Solution Summary

    This posting shows how to compare the sensitivity of the model solution to changes in parameter values.

    $2.19