What is the minimum-cost economic order quantity

Assignment Help Operation Management

Reference no: EM132230916

Excel Online Activity: FQS Safety Stock

Southern Office Supplies Inc. distributes office supplies to customers in the Southeast. One popular SKU is laser printer paper. Ordering costs are $49.00 per order. One ream of paper costs $3.60, and Southern uses a 15 percent annual inventory-holding cost rate. The average annual demand is 17,000 reams and historical data shows that the standard deviation of weekly demand is about 74. The lead time from the manufacturer is 2 weeks. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Questions

1. What is the minimum-cost economic order quantity? Round your answer to the nearest whole number.

reams

2. What is the annual ordering cost for the EOQ? Use the rounded EOQ value in your calculations. Round your answer to the nearest cent.

3. What is the annual inventory holding cost for the EOQ? Use the rounded EOQ value in your calculations. Round your answer to the nearest cent.

4. What is the total annual cost for the EOQ? Use the rounded EOQ value in your calculations. Round your answer to the nearest cent.

5. Assuming that there are 52 weeks in a year what is the average demand during the lead time? Round your answer to two decimal places.

reams

6. What is the standard deviation of demand during the lead time? Round your answer to two decimal places.

reams

7. What is the safety stock with a 90 percent service level? Round your answer to two decimal places.

reams

8. What is the reorder point with safety stock? Round your answer to the nearest whole number.

reams

Reference no: EM132230916

Questions Cloud

Ordering cost based on minimum-cost economic order quantity : What is the minimum-cost economic order quantity? What is the annual ordering cost based on the minimum-cost economic order quantity?

What is the per-item cost of overestimating demand : What is the per-item cost of overestimating demand? If the demand distribution is uniform what is the optimal order quantity?

Methods of shaping employee behavior : Review the following methods of shaping employee behavior and write the letter corresponding to each before the situation(s) illustrating it.

Demonstrate the various features of your software : You are a software sales manager and you want your new sales reps to be able to demonstrate the various features of your software.

What is the minimum-cost economic order quantity : What is the minimum-cost economic order quantity? What is the standard deviation of demand during the lead time?

Starting point for setting up information governance program : An obvious starting point for setting up an information governance program is for an organization to complete a needs assessment.

Considerations in order to satisfying customers needs : Business environment is affected by some of factors which we should be taken in our Considerations in order to satisfying customers’ needs

Graphical solution procedure to find new optimal solution : Does the optimal solution change? Use the graphical solution procedure to find the new optimal solution.

Test is in fact good predictor of job performance : What type of evidence do you need to ensure that the test is in fact a good predictor of job performance?

User Account

All Pages