Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

pls help with 6, 7, and 8 Excel Online Activity: FQS Safety Stock Southern office Supplies Inc, distributes office supplies to customers in the Southeast.

pls help with 6, 7, and 8
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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 $40.00 per order, One ream of paper costs $3.70, and Southern uses a 20 percent annual inventory-holding cost rate. The average annual demand is 13,500 reams and historical data shows that the standard deviation of weekly demand is about 67 . The lead time from the manufacturer is 3 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. 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 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. (3) reams 7. What is the safety stock with a 90 percent service level? Round your answer to two decimal places. reams 6. What is the standard deviation of demand during thy 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 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 $40.00 per order, One ream of paper costs $3.70, and Southern uses a 20 percent annual inventory-holding cost rate. The average annual demand is 13,500 reams and historical data shows that the standard deviation of weekly demand is about 67 . The lead time from the manufacturer is 3 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. 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 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. (3) reams 7. What is the safety stock with a 90 percent service level? Round your answer to two decimal places. reams 6. What is the standard deviation of demand during thy 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Accounting Information Systems

Authors: Tony Boczko

1st Edition

0273684876, 978-0273684879

More Books

Students also viewed these Accounting questions