Question: Based on my Excel calculation, I still don't know why my answer still incorrect. Could you please help me find out what I did wrong?


Based on my Excel calculation, I still don't know why my answer still incorrect.
Could you please help me find out what I did wrong? I lost 2 pts from 10 pts scale
Thank you,
Partial 8/10 pts Question 1 The following table contains data about the inventory for five items at Jones Corporation. Complete the missing items in the table. (Round your inventory turnover to 3 decimal places.) Item Beginning Unit # Inventory Ending Unit Inventory Average Unit Inventory Average Unit Sales Inventory Turnover 1 200,000 170,000 185000 400,000 2.162 90000 2 100,000 80,000 105,000 1.167 3 120,000 120000 120,000 210,000 1.750 14 350,000 420,000 385000 500,000 1.299 15 90,000 98,000 94000 170,000 1.809 Total 860000 888000 874000 1385000 8.186 Question 1 beginning Ending 200000 100000 120000 350000 90000 860000 Average inventory Avg Unit Sale Inventory overturn 170000 185000 400000 2.162162162 80000 90000 105000 1.166666667 120000 120000 210000 1.75 420000 385000 500000 1.298701299 98000 94000 170000 1.808510638 888000 874000 1385000 8.186040766 TotalStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
