Purchase Solution

Sensitivity of inventory model parameters- Hayes Electronics

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

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

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

Purchase this Solution
Free BrainMass Quizzes
Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Motivation

This tests some key elements of major motivation theories.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

View More Free Quizzes
Related BrainMass Solutions

  • Hayes Electronics: Inventory Management

    82687 Hayes Electronics: Inventory Management Hayes Electronics assumes with certainty that the ordering cost is $450 per order and the inventory carrying cost is $170 per unit per year.

  • optimal order quantity

    However, the inventory model parameters are frequently only estimates that are subject to some degree of uncertainty.

  • Sensitivity analysis



    Here is some info on sensitivity analysis:

    A sensitivity analysis is the process of varying model input parameters over a reasonable range (range of uncertainty in values of model parameters) and observing the relative change in model

  • Inventory Management Decision Model

    Solution builds a mathematical model to determine the economic order quantity. It estimates the minimum inventory cost also. "What if " analysis is carried out in MS Excel to study the sensitivity of model parameters.

  • Profit Analysis

    A consumer electronics firm produces a line of battery rechargers for cell phones. Profit Analysis. A consumer electronics firm produces a line of battery rechargers for cell phones.

  • Capital Budgeting and Sensitivity Analysis Paper

    Types of Sensitivity Analyses While the basic premise of sensitivity analysis is fairly straightforward, these can be categorized into a number of categories based on the put parameters and type of analyses required A).

  • Calculating Negative Predictive Value (Statistics)

    In fact, not only does it reduce the NPV with the current parameters, but the range of parameters (years of sales increase and rate of sales increase) for which the project has a positive NPV is now greatly reduced, as evidenced by the sensitivity table

  • Inventory Management - Hayes Electronic

    154357 Inventory Management - Hayes Electronic Hayes Electronic stocks and sells a particular brand of personal computer. It costs the firm $450 each time it places an order with the manufacturer for the personal computers.

  • Conch Republic Electronics Case

    388100 Conch Republic Electronics Case Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company.

View More Related Solutions