I have an excel project to do be done. Related to budgeting

it’s due in one day , it not that hard but I have many assignments to do it besides this. My Professor provide us for the final answer I’ll share it as picture.

Budgeting Project – 36 Points
Assumptions:
Sales volume increases 500 units each quarter, including Q1 of the next year
Ending Inventory is 20% of next quarter’s budgeted sales
Unit cost is 45% of sales price
Salaries are 25% of sales
Commissions are 5% of sales
Benefits are 25% of salaries
Supplies are 1% of sales
All other expenses are the same amount each quarter
Interest expenses are 1% of Sales
Income taxes are 20% of earnings before taxes
Rent is $50,000 per quarter
Utilities are $5,000 per quarter
Depreciation is $20,000 per quarter
Sales Budget
Sales Units
Price per unit
Total Sales
Purchases Budget
Units Sold
Ending Inventory
Tablets Needed
Beginning
Purchases
Revenue
Sales
Cost of Goods Sold
Gross Profit
Gross Profit %
Expenses
Salaries
Commissions
Benefits
Rent
Utilities
Supplies
Total expenses
Q1
15,000
125
1,875,000
Q2
Q3
Q4
–
–
–
15,000
–
–
–
15,000
3,000
12,000
–
–
–
–
–
–
1,875,000
843,750
1,031,250
–
–
–
–
–
–
–
Operating Income
Operating Income %
Depreciation
Interest expense
Earnings before taxes
Income Taxes
Net Income
Net Income %
1,031,250
–
–
–
1,031,250
–
–
–
1,031,250
–
–
–
Total
15,000
125
1,875,000
15,000
3,000
12,000
1,875,000
843,750
1,031,250
–
1,031,250
1,031,250
226,875
804,375