1 2 6. 9. A A Problem 1: ABC Corporation is preparing its sales and receivable budget for the year 2022. Details are as follows: The sales during the 4" quarter of 2021 is 30,000 units and the selling price per unit is P500 per unit. Units to be sold is forecasted to increase by 5% per quarter while the sales price for 2022 will be 2% higher than the previous P500 per unit. of the sales per quarter, 55% are cash sales while the remaining credit sales. The credit sales are expected to be settled as follows: 5/9 will be collected during month of sales, 3/9 will be collected the month after month of sales, and the remaining will be written off two months after month of sale. The forecasted receivable balance on Jan. 1, 2022 is P3,500,000, 90% of which is expected to be collected during the first quarter while the remaining will be written off during the second quarter of 2022. Required: 1 Quarter 2 Quarter 3 Quarter 4th Quarter Sales 3. 4. Receivable balance as of the end of 5. 7. 8. Cash collections 10. 11. 12 Supporting Tables: A. Sale Budget (Notes: Round off the units to whole numbers.) 1 Quarter 200 Quarter 3rd Quarter 4 Quarter A Sales Price Multiplied by: Units to be sold B D E Sales F/1. G/2 H/3. 1/4 B. Sales Composition Percent 1" Quarter 2 Quarter 3 Quarter 4 Quarter Cash Sales R Credit M Q Sales Total Sales 100% F H C. Collection from Credit Sales/Accounts Receivable Collections during: Write-offs for Total 1 Quarter 2nd Quarter 3 Quarter 4th Quarter the year Receivables From Beginning U T Receivables From credit sales made in: - 15 Quarter w Y M - 2 Quarter Z AA AB 314 Quarter AC AD - 4 Quarter AE Totals AF AG AH AL AJ N P o S 1 V soon AK