Question: Please help to answer the question in EXCEL. Also, would you mind to do step by step? Thank you Question 1 (15 pts): The following

Please help to answer the question in EXCEL. Also, would you mind to do step by step? Thank you
Question 1 (15 pts): The following table shows financial data (year 2006) for Dirt Cheap Wholesale and Kwiki-Mart, two US retailers. Assume that both companies have an average annual holding cost rate of 20%. DIRT CHEAP WHOLESALE All Numbers In Million $ KWIKI-MART STORES 40,894 Inventories 4,754 Sales (net) 59,217 397,206 COGS 52,762 326,606 Work on worksheet Q1 for the following questions: a) How many days, on average, does a product stay in Dirt Cheap's inventory before it is sold? Assume that stores operate 365 days a year. b) How much lower (expressed in $'s) is, on average, the inventory cost for Dirt Cheap compared to Kwiki-Mart of a house hold cleaner valued at $15Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
