The assignment must be submitted as an Excel file. You can use different spreadsheets in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The assignment must be submitted as an Excel file. You can use different spreadsheets in the workbook to show your calculations. I 1. Use the cost information provided to prepare a cash-budget for a construction company for one year of operation. 2. Calculate also in a separate spreadsheet the payroll of the company Revenues Month January February March April May June July August September October November December Total Revenue $2,568,000 $3,212,000 $1,785,000 $2,659,000 $1,460,000 $2,145,000 $1,503,000 $2,397,000 $3,352,000 $1,465,000 $3,452,000 $1,676,000 $27,674,000 The company employs 5 workers: 1. Owner is paid $13K/month 2. The project manager is paid $6.5K/month 3. The construction assistant is paid $27.50/hour working average of 48 hours/week 4. Accountant is paid $33/hour working average of 43 hours/week 5. The site superintendent is paid $8K/month ⇒ Calculate and include all the legal payroll expenses as per part one of the assignment. Vacation, holidays and sick days as 20 days/year. 10 Vacation days (BC regulation) + 10 sick days ➡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 $150/month o Telephone $380/month o Hydro $125/month o Cellphone $740/month ⇒ The rent of the office is $7K/month Bank fees are $250/month ➡Meals and coffee $2450/month ⇒ The expense for cleaning and janitorial is $2350/month ⇒ Vehicle expenses are $7,500/month ⇒ Computer expenses $2,500/month ⇒ Legal services $600/month ⇒ Miscellaneous expenses $2,000/month The assignment must be submitted as an Excel file. You can use different spreadsheets in the workbook to show your calculations. I 1. Use the cost information provided to prepare a cash-budget for a construction company for one year of operation. 2. Calculate also in a separate spreadsheet the payroll of the company Revenues Month January February March April May June July August September October November December Total Revenue $2,568,000 $3,212,000 $1,785,000 $2,659,000 $1,460,000 $2,145,000 $1,503,000 $2,397,000 $3,352,000 $1,465,000 $3,452,000 $1,676,000 $27,674,000 The company employs 5 workers: 1. Owner is paid $13K/month 2. The project manager is paid $6.5K/month 3. The construction assistant is paid $27.50/hour working average of 48 hours/week 4. Accountant is paid $33/hour working average of 43 hours/week 5. The site superintendent is paid $8K/month ⇒ Calculate and include all the legal payroll expenses as per part one of the assignment. Vacation, holidays and sick days as 20 days/year. 10 Vacation days (BC regulation) + 10 sick days ➡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 $150/month o Telephone $380/month o Hydro $125/month o Cellphone $740/month ⇒ The rent of the office is $7K/month Bank fees are $250/month ➡Meals and coffee $2450/month ⇒ The expense for cleaning and janitorial is $2350/month ⇒ Vehicle expenses are $7,500/month ⇒ Computer expenses $2,500/month ⇒ Legal services $600/month ⇒ Miscellaneous expenses $2,000/month
Expert Answer:
Answer rating: 100% (QA)
Spreadsheet 1 Cash Budget Month Revenue Sales Budget Insurance Budget Office Utilities Rent Bank F... View the full answer
Related Book For
Discovering Advanced Algebra An Investigative Approach
ISBN: 978-1559539845
1st edition
Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke
Posted Date:
Students also viewed these accounting questions
-
Use the information provided to prepare a cash flow statement for Starr Karaoke using the direct method for December 31, 2014. Assume that the beginning balance of cash is $55,000. Identify by letter...
-
Use the information provided to prepare a cash flow statement for Starr Karaoke using the direct method for December 31, 2017. Assume that the beginning balance of cash is $55,000. Identify by letter...
-
People who earn a higher salary can afford more goods, including health care. However, according to Grossman, they will choose a higher desired health stock. Why is this so, according to the model?
-
Classify each transaction as an operating, investing, or financing activity. Assume all transactions are for cash. 1. Jackie Benefield makes a contribution of $95,000 to start the Horse Trails &...
-
Which oocyte stage is ovulated? What happens to it if it encounters a sperm cell there? What happens if it does not meet up with sperm?
-
A nonstatistical sampling plan can: a. Overstate the estimate of sampling risk. b. Misdirect an auditor to unreliable sampling units. c. Replicate the results of a statistical sampling plan. d....
-
Presented below are selected transactions at Ingles Company for 2010. Jan. 1 Retired a piece of machinery that was purchased on January 1, 2000.The machine cost $62,000 on that date. It had a useful...
-
Explain democratic leadership style, skills, behaviors, traits, and characteristics to lead change and innovation at an organization. 2. There is no right or wrong answer about the best leadership...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Can a good be both a complement and a substitute at the same time? If so, provide an example. If not, explain why.
-
Consider Tom, who is eligible for government health insurance and consumes two goods, "insurance" and "all other goods." Health insurance and other goods trade off dollar for dollar (there is no tax...
-
A city government passes a law setting the maximum price a landlord can charge for an apartment significantly above the market equilibrium. What impact will this have on the market for apartments?...
-
How does the Federal Open Market Committee increase the money supply? Why might the Federal Open Market Committee choose to increase the money supply?
-
In a certain market, demand for diamonds is relatively elastic, while supply is quite inelastic. If the government imposes a tax on diamonds, who will pay the majority of the tax via lost surplus?
-
If the savings rate for a country is 12% and the rate of economic growth rate is 3%, what will the wealth/income ratio for the society converge on in the long run?
-
The trial balance of Walive Ltd. as at 31 December 2016 was as follows: Share capital (10,000 Sh 20 Ordinary shares) Purchases and Sales Debtors and Creditors Profit and loss 1 January 2012 Sales...
-
The following information is available for Partin Company: Sales $598,000 Sales Returns and Allowances 20,000 Cost of Goods Sold 398,000 Selling Expense 69,000 Administrative Expense 25,000 Interest...
-
Follow these steps to find the equation for the median-median line for the data on life expectancy at birth for males in the United States for different years in the 20th century. Let x represent the...
-
The graph of the parametric equations x = ((t) and y = g(t) is pictured at right. a. Sketch a graph of x = ((t) and y = -g(t) and describe the transformation. b. Sketch a graph of x = -( (t) and y =...
-
The enrollment at a college is currently 5678. From now on, the board of administrators estimates that each year the school will graduate 24% of its students and admit 1250 new students. What will...
-
Determine the fundamental frequency of a uniform fixed-fixed beam carrying a mass \(M\) at the middle by applying Rayleigh's method. Use the static deflection curve for \(W(x)\).
-
Applying Rayleigh's method, determine the fundamental frequency of a cantilever beam (fixed at \(x=l\) ) whose cross-sectional area \(A(x)\) and moment of inertia \(I(x)\) vary as \(A(x)=A_{0} x /...
-
Using Rayleigh's method, estimate the fundamental frequency for the lateral vibration of a uniform beam fixed at both the ends. Assume the deflection curve to be \[W(x)=c_{1}\left(1-\cos \frac{2 \pi...
Study smarter with the SolutionInn App