Prepare static budget for the company

Assignment Help Managerial Accounting
Reference no: EM132571368

The ABC Company (Civil Engineers) consists of two divisions. The divisions are Transportation and Infrastructure. The company sells engineering services to various customers. The following are the bill rates for the various staff classifications:

Vice President               $250/hour

Senior Engineer                 $200/hour

Associate Engineer                $190/hour

Staff Engineer                         $160/hour

The two divisions expect to bill the following hours:

  • Transportation - 10,000 hours, vice president at 10% of the time, 20% of Senior Engineer time 10% to Associate engineers and remaining to Staff Engineers.
  • Infrastructure - 6,000 hours, vice president at 12% of the time, 20% of Senior Engineer time, 5% to Associate engineers and remaining to Staff Engineers.

The Direct Labor costs per hours are as follows:

Vice President                      $90/hour

Senior Engineer                   $70/hour

Associate Engineer                 $60/hour

Staff Engineer                    $50/hour

The utilization (billable ratio to total hours) for each staff member is as follows:

Vice President                    60%

Senior Engineer                     80%

Associate Engineer                   85%

Staff Engineer                            90%

The company has the following other costs:

Admin Salaries                  $81,000

Rent                                  $120,000

Utilities                                $16,000

Benefits                                              $75,000

Assume that there are 2080 hours per year that each engineer can work including vacation and other benefit hours.

Group Assignment:

You are an outside third-party Human Resources consulting firm and the ABC Company Board of Directors, CFO and the CPO have engaged your company. The goal of the Board, CFO and the CPO is to improve profitability of the divisions and company. Therefore, to accomplish providing engagement advice to the Board, CFO and CPO the consulting team should answer the following questions during the presentation and in the final report.

Question 1. Prepare static budget for the company.

Question 2. Assume that the actual utilization came in at the following rates:

Vice President          50%

Senior Engineer          82%

Associate Engineer       88%

Staff Engineer           93%

Question 3. Based on the above utilization, prepare flexible budget

Question 4. calculate the Level 2/3 variances.

Reference no: EM132571368

Questions Cloud

What would be the effect on operating income next year : The special order is accepted for 15% off the regular selling price, what would be the effect on operating income next year due to accepting this order?
Discuss the objectives of the internal auditor : For each of the above three areas, discuss the objectives of the internal auditor and the objectives of the external auditor
Student conflict resolution : Conflict is a natural part of the human experience. Young children are experimenting with their autonomy and independence,
Discuss how the forces interact to influence : Identify and explain each of the forces that contribute to the biopsychosocial framework. Discuss how the forces interact to influence and shape human
Prepare static budget for the company : Prepare static budget for the company. The ABC Company (Civil Engineers) consists of two divisions. The divisions are Transportation and Infrastructure.
De-escalation strategies and conflict resolution techniques : How might an educator need to modify his or her de-escalation strategies and conflict resolution techniques to account for these considerations?
Rewrite the auditor report in an acceptable format : Rewrite the auditor's report in an acceptable and complete format, incorporating any necessary departures from an unmodified report
Calculate the depreciation expense for the year : Calculate the depreciation expense for the year 2019-20 using each of the following depreciation methods: straight-line, diminishing balance
Make A Plan And Develop Your Ideas : you have to manage all of the stakeholders of your unit including teachers, students, parents etc; as well as all the relevant policies.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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