Show all work using Excel formulas (you must submit an Excel worksheet showing your work) FPPT Clinic offers Family Practice and Physical Therapy services at its location. The Family Practice Department generates $4,000,000 in revenue per year and the Physical Therapy Department generates $850,000 in revenue per year. The Family Practice Department occupies 80,000 square feet and the Physical Therapy Department occupies 40,000 square feet. Expenses for the departments are: Salaries/Wages & Benefits Other Expenses Family Practice $1,885,000 $1,226,000 Physical Therapy $400,000 $261,111 The Clinic is supported by three cost centers - Human Resources, Accounting, and Housekeeping services. Cost for those services are: Human Resources: $100,000 Accounting: $100,000 Housekeeping: $75,000 Allocate the costs for each of the three cost centers to the Family Practice Department and Physical Therapy Department. For each cost center, select a driver that you think is fair and allocate the cost pool for that cost center. Complete a P&L for the Family Practice Department and for the Physical Therapy Department.

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
Topic Video
Question
Show all work using Excel formulas (you must submit an Excel worksheet
showing your work)
FPPT Clinic offers Family Practice and Physical Therapy services at its location. The
Family Practice Department generates $4,000,000 in revenue per year and the Physical
Therapy Department generates $850,000 in revenue per year.
The Family Practice Department occupies 80,000 square feet and the Physical Therapy
Department occupies 40,000 square feet.
Expenses for the departments are:
Salaries/Wages & Benefits
Other Expenses
Family Practice
$1,885,000
$1,226,000
Physical Therapy
$400,000
$261,111
The Clinic is supported by three cost centers - Human Resources, Accounting, and
Housekeeping services. Cost for those services are:
Human Resources: $100,000
Accounting: $100,000
Housekeeping: $75,000
Allocate the costs for each of the three cost centers to the Family Practice Department
and Physical Therapy Department. For each cost center, select a driver that you think
is fair and allocate the cost pool for that cost center.
Complete a P&L for the Family Practice Department and for the Physical Therapy
Department.
Transcribed Image Text:Show all work using Excel formulas (you must submit an Excel worksheet showing your work) FPPT Clinic offers Family Practice and Physical Therapy services at its location. The Family Practice Department generates $4,000,000 in revenue per year and the Physical Therapy Department generates $850,000 in revenue per year. The Family Practice Department occupies 80,000 square feet and the Physical Therapy Department occupies 40,000 square feet. Expenses for the departments are: Salaries/Wages & Benefits Other Expenses Family Practice $1,885,000 $1,226,000 Physical Therapy $400,000 $261,111 The Clinic is supported by three cost centers - Human Resources, Accounting, and Housekeeping services. Cost for those services are: Human Resources: $100,000 Accounting: $100,000 Housekeeping: $75,000 Allocate the costs for each of the three cost centers to the Family Practice Department and Physical Therapy Department. For each cost center, select a driver that you think is fair and allocate the cost pool for that cost center. Complete a P&L for the Family Practice Department and for the Physical Therapy Department.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Costing Systems
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