Data Table - X (Click on the following icon in order to copy its contents into a spreadsheet.) Sales-Net Receivables-Total Acounts payable Inventories-Total 2014 4,303 611 447 347 2015 5,256 818 676 445 2016 7,971 1,038 689 640 2017 11,634 1,332 1,589 364 2018 18,486 2,282 2,418 350 Print Done (Cash conversion cycle) Historical data for the firm's sales, accounts receivable, inventories, and accounts payable for the Crimson Mfg. Company follow: a. Calculate Crimson's days of sales outstanding, days of payables outstanding, and days of sales in Inventory for each of the 5 years. (Assume a 365-day year. Hint Assume that the firm's cost of goods sold equals 70% of sales.) What has Crimson accomplished in its atempts to better manage its investments in account receivable and Inventory? b. Calculate Crimson's cash conversion cycle for each of the 5 years. Evaluate the firm's overall management of its working capital. Assume a 365-day year. a. Calculate Crimson's days of sales outstanding, days of payables outstanding, and days of sales in inventory for each of the 5 years. Assume a 365-day year. Hint: Assume that the firm's cost of goods sold equals 70% of sales. (Round to two decimal places.) 2016 Days of sales outstanding (DSO) 2014 2015 2017 2018 (Round to two decimal places.) 2014 2015 2016 2017 2018 Days of sales in inventory (DSI) (Round to two decimal places.) 2014 2015 2016 2017 2018 Days of payables outstanding (DPO) What has Crimson accomplished in its atempts to better manage its investments in account receivable and inventory? "Crimson has made dramatic improvement to its working capital management by making a reduction in the firm's cash conversion cycle." 1. (Select from the drop-down menu.) Is the above statement true of false? What has Crimson accomplished in its atempts to better manage its investments in account receivable and inventory? "Crimson has made dramatic improvement to its working capital management by making a reduction in the firm's cash conversion cycle." Is the above statement true of false? V. (Select from the drop-down menu.) b. Calculate Crimson's cash conversion cycle for each of the 5 years. Assume a 365-day year. (Round to two decimal places.) 2018 Cash conversion cycle (CCC) 2014 2015 2016 2017 Enter your answer in each of the answer boxes