Week 4 Discussion
Mking25
cf_week_4_discussion_question_spreadsheet.xlsxWeek 4; DQ
| Financial Data | Financial Data | Financial Data | ||||||||||||||
| Price per UOSb | $ 367.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 | $ 60,350.51 | 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.9347063144 | 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 | $36,757.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 | $73,514.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 | $110,271.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 | $147,028.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 | $183,785.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 | $220,542.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 | $257,299.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 | $294,056.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 | $330,813.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 | $367,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 | $404,327.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 | $441,084.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 | $477,841.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 | $514,598.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 | $551,355.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 | $588,112.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 | $624,869.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 | $661,626.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 | $698,383.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 | $735,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 | $771,897.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 | $808,654.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
#REF! 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 #REF! 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.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
#REF! 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 #REF! 0.0 0.0 0.0 0.0 0.0 0. 0 0.0 0.0 0.0 0.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
#REF! 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 #REF! 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.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
