Question: 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

been collected in the Microsoft Excel Online file

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. 5 3. What is the annual inventory halding 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 95 perecnt 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 been collectod 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. 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 review periad? Round up your answer to the nearest whole number. weeks 6. What is the optimal replenishment level without safety stock? Round your answer to the nearest whole number. reams reams reams 9. What is the optimal replenishment level with safety stock? Round your answer to the nearest whole number

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!

The sales of a popular mouthwash at Merkle Pharmacies over the past 6 months have averaged 1,800 cases per month resulting in 21,600 cases per month, which is the current order quantity. Merkle's...

The sales of a popular mouthwash at Merkle Pharmacies over the past 6 months have averaged 1 , 9 0 0 cases per month resulting in 2 2 , 8 0 0 cases per month, which is the current order quantity....

Economic Order Quantity Model Use the are Annual Demand Rate Ordering Cost Unit Cost Carrying Charge Rate 19,200 $42.00 $11.00 0.18 Formulas Economic Order Quantity (to the nearest whole) Order cost...

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

Southern Office Supplies Inc. distributes office supplies to customers in the Southeast. One popular SKU is laser printer paper. Ordering costs are $50.00 per order. One ream of paper costs $4.00,...

The weekly requirement of a part is 8 5 0 units. The order cost is $ 9 0 per order, the holding cost is $ 4 per unit per year, and the part cost is $ 2 0 0 per unit. The firm operates fifty - two...

Southern Office Supplies Inc. distributes office supplies to customers in the Southeast. One popular SKU is laser printer paper. Ordering costs are $50.00 per order. One ream of paper costs $3.60,...

Southern Office Supplies Inc. distributes office supplies to customers in the Southeast. One popular SKU is laser printer paper. Ordering costs are $42.00 per order. One ream of paper costs $3.40,...

The sales of a popular mouthwash at Merkle Pharmacies over the past 6 months have averaged 2,100 cases per month resulting in 25,200 cases per month, which is the current order quantity. Merkles cost...

EXCEL FILE DATA IS THIS VVVVVVVVVVV E F H Economic Order Quantity Model Use the area below to draw a line chart for cost functions. Annual Demand Rate Ordering Cost Unit Cost Carrying Charge Rate...

Stoichiometry: Prolonged exposure of some functionalities to the eluent (methanol) in this experiment may lead to undesirable reactions. In one case, Acetylsalicylic acid (Aspirin) can react with...

Crumble Inc., a calendar year C-Corporation, and accrual method taxpayer, provides the following information and asks you to prepare a Schedule M-1. Complete the assignment using the actual Schedule...

An interest rate increase Question 2 options: 1 ) benefits the FI by increasing the market value of the FI's liabilities. 2 ) harms the FI by increasing the market value of the FI's liabilities. 3 )...

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