Question

In: Operations Management

As a result of many process improvements and IT implementations (like EDI), Big Box-Mart has been...

As a result of many process improvements and IT implementations (like EDI), Big Box-Mart has been able to reduce its order costs from $38.38 to $7.29 when purchasing cases of paper towels from its main paper-products supplier. Annual demand is expected to be 163,000 cases and annual holding costs are $9.38 per case.

Hint #1: This is a purchasing order quantity problem (EOQ), not a production order quantity problem. For this question we are combining a JIT concept (lower ordering costs) with what you learned from a previous chapter (inventory management). If necessary, refer back to that chapter.
Hint #2: Remember to use cell references in all your formulas rather than using a rounded input value from a previous calculation.

Based on this information, what will be the new optimal order quantity (using the reduced ordering cost)? (Display your answer to the nearest whole number.)

When using the reduced ordering cost, as compared to the original ordering cost, by how many cases will the average inventory go down? (Display your answer to the nearest whole number.)

What will be the annual total combined savings to ordering costs and holding costs when using the reduced order cost, as compared to the original ordering cost? (Display your answer to two decimal places.)

Please show your work so I may learn.

Solutions

Expert Solution

Original Order Cost Reduced Order Cost Inventory go down/Savings in cost
Annual Demand 163000 163000
Holding Cost 9.38 9.38
Ordering Cost 38.38 7.29
Optimal order quantity 1155 503
Average Inventory 577 252 326
Order Frequency 141 324
Annual Holding Cost 5416.67 2360.72
Annual Ordering Cost 5416.67 2360.72
Combined Cost 10833.35 4721.43 6111.91

Explanation:

Optimal order quantity = (2*Annual Demand*Ordering Cost/Holding Cost)^0.5

The optimal order quantity is calculated for both the ordering cost

Average Inventory = Optimal Quantitiy/2

The difference of average inventories of both the order cost = 577-252 = 326

When using the reduced ordering cost, as compared to the original ordering cost, the average inventory will go down by 326 cases

Annual holding cost = Average inventory*Holding cost

Annual ordering cost = order frequency*order cost = (Annual demand/optimal quantity)*order cost

Combined cost = Annual holding cost+Annual ordering cost

The annual total combined savings to ordering costs and holding costs when using the reduced order cost, as compared to the original ordering cost is 6111.91.

Excel formula:


Related Solutions

JL.81 As a result of many process improvements and IT implementations (like EDI), Big Box-Mart has...
JL.81 As a result of many process improvements and IT implementations (like EDI), Big Box-Mart has been able to reduce its order costs from $18.17 to $5.09 when purchasing cases of paper towels from its main paper-products supplier. Annual demand is expected to be 164,000 cases and annual holding costs are $19.56 per case. Hint #1: This is a purchasing order quantity problem (EOQ), not a production order quantity problem. For this question we are combining a JIT concept (lower...
What has Wal-Mart done well (and differently) than other companies like Target, K-Mart, Sears?
What has Wal-Mart done well (and differently) than other companies like Target, K-Mart, Sears?
9.50. t test and and retail; Many communities worldwide are lamenting the effects of so-called big-box...
9.50. t test and and retail; Many communities worldwide are lamenting the effects of so-called big-box retailers (eg. Walmart) on their local communities, particularly on small, independent owned shops. Do these large stores affect the bottom lines of locally owned retailers? Imagine that you decide to test this premise. You assess earnings at 20 local stores for the month of October, a few month before a big box store opens. you then assess earnings the following October, correcting for inflation....
lisah inc manufactures golf clubs in three models. for the year the big mart line has...
lisah inc manufactures golf clubs in three models. for the year the big mart line has a net loss of $10,000 from sales $200,000, variable cost $180,000 and fixed costs $30,000. If the Big mart line is eliminated, $20,000 of fixed costs will remain. Prepare an analysis showing whether the Big Bart line should be eliminated.
In our Chapter 5 discussions, we spoke about the tensions between big box chain stores like...
In our Chapter 5 discussions, we spoke about the tensions between big box chain stores like Target, Walmart, Best Buy etc. and local "mom and pop" stores. Please describe this dynamic in the community where you live. Are there more big box or local stores? Which ones do people patronize more? How do they compare in terms of price and customer service
Suppose that a committee has been set up to evaluate and propose improvements to the current...
Suppose that a committee has been set up to evaluate and propose improvements to the current criteria used in Shariah stock screening and that you have been asked to provide inputs and suggestions. What are the recommendations on how the Shariah stock screening process and/or the criteria used can be improved?
Big Box Store (BBS) has an annual rate of 4% of all sales being returned. In...
Big Box Store (BBS) has an annual rate of 4% of all sales being returned. In a recent sample of thirty randomly selected sales the number of returns was five.(Use binomial probability) What is the probability that a random sample of 30 sales has less than four returns? What is the probability that the number of returns is not equal to 4 in a random sample of 30 sales? What is the probability that a random sample of 30 sales...
Quick Mart has been paying a quarterly dividend of $1.20 a share. Which of the following...
Quick Mart has been paying a quarterly dividend of $1.20 a share. Which of the following are valid reasons for the firm to reduce or eliminate these dividends? I. The firm is on the verge of violating a bond restriction. II. The firm wants to save cash for an acquisition with a 40 percent premium. III. The firm can raise new capital easily at a very low cost. IV. Congress just changed the tax laws eliminating all taxes on capital...
Big Spenders Inc Big Spenders Inc. has been working on diversifying its portfolio of investments and...
Big Spenders Inc Big Spenders Inc. has been working on diversifying its portfolio of investments and requires accounting advice for a decision between two car cleaning and detailing companies. Annual cash inflows from two competing investment opportunities are given below. Each investment opportunity will require the same initial investment Cleaning $3,000 and Detailing $3,200. Compute the present value of the cash inflows for each investment using an 8% discount rate for Cleaning and 10% for Detailing. Year Cleaning Detailing Discount...
BINOMIAL PROBABILITIES Big Box Store (BBS) has an annual rate of 4% of all sales being...
BINOMIAL PROBABILITIES Big Box Store (BBS) has an annual rate of 4% of all sales being returned. In a recent sample of thirty randomly selected sales the number of returns was five. BBS is concerned about the event, and your advice is solicited. FOR 4 – 9, OPEN THE EXCEL EXAM TWO FILE. THE SPREADSHEET FOR THIS PROBLEM IS FOUND ON SHEET TWO. COMPLETE AND SAVE YOUR WORK IN EXCEL AND ENTER THE SOLUTIONS BELOW. (6) (2.5points) What is the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT