David Jones, the new administrator for a surgical clinic, was trying to determine now to allocate his indirect expenses. His staff was complaining that the current method of taking a percentage of revenues was unfair. He decided to try to allocate utilities based on square footage of each department, administration based on direct costs, and laboratory based on tests. Use the information in the chart below. Square Footage Direct Lab Tests Expenses $200,000 500,000 625,000 1,400,000 300,000 600,000 $3,375,000 Utilities Administration 2,000 Laboratory Day-op suite Cystoscopy Endoscopy Total 2,000 3,000 1,500 1,500 10,000 4,000 500 500 5,000
David Jones, the new administrator for a surgical clinic, was trying to determine now to allocate his indirect expenses. His staff was complaining that the current method of taking a percentage of revenues was unfair. He decided to try to allocate utilities based on square footage of each department, administration based on direct costs, and laboratory based on tests. Use the information in the chart below. Square Footage Direct Lab Tests Expenses $200,000 500,000 625,000 1,400,000 300,000 600,000 $3,375,000 Utilities Administration 2,000 Laboratory Day-op suite Cystoscopy Endoscopy Total 2,000 3,000 1,500 1,500 10,000 4,000 500 500 5,000
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Can you please check my answer

Transcribed Image Text:**Allocating Indirect Expenses in a Surgical Clinic**
David Jones, the new administrator for a surgical clinic, aimed to determine a fair method of allocating indirect expenses. Previously, his staff expressed dissatisfaction with the revenue-based allocation model, deeming it unfair. In response, David decided on a new approach:
- Utilities would be allocated based on square footage.
- Administration costs would be distributed according to direct expenses.
- Laboratory expenses would be divided based on the number of lab tests.
The following chart provides relevant data for each department:
| Department | Square Footage | Direct Expenses | Lab Tests |
|-----------------|----------------|-----------------|-----------|
| Utilities | | $200,000 | |
| Administration | 2,000 | $500,000 | |
| Laboratory | 2,000 | $625,000 | |
| Day-op suite | 3,000 | $1,400,000 | 4,000 |
| Cystoscopy | 1,500 | $300,000 | 500 |
| Endoscopy | 1,500 | $600,000 | 500 |
| **Total** | **10,000** | **$3,375,000** | **5,000** |
**Question:** What are the day-op suite's total expenses?
The calculated total expense for the day-op suite is **$2,375,551**.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.