How do I Solve this on Excel I need help solving this on excel as a cash budget in excel there was an example of this on Chegg but it was incorrectly done

The following is a summary of the cash inflows and outflows our team put together last month:

1. Expected gross sales for April 2020 December 2020 are: $300,000, $300,000, $290,000, $425,000, $500,000, $600,000, $625,000, $650,000, and $700,000
2. 5% of the sales are collected in cash each month
3. 15% of sales are collected during the following month; 50% in the second month; 30% in the third month
4. Expected purchases of raw materials are 70% of the expected sales each month
5. The firm pays 100% of its raw materials purchases in the following month
6. Wages and salaries are paid monthly and are 10% of the current months sales
7. Monthly lease payments are 6% of the current months sales
8. Monthly advertising expense amounts to 8% of current months sales
9. R&D expenditures are expected to be allocated in August, September, and October at the rate of 12% of sales in those months
10. During December, a prepayment of insurance will be made in the amount of $24,000
11. During the months of July through December, the firm expects to have miscellaneous expenditures of $15,000, $20,000, $25,000, $30,000, $35,000, and $40,000
12. Taxes will be paid in September in the amount of $40,000 and in December in the amount of $45,000
13. The beginning cash balance in July is $15,000
14. The target cash balance is $15,000