Revising and Analyzing an operating budget Attala Co., a division of Jackson Industries (JI), offers consulting services to clients for a fee. JI's corporate management is pleased with the performance of Atttala Co. for the first nine months of the current year and has recommended that Attala Co.'s division manager, Jason Newport, submit a revised forecast for the remaining quarter because the division has exceeded the annual year-to-date plan by 20 percent of operating income. An unexpected increase in billed hour volume over the original plan is the main reason for this gain in income. The original operating budget for the first three quarters for Attala Co. is as follows: (See attatched Image) When comparing the actuals for the first three quarters to the original plan, Newport analyzed the variences and will reflect the following information in his revised forecast for the fourth quarter.  The division currently has 25 consultants on staff, 10 management consulting and 15 for EDP consulting, and has hired 3 additional management consultats to start work at the beginning of the fourth quarter to meet the increased client demand. The hourly billing rates for consulting revenues will remain $90 for each management consultant and $75 for each EDP 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 pwe quarter. New employees are equally as capable as current employees and their time will be billed at the same rates. The annual budgeted salaries and actual salaries, paid monthly, are $50,000 for a management consultant and 8 percent less for an EDP consultant. Corporate management has approved a merit increase of 10 percent at the beginning of the fourth quarter for all 25 existing consultants, but the new consultants will be compensated at the planned rate. The planned salary expense includes provision for employee fringe benefits amounting to 30 percent of the annual salaries; however, the improvement of some corporate-wide employee programs will increase the fringe benefit allocation to 40 percent. The original plan assumes a fixed hourly rate for travel and other related expenses for each billing hour of consulting. These expenses are not reimbursed by the client, and the previously determined hourly rate has proven to be adequate to cover these costs. Other revenues are derived from temporary rentals and interes income and remain unchanged for the fourth quarter. Administrative expenses are 7 percent below the plan; this 7 percent savings on fourth-quarter expenses will be reflected in the revised plan. Depreciation for the office equipment and 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, JI corporate management has increased the corporate expense allocation by 50 percent. a. Prepare a revised operating budget for the fourth quarter for Attala Co. that Jason Newport will present to Jackson Industries. Be sure to furnish supporting calculations for all revised revenue and expense amounts. b. Discuss the reason that an organization would prepare a revised forecast. c. Discuss your feelings about the 50 percent increase in corporate expense allocations.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
100%

Revising and Analyzing an operating budget Attala Co., a division of Jackson Industries (JI), offers consulting services to clients for a fee. JI's corporate management is pleased with the performance of Atttala Co. for the first nine months of the current year and has recommended that Attala Co.'s division manager, Jason Newport, submit a revised forecast for the remaining quarter because the division has exceeded the annual year-to-date plan by 20 percent of operating income. An unexpected increase in billed hour volume over the original plan is the main reason for this gain in income. The original operating budget for the first three quarters for Attala Co. is as follows: (See attatched Image)

When comparing the actuals for the first three quarters to the original plan, Newport analyzed the variences and will reflect the following information in his revised forecast for the fourth quarter. 

The division currently has 25 consultants on staff, 10 management consulting and 15 for EDP consulting, and has hired 3 additional management consultats to start work at the beginning of the fourth quarter to meet the increased client demand.

The hourly billing rates for consulting revenues will remain $90 for each management consultant and $75 for each EDP 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 pwe quarter. New employees are equally as capable as current employees and their time will be billed at the same rates.

The annual budgeted salaries and actual salaries, paid monthly, are $50,000 for a management consultant and 8 percent less for an EDP consultant. Corporate management has approved a merit increase of 10 percent at the beginning of the fourth quarter for all 25 existing consultants, but the new consultants will be compensated at the planned rate.

The planned salary expense includes provision for employee fringe benefits amounting to 30 percent of the annual salaries; however, the improvement of some corporate-wide employee programs will increase the fringe benefit allocation to 40 percent.

The original plan assumes a fixed hourly rate for travel and other related expenses for each billing hour of consulting. These expenses are not reimbursed by the client, and the previously determined hourly rate has proven to be adequate to cover these costs.

Other revenues are derived from temporary rentals and interes income and remain unchanged for the fourth quarter.

Administrative expenses are 7 percent below the plan; this 7 percent savings on fourth-quarter expenses will be reflected in the revised plan.

Depreciation for the office equipment and 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, JI corporate management has increased the corporate expense allocation by 50 percent.

a. Prepare a revised operating budget for the fourth quarter for Attala Co. that Jason Newport will present to Jackson Industries. Be sure to furnish supporting calculations for all revised revenue and expense amounts.

b. Discuss the reason that an organization would prepare a revised forecast.

c. Discuss your feelings about the 50 percent increase in corporate expense allocations.

Chapter 8 The Master Budget
OPERATING BUDGET
1st
2nd
3rd
Total
9 Months
Quarter
Quarter
Quarter
Consulting fees
Management consulting..
EDP consulting...
.. $ 315,000
$ 315,000
$ 315,000
421,875
$ 945,000
1,265,625
421,875
421,875
.. $ 736,875
$736,875
$736,875
10,000
$ 2,210,625
30,000
Total...
Other revenue...
10,000
10,000
Total ....
$746,875
$746,875
$746,875
$2,240,625
..
Expenses
Consultant salaries.. ...
. $(386,750)
(45,625)
(100,000)
(40,000)
(50,000)
$(386,750)
(45,625)
(100,000)
(40,000)
(50,000)
$(386,750)
(45,625)
(100,000) (300,000)
(40,000)
(50,000)
$(1,160,250)
(136,875)
Travel and entertainment
Administrative....
Depreciation...
Corporate allocation..
(120,000)
(150,000)
Total...
$(622,375)
$(622,375)
$(622,375)
$(1,867,125)
Operating income.
$ 124,500
$ 124,500
$ 124,500
$ 373,500
When comparing the actuals for the first three quarters to the original plan, Newport analyze
the variances and will rofloot tl
%24
Transcribed Image Text:Chapter 8 The Master Budget OPERATING BUDGET 1st 2nd 3rd Total 9 Months Quarter Quarter Quarter Consulting fees Management consulting.. EDP consulting... .. $ 315,000 $ 315,000 $ 315,000 421,875 $ 945,000 1,265,625 421,875 421,875 .. $ 736,875 $736,875 $736,875 10,000 $ 2,210,625 30,000 Total... Other revenue... 10,000 10,000 Total .... $746,875 $746,875 $746,875 $2,240,625 .. Expenses Consultant salaries.. ... . $(386,750) (45,625) (100,000) (40,000) (50,000) $(386,750) (45,625) (100,000) (40,000) (50,000) $(386,750) (45,625) (100,000) (300,000) (40,000) (50,000) $(1,160,250) (136,875) Travel and entertainment Administrative.... Depreciation... Corporate allocation.. (120,000) (150,000) Total... $(622,375) $(622,375) $(622,375) $(1,867,125) Operating income. $ 124,500 $ 124,500 $ 124,500 $ 373,500 When comparing the actuals for the first three quarters to the original plan, Newport analyze the variances and will rofloot tl %24
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 6 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education