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

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

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