F. Sunny and Clear, Inc. Schedule of Expected Cash Collections Absorbtion Costing Income Statement July August September Quarter For the Quarter Ended September 30, 2020 Budgeted Sales $ 52,000 $ 56,000 $ 60,000 $ 168,000 Cash Sales 13,520 $ 14,560 $ 15,600 $ 13,680 Calculation (52,000*.26 (56000*.26) (60000*.26) Credit Calculations 29,250 $ 38,480 $ 41,440 $ 109,170 Calculation (52000* .74) (56000*.74) Total Cash Collections $ 42,770 $ 53,040 $ 57,040 $ 152,850 culation (13520+29250) (14560+38480) (15600+41440) Merchandise Purchase Budget For the Quarter Ended September 30 July August September Quarter Cost of Goods Sold $ 40,040 S 43,120 $ 46,200 $ 129.360 Calculation (52000*.77) (56000*.77) (60000*.77) Plus: Desired Ending Inventory 15,092 $ 16,170 $ 12,936 $ 12,93 Calculation (43120*.35) (46200*.35) (48000*0.35*.77) Total Needed S 55,132 $ 59,290 $ 59,136 $ 142,296 Calculation (40040+15092) (43120+16170) (46200+12936) (129360+12936) G. Sunny and Clear, Inc. Minus Beg. Inventory: 14,014 $ 15,092 $ 16,170 $ 14,014 Balance Sheet Calculation (40040*.35) (43120*.35) (46200*.35) September 30, 2020 Required Inventory Purchases: 41,118 $ 44,198 $ 42,966 $ 128,282 Calculation (55132-14014) (59260-15092) (59136-16170) (142296-14014) Schedule of Expected Cash Disbursents - Merchandise Purchases July August September Quarter June Purchase 22,400 JulyPurchas 19,737 $ 21,381 Calculation (41118*.48) (411198*.52 August Purchase 21,215 $ 22,983 Calculation (44198*.48) (44198*.52) September Purchase 20,624 Calculation (42966*.48) Total Disbursement $ 42,137 $ 42,596 43,607 $ 128,340 Calculation (22400+19737) (21381+21215) (22983+20624) (42137+42596+43607) D. Schedule of Expected Cash Disbursements - Selling and Administrative Expenses July August September Quarter Commissions $ 9,000 $ 9,000 9,000 S 27.000 Rent 1,200 $ 1,200 $ 1,200 $ 3,600 Other Expenses(8%) 4,160 $ 4,480 $ 4,800 $ 13,440 Calculation (52000*.08) (56000*.08 (60000* .08) Total Cash for Expenses $ 14,360 $ 14,680 $ 15,000 $ 44,040 Calculation (9000+1200+4160) (9000+1200+4480) (9000+1200+4800) E. Cash Budget