Revenues Operating Expenses Income before Service Charges Investment ROI before service charges Number of professors Number of students in program Service department expenses Service department charge rate Revenues Operating expenses Income before service charges Service charges: Payroll Advising Income from operations ROI after service charges Instructional Instructional Accounting Business 500,000 $1,000,000 250,000 $ 550,000 FORMULA 2 FORMULA 1 300,000 $ 500,000 FORMULA 3 $ $ $ 5 200 Payroll (Driver is # of professors) 100,000 FORMULA 5 Instructional Accounting FORMULA 7 FORMULA 9 FORMULA 11 FORMULA 4 FORMULA 13 10 500 Advising (Driver is # of students) $ 200,000 FORMULA 6 500,000 $1,000,000 250,000 $ 550,000 250,000 $ 450,000 Instructional Business FORMULA 8 FORMULA 10 FORMULA 12 FORMULA 14

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

this is an excel style practice

Revenues
Operating Expenses
Income before Service Charges
Investment
ROI before service charges
Number of professors
Number of students in program
Service department expenses
Service department charge rate
Revenues
Operating expenses
Income before service charges
Service charges:
Payroll
Advising
Income from operations
ROI after service charges
Instructional Instructional
Accounting Business
$ 500,000 $1,000,000
250,000
$ 550,000
FORMULA 1
FORMULA 2
300,000 $ 500,000
FORMULA 3
5
200
Payroll
(Driver is # of
professors)
100,000
FORMULA 5
Instructional
Accounting
FORMULA 7
FORMULA 9
FORMULA 11
FORMULA 4
FORMULA 13
10
500
Advising
(Driver is # of
students)
$ 200,000
FORMULA 6
$
500,000
$
250,000 $ 550,000
$ 250,000 $ 450,000
Instructional
Business
$1,000,000
FORMULA 8
FORMULA 10
FORMULA 12
FORMULA 14
Transcribed Image Text:Revenues Operating Expenses Income before Service Charges Investment ROI before service charges Number of professors Number of students in program Service department expenses Service department charge rate Revenues Operating expenses Income before service charges Service charges: Payroll Advising Income from operations ROI after service charges Instructional Instructional Accounting Business $ 500,000 $1,000,000 250,000 $ 550,000 FORMULA 1 FORMULA 2 300,000 $ 500,000 FORMULA 3 5 200 Payroll (Driver is # of professors) 100,000 FORMULA 5 Instructional Accounting FORMULA 7 FORMULA 9 FORMULA 11 FORMULA 4 FORMULA 13 10 500 Advising (Driver is # of students) $ 200,000 FORMULA 6 $ 500,000 $ 250,000 $ 550,000 $ 250,000 $ 450,000 Instructional Business $1,000,000 FORMULA 8 FORMULA 10 FORMULA 12 FORMULA 14
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Segment Reporting
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.
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