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 payroll of the company

* The company employs 5 workers:

1. Owner is paid $15K/month

2. The project manager is paid $6.5K/month

3. The construction assistant is paid $37.50/hour working average of 48 hours/week

4. Accountant is paid $43/hour working average of 43 hours/week

5. The site superintendent is paid $9K/month

Calculate and include all the legal payroll expenses as per part one of the assignment.

10 Vacation days (BC regulation) 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 $250/month

o Telephone $480/month

o Hydro $325/month

o Cellphones $940/month

The rent of the office is $10K/month

Bank fees are $550/month

Meals and coffee $4,450/month

The expense for cleaning and janitorial is $3,350/month

Vehicle expenses are $7,500/month

Computer expenses $2,500/month

Legal services $600/month

Miscellaneous expenses $2,000/month

\begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Revenues } \\ \hline Month & Revenue \\ \hline January & $2,568,000 \\ \hline February & $3,212,000 \\ \hline March & $1,785,000 \\ \hline April & $2,659,000 \\ \hline May & $1,460,000 \\ \hline June & $2,145,000 \\ \hline July & $1,503,000 \\ \hline August & $2,397,000 \\ \hline September & $3,352,000 \\ \hline October & $1,465,000 \\ \hline November & $3,452,000 \\ \hline December & $1,676,000 \\ \hline & \\ \hline Total & $27,674,000 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Revenues } \\ \hline Month & Revenue \\ \hline January & $2,568,000 \\ \hline February & $3,212,000 \\ \hline March & $1,785,000 \\ \hline April & $2,659,000 \\ \hline May & $1,460,000 \\ \hline June & $2,145,000 \\ \hline July & $1,503,000 \\ \hline August & $2,397,000 \\ \hline September & $3,352,000 \\ \hline October & $1,465,000 \\ \hline November & $3,452,000 \\ \hline December & $1,676,000 \\ \hline & \\ \hline Total & $27,674,000 \\ \hline \end{tabular}