I need help creating a monthly cash budget from the operational budget I calculated for 2020 based on the Income Statement for 2019

BUSN 1320 Business Calculations Lesson 6 Homework Answer Sheet Round answers to the nearest whole dollar. 1. a. Sales 92,759 dollars b. Cost of Goods Sold_27828 dollars * 0.30 = 27828 c. Rent 21.600 dollars d. Wages 13,914_dollars e. Utilities 5.434 dollars f. Other Expenses 4838_dollars 92,75940.05 - 10 g. Net Income 19.345 dollars 80,660 x 1,15= 92,759 12,759 x 0 1800 x 12 21,00 92,759 0,15 = 13,914 M440x1.to 5434 27828 + 2. Using your operational budget prepared in (1) above and the following additional information, prepare a monthly cash budget for Billy's Beefy Burgers for the month of January 2020. Billy's bank balance on December 31, 2019 is $3,610 All Billy's sales are for cash. He pays for his ingredients (Cost of Goods sold) in the month after he uses them. He pays 3 months' rent every quarter (January, April, July, October) He pays monthly wages on the last day of each month. He pays his utility bill the month after he is charged. He pays his other expenses in cash. What is Billy's expected cash balance on January 31", 2020? year 2020. Bily's Beefy Burgers Income Statement Year Ending December 31, 2019 2019 Sales Jan 5,400 Feb 5,960 Mar 6.500 Apr 7.100 May 7,250 Jun 7,600 Jul 7,810 Aug 7.540 Sep 6,890 Oct 6,755 Nov 5,980 Dec 5,875 Tota! 80,660 1.788 1,800 1.950 1,800 894 Cost of Goods Sold Rent Wages Ubilities Other Expenses Total Expenses 975 1,620 1.800 810 360 270 4,850 2,130 1,800 1,065 390 355 2,175 1,800 1,088 350 363 5,775 2,280 1,800 1,140 405 380 6,005 2.343 1,800 1.172 445 391 6,150 2.262 1,800 1.131 490 377 6,060 2,067 1.800 1,034 425 345 5,670 1.794 1,800 897 410 2,027 1,800 1,013 395 338 5.573 1,763 1.800 881 440 294 5,178 24,198 21,600 12,099 4940 4,033 299 410 298 5,190 420 325 5.470 5,740 5,200 66,870 770 540 1,030 2.360 Net Income 1,475 1,595 2,560 1,490 699 1.220 780 1.183 13,790 Complete the anticipated totals for the year according to your 2020 operational budget