Prepare a cash-budget for a construction company

Assignment Help Financial Management

Reference no: EM133550119

Financial Management and Budget Planning

Assignment - Managing Costs

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 $15K/month

2. The site supervisor is paid $7K/month

3. The office coordinator is paid $55/hour working average of 45 hours/week

» Calculate and include all the legal payroll burden as per BC regulation (EI and CPP). Use WorkSafe cost $4,500/ month. Ignore other additional benefits
» Sales budget is 0.2% of revenue budget
» The monthly insurance budget is calculated as:
o 0.03% of revenues
o 0.07% wages for hourly employees
o 0.06% wages for salaried employees for general liability insurance
» The monthly budget for office utilities includes
o Internet $200/month
o Telephone $90/month
o Hydro $150/month
o Cellphones $850/month
» The rent of the office is $7K/month
» Bank fees are $320/month
» Meals and coffee $1,740/month
» The expense for cleaning and janitorial is $3,600/month
» Vehicle expenses are $4,600/month
» Computer expenses $1,000/month
» Legal services $500/month
» Miscellaneous expenses $4,700/month

Month	Revenue
January	$2,500,500
February	$1,600,400
March	$7,830,000
April	$2,500,000
May	$4,700,000
June	$6,300,500
July	$5,460,000
August	$3,525,000
September	$7,600,200
October	$8,650,000
November	$4,300,000
December	$2,525,000

Total	$60,387,213

Note: Please use excel and seperate spreadsheets for the following:

1st SPREADSHEET- Salaries Budget
2nd Spreadsheet- Salaries Burden Budget.
3rd Spreadsheet- General Overhead Budget
4th Spreadsheet- Insurance Budget.

And for the calculation of WCP, use the rate in Worksafe BC website.

Reference no: EM133550119

Questions Cloud

Which maintains chromosomal constancy, blankprovides for : Compared with Blank, which maintains chromosomal constancy, Blankprovides for a reduction in chromosome number and an opportunity for exchange of genetic

What do you see as the objectives of the submarine project : International Project Management - What do you see as the objectives of the submarine project? Think beyond just the operational requirements and consider

How organization like best buy use five managerial tools : Explain how an organization like Best buy use five managerial tools to enhance its business growth and excel over it competitors, such as political,

What method for gaining attention and interest did victoria : what if you got one of those diseases today and the antibiotics that used to cure them didn't work anymore? Or what if you got a skin infection and died

Prepare a cash-budget for a construction company : Calculate in a separate spreadsheet the employee salaries' budget of the company and prepare a cash-budget for a construction company for one year of operation

Explain the national construction code : Explain about design and building practitioners act 2020? Explain the national construction code? Explain national employment standards?

What is a pneumothorax : Heart anatomy, physiology, and flow of blood to and from the heart What is a pneumothorax? Blood vessels, arteries, veins and capillaries and their functions

What do you think are most important lessons on leadership : What do you think are the most important lessons on leadership and power that you learned from reading about Musk's leadership struggle with his employees?

What is the cell concentration : The image below shows a cell count and is of one of the large corner squares in the haemocytometer grid. 20µL of cell suspension was mixed with 80µL of Trypan

User Account

All Pages