Calculate and include all the legal payroll burden

Assignment Help Financial Management

Reference no: EM133550112

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

Reference no: EM133550112

Questions Cloud

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

What is the physiological ph of blood : What is the physiological pH of blood? Click or tap here to enter text. How do the arterial concentrations of gases affect the blood pH?

Altered due to changing requirements of customers : Give at least one example of where a policy or procedure needed to be altered due to changing requirements of customers, staff, or supply chain.

Calculate and include all the legal payroll burden : BLDC 1020 Financial Management and Budget Planning, British Columbia Institute of Technology - Calculate and include all the legal payroll burden

List the two structural categories of cartilaginous joints : List the two structural categories of cartilaginous joints, describe their characteristics and provide at least one example of each. List the six structural

Which of six potential sources of power does manager draw : Which of the six potential sources of power does this manager draw upon when leading a team of employees?

Universal governing body : Is player poaching an issue that should be addressed by a universal governing body? Why or why not?

What ways do toxic chemical fires affect local communities : What are some chemical reactions used in the manufacture of paper? How might the reactants or products of the pulp and paper production process affect

Reviews

len3550112

10/18/2023 11:09:08 PM

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,please use the rate in Worksafe BC website. I am attaching the picture of the website. For reference i am also providing pictures of how budgets are to be made in excel sheets.

Write a Review

Required(*) Message

User Account

All Pages