An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
1.
Budget Actual Over Budget Under Budget
Customer service salaries
Insurance and property taxes
Distribution salaries
Marketing salaries
Engineer salaries
Warehouse wages
Equipment depreciation
Total
2.
[Key essay answer here]
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
VALOTIC TECH, INC.
Budget Performance Report – Director, Consumer Products Division
For the Month Ended January 31, 2016
Score:
Key Code:
Instructions
Problem 24-1A
Name:
Section:
0%
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
1.
Budget Actual Over Budget Under Budget
Customer service salaries 546,840$ 602,350$ 55,510$ –$
Insurance and property taxes 114,660 110,240 – 4,420
Distribution salaries 872,340 861,200 – 11,140
2.
The customer service and marketing salaries are significantly over budget. The director should investigate the
cause of these results. One possibility is that the company is having an increase in sales, requiring greater
Problem 24-1A
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
For the Month Ended January 31, 2016
VALOTIC TECH, INC.
Budget Performance Report – Director, Consumer Products Division
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
1.
Budget Actual Over Budget Under Budget
Sales salaries
System administration salaries
Customer service salaries
Billing salaries
Maintenance
Depreciation of plant and equip.
Insurance and property taxes
Total
2.
[Key essay answer here]
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
ADELSON INC.
Budget Performance Report⎯Manager, Eastern District
For the Month Ended December 31, 2016
Score:
Key Code:
Instructions
Problem 24-1B
Name:
Section:
0%
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
1.
Budget Actual Over Budget Under Budget
Sales salaries 819,840$ 818,880$ –$ 960$
System administration salaries 448,152 447,720 – 432
Customer service salaries 152,600 183,120 30,520
2.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
For the Month Ended December 31, 2016
ADELSON INC.
Budget Performance Report⎯Manager, Eastern District
The customer service salaries exceed the budget by over 20% of budget ($30,520/$152,600). The manager
should request additional detailed information about the customer service department. There are several
possible reasons for the budget variance. The manager should determine if the cause is related to an increase
Problem 24-1B
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
East West Central
Revenues
Operating expenses
Income from operations before service dept. charges
Less service department charges:
Customer support
Legal
Total
Income from operations
Supporting schedules:
East West Central Total
Number of customer contacts
Number of hours billed
Service Cost Output = Rate
Customer contact rate per contact
Legal billing rate per hour
2.
Profit margin: Income from Profit
Operations Revenues = Margin
East Division
West Division
Central Division
Based on profit margin, the
Division has the highest performance.
3.
[Key essay answer here]
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
TRAXONIA RAILROAD INC.
Divisional Income Statements
For the Quarter Ended December 31, 2016
Score:
Key Code:
Instructions
Problem 24-2A
Name:
Section:
0%
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
East West Central
Revenues 870,000$ 1,032,000$ 1,872,000$
Operating expenses 563,300 618,240 1,166,940
Supporting schedules:
East West Central Total
Number of customer contacts 5,000 6,000 9,000 20,000
2.
Profit margin: Income from Profit
Operations Revenues = Margin
East Division $139,200 $870,000 16%
West Division $185,760 $1,032,000 18%
3.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
For the Quarter Ended December 31, 2016
TRAXONIA RAILROAD INC.
Divisional Income Statements
To: CEO
The method used to evaluate the performance of the divisions should be reevaluated. The present method
important consideration in evaluating divisional performance. Therefore, a better divisional performance
ld b ithe (a) rate of etu n i tm t (in e f erati di ided b di i i al
Problem 24-2A
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
North South West
Revenues
Operating expenses
Income from operations before service dept. charges
Less service department charges:
Dispatching
Equipment management
Total
Income from operations
Supporting schedules:
North South West Total
Number of scheduled trains
Number of railroad cars in inventory
Service Cost Output = Rate
Dispatching rate per scheduled train
Equipment management rate per railroad car
2.
Profit margin: Income from Profit
Operations Revenues = Margin
North Region
South Region
West Region
Based on profit margin, the Region has the highest performance.
3.
Score:
Key Code:
Instructions
Problem 24-2B
Name:
Section:
0%
[Key essay answer here]
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
THOMAS RAILROAD COMPANY
Divisional Income Statements
For the Quarter Ended December 31, 2016
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
North South West
Revenues 3,780,000$ 5,673,000$ 5,130,000$
Supporting schedules:
North South West Total
Number of scheduled trains 650 1,105 845 2,600
2.
Profit margin: Income from Profit
Operations Revenues = Margin
North Region $756,000 $3,780,000 20%
South Region $680,760 $5,673,000 12%
3.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
For the Quarter Ended December 31, 2016
THOMAS RAILROAD COMPANY
Divisional Income Statements
To: CEO
The method used to evaluate the performance of the regions should be re-evaluated. The present method
identifies the amount of income from operations per dollar of earned revenue. However, a railroad company
er thos ets. The t m ure fail to i ate th e diff i et utili ati into th
Problem 24-2B
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry in the income statement and above or below
elements in the equations. The essay answer will not be graded.
1.
Snack Retail
Cereal Cake Bakeries
Division Division Division
Sales
Cost of goods sold
Gross profit
Operating expenses
Income from operations
2.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Cereal Division:
Snack Cake Division:
Retail Bakeries Division:
3.
ROI
=
x
=
ROI
=
x
=
Score:
Key Code:
Instructions
Problem 24-3A
Name:
Section:
0%
Sales
Invested Assets
ROI
=
x
=
x
[Key essay answer here]
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
THE CRUNCHY GRANOLA COMPANY
Divisional Income Statements
For the Year Ended June 30, 2016
Rate of Return (ROI) on Investment
=
Income from Operations
An asterisk (*) will appear to the right of an incorrect entry in the income statement and above or below
elements in the equations. The essay answer will not be graded.
1.
Snack Retail
Cereal Cake Bakeries
Division Division Division
x
x
=
=
=
=
=
x
=
Sales 25,000,000$ 8,000,000$ 9,750,000$
Cost of goods sold 16,670,000 5,575,000 6,795,000
2.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Cereal Division:
$1,000,000 $25,000,000
3.
Rate of Return (ROI) on Investment
Income from Operations
Sales
Invested Assets
=
x
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
For the Year Ended June 30, 2016
THE CRUNCHY GRANOLA COMPANY
Divisional Income Statements
Per dollar of invested assets, the Snack Cake Division is the most profitable of the three
Problem 24-3A
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry in the income statement and above or below
elements in the equations. The essay answer will not be graded.
1.
Mutual Electronic Investment
Fund Brokerage Banking
Division Division Division
Fee revenue
Operating expenses
Income from operations
2.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Mutual Fund Division:
Electronic Brokerage Division:
Investment Banking Division:
3.
ROI
=
x
=
ROI
=
x
=
Sales
Invested Assets
ROI
=
x
=
x
Score:
Key Code:
Instructions
Problem 24-3B
Name:
Section:
0%
[Key essay answer here]
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
E.F. LYNCH COMPANY
Divisional Income Statements
For the Year Ended June 30, 2016
Rate of Return (ROI) on Investment
=
Income from Operations
An asterisk (*) will appear to the right of an incorrect entry in the income statement and above or below
elements in the equations. The essay answer will not be graded.
1.
Mutual Electronic Investment
Fund Brokerage Banking
Division Division Division
x
21.6%
ROI
=
=
x
24.0%
ROI
=
=
Fee revenue 4,140,000$ 3,360,000$ 4,560,000$
2.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Mutual Fund Division:
$1,159,200 $4,140,000
4,140,000$ $5,175,000
3.
x
Rate of Return (ROI) on Investment
Income from Operations
Sales
Invested Assets
=
22.4%
ROI
=
x
=
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
For the Year Ended June 30, 2016
E.F. LYNCH COMPANY
Divisional Income Statements
Per dollar of invested assets, the Electronic Brokerage Division is the most profitable of the
three divisions. Assuming that the rates of return on investments do not change in the future, an
Problem 24-3B
Name:
Solution
Section:
ON
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry in the income statement and above or below
elements in the equations.
1.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Commercial Division:
2.
Proposal 1 Proposal 2 Proposal 3
Sales
Cost of goods sold
Gross profit
Operating expenses
Income from operations
Invested assets
3.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Proposal 1:
Proposal 2:
Proposal 3:
ROI
=
ROI
=
ROI
=
Invested Assets
ROI
=
x
=
Rate of Return (ROI) on Investment
=
Income from Operations
Sales
Invested Assets
x
x
Sales
Rate of Return (ROI) on Investment
=
Income from Operations
Problem 24-4A
Name:
Section:
[Key code here]
Score:
Key Code:
Instructions
For the Year Ended December 31, 2016
0%
MAXELL MANUFACTURING INC.⎯COMMERICAL DIVISION
Estimated Income Statements
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
=
x
=
x
=
x
4.
meet(s) the required 21% rate of return on investment.
5.
Rate of return on investment (ROI) = Profit margin x Required investment turnover
= x Required investment turnover
Required investment turnover =
Current investment turnover =
Increase in investment turnover =
An asterisk (*) will appear to the right of an incorrect entry in the income statement and above or below
elements in the equations.
1.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
2.
Proposal 1 Proposal 2 Proposal 3
Sales 3,500,000$ 3,500,000$ 2,905,000$
Cost of goods sold 2,585,000 1,920,000 2,073,300
3.
Rate of Return (ROI) on Investment = Profit Margin x Investment Turnover
Sales
Proposal 1:
$315,000 $3,500,000
$3,500,000 $2,187,500
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Problem 24-4A
Name:
Solution
Section:
Answers are entered in the cells with gray backgrounds.
Rate of Return (ROI) on Investment
=
Income from Operations
x
Sales
For the Year Ended December 31, 2016
MAXELL MANUFACTURING INC.⎯COMMERICAL DIVISION
Estimated Income Statements
Rate of Return (ROI) on Investment
Income from Operations
Sales
Invested Assets
=
x
Invested Assets
ROI
=
x
=
14.4%
16.8%
=
x
=
5.
Rate of return on investment (ROI) = Profit margin x Required investment turnover