The assignment must be submitted as an Excel file. You can use different spreadsheets in the workbook to show your calculations. I 1. Use the cost information provided to prepare a cash-budget for a construction company for one year of operation. 2. Calculate also in a separate spreadsheet the payroll of the company Revenues Month January February March April May June July August September October November December Total Revenue $2,568,000 $3,212,000 $1,785,000 $2,659,000 $1,460,000 $2,145,000 $1,503,000 $2,397,000 $3,352,000 $1,465,000 $3,452,000 $1,676,000 $27,674,000 The company employs 5 workers: 1. Owner is paid $13K/month 2. The project manager is paid $6.5K/month 3. The construction assistant is paid $27.50/hour working average of 48 hours/week 4. Accountant is paid $33/hour working average of 43 hours/week 5. The site superintendent is paid $8K/month Calculate and include all the legal payroll expenses as per part one of the assignment. Vacation, holidays and sick days as 20 days/year. 10 Vacation days (BC regulation) + 10 sick days Sales budget is 1% of revenue budget The monthly insurance budget is calculated as: o 0.1% of revenues o 0.5% wages for hourly employees o 2% wages for salaried employees for general liability insurance. The monthly budget for office utilities includes o Internet $150/month o Telephone $380/month o Hydro $125/month o Cellphone $740/month The rent of the office is $7K/month Bank fees are $250/month Meals and coffee $2450/month The expense for cleaning and janitorial is $2350/month Vehicle expenses are $7,500/month Computer expenses $2,500/month Legal services $600/month Miscellaneous expenses $2,000/month