Question: Fixed Order Quantity Inventory System with Uncertain Demand Average Annual Demand 16,500.00 Ordering Cost $47.00 Unit Cost $3.70 Carrying Charge Rate 0.20 Lead time (weeks)

Fixed Order Quantity Inventory System with

Fixed Order Quantity Inventory System with Uncertain Demand Average Annual Demand 16,500.00 Ordering Cost $47.00 Unit Cost $3.70 Carrying Charge Rate 0.20 Lead time (weeks) 2.00 Weeks in a year 52 Standard deviation of weekly demand 69.00 Service level 0.99 Formulas Economic Order Quantity (to whole number) Order cost Inventory cost Total cost #N/A #N/A #N/A #N/A Average demand during lead time Standard deviation during lead time z-value Safety stock Reorder point #N/A #N/A #N/A #N/A #N/A Southern Office Supplies Inc. distributes office supplies to customers in the Southeast. One popular SKU is laser printer paper. Ordering costs are $47.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 16,500 reams and historical data shows that the standard deviation of weekly demand is about 69. 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. Open spreadsheet Questions 1. What is the minimum-cost economic order quantity? Round your answer to the nearest whole number. 1448 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. $ 535.57 g 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. $ 535.76 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. $ 1071.33 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. 317.31 X reams 6. What is the standard deviation of demand during the lead time? Round your answer to two decimal places. 138.00 X reams 7. What is the safety stock with a 99 percent service level? Round your answer to two decimal places. 2.33 X reams 8. What is the reorder point with safety stock? Round your answer to the nearest whole number. 956 X reams

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Fixed Order Quantity Inventory System with Uncertain Demand Average Annual Demand 16,500.00 Ordering Cost $47.00 Unit Cost $3.70 Carrying Charge Rate 0.20 Lead time (weeks) 2.00 Weeks in a year 52...

C Fixed Order Quantity Inventory System with Uncertain Demand Average Annual Demand 15,500.00 Ordering Cost $44.00 Unit Cost $4.00 Carrying Charge Rate 0.20 Lead time (weeks) 2.00 Weeks in a year 52...

Fixed Order Quantity Inventory System with Uncertain Demand Average Annual Demand 14,000.00 Ordering Cost $44.00 Unit Cost $3.60 Carrying Charge Rate 0.25 Lead time (weeks) 2.00 Weeks in a year 52...

Fixed Order Quantity Inventory System with Uncertain Demand Average Annual Demand 13,000.00 Ordering Cost $50.00 Unit Cost $3.60 CarryingChargeRateLeadtime(weeks)0.152.00...

Fixed Order Quantity Inventory System with Uncertain Demand Average Annual Demand 14,000.00 Ordering Cost $44.00 Unit Cost $3.60 Carrying Charge Rate 0.25 Lead time (weeks) 2.00 Weeks in a year 52...

CENGAGE |MINDTAP Q Search this course Excel template - Saved v Search (Option + Q) Chapter 12 Excel Activity: FQS Safety Stock X File Home Insert Draw Page Layout Formulas Data Review View Help...

Arial Merge $ 40 .00 .00 .0 SH 12 fx B D E F G H | A Fixed Order Quantity Inventory System with Uncertain Demand 1 2 B 1 5 5 7 Average Annual Demand 13,500.00 Ordering Cost $43.00 Unit Cost $4.00...

B C D E Fixed Period Inventory System with Uncertain Demand + Average Annual Demand Ordering Cost Unit Cost Carrying Charge Rate Lead time (weeks) Weeks in a year Standard deviation of weekly demand...

6. What is the optimal replenishment level without safety stock? Round your answer to the nearest whole number. reams 7. What is the standard deviation of demand over the period T + L? Use the...

[20 points] Petromax Enterprises uses a continuous review inventory control system for one of its SKUs. The following information is available on the item. Order cost = $35/order Unit cost = $10...

A Ltd signed a legal agreement in terms of which the company would obtain control over the majority of the assets and liabilities of B Ltd on 1 January 2020, subject to approval by the South African...

As of mid-June 2009, five U.S. Government Bond mutual funds were reported as having generated the 1-year and 3-year (annualized) rates of return shown below. a. Determine the least-squares regression...

7 At each stage of a supply chain, why do forecasts based on orders received lead to the bullwhip effect, especially if lead times are long? What countermeasures can improve the situation?

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...