please show the actual work on how it was solved!!!

Information: Cash Receipts Information: Galaxy Lighting Company Manufactures and sells lighting fixtures. Estimated sales for the months of September, October, and November are $350,000, $500,000 and $400,000, respectively. Actual sales for August were $400,000. These numbers are entered on your Excel template. Galaxy estimates that 60% of sales are collected in the month of the sale and 40% are collected the following month. Inventory Purchases Information: 60% of monthly purchases are paid in the month of purchase and the remainder are paid in the following month. Estimated Purchases for September, October and November are 219,000, 294,000 and 216,000, respectively. Actual purchases for August are 237,000. These numbers are entered on your Excel template. Additional information: In addition to the inventory purchases noted above, the company pays selling and administrative expenses of $120,000 per month. The cash balance at the beginning of September is $100,000. Instructions: Using this assignment information and the template provided, construct a cash budget for the three months of September, October and November. As an example, the budget for September is completed on the template. Show your work!!

Galaxy Lighting Company Monthly Cash Budget For the Months of September, October and November