Accounting
Sathomas1019
CopyofCopyofStrayerUniversityHSA525Week4DQ_StudentSpreadsheet_.xlsxSheet1
| Financial Data | Financial Data | Financial Data | ||||||||||||||
| Price per UOSb | B/E Point (Volume) = Formula: TFC/CM Unit | ERROR:#DIV/0! | Price per UOSb | B/E Point (Volume) = Formula: TFC/CM Unit | ERROR:#DIV/0! | Price per UOSb | B/E Point (Volume) = Formula: TFC/CM Unit | ERROR:#DIV/0! | ||||||||
| VC per UOSc | B/E Point (Sales) = Formula: TFC/CM Ratio | ERROR:#DIV/0! | VC per UOSc | B/E Point (Sales) = Formula: TFC/CM Ratio | ERROR:#DIV/0! | VC per UOSc | B/E Point (Sales) = Formula: TFC/CM Ratio | ERROR:#DIV/0! | ||||||||
| CM per UOSd (b-c) | $ - 0 | CM per UOSd (b-c) | $0.00 | CM per UOSd (b-c) | $0.00 | |||||||||||
| TFCa | CM Ratio (d/b) | ERROR:#DIV/0! | CM Ratio (d/b) | ERROR:#DIV/0! | ||||||||||||
| CM Ratio (d/b) | ERROR:#DIV/0! | TFCa | TFCa | |||||||||||||
| Acupuncture | Biofeedback Therapy | Yoga Therapy | ||||||||||||||
| UOS/Patients | TFCe (= a) | TVCf c * UOS | TC e + f | TR b * UOS | UOS/Patients | TFCe (= a) | TVCf c * UOS | TC e + f | TR b * UOS | UOS/Patients | TFCe (= a) | TVCf c * UOS | TC e + f | TR b * UOS | ||
| 0 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 100 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 100 | $0.00 | $0.00 | $0.00 | $0.00 | 100 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 200 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 200 | $0.00 | $0.00 | $0.00 | $0.00 | 200 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 300 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 300 | $0.00 | $0.00 | $0.00 | $0.00 | 300 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 400 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 400 | $0.00 | $0.00 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 500 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 500 | $0.00 | $0.00 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 600 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 600 | $0.00 | $0.00 | $0.00 | $0.00 | 600 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 700 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 700 | $0.00 | $0.00 | $0.00 | $0.00 | 700 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 800 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 800 | $0.00 | $0.00 | $0.00 | $0.00 | 800 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 900 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 900 | $0.00 | $0.00 | $0.00 | $0.00 | 900 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 1000 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 1000 | $0.00 | $0.00 | $0.00 | $0.00 | 1000 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 1100 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 1100 | $0.00 | $0.00 | $0.00 | $0.00 | 1100 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 1200 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 1200 | $0.00 | $0.00 | $0.00 | $0.00 | 1200 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 1300 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 1300 | $0.00 | $0.00 | $0.00 | $0.00 | 1300 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 1400 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 1400 | $0.00 | $0.00 | $0.00 | $0.00 | 1400 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 1500 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | 1500 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 1600 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 1600 | $0.00 | $0.00 | $0.00 | $0.00 | 1600 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 1700 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 1700 | $0.00 | $0.00 | $0.00 | $0.00 | 1700 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 1800 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 1800 | $0.00 | $0.00 | $0.00 | $0.00 | 1800 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 1900 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 1900 | $0.00 | $0.00 | $0.00 | $0.00 | 1900 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 2000 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 2000 | $0.00 | $0.00 | $0.00 | $0.00 | 2000 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 2100 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 2100 | $0.00 | $0.00 | $0.00 | $0.00 | 2100 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 2200 | $34,835.00 | $0.00 | $34,835.00 | $0.00 | 2200 | $0.00 | $0.00 | $0.00 | $0.00 | 2200 | $0.00 | $0.00 | $0.00 | $0.00 | ||
$$ Breakeven: Acupuncture
TC e + f 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 34835 TR b * UOS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Volume (Units of Service)
Dollars
$$ Breakeven-Biofeedback Therapy
TC e + f 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TR b * UOS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Units of Service / Patients
Dollars
$$ Breakeven-Yoga Therapy
TC e + f 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TR b * UOS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Volume (Units of Service)
Dollars
