Timber's Lodge shop has forecast credit sales for the 4th quarter:
September (actual sales)---- $50,000
Experience has shown that 25% of sales are collected in the month of sales. 70% in the following month and 5 percent are never collected.© BrainMass Inc. brainmass.com June 3, 2020, 10:59 pm ad1c9bdddf
This solution prepares a schedule of cash receipts in an Excel file from October through December of Timber's Lodge Shop.