The assignment must be submitted as an Excel file. You can use different spreadsheets in the workbook to show your calculations. 1. Use the cost information provided to prepare a cash budget for a construction company for one year of operation. 2. Calculate in a separate spreadsheet the employee salaries budget of the company The company employs 3 people: 1. Owner is paid $12K/month 2. The site supervisor is paid $6K/month 3. The office coordinator is paid $45/hour working an average of 43 hours/per week Calculate and include all the legal payroll burden per BC regulation (EI and CPP). Use WorkSafe costs $3,500/ month. Ignore other additional benefits Sales budget is 0.5% of the revenue budget The monthly insurance budget is calculated as: o 0.09% of revenues o 0.08% wages for hourly employees o 0.07% wages for salaried employees for general liability insurance The monthly budget for office utilities includes o Internet $220/month o Telephone $290/month o Hydro $135/month o Cellphones $430/month The rent of the office is $6K/month Bank fees are $250/month Meals and coffee $2,350/month The expense for cleaning and janitorial is $1,550/month Vehicle expenses are $3,500/month Computer expenses $770/month Legal services $200/month Miscellaneous expenses $1,500/month