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.
3CO02: Explain what evidence-based practice is and how it might be applied within an organisation :
Read MoreReview relevant organizational behaviour theories, such as conflict resolution strategies, leadership styles, and team dynamics:
Read MoreLevel 6 NVQ : Describe the nature and role of a positive health and safety culture within the organisation:
Read MoreDiscuss how product program management strategies can be used to integrate cybersecurity considerations at each stage.
Read MoreCritically discuss Freud and Jung’s theory of personality using the unconscious mind. In relation to Freud discuss his theory of dreams and defence mechanism on accessing the unconscious mind.
Read MoreRecruitment and Selection Analysis, Assignment 2,
Read MoreLab Assignment 1: Modeling and Analysis of a DC motor : Control Systems Analysis and Design,
Read MoreDifferentiate between the functions of the various members of the legal profession and discuss reform in the area
Read MoreA comparison of the most recent macroeconomic performancomy compared to your home economy:
Read MoreHow did your raw data turn into information, and what knowledge did you gain from it?
Read More