4 dis
MrsLovingLife2016
CopyofCopyofStrayerUniversityHSA525Week4DQ_StudentSpreadsheet_2.xlsxSheet1
| Financial Data | Financial Data | Financial Data | ||||||||||||
| Price per UOSb | $ 376.57 | B/E Point (Volume) = Formula: TFC/CM Unit | 164 | Price per UOSb | $252.73 | B/E Point (Volume) = Formula: TFC/CM Unit | 160 | Price per UOSb | $183.74 | B/E Point (Volume) = Formula: TFC/CM Unit | 160 | |||
| VC per UOSc | $ 24.00 | B/E Point (Sales) = Formula: TFC/CM Ratio | $ 61,828.20 | VC per UOSc | $9.54 | B/E Point (Sales) = Formula: TFC/CM Ratio | $ 40,436.38 | VC per UOSc | $3.05 | B/E Point (Sales) = Formula: TFC/CM Ratio | $ 29,397.99 | |||
| CM per UOSd (b-c) | $ 343.57 | CM per UOSd (b-c) | $243.19 | CM per UOSd (b-c) | $180.69 | |||||||||
| TFCa | $ 56,410.00 | CM Ratio (d/b) | 0.962 | CM Ratio (d/b) | 0.983 | |||||||||
| CM Ratio (d/b) | 0.9123668906 | TFCa | $38,910.00 | TFCa | $28,910.00 | |||||||||
| 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 | $38,910.00 | $0.00 | $38,910.00 | $0.00 | 0 | $28,910.00 | $0.00 | $28,910.00 | $0.00 |
| 100 | $34,835.00 | $2,400.00 | $37,235.00 | $37,657.00 | 100 | $38,910.00 | $954.00 | $39,864.00 | $25,273.00 | 100 | $28,910.00 | $305.00 | $29,215.00 | $18,374.00 |
| 200 | $34,835.00 | $4,800.00 | $39,635.00 | $75,314.00 | 200 | $38,910.00 | $1,908.00 | $40,818.00 | $50,546.00 | 200 | $28,910.00 | $610.00 | $29,520.00 | $36,748.00 |
| 300 | $34,835.00 | $7,200.00 | $42,035.00 | $112,971.00 | 300 | $38,910.00 | $2,862.00 | $41,772.00 | $75,819.00 | 300 | $28,910.00 | $915.00 | $29,825.00 | $55,122.00 |
| 400 | $34,835.00 | $9,600.00 | $44,435.00 | $150,628.00 | 400 | $38,910.00 | $3,816.00 | $42,726.00 | $101,092.00 | 400 | $28,910.00 | $1,220.00 | $30,130.00 | $73,496.00 |
| 500 | $34,835.00 | $12,000.00 | $46,835.00 | $188,285.00 | 500 | $38,910.00 | $4,770.00 | $43,680.00 | $126,365.00 | 500 | $28,910.00 | $1,525.00 | $30,435.00 | $91,870.00 |
| 600 | $34,835.00 | $14,400.00 | $49,235.00 | $225,942.00 | 600 | $38,910.00 | $5,724.00 | $44,634.00 | $151,638.00 | 600 | $28,910.00 | $1,830.00 | $30,740.00 | $110,244.00 |
| 700 | $34,835.00 | $16,800.00 | $51,635.00 | $263,599.00 | 700 | $38,910.00 | $6,678.00 | $45,588.00 | $176,911.00 | 700 | $28,910.00 | $2,135.00 | $31,045.00 | $128,618.00 |
| 800 | $34,835.00 | $19,200.00 | $54,035.00 | $301,256.00 | 800 | $38,910.00 | $7,632.00 | $46,542.00 | $202,184.00 | 800 | $28,910.00 | $2,440.00 | $31,350.00 | $146,992.00 |
| 900 | $34,835.00 | $21,600.00 | $56,435.00 | $338,913.00 | 900 | $38,910.00 | $8,586.00 | $47,496.00 | $227,457.00 | 900 | $28,910.00 | $2,745.00 | $31,655.00 | $165,366.00 |
| 1000 | $34,835.00 | $24,000.00 | $58,835.00 | $376,570.00 | 1000 | $38,910.00 | $9,540.00 | $48,450.00 | $252,730.00 | 1000 | $28,910.00 | $3,050.00 | $31,960.00 | $183,740.00 |
| 1100 | $34,835.00 | $26,400.00 | $61,235.00 | $414,227.00 | 1100 | $38,910.00 | $10,494.00 | $49,404.00 | $278,003.00 | 1100 | $28,910.00 | $3,355.00 | $32,265.00 | $202,114.00 |
| 1200 | $34,835.00 | $28,800.00 | $63,635.00 | $451,884.00 | 1200 | $38,910.00 | $11,448.00 | $50,358.00 | $303,276.00 | 1200 | $28,910.00 | $3,660.00 | $32,570.00 | $220,488.00 |
| 1300 | $34,835.00 | $31,200.00 | $66,035.00 | $489,541.00 | 1300 | $38,910.00 | $12,402.00 | $51,312.00 | $328,549.00 | 1300 | $28,910.00 | $3,965.00 | $32,875.00 | $238,862.00 |
| 1400 | $34,835.00 | $33,600.00 | $68,435.00 | $527,198.00 | 1400 | $38,910.00 | $13,356.00 | $52,266.00 | $353,822.00 | 1400 | $28,910.00 | $4,270.00 | $33,180.00 | $257,236.00 |
| 1500 | $34,835.00 | $36,000.00 | $70,835.00 | $564,855.00 | 1500 | $38,910.00 | $14,310.00 | $53,220.00 | $379,095.00 | 1500 | $28,910.00 | $4,575.00 | $33,485.00 | $275,610.00 |
| 1600 | $34,835.00 | $38,400.00 | $73,235.00 | $602,512.00 | 1600 | $38,910.00 | $15,264.00 | $54,174.00 | $404,368.00 | 1600 | $28,910.00 | $4,880.00 | $33,790.00 | $293,984.00 |
| 1700 | $34,835.00 | $40,800.00 | $75,635.00 | $640,169.00 | 1700 | $38,910.00 | $16,218.00 | $55,128.00 | $429,641.00 | 1700 | $28,910.00 | $5,185.00 | $34,095.00 | $312,358.00 |
| 1800 | $34,835.00 | $43,200.00 | $78,035.00 | $677,826.00 | 1800 | $38,910.00 | $17,172.00 | $56,082.00 | $454,914.00 | 1800 | $28,910.00 | $5,490.00 | $34,400.00 | $330,732.00 |
| 1900 | $34,835.00 | $45,600.00 | $80,435.00 | $715,483.00 | 1900 | $38,910.00 | $18,126.00 | $57,036.00 | $480,187.00 | 1900 | $28,910.00 | $5,795.00 | $34,705.00 | $349,106.00 |
| 2000 | $34,835.00 | $48,000.00 | $82,835.00 | $753,140.00 | 2000 | $38,910.00 | $19,080.00 | $57,990.00 | $505,460.00 | 2000 | $28,910.00 | $6,100.00 | $35,010.00 | $367,480.00 |
| 2100 | $34,835.00 | $50,400.00 | $85,235.00 | $790,797.00 | 2100 | $38,910.00 | $20,034.00 | $58,944.00 | $530,733.00 | 2100 | $28,910.00 | $6,405.00 | $35,315.00 | $385,854.00 |
| 2200 | $34,835.00 | $52,800.00 | $87,635.00 | $828,454.00 | 2200 | $38,910.00 | $20,988.00 | $59,898.00 | $556,006.00 | 2200 | $28,910.00 | $6,710.00 | $35,620.00 | $404,228.00 |
$$ Breakeven: Acupuncture
TC e + f 34835 37235 39635 42035 44435 46835 49235 51635 54035 56435 58835 61235 63635 66035 68435 70835 73235 75635 78035 80435 82835 85235 87635 TR b * UOS 0 37657 75314 112971 150628 188285 225942 263599 301256 338913 376570 414227 451884 489541 527198 564855 602512 640169 677826 715483 753140 790797 828454
Volume (Units of Service)
Dollars
$$ Breakeven-Biofeedback Therapy
TC e + f 38910 39864 40818 41772 42726 43680 44634 45588 46542 47496 48450 49404 50358 51312 52266 53220 54174 55128 56082 TR b * UOS 0 25273 50546 75819 101092 126365 151638 176911 202184 227457 252730 278003 303276 328549 353822 379095 404368 429641 454914
Units of Service / Patients
Dollars
$$ Breakeven-Yoga Therapy
TC e + f 28910 29215 29520 29825 30130 30435 30740 31045 31350 31655 31960 32265 32570 32875 33180 33485 33790 34095 34400 TR b * UOS 0 18374 36748 55122 73496 91870 110244 128618 146992 165366 183740 202114 220488 238862 257236 275610 293984 312358 330732
Volume (Units of Service)
Dollars
$$ Breakeven: Acupuncture
TC e + f 34835 37235 39635 42035 44435 46835 49235 51635 54035 56435 58835 61235 63635 66035 68435 70835 73235 75635 78035 80435 82835 85235 87635 TR b * UOS 0 37657 75314 112971 150628 188285 225942 263599 301256 338913 376570 414227 451884 489541 527198 564855 602512 640169 677826 715483 753140 790797 828454
Volume (Units of Service)
Dollars
$$ Breakeven-Biofeedback Therapy
TC e + f 38910 39864 40818 41772 42726 43680 44634 45588 46542 47496 48450 49404 50358 51312 52266 53220 54174 55128 56082 TR b * UOS 0 25273 50546 75819 101092 126365 151638 176911 202184 227457 252730 278003 303276 328549 353822 379095 404368 429641 454914
Units of Service / Patients
Dollars
$$ Breakeven-Yoga Therapy
TC e + f 28910 29215 29520 29825 30130 30435 30740 31045 31350 31655 31960 32265 32570 32875 33180 33485 33790 34095 34400 TR b * UOS 0 18374 36748 55122 73496 91870 110244 128618 146992 165366 183740 202114 220488 238862 257236 275610 293984 312358 330732
Volume (Units of Service)
Dollars
$$ Breakeven: Acupuncture
TC e + f 34835 37235 39635 42035 44435 46835 49235 51635 54035 56435 58835 61235 63635 66035 68435 70835 73235 75635 78035 80435 82835 85235 87635 TR b * UOS 0 37657 75314 112971 150628 188285 225942 263599 301256 338913 376570 414227 451884 489541 527198 564855 602512 640169 677826 715483 753140 790797 828454
Volume (Units of Service)
Dollars
$$ Breakeven-Biofeedback Therapy
TC e + f 38910 39864 40818 41772 42726 43680 44634 45588 46542 47496 48450 49404 50358 51312 52266 53220 54174 55128 56082 TR b * UOS 0 25273 50546 75819 101092 126365 151638 176911 202184 227457 252730 278003 303276 328549 353822 379095 404368 429641 454914
Units of Service / Patients
Dollars
$$ Breakeven-Yoga Therapy
TC e + f 28910 29215 29520 29825 30130 30435 30740 31045 31350 31655 31960 32265 32570 32875 33180 33485 33790 34095 34400 TR b * UOS 0 18374 36748 55122 73496 91870 110244 128618 146992 165366 183740 202114 220488 238862 257236 275610 293984 312358 330732
Volume (Units of Service)
Dollars
