Chapter 14 Excel Problem Days' Sales in Inventory 1. Calculate the length of the days' sales in inventory. X 5 ? Days' Sales in Inventory - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In X Arial 12 % Paste B IU- Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D17 A B E G H 1 Dabble, Inc., has sales of $984,000 and cost of goods sold of $644,000. The firm had a beginning inventory of $38,000 and an ending inventory of $48,000. What is the length of the days' sales in inventory? (Use 365 days a year. Use ending inventory rather than average inventory. Round your answer to 2 decimal places.) 5 6 7 8 Sales Cost of goods sold Beginning inventory Ending inventory $984,000 $644,000 $38,000 $48,000 9 10 11 12 13 14 Complete the following analysis. Do not hard code values in your calculations, and do not round intermediate calculations. 15 Days' sales in inventory 16 17 18 19 20 1 Sheet1 READY + 100% Attempt(s) 10/10 Hint Show Me