Can you show me how to make a monthly cash budget for Jones Products Inc. for the first six months of 2020If possible in excel so i understand how you get the numbers please?

Revenue estimates (in thousands):

Nov* $340 Dec* $380

Jan $280 Feb $290

Mar $290 Apr $320

May $380 Jun $420

Jul $440

* = Historical

Collection on sales (all sales on credit):

Current month: 10%

First month following: 70%

Second month following: 19% (1% bad debt losses)

Purchases of raw materials:

71% of projected following month sales

Payment on purchases: 30 days following purchase of materials

Other expenses and disbursements (in thousands):

Utilities: $8/month

Wages and salaries: $45 + 2% current month's sales

Other fixed expenses: $6/month

Interest on bonds (not LOC): $8.5 in May ($0 all other months)

Quarterly tax payments: $12/month in Mar and Jun ($0 all other months)

Equipment maintenance: $35 in Feb ($0 all other months)

Line-of-credit:

$250,000 maximum available credit

No maintenance fee

5.50% interest (annual rate, compounded monthly) on ending balance of prior month

Other:

- A minimum cash balance of $60K must be maintained at the end of each month

- A balance of $47K on the line-of-credit exists at the end of Dec

- Quarterly dividends of $15K will be paid in Jan and Apr ($0 all other months)

- Any cash in excess of $60K at the end of each month will first be used to pay down any existing balance on the LOC, then swept into money market funds. Money market funds will earn 2.1% per annum (0.175% per month)