Make sure you fill in all Yellow cells. Yellow cells left blank will receive zero credit Problem E: Refer to the Problem D. In addition to the information given, selling and administrative expenses paid in cash are $220,000 per month. The cash balance for September 1 is $80,000. Prepare a monthly cash budget for September October, and November for Galaxy Lighting Company. Problem E: Cash Budget Oct Nov (the first month is done for you Galaxy Lighting Company Cash Budget Sept $ 80,000 360,000 $ 440,000 from schedule of cash receipt Beginning Cash Balance, Sept 1 Add: Cash collections from customers Total Cash Available Less: Cash payments for purchases Cash payments for selling and admin (GIVEN) Total Cash Payments 112,050 220,000 332,050 from schedule of cash payme Given in problem Ending Cash Balance $ 107,950 Make sure you fill in all Yellow cells. Yellow cells left blank will receive zero credit Problem E: Refer to the Problem D. In addition to the information given, selling and administrative expenses paid in cash are $220,000 per month. The cash balance for September 1 is $80,000. Prepare a monthly cash budget for September October, and November for Galaxy Lighting Company. Problem E: Cash Budget Oct Nov (the first month is done for you Galaxy Lighting Company Cash Budget Sept $ 80,000 360,000 $ 440,000 from schedule of cash receipt Beginning Cash Balance, Sept 1 Add: Cash collections from customers Total Cash Available Less: Cash payments for purchases Cash payments for selling and admin (GIVEN) Total Cash Payments 112,050 220,000 332,050 from schedule of cash payme Given in problem Ending Cash Balance $ 107,950