Inventory management decision model

Assignment Help Basic Statistics
Reference no: EM1392703

Inventories represent a considerable investment for every organization; thus, it is important that they be managed well. Excess inventories can indicate poor financial and operational management. On the other hand, not having inventory when it is needed can also result in business failure. The two basic inventory decisions that managers face are how much to order or produce for additional inventory, and when to order or produce it to minimize total inventory cost, which consists of the cost of holding inventory and the cost of ordering it from the supplier.

Holding costs, or carrying costs, represent costs associated with maintaining inventory. These costs include interest incurred or the opportunity cost of having capital tied up in inventories; storage costs such as insurance, taxes, rental fees, utilities, and other maintenance costs of storage space; warehousing or storage operation costs, including handling, record keeping, information processing, and actual physical inventory expenses; and costs associated with deterioration, shrinkage, obsolescence, and damage. Total holding costs are dependent on how many items are stored and for how long they are stored. Therefore, holding costs are dependent on how many items are stored and for how long they are stored. Therefore, holding costs are expressed in terms of dollars associated with carrying one unit of inventory for one unit of time.

Ordering costs represent costs associated with replenishing inventories. These costs are not dependent on how many items are ordered at a time, but on the number of orders that are prepared. Ordering costs include overhead, clerical work, data processing, and other expenses that are incurred in searching for supply sources, as well as costs associated with purchasing, expediting, transporting, receiving, and inspecting. It is typical to assume that the ordering cost is constant and is expressed in terms of dollars per order.

For a manufacturing company that you are consulting for, managers are unsure about making inventory decisions associated with a key engine component. The annual demand is estimated to be 15,000 units and is assumed to be constant throughout the year. Each unit costs $80. The company's accounting department estimates that its opportunity cost for holding this item in stock for one year is 18% of the unit value. Each order placed with the supplier costs $220. The company's policy is to place a fixed order for Q units whenever the inventory level reaches a predetermined reorder point that provides sufficient stock to meet demand until the supplier's order can be shipped and received.

As a consultant, your task is to develop and implement a decision model to help them arrive at the best decision. As a guide, consider the following:

1) Define the data, uncontrollable inputs, and decision variables that influence total inventory cost.

2) Develop mathematical functions that compute the annual ordering cost and annual holding cost based on average inventory held throughout the year in order to arrive at a model for total cost.

3) Implement your model on a spreadsheet.

4) Use data tables to find an approximate order quantity that results in the smallest total cost.

5) Use Solver (in Excel) to verify your result.

6) Conduct "what-if" analyses to study the sensitivity of total cost to changes in the model parameters.

7) Explain your results and analysis.

Reference no: EM1392703

Questions Cloud

Effective human resources professionals : Effective human resources professionals have a solid understanding of the changing nature of work and the workplace
Determine number of dark parallel bands crossing top plate : The top plate is illuminated by monochromatic light of wavelength 544.1 nm. Determine number of dark parallel bands crossing the top plate (including the dark band at zero thickness along the edge of contact between the two plates).
Selecting one cable at random : The distributor selects one cable at random from among all cables in stock. If the cable selected is found to meet the strength specifications, what is the probability that the cable was produced at Plant A?
At what angular speed does the bar/clay system rotate : The loaded cab of an elevator has a mass of 3.0 x10^3 kg and moves 236 m up the shaft in 23s at constant speed. At what average speed does the force from the cable do work on the cab?
Inventory management decision model : Inventories represent a considerable investment for every organization; thus, it is important that they be managed well. Excess inventories can indicate poor financial and operational management.
How to encourage team-benefit of health of local population : How would you encourage the team to make sure that innovative and creative talents of all team members flourish for benefit of health of local population?
What force does the seat exert on the child : An 18.00 g rifle bullet travelling 250 m/s buries itself in a 3.6 kg pendulum hanging on a 2.8 m long string, which makes the pendulum swing upward in an arc. Determine the horizontal component of the pendulum's displacement.
R-chart using samples of size five : A precision parts manufacturer produces bolts for use in military aircraft. The specifications for bolt length are 37.50 ± 0.25 cm. The company has established an -chart and an R-chart using samples of size five.
Estimate the phenotypic ratios for monohybrid : Estimate the phenotypic ratios for monohybrid, dihybrid, and trihybrid crosses involving dominant/recessive loci? Using transmission genetics and the rules of probability.

Reviews

Write a Review

 

Basic Statistics Questions & Answers

  Inverse probability-normal distribution

What should the cut-off score be for the interviews? (Round to nearest whole number).

  Expected value and probability values

How much would ING be willing to pay if the General Counsel could arrange for an absolutely reliable mock trial?

  Standard deviation of r

Determine the expected number of Republicans who will win office in the coming election? Illustrate the standard deviation of r?

  Chebyshev theorem and normal distribution

Given a normal distribution of data, we know from the Empirical Rule that in between 2 standard deviations from the mean

  Completing linear programming model

Write complete linear programming model (All three parts) to find out the number of items to be transported from models A, B, C, and D to nodes 1 and 2 at minimum cost.

  Find mean and standard deviation of uniform distribution

Consider a four digit uniform random number generator; as in each of the 10,000 values 0.0000 through 9999 is equally likely. Find the mean and variance of the values produced by such a random number generator.

  Kruskal wallis non-parametric anova

Describe what the researcher must do if one of the requirements is not met and give illustrations.

  Determine population average-confidence interval

Find a 90% confidence interval for the population average µ of the percentage of hospitals providing at least some charity care.

  Using information compute blpha risk

Using this information, calculate Blpha risk (probability of Type II error) if the true population mean really is 81.

  Treatment effect and plans to use a two-tailed hypothesis

The researcher expects a 12-point treatment effect and plans to use a two-tailed hypothesis test with a = 0.05.

  Finding the range and median

Using data table given below, find out the range and median?

  Recipe brought to america by an immigrant ancestor

Leggo's pesto is make from a recipe brought to America by an immigrant ancestor the present generation refers to as Bisnonna Maria.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd