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. X bpen spreadsheet 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 99 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

1 Expert Approved Answer

Step: 1 Unlock

To solve this problem we will follow each calculation step by step 1 Economic Order Quantity EOQ textEOQ sqrtfrac2DSH Where D 16500 average annual dem... View full answer

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!

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

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

Wallace and Son 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 Carrying charge rate...

Peters of Persia sells fabric to a wide range of industrial and consumer users. One of the products it carries is denim cloth, used in the manufacture of jeans and carry bags. The supplier for the...

Problem 1: Jill's Job Shop buys the following Part (X-123) for use in its production system. The parts are needed throughout the entire 52-week year. Data for the part are as follows: ITEM X-123...

Problem 1 : Jills Job Shop buys the following Part (X-123) for use in its production system. The parts are needed throughout the entire 52-week year. Data for the part are as follows: ITEM X-123...

Question 17 to Question 21 are based on the problem below. High Tech, Inc. is a virtual store that stocks a variety of calculators in their warehouse. Customer orders are placed; the order is picked...

D Question 17 1 pts Question 17 to Question 21 are based on the problem below. High Tech, Inc. is a virtual store that stocks a variety of calculators in their warehouse. Customer orders are placed...

Bertas Shoe Company is considering a change of their current inventory-control system for soccer shoes. The information regarding the shoes is given below. The company decides to use a...

H&S, Inc. is a virtual store that stocks a variety of calculators in their warehouse. Customer orders are placed; the order is picked and packaged, and then shipped to the customer. A fixed order...

If your company purchases an annuity that will pay $50,000/year for 10 years ata 11% discount rate, what is the value of the annuity on the purchase date if the first annuity payment is made on the...

Consider now that you have started your new firearms business, after identifying the customers who you believe will purchase your products, along with predicting demand for the products you will...

Sered Helo Sove 8 Exit Submit ich of the following statements regarding lessee - guaranteed residual values is true for the lessee? Multiple Choice The asset and liability at the beginning of the...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...