Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Wal Mart, Kroger, Amazon, and Costco are all companies that sell products. Find their annual reports or other financial site that contains the needed financial

Wal Mart, Kroger, Amazon, and Costco are all companies that sell products. Find their annual reports or other financial site that contains the needed financial information. Part A: Using Excel, develop a spreadsheet detailing their; Company Name, Sales $, Cost of Goods Sold $, Inventory Level $, Inventory Turnover Ratio, and Inventory Holding $ (use 25% of their inventory level $). The Inventory holding cost and Turnover Ratio calculations must be performed in Excel using a formula. Include the source of your information for each company Part A is worth 16 points Part B: Compare the Inventory Turnover Ratio of Amazon and Wal Mart. Calculate how much savings could be obtained if the lesser performing company could obtain the same Turnover ratio as the better performing company. Hint: Calculate how much the other company would have to reduce inventory to match the Turnover Ratio of Amazon if it has the better turnover or WalMart if it has the better turnover x the value of inventory. Part B is worth 4 points

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Managerial Finance

Authors: Lawrence J Gitman, Chad J Zutter

7th Edition

0133546403, 9780133546408

More Books

Students also viewed these Finance questions

Question

a. What department offers the course?

Answered: 1 week ago