Please show steps/work with formulas or excel

Average accounts payable 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 Accounts receivable $39,336 $47,549 Inventory $58,475 $62,632 Accounts payable $28,981 $27,016 Change $8,213 $4,157 $1,965 Click on the icon in order to copy its content into a spreadsheet 2014 Selected Income Statement Items for Rian Company Cash sales $451,000 Credit sales $563,000 GDDED What would the ending balance in the accounts payable account for 2014 have needed to be to reach this target (holding all other accounts the same)? (Round to the nearest dollar) Average accounts payable 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 Accounts receivable $39,336 $47,549 Inventory $58,475 $62,632 Accounts payable $28,981 $27,016 Change $8,213 $4,157 $1,965 Click on the icon in order to copy its content into a spreadsheet 2014 Selected Income Statement Items for Rian Company Cash sales $451,000 Credit sales $563,000 GDDED What would the ending balance in the accounts payable account for 2014 have needed to be to reach this target (holding all other accounts the same)? (Round to the nearest dollar)