The solver to find the optimal order quantity

Assignment Help Basic Statistics
Reference no: EM131105030

Tim Madsen is the purchasing agent for Computer Center, a large discount computer store. He has recently added the hottest new computer, the Power model, to the store's stock of goods. Sales of this model now are running at about 13 per week. Tim purchases these customers directly from the manufacturer at a unit cost of $3,000, where each shipment takes half a week to arrive. Tim routinely uses the basic EOQ model to determine the store's inventory policy for each of its more important products. For this purpose, he estimates that the annual cost of holding items in inventory is 20 percent of their purchase cost. He also estimates that the administrative cost associated with placing each order is $75.

(a) Tim currently is using the policy of ordering 5 Power model computers at a time, where each order is timed to have the shipment arrive just about when the inventory of these computers is being depleted. Use the Solver version of the Excel template for the basic EOQ model to determine the various annual costs being incurred with this policy.

(b) Use this same spreadsheet to generate a table that shows how these costs would change if the order quantity were changed to the following values: 5, 7, 9, . . . , 25.

(c) Use the Solver to find the optimal order quantity.

(d) Now use the analytical version of the Excel template for the basic EOQ model (which applies the EOQ formula directly) to find the optimal quantity. Compare the results (including the various costs) with those obtained in part (c).

(e) Verify your answer for the optimal order quantity obtained in part (d) by applying the EOQ formula by hand.

(f) With the optimal order quantity obtained above, how frequently will orders need to be placed on the average? What should the approximate inventory level be when each order is placed?

(g) How much does the optimal inventory policy reduce the total variable inventory cost per year (holding costs plus administrative costs for placing orders) for Power model computers from that for the policy described in part (a)? What is the percentage reduction?

Reference no: EM131105030

Questions Cloud

The optimal order quantity obtained in part : The Blue Cab Company is the primary taxi company in the city of Maintown. It uses gasoline at the rate of 8,500 gallons per month. Because this is such a major cost, the company has made a special arrangement with the Amicable Petroleum Company to..
Calculate the required return for gdfc ltd : Calculate the required return (i.e. Expected Return) for GDFC Ltd - What is the maximum expected return from this project from this investment?
What is the dollar returns : OFDC Ltd is offering 6% coupon bonds, 8 years to maturity. Bonds make annual payments and have face value of $1,200. Bond sells for $925 - What is the YTM?
Question regarding the value for goodwill : A target firm has 7 million shares outstanding at a price of $20 per share. The acquiring firm offers a 10% takeover premium. The market value of the target's fixed assets is $125 million and it has $20 million in current assets. If the firm has $..
The solver to find the optimal order quantity : Tim Madsen is the purchasing agent for Computer Center, a large discount computer store. He has recently added the hottest new computer, the Power model, to the store's stock of goods.
Acquirer herfindahl index : Combined, the merged company would earn 70 percent of revenues from chemicals, 15 percent from retail drugs, and 15 percent from cosmetics. What is the acquirer's Herfindahl Index (HI) before the merge?
Optimize the amplifier matching networks : Use the amplifier of Example 12.4 in a balanced configuration operating from 3 to 5 GHz. Use quadrature hybrids, and plot the gain and return loss over this frequency range. Using microwave CAD software, optimize the amplifier matching networks to..
The setup cost for placing an order to replenish inventory : The demand for a product is 600 units per week, and the items are withdrawn at a constant rate. The setup cost for placing an order to replenish inventory is $25. The unit cost of each item is $3, and the inventory holding cost is $0.05 per item ..
Calculate the mean and the variance of this random variable : Calculate the mean and the variance of this random variable. Change the mean of this random variable to .05 by subtracting an appropriate constant from ?x. That is, calculate  ?y = ?x - μ Such that ?y has mean .05. Has the variance changed?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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