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

  Determine cash collections during the period

Determine cash collections during the period and discuss how your findings in part (a) would affect Redding Corp."s quality of earnings ratio.

  Calculate bep and profit of gupta bros

The P/V ratio of Gupta Bros. is 40% and percentage of margin of safety is 30. You are required to calculate B.E.P and profit, if the sales volume is $150000.

  What can be the effect of the price increase

What can be the effect of the price increase on the firm's FCF for the year?

  What is the margin of safety for a profit

Sales volume if in the next period, the company suffered a loss of $30,000. What is the margin of safety for a profit of $90,000?

  What are the two methods of accounting for cash discounts

What are the two methods of accounting for cash discounts?

  Look at ford motor companys accounts receivable accountdoes

look at ford motor companys accounts receivable account.does ford have an accounts receivable balance?has it decreased

  Prepare fred pearsons report to mr mckay

You are required to prepare Fred Pearson's report to Mr McKay. Your report should incorporate. The relative profitability of each option. The break-even point and margin of safety.

  What was lequins cost of goods sold

Lequin's total manufacturing cost was $543,000. What was Lequin's cost of goods sold?

  Make a recommendation to oceanic boat works

Compute the net present value of cash flows from each of the alternatives facing Oceanic Boat works. Make a recommendation to Oceanic Boat works.

  Production based on the number of gallons

Allocate the joint cost of $558,000 to the production based on the number of gallons, sales value at split-off and approximated net realizable values at split-0ff.

  What is maximum amount nate and nan can contribute to ira

Nate and Nan Munson (ages 58 and 49, respectively) each have a traditional IRA. Nate retired last year and has no earned income. Nan works full-time. Her 2013 wages were $36,000. What is the maximum amount Nate and Nan can contribute to their resp..

  Is the company engaging in predatory pricing

A company has several units of old-model telephones that it is selling for $10 per unit. The units cost $25 to produce. Is the company engaging in predatory pricing? Explain.

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