Please show formulas / work Thank you.

Estimates for November Tile Wood Sales (square feet) 1,000,000 1,800,000 Sales price (per sq. ft.) $4 $6 Costs (per sq. ft.) $3 $4 Inventory - Beginning 100,000 125,000 Inventory - Ending 110,000 100,000 Prior Month Current Month (Oct) (Nov) Next Month Est. (Dec) Sales $15,000,000 As above $14,600,000 Purchases 9,000,000 As above 10,000,000 Wages & Salaries 850,000 850,000 850,000 Overheads 460,000 460,000 475,000 Selling & Administrative 1,250,000 1,250,000 1,250,000 Additional Information Sales- Collected 80% in current month; 20% in following month Purchases - 40% paid in current month; 60% in following month Wages & Salaries - Paid in current month Overheads- Paid in following month Selling & Admin expenses -paid in current month Selling & Admin expenses include $125,000 depreciation Beginning cash balance (current month) is 2,000,000 a. Calculate Sales & Purchases Budgets for the Current Month of November b. Prepare the Cash Budget for the Current Month of November c. Prepare the Budgeted Income Statement for the Current Month of November