Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Windsor Ltd , offers management and computer consulting services to clients throughout Canada and the northwestern United States. The division specializes in website development and

Windsor Ltd , offers management and computer consulting services to clients throughout Canada and the northwestern United States. The division specializes in website development and other Internet applications. The corporate management at Maple Leaf Services is pleased with the performance of Windsor Ltd for the first nine months of the current year and has recommended that the division manager, Richard Howell, submit a revised forecast for the remaining quarter, as the division has exceeded the annual plan year-to-date by 20 percent of operating income. An unexpected increase in billed hour volume over the original plan is the main reason for this increase in income. The original operating budget for the first three quarters for Windsor Ltd follows.

WINDSOR LTD

20x1 Operating Budget

1st Quarter

2nd Quarter

3rd Quarter

Total for First Three Quarters

Revenue:

Consulting fees:

Computer system consulting

$

560,625

$

560,625

$

560,625

$

1,681,875

Management consulting

440,000

440,000

440,000

1,320,000

Total consulting fees

$

1,000,625

$

1,000,625

$

1,000,625

$

3,001,875

Other revenue

20,000

20,000

20,000

60,000

Total revenue

$

1,020,625

$

1,020,625

$

1,020,625

$

3,061,875

Expenses:

Consultant salary expenses

$

396,750

$

396,750

$

396,750

$

1,190,250

Travel and related expenses

56,500

56,500

56,500

169,500

General and administrative expenses

120,000

120,000

120,000

360,000

Depreciation expense

60,000

60,000

60,000

180,000

Corporate expense allocation

70,000

70,000

70,000

210,000

Total expenses

$

703,250

$

703,250

$

703,250

$

2,109,750

Operating income

$

317,375

$

317,375

$

317,375

$

952,125

Howell will reflect the following information in his revised forecast for the fourth quarter.

  • Windsor Ltd currently has 25 consultants on staff, 10 for management consulting and 15 for computer systems consulting. Three additional management consultants have been hired to start work at the beginning of the fourth quarter in order to meet the increased client demand.
  • The hourly billing rate for consulting revenue will remain at $80 per hour for each management consultant and $65 per hour for each computer consultant. However, due to the favorable increase in billing hour volume when compared to the plan, the hours for each consultant will be increased by 50 hours per quarter.
  • The budgeted annual salaries and actual annual salaries, paid monthly, are the same: $70,000 for a management consultant and $66,000 for a computer consultant. Corporate management has approved a merit increase of 10 percent at the beginning of the fourth quarter for all 25 existing consultants, while the new consultants will be compensated at the planned rate.
  • The planned salary expense includes a provision for employee fringe benefits amounting to 30 percent of the annual salaries. However, the improvement of some corporatewide employee programs will increase the fringe benefits to 40 percent.
  • The original plan assumes a fixed hourly rate for travel and other related expenses for each billing hour of consulting. These are expenses that are not reimbursed by the client, and the previously determined hourly rate has proven to be adequate to cover these costs.
  • Other revenue is derived from temporary rentals and interest income and remains unchanged for the fourth quarter.
  • General and administrative expenses have been favorable at 7 percent below the plan; this 7 percent savings on fourth quarter expenses will be reflected in the revised plan.
  • Depreciation of office equipment and personal computers will stay constant at the projected straight-line rate.
  • Due to the favorable experience for the first three quarters and the division's increased ability to absorb costs, the corporate management at Maple Leaf Services has increased the corporate expense allocation by 50 percent.

Required: 1. Prepare a revised operating budget for the fourth quarter for Windsor Ltd that Richard Howell will present to corporate management. 2. Identify the circumstance under which an organization would prepare a revised operating budget.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray Garrison, Eric Noreen and Peter Brewer

14th edition

978-007811100, 78111005, 978-0078111006

Students also viewed these Accounting questions

Question

Can you please help with the question below, thanks

Answered: 1 week ago