# Week 3 - Assignment - Low Nail Company (1).xlsx - Week...

• 9
• 71% (7) 5 out of 7 people found this document helpful

This preview shows page 1 - 3 out of 9 pages.

The preview shows page 1 - 3 out of 9 pages.
Week Three: Inventory AnalysisLOW NAIL COMPANY1a.2100= Annual use in units1b.\$60.00= Cost of placing an order1c.\$1.08= Annual carrying cost per item per year1d.\$1.08= Additional carrying cost per item per year for half empty warehouse spaAnswer all the questions to the Low Nail Company Case. Questions can be foundcustom textbook and page 356 of the original textbook.Use Excel & EOQ Formulas in solving all problems.Place the required Excel formhighlighted in yellow to show correct answer.Format cells appropriately.Question 1:Using the EOQ formula and the information contained in the Low Nailkegs of nails should Low order at one time?
Question 2:The new EOQ, based on the following information is:Order Size12100\$0.00\$2,268.00\$2,268.0021050\$0.00\$1,134.00\$1,134.003700\$90.00\$756.00\$846.00Orders perYearProcessingCosts (\$)WarehousingCosts (\$)Sum of Processing andWarehousing Costs (\$)
4525\$120.00\$567.00\$687.005420\$150.00\$453.60\$603.606350\$180.00\$378.00\$558.007300\$210.00\$324.00\$534.008263\$240.00\$283.50\$523.509233\$540.00\$252.00\$792.00Discussion of Question 2:Question 3:The new EOQ, based on the following information is:Order Size12100\$60.00\$1,134.00\$1,194.00

Course Hero member to access this document

Course Hero member to access this document

End of preview. Want to read all 9 pages?