please help me fix my spreadsheet

D7 A B C E F 1 2 Allied Company Cash Budget 3 4 5 July August September $ 425,000 737,763 446,530 737,763 829,270 6 7 Beginning cash balance 8 9 Cash receipts: 10 11 From sales in: 12 June 13 July 14 August 15 September 16 Total cash receipts 17 18 Collection Pattern %'s 19 Month of sale 20 Month after sale 21 Sales 1,135,020 1,275,800 1,483,500 1,096,300 4,990,620 1,184,293 383,705 383,705 1,567,033 35% 65% D7 B D E F 19 Month of sale 20 Month after sale 35% 65% 21 22 23 Cash disbursements: 24 wages and salaries 25 rent 26 utilities 27 inventory purchases 2B 29 Total cash disbursements 30 31 Ending cash balance 32 348,600 40,000 14,500 765,480 395,620 40,000 17,800 890,1601 337,150 40,000 19,800 657,780 1,168,580 1,343,580 1,054,730 $ 440,713 33 Instructions: Using the following information for the Allied Company, prepare a Cash Budget for July, August, and September. July 1,275,800 765,480 August 1,483,500 890,160 September 1,096,300 657,780 348,600 40,000 14,500 395,620 40,000 17,800 337,150 40,000 19,800 Credit sales Credit inventory purchases Cash disbursements: Wages and salaries Rent Utilities Credit sales collections: Collected in month of sale Collected in month after sale June credit sales June credit inventory purchases Beginning cash balance (July 1) 35% 65% 1,135,020 681,012 425,000 All credit inventory purchases are paid in the month after purchase