User Account

All Pages

Prepare a static budget for the company

Assignment Help Managerial Accounting
Reference no: EM133041818

Question - The Seneca 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.

You are an outside third party Human Resources consulting firm and the Seneca 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.

1. Prepare a static budget for the company.

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

Vice President 50%

Senior Engineer 82%

Associate Engineer 88%

Staff Engineer 93%

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

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

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

6. How will your recommendations impact customer profitability or divisional profitability?

7. 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 adding the division.

Reference no: EM133041818

Questions Cloud

What would happen if both projects had negative npv totals : What would happen if both projects had negative NPV totals? Which project would you choose? What do negative NPVs indicate? Explain
How to write a research report on present findings : How to write a research report on present findings of an occupation in APA format:
Describe what is e-prescribe : Describe what is e-prescribe and explain in detail how it can eliminate errors. In addition, use a practical example to illustrate your point?
Hr planning implications and challenges for organizations : 1. Discuss the HR planning implications and challenges for organizations and how they have to shift their business strategies or plans in light of the pandemic
Prepare a static budget for the company : Assume that there are 2080 hours per year that each engineer can work including vacation and other benefit hours. Prepare a static budget for the company
Identify the role of government in regulating : Identify the role of government in regulating and ensuring access to health care services for its citizens.
Describe what is computer-assisted coding : Describe what is Computer-Assisted Coding, and list and fully explain two advantages that it has when being used in an electronic health record (EHR)system?
What is meant by diversity of thought : Do you believe that this will be a valuable strategy to help diversify your workplace? Why or why not?
Why does ge want to change auditors : In your opinion, why does GE want to change auditors? What are the requirements from Sarbanes-Oxley regarding using the same auditor

Reviews

Write a Review

Managerial Accounting Questions & Answers

  What is the net present value or npv of the project

£300,000 in year 2 and in £600,000 in year 3.the company's cost of capital is 8% . What is the net present value (NPV) of the project?

  Which of statements are true about managerial perspective

Which of statements are true about the managerial perspective? Glenn, a manager at Olive Corp., has decided to adopt a managerial perspective

  Would dividend harvesting strategy work

Would this dividend "harvesting" strategy work? Why or why not? All dividend-paying companies have to announce the dividend date in advance.

  How many units did it produce

Net income under variable costing was $10000, and $12000 under absorption costing last year. EKP sold 15000 units. How many units did it produce

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Prepare a contribution format income statement

Todrick Company is a merchandiser that reported the following information based on 1,000 units sold: Prepare a contribution format income statement

  What nella full-cycle cash flow was

Compare the financial return of the two stores using any appropriate financial technique. Assume a 12% cost of capital and that the IRS does not penalize Ibot

  Estimate the percentage to be assigned for year two

Estimate the percentage to be assigned for Year 2 in a trend analysis, assuming that Year 1 is base year, is? If Year 1 sales equal $ 800, Year 2 sales equal.

  Prepare the depreciation journal entries required at end

Prepare general journal entries to record the above transactions and the depreciation journal entries required at the end of each reporting period up to 30 June

  Compute the equivalent units and costs per equivalent unit

McElroy, Inc., produces a single model ofa popular cell phone, Compute the equivalent units and costs per equivalent unit for March in the assembly department.

  Find cash inflows from sales to customers totalled

Customers at the beginning of the year were $75,000 and at the end of the year $100,000. As a result cash inflows from sales to customers totalled?

  Compute the anticipated break-even sales

Compute the anticipated break-even sales (units). Compute the sales (units) required to realize an operating profit of $8,000.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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