90.2K

Verified Solution

Link Copied!

i posted close up images of the one large unclear image. please let me know if you still cant read them, i really dont understand this problem

Sales and Cash Collections: This budget starts with three product sales units budgeted. Calculate the sales revenues for each and in total. Using the Total Revenues, create the Expected cash collections. Scrolling down, you will find the cash collection pattern at the bottom. The structure for cash collections is in place, you must simply add the detail calculations. Product Selling Price AA - 2460 $168.00 CC - 4820 $91.00 PT - 9450 $129.00 Salut P A3450 A/R Collection Pattern Collection % - Month of Sale 20.0% Collection % - Month after Sale 72.0% Collection % - 2nd Month after Sale 6.0% Uncollectible 2.0% Total 100.0% Budget - 2020 Jung August October November December September 1,245 885 975 900 1,170 1,425 1,238 1,890 1,913 1,875 2,175 2,213 2,850 3,150 - - 1,02 2,75 1,20 5,0 323 225 263 518 788 1,080 983 5,371 3,098 3,113 3,038 3,863 4,246 5.355 s Budget - 2020 May June ly August September October November December SO SO SO h Collections - 2020 August September October November Decembe August July September October December November Total 900 1,245 1,425 1,238 12,346 1,170 2,175 1,875 2,213 2,850 3,150 26,026 1,028 2,790 1,200 5,018 263 788 983 8,096 518 3,863 1,080 5,355 3,038 4,246 5,371 46,468 August September October November December Total July August September October November December Total SO

Answer & Explanation Solved by verified expert

See Answer