Question: the spreadsheet and perform the repuirod analysis to answer the questions below. X Open spreadsheet Questions 1. What is the minimum-cost economic order quantity? Round

the spreadsheet and perform the repuirod analysis

the spreadsheet and perform the repuirod analysis to answer the questions below. X Open spreadsheet Questions 1. What is the minimum-cost economic order quantity? Round your answer to the nearest whole number. 2) reams 2. What is the annual ordering cost far the EQQ? Use the rounded EOQ value in your calculatians. Round your answer ta the nearest cent. $464.326 3. What is the annual inventory holding cost for the ECQ? 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 caloulations. Round your answer to the nearest cent, $464.36 5. Assuming that there are 52 weeks in a year what is the review period? Round up your answer to the nearest whole number. weeks 6. What is the optimal replenishment level without aafety stock? Raund your answer to the nearest whole number. 538 treams D rosms 9. What is the optimal replenishment level with safety stock? Round your answer to the nearest whole number. 3 reams 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. rearns 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. s 3 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. 9 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 95 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 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!

A company has a 12% WACC and is considering two mutually exclusive investments that cannot be repeated) with the following cash flows: 0 1 2 4 3 + 5 1 6 1 7 1 + -$300-$387 - $193 -$100 $600 $600 $850...

A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 5 Project A $300 $387 $193 $100 $600 $600 $850 $180 Project B...

Excel Online Structured Activity: Evaluating risk and return Stock x has a 9.5% expected return, a beta coefficient of 0.8, and a 30 standard deviation of expected returns Shock Y has a 12.5%...

Excel Online Structured Activity: Cash conversion cycle Chastain Corporation is trying to determine the effect of its inventory tumover ratio and days sales outstanding (DSO) on its cash conversion...

Excel Online Structured Activity: Cash conversion cycle Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion...

Can You please show in excel format and show the formulas on how to get the final answers. Please and Thank you! Excel Online Structured Activity: Cash conversion cycle Chastain Corporation is trying...

Chastain Corporation is trying to determine the effect of its inventory tumover ratio and days sales outstanding (DSO) on its cash conversion cyde. Chastain's 2016 sales (all on credit) were $236000;...

Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were...

LALEI UE DUULUI CU MLUVILLA CIVILE Chastain Corporation is trying to determine the effect of its inventory tumover ratio and days sales outstanding (050) on its cash conversion cyde. Chastain's 2016...

Given the following sketches, generate an Excel spreadsheet: 1) Count the total degrees of freedom in the sketch. 2) Count the constraints 3) Provide the number of dimensions that are necessary to...

You obtained a loan of $20,000 to finance an automobile. Based on monthly compounding over 36 months, the end-of-the-month equal payment was figured to be $650.52. What APR was used for this loan?

Question 1 2 A company which uses the MACRS system of depreciation: will have equal depreciation costs each year of an asset's life. will write off the entire cost of an asset over the asset's class...

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