

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
The calculation of Inventory Turnover and Day Sales in Inventory for two companies, Target and Amazon. The formulas used are explained step by step, and the necessary data is provided. useful for students studying accounting or finance, as well as for professionals working in these fields.
Typology: Thesis
1 / 2
This page cannot be seen from the preview
Don't miss anything!


Wk 4 Problem ACC220 – Week 4 A. The Inventory Turnover is made from the Cost of Merchandise Sold over the Average Inventory. So, the Average Inventory = in the inventory, end of the year + inventory, beginning of the year. So, the Target Average Inventory=8,601+8,282 /2 or 8,441. So, target – Inventory turnover= $51,997/8,441.5 or 6. Amazon Average Inventory= (10,243+8,299)/2 or 9, Amazon – Inventory turnover = 71,651/9,271 or 7. B. The Day Sales in the inventory would equal from Average Inventory/ Average Daily Cost of Merchandise Sold. So, the target inventory = 8,441.5 The Target Average Daily of merchandise would = cost of merchandise sold / 365 days or 51,997/365=142. Target days sales in inventory= 8,441.5/142.5 or 59 Days. Amazon Average inventory = 9,271 with amazon average daily cost of merch = cost of merch sold / 365 days or 71,651/365=196. Amazon Days Sale in inventory=9,271/196.3 or 47days.
C. After all this data Amazon has a more favorable trend on their inventory turnover at being higher then Target as well their days in sale inventory where also lower than target.