Answer:
1) Budgeted cash collections for December 2018 from November 2018 Sales - $ 100,320
2) Budgeted total cash collections for January 2019 - $ 221,880
3) Budgeted total cash payments for December 2018 - $ 135,420
Explanation:
Computation of cash collections for December 2018 from November 2018
Credit Sales for November 2018 $ 264,000
Less: Uncollectible sales - 5 % of credit sales <u>$ ( 13,200)</u>
Collectible sales $ 250,800
Percentage of collectible sales in month of sales- 60 % <u>$ (150,480)</u>
Percentage of collectible sales in next month -Dec 18 - 40 % $ 100.320
Computation of total cash collections for January 2019
Cash collections from December sales
Credit sales for December 2018 $ 388,000
Less 5 % Uncollectible sales <u>$ ( 19,400)</u>
Collectible sales <u>$ 366,600</u>
Collections in month subsequent to sale 40 % * $ 366,600 $ 147,400
Cash collections from Januray 2019 sales
Credit sales for Janaury 2019 $ 196,000
Less: 5 % uncollectible sales <u>$( 9,800)</u>
Collectible sales $ 186,200
Collections in month of sale 60 % * $ 186,200 <u>$ 74,480</u>
Total collections for January 2019 <u>$ 221,880</u>
Computation of cash payments for December 2018
Purchases for December 2018 sales - 30 % of $ 388,000 $ 116,400
Purchases for January 2019 sales - 70 % of $ 196,000 <u>$ 137,200</u>
Total purchases for December 2018 on selling price <u>$ 253,600</u>
Purchases are 60 % of selling price - $ 253,600 * 60 % <u> </u><u>$ 152,160</u>
Payments for December purchases 25 % (A) <u> </u><u>$ 38,040</u><u> </u>
Purchases for November 2018 sales - 30 % of $ 264,000 $ 79,200
Purchases for December 2018 sales - 70 % of $ 388,000 <u>$ 137,200</u>
Total purchases for November 2018 on selling price <u>$</u> 216,400
Purchases are 60 % of selling price - $ 216,400 * 60 % <u> </u><u>$ 129,840</u>
Payments for November purchases 75 % (B) <u> </u><u>$ 97,380</u>
Total payment for purchases in December 2018 (A) + (B) <u>$ 135,420 </u>