Please show steps/work with formulas or excel

Average collection cycle. Use the following account information for Rian Company Click on the icon in order to copy its content into a spreadsheet 2013 and 2014 Selected Balance Sheet Accounts of Rian Company 12/31/14 12/31/13 Change Accounts receivable $40,668 $49,276 $8,608 Inventory $58,575 $62,188 $3,613 Accounts payable $28,488 $26.483 $2,005 Click on the icon in order to copy its content into a spreadsheet 2014 Selected Income Statement Items for Rian Company Cash sales $442,000 Credit sales $590,000 CORO If total sales had remained at $1,032,000, how much of the sales revenue would have needed to be cash sales for the company to meet the collection goal? (Round to the nearest dollar) Average collection cycle. Use the following account information for Rian Company Click on the icon in order to copy its content into a spreadsheet 2013 and 2014 Selected Balance Sheet Accounts of Rian Company 12/31/14 12/31/13 Change Accounts receivable $40,668 $49,276 $8,608 Inventory $58,575 $62,188 $3,613 Accounts payable $28,488 $26.483 $2,005 Click on the icon in order to copy its content into a spreadsheet 2014 Selected Income Statement Items for Rian Company Cash sales $442,000 Credit sales $590,000 CORO If total sales had remained at $1,032,000, how much of the sales revenue would have needed to be cash sales for the company to meet the collection goal? (Round to the nearest dollar)