Question

In: Operations Management

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

Solutions

Expert Solution

CASE 1 : WHEN ORDERING COST IS $ 18.17

Annual Demand (D) = 164,000 cases

Ordering cost per order (S) = $ 18.17

Annual Holding cost per unit (H) = $ 19.56

EOQ = 552 cases

Average Inventory = Q/2

Average Inventory = 552/2

Average Inventory = 276 cases

Annual Inventory Cost = (D/Q) × S + (Q/2) × H

Annual Inventory Cost = [(164,000/552) × 18.17] + [(552/2) × 19.56]

Annual Inventory Cost = 5398.3333 + 5398.56

Annual Inventory Cost = $ 10,796.8933

CASE 2: WHEN ORDERING COST IS $ 5.09

Annual Demand (D) = 164,000 cases

Ordering cost per order (S) = $ 5.09

Annual Holding cost per unit (H) = $ 19.56

(A)

EOQ = 292 cases

Optimal Order Quantity = 292 cases

(B)

Average Inventory = Q/2

Average Inventory = 292/2

Average Inventory = 146 cases

Reduction in average Inventory = 276 - 146

Reduction in average Inventory = 130 cases

(C)

Annual Inventory Cost = (D/Q) × S + (Q/2) × H

Annual Inventory Cost = [(164,000/292) × 5.09] + [(292/2) × 19.56]

Annual Inventory Cost = 2,858.767 + 2855.76

Annual Inventory Cost = $ 5714.527

Savings in Annual Inventory Cost = $ 10,796.8933 - $ 5714.527

Savings in Annual Inventory Cost = $ 5082.3663

Savings in Annual Inventory Cost = $ 5,082.37


Related Solutions

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...
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
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...
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...
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 cost of a wedding has skyrocketed in recent years. As a result, many couples are...
The cost of a wedding has skyrocketed in recent years. As a result, many couples are opting to have their weddings in the Caribbean. A Caribbean vacation resort recently advertised that the cost of a Caribbean wedding was less than $10 000. Listed below is the total cost (in $ thousands) for a sample of eight Caribbean weddings: $10.0 $9.4 $9.9 $9.4 $9.4 $9.1 $10.9 $10.7 a. State the null hypothesis and the alternate hypothesis. (Enter the final answers in...
The cost of a wedding has skyrocketed in recent years. As a result, many couples are...
The cost of a wedding has skyrocketed in recent years. As a result, many couples are opting to have their weddings in the Caribbean. A Caribbean vacation resort recently advertised that the cost of a Caribbean wedding was less than $10 000. Listed below is the total cost (in $ thousands) for a sample of eight Caribbean weddings: $9.7 $10.2 $9.1 $10.6 $9.3 $10.1 $11.0 $9.8 a. State the null hypothesis and the alternate hypothesis. (Enter the final answers in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT