Question

Southern Office Supplies Inc.

Southern Office Supplies Inc. distributes office supplies to customers in the Southeast. One popular SKU is laser printer paper. Ordering costs are $51.00 per order. One ream of paper costs $3.80, and Southern uses a 25 percent annual inventory-holding cost rate. The average annual demand is 15,500 reams and historical data shows that the standard deviation of weekly demand is about 72. 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.

Questions

1. What is the minimum-cost economic order quantity?

2. What is the annual ordering cost for the EOQ? Use the rounded EOQ value in your calculations

3. What is the annual inventory holding cost for the EOQ?

4. What is the total annual cost for the EOQ? Use the rounded EOQ value in your calculations?

5. Assuming that there are 52 weeks in a year what is the average demand during the lead time?

6. What is the standard deviation of demand during the lead time?

7. What is the safety stock with a 99 percent service level?

8. What is the reorder point with safety stock?


0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

ans.jpeg

answered by: Subrahmanyam golla
Add a comment
Know the answer?
Add Answer to:
Southern Office Supplies Inc.
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • High Tech Inc. is a virtual store that stocks a variety of calculators in its warehouse. Customer orders are placed; the orders are picked and packaged; and then orders are shipped to the customers. A...

    High Tech Inc. is a virtual store that stocks a variety of calculators in its warehouse. Customer orders are placed; the orders are picked and packaged; and then orders are shipped to the customers. A fixed-order-quantity inventory control system (FQS) helps monitor and control these SKUs. The following information is for one of the calculators that High Tech stocks, sells, and ships. Average demand 9.5 calculators per week Lead time 5 weeks Order cost $15/order Unit cost $10.00 Carrying charge...

  • Petty House operates 52 weeks per year, 6 days per week, and uses a continuous review inventory

    Petty House operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system (i.e. Q system). It purchases kitty litter for $ 10 per bag. The following information is available about these bags. Demand = 102 bags/ week Order cost = $ 49/ order Annual holding cost = 25 percent of cogs Desired cycle service level = 80 percent Lead time = 3 weeks Standard deviation of weekly demand = 15 bags Current on-hand inventory...

  • One of the products sold by OfficeMax is a Hewlett-Packard LaserJet 299 printer. As purchasing manager,...

    One of the products sold by OfficeMax is a Hewlett-Packard LaserJet 299 printer. As purchasing manager, you have the following information for the printer: i Click the icon to view the information for the printer. a. The EOQ is 21. (Enter your response rounded to the nearest whole number.) b. The annual ordering costs and holding costs (ignoring safety stock) for the EOQ is $ 988 . (Enter your response rounded to the nearest dollar.) c. Suppose Office Max currently...

  • A local store sells toilet paper to people in the surrounding communities. The demand for the...

    A local store sells toilet paper to people in the surrounding communities. The demand for the toilet paper has been increasing and management needs to ensure that enough rolls are available to meet the increasing demand. The daily demand for the toilet paper is 400 rolls. The store operates 250 days per year. The following information is also available about the product. The cost of each roll……………………….…..$2. Ordering costs………………………………..……$100 per order Annual holding costs per unit…………… 10% of the costs...

  • Sam's Cat Hotel operates 52 weeks per year, 7 days per week, and uses a continuous...

    Sam's Cat Hotel operates 52 weeks per year, 7 days per week, and uses a continuous review inventory system. It purchases kitty litter for $10.75 per bag. The following information is available about these bags. Demand = 95 bags/week Order cost = $58/order Annual holding cost = 25 percent of cost Desired cycle@service level = 90 percent Lead time = 4 weeks (28 working days) Standard deviation of weekly demand = 16 bags Current on-hand inventory is 315 bags, with...

  • TEST Assignment 1 A computer-supply mail- order house has a memory chips in inventory that it...

    TEST Assignment 1 A computer-supply mail- order house has a memory chips in inventory that it sells to customers around the coutry. A Japanese manufacture supplies theitem using airfreigt. It has following characteristics:m Annual demand 1.200 units Leadtime Holding costs -25% per year Purchase price, delivered 75 USD per unit Ordering cost 25USD per unit - 1 week 1. Design a reorder point method of control for this item. Plot orders time diagramme. 2. What are the annual ordering and...

  • 4a. A computer company has annual demand of 100,000. They want to determine EOQ for circuit...

    4a. A computer company has annual demand of 100,000. They want to determine EOQ for circuit boards which have an annual holding cost (H) of $10/unit, and an ordering cost (S) of $200. What is the EOQ? 2000 4b. A computer company has annual demand of 100,000. They want to determine EOQ for circuit boards which have an annual holding cost (H) of $10/unit, and an ordering cost (S) of $200. What is the total annual inventory cost (setup and...

  • The Walmart distribution center has a constant demand for SKU #T35M of 10 units per day....

    The Walmart distribution center has a constant demand for SKU #T35M of 10 units per day. Walmart is very particular and wishes a 98% service level. The lead time is normally distributed with a mean of 4 days and a standard deviation of 2 days. Holding cost is $2 per unit per year. A) What is the standard deviation of demand for the lead time? B) How much safety stock should be carried and what is the reorder point? C)...

  • Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of...

    Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores and their distribution warehouse. The Paint Supply Store franchise sells an average of 64 gallons of Green Paint every week (for 52 weeks per year). They purchase Green Paint from their supplier at a price of $3.50 per gallon. [The company does not hold Safety Stock] It takes 2.25 weeks to receive an order...

  • can you show how to do this work Question 13 Using a computerized Inventory Management System,...

    can you show how to do this work Question 13 Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores X and their distribution warehouse. The Paint Supply Store franchise sells an average of 74 gallons of Purple Paint every week (for 52 weeks per year, Standard Deviation of the Demand - 8 gallons). They purchase Purple Paint from their supplier at a price...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT