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 (the first month is di Galaxy Lighting Company Cash Budget Sept $ 80,000 S 360,000 $ 440,000 107,950 Beginning Cash Balance, Sept 1 Add: Cash collections from customers Total Cash Available from schedule Less: Cash payments for purchases Cash payments for selling and admin (GIVEN) Total Cash Payments 112,050 220,000 332,050 from schedule Given in proble Ending Cash Balance $ 107,950 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 (the first month is di Galaxy Lighting Company Cash Budget Sept $ 80,000 S 360,000 $ 440,000 107,950 Beginning Cash Balance, Sept 1 Add: Cash collections from customers Total Cash Available from schedule Less: Cash payments for purchases Cash payments for selling and admin (GIVEN) Total Cash Payments 112,050 220,000 332,050 from schedule Given in proble Ending Cash Balance $ 107,950