I need help to do my Accounting Lab 7..

it connects to Lab 1, 4 and 6. I posted all the requirements please help me get all parts of Lab 7 done. Thank you!

Here is Lab 7 that needs to be done...

Here is Lab 1 all completed

Here is Lab 4 all completed

And here is Lab 6 all completed

COMBINED CASH BUDGET LAB 7 Now that the operating budgets are and Tara prepare a combined cash budget for the complete, Tonia upcoming year. Based on the forecasted cash balances each month, the company can predict if they will have to borrow money at any time during the next quarter. Using information from Labs 1,4 and 6. prepare the cash forecasts for the months of January, February and March. All sales are on account. Past history shows following collection patterns: 20% in month of sale and the 80% in the month following. Bad debts are negligible. December sales are projected to be s200,000. Direct labor and all salaries and wages are paid one-halfin the month incurred and the second half in the following month. Wages and salaries for December were: Direct Labor S28,750 other Salaries and wages: Executive Salaries S17,500 Plant Manager $5,800 Plant Maintenance Supervisor S2,800 Shipping Manager $4,000 Sales Commissions $12,600 Sales Salaries $1,000 Rent is paid on the tenth day of each month. Direct materials are paid on the fifteenth day of the month following purchase. The total cost of direct materials in December was si20,000. Total insurance (both liability and plant premiums of S26,000 are paid on January 10