Prepare a static budget for the company

Assignment Help Cost Accounting
Reference no: EM131140148

Facts:
The W Company Civil Engineers consists of two divisions. The divisions are Water and Waste Water. The company sells engineering services to various customers. The following are the bill rates for the various staff classifications:

• Vice President $200/hour
• Senior Engineer $180/hour
• Staff Engineer $150/hour.

The two divisions expect to bill the following hours:

Water- 10000 hours, vice president at 10% of the time, 30% of Senior Engineer time and remaining to Staff Engineers.

Waste Water- 6000 hours, vice president at 20% of the time, 20% of Senior Engineer time and remaining to Staff Engineers.

The Direct Labor costs per hours are as follows:
• Vice President $80/hour
• Senior Engineer $60/hour
• Staff Engineer $40/hour.

The utilization for each staff members are as follows:
• Vice President 60%
• Senior Engineer 80%
• Staff Engineer 90%.

The company has the following other costs:
• Admin Salaries $90,000
• Rent $100,000
• Utilities $6,000
• Benefits $76,000

Assume 20% of time for each staff member includes vacation and sick time. 2080 is the annual total work hours.

Project:-
(1). Prepare a static budget for the company.

(2). Assume that the actual utilization came in at the following rates:
• VP-50%
• Senior-82%
• Staff-93%

Based on the above utilization, prepare a flexible budget and calculate the Level 2/3 variances.

(3). What recommendations can be made for the upcoming year in budgeting to the CFO for additional profitability and increasing revenue?

(4). What approaches would your recommendations to increase the company overall utilization of staff and billable hours?

(5). How will your recommendations impact customer profitability or divisional profitability?

(6). The company wants to add a new division. It will be the Construction Division with 3 people. Please discuss pros and cons of adding a division and when you might consider not to add the division.

 

 

Reference no: EM131140148

Questions Cloud

Explain the checks and balances system : Describe the US government structure in 1000 or more words. Explain the checks and balances system and indicate its strengths and weaknesses
Insert the beginning balances in the accounts receivable : Insert the beginning balances in the Accounts Receivable control and subsidiary accounts, and post the June transactions to these accounts.
Examine the prescription drug pricing : Examine the prescription drug pricing and pharmaceutical company profitability: State your assessment of the pros and cons of the existing situation
They produce any dangerous waster products : Assume that you are a business owner seeking a location for a new factory. Your company makes products that are relatively “clean” that is, they do not pollute the enviroment, nor will they produce any dangerous waster products. Thus most communities..
Prepare a static budget for the company : Prepare a static budget for the company. - How will your recommendations impact customer profitability or divisional profitability?
Discuss a defense or foreign policy pursued us government : Identify and discuss a defense or foreign policy pursued by the United States government. Within your discussion, include some of the events and actions leading up to, during, and after these policies
Record the january transactions in a sales journal : Record the January transactions in a sales journal, a single-column purchases journal, a cash receipts journal (see Illustration 7-9), a cash payments journal (see Illustration 7-16), and a general journal.
Expalin effects that war and peace have on foreign aid : Use the Internet to research one developing nation of your choice. Your research should include an examination of the effects that war and peace have on the distribution of foreign aid.
Describe the process by which federal budget is developed : What legal and political influences can affect the decisions of judges? How does the judiciary play a part in policymaking? Describe the process by which the federal budget is developed

Reviews

Write a Review

Cost Accounting Questions & Answers

  Differences between accounting profit and cash flow

What are the differences between accounting profit and cash flow and what was Senbets net operating income?

  Compute the cost

(Individual or component costs of capital) Compute the cost of the following: A bond that has $ 1,000 par value (face value) and a contract or coupon interest rate of 11 percent. A new issue would have a flotation cost of 5 percent of the $ 1..

  Part of the budgeting process

An often used approach to budgeting that simply derives the new year's bud get from the current year's budget is called - Which of the following steps would not usually be part of the budgeting process?

  Calculate johnsons expense deduction using the 2011

Calculate Johnsons expense deduction using the 2011 Form 2106 based on actual automobile expenses and other employee business expenses.

  Prepare a performance report based on your variance analysis

Clean Sweep Company produces all-vinyl mats. Each doormat calls for 0.5 meter of vinyl material. Prepare a performance report based on your variance analysis, and suggest possible causes for each variance.

  Prepare a post-closing trial balance

Prepare the income statement and the statement of owner's equity for the month of April and the balance sheet at April 30, 2008.

  Classified balance sheet in account

Prepare the income statement, the statement of owner's equity, and the classified balance sheet in account form for the month ended November 30, 2012.

  High level of activity consists of maintenance cost

High level of activity consists of maintenance cost - company to incur at an operating level of 70,000 directlabor-hours?

  Estimate a cost formula for power cost

Prepare a scattergraph by plotting ingots processed and power cost on a graph. Using the high-low method, estimate a cost formula for power cost. Express the formula in the form Y = a + bX.

  What is the payables period in this case

Calculating payments iron man products had projected the following sales for the coming year. Sales in the year following this one are projected to be 15 percent greater in each quarter.

  Evaluate cost per cost driver of the three cost centers

Evaluate the cost per cost driver for each of the three cost centers. Use the results from part 1 to allocate costs from each of the three cost centers to both the general surgery and the orthopedic surgery units.

  Prepare the necessary entries to close the general fund

Prepare a Statement of Revenues, Expenditures, and Changes in Fund Balance for the City of Martinville for the year ended June 30, 2012. Please make sure you end with the Fund Balance for the year ending June 30, 2012.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd