Perform a cost volume profit (CVP) analysis on a couple of alternatives that management is considering for implementation (details to be worked out). Download and

Perform a cost volume profit (CVP) analysis on a couple of alternatives that management is considering for implementation (details to be worked out).
Download and review the case study in the Week 4 Discussion Question [DOCX] and the Week 4 Discussion Spreadsheet [XLSX].
These two files contain the data necessary to complete the CVPs (dollar breakeven and volume breakeven) and to create the CVP graphs for each alternative.
Prepare a narrated PowerPoint presentation (15 minutes in duration).

i3 ' E HSA525 Week 4 Case Study , Home Insert Design Layout References Mailings Review View Acrobat L+ Share A X . E , WW , ,A Av e lo , \"Brandt. more AaBchDc some , [3, 5%,. Paste Heading 2 Styles Create and Share Request v , , Pane Adobe PDF Signatures Normal No Spacing Heading 1 HSA525 Week 4; Discussion Question Cost Volume Prot Analysis for Proposed CAM Alternatives For this assignment, you're assuming the persona of a health services manager working for Benson Regional Medical Center, The Center has been seeking opportunities to incorporate more complementary and alternative medicine (CAM) into its existing service offerings; however, it wasn't until recently being awarded a federal grant from the National Center for Complementary and Integrative Health that made this goal possible. Despite western trained providers' skepticism of non-traditional forms of medicine/therapies, there is a growing body of evidence to support the combination of complementary and conventional medical therapeutic interventions To consumers, complementary medicine is less expensive than conventional treatments, easy to access, and attractive to patients who have tried more traditional treatment approaches with limited or no success Dr. Dana Foster, Chief of Staff, has requested that you complete a cost volume prot (CVP) analysis looking to determine the sales and volume breakeven points for three (3) CAM altemalives: acupuncture, biofeedback, and yoga therapy. In addition to computing the breakeven points, you are also being asked to create CV? graphs for these unconventional interventions. Many who work in the local economy hold what are classically viewed as blue collar positions and are; therefore, prone to suffering from chronic lower back pain. Financial assumptions, costing data, and prices per units of service (UOS) have been identied with assistance from various functional areas within and outside the Center. You recently completed your analysis using Microsoft Excel. Now that the CV? analysis and CV? graphs have been completed for each alternative, Dr. Foster would like for you to email her your ndings, which CAM alternative you'd recommend launching first, and your supporting rationale. Hint: As you know, when a (N P graph is created using Microso ExoeL you can manipulate the nancial data used to create the graph (price, unit VC, U08), and immediately observe how these changes impact the breakeven point within the graph. For example, perhaps you could lower your PC forecasts during the contract negotiation process; find suppliers that care produce educational materials for less; or negotiate more favorable credit terms on the purchase of supplies CAM Alternatives The first alternative is acupuncture This is an ancient process, rooted in Eastern medicine, where thin, solid needles are strategically inserted in the body, and then are carefully manipulated by the practitionert The next alternative is biofeedback. In this intervention, patients harness the power of their mind and becoming aware of what's going on inside their body, so they can gain more control over their health. The last intervention to consider is yoga therapy. Yoga therapy is a type of therapy that uses yoga postures, breathing exercises, meditation, and guided imagery to improve mental and physical health. The holistic focus of yoga therapy encourages the integration of mind, body, and spirit. Modern yoga therapy covers a broad range of therapeutic modalities, incorporating elements from both physical therapy and psychotherapy. The objective of all of these interventions is to help patients find relief from chronic lower back discomfort when more conventional medical interventions seem to fall short of expectations. An in-depth review of the literature revealed that each CAM approach has been effective in managing chronic lower back pain for a number of clients. Each is considered relatively safe when performed by certied or licensed practitioners. There are certainly intangible benets associated with each therapy. For example, many patients report being pain free after years of intolerable discomfort. Others reported being able to resume leisure and work-related activities that were not possible due to the back pain prior to receiving complementary and alternative medical interventions. You and your colleagues know that in addition to the intangible benets there are those that can be measured in dollars and cents. These include a reduction in the frequency of doctor visits; lead to less reliance on pain medications (opioids); and lessen lost productive time at work. These tangible and intangible benets are not quantied for the purposes of completing the CV? analysis and graphing. Intervention Costs (FC and VC) In order to decide which therapy to recommend for funding, you need to identied the relevant costs (xed and variable) associated with each alternative on a per client and annual basis, as well as develop nancial assumptions which were used to estimate the costs. Fixed costs (FC) remain more or less unchanged irrespective of the volume of clients seen; however, in reality, all costs will tend to vary over time. Generally speaking, direct labor is considered a variable cost (VC); however, in health care we typically consider direct labor (practitioners, nurses, therapists, nursing aids, medical assistants, etc.) to be a semi-xed cost or mixed costs. For CVP purposes, semifixed costs are PC. For example, FC, for purposes of the CV? include hourly wages for the staff and any equipment used in the provision of care. Variable costs (VC) vary with output, so the greater the volume of clients see the greater the VC. For the CEA and CVP, the VC will include patient education materials and consumable supplies used in the provision of care. Financial mmption: It was assumed that the complementary and integrative health service line which will incorporate the chosen CAM alternative into its existing services will have 160 clients for the first year of operation which will be appropriate for this new service. It was Page 1 OH 2056 Words I213 English (US) in Focus - V + 100% HSA525 Week 4 Case Study Q ~ Search in Document Home Insert Design Layout References Mailings Review View Acrobat "+ Share ~ Times New Ro... 16 A- A Aa A AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE Paste B I U . abe X2 X2 A . A Normal No Spacing Heading 1 Heading 2 styles Create and Share Request Pane Adobe PDF Signatures that the complementary and integrative health service line, which will incorporate the chosen CAM alternative into its existing services, will have 160 clients, for the first year of operation, which will be appropriate for this new service. It was also assumed that the provider will be contracted (non-benefited) with the Center and will be expected to dedicate a total of 10 hours per week at the Center providing care to clients. This includes time to not only evaluate and treat the clients, but also provide ample time for charting and other necessary paperwork. It is assumed that the provider will only be available 50 weeks per year allowing 2 weeks for rest and relaxation (vacation). The Center will allot a total of 2 hours per week of one (1) clerical worker who will assist in scheduling; ensuring patient education materials are stocked and available; coordinating resources necessary to meet the clients' needs; and place follow-up calls with clients and other persons connected with the clients' care. For the spinal manipulation alternative, the Center will need to retain the services of an outside Radiologist to read the radiographs. This is estimated to take a total of one (1) hour per week. There will also be a need for an X-ray Technician, who will be responsible for taking the radiographs and sending them to the Radiologist. The Technician will be employed by the Center and supporting this alternative shouldn't consume more than an hour per week. It was assumed that each alternative will routinely provide appropriate patient education materials (take-away pieces) for their clients, and that this cost will vary based on the market value of these collaterals. Under yoga therapy, the clients would receive five (5) appropriate brochures at $.61 apiece; for biofeedback therapy the clients receive a single trifold brochure at a cost of $.19; and finally the acupuncture service would provide three (3) separate brochures at a unit price of $7 apiece for the Q&A and First Visit brochure and $6.50 for the Steps of Care brochure. Completing the Cost Volume Profit Analysis (Sales & Volume) In order to complete the CVP analyses for each CAM alternative, you will need the price per unit of service (UOS) or patient, the VC per UOS or patient (ie, patient education materials and consumable supplies), the total variable cost (TVC), the annual FC, the total fixed cost (TFC) per year (i.e., salaries), the unit contribution margin (CM), and the contribution margin ratio. In addition to computing the CVP (sale & volume breakeven point) for each CAM alternative, you'll be constructing a CVP Graph for these alternatives The FC (i.e., salaries) was calculated using the following formula: (hourly rate of compensation * number of hours dedicated to these clients per week) * 50 weeks in a given year. (See table 1) To determine the TFC per year, the following formula was applied: (add the annual compensation for each alternative). (See table 1) To calculate the VC (i.e., patient education materials and consumable supplies) for each alternative, the following formula was applied: unit cost of brochures and consumable supplies * the anticipated total number of clients in a given year. (See table 1) To calculate the TVC, the following formula was applied: add the VC for the consumable supplies and brochures for each alternative. (See table 1) To determine the VC per UOS/patient, the following formula is to be applied: TVC / total number of patients seen in a given period of time (initial year). The price per UOS was estimated by taking the national average for each alternative being considered. (See table 1) To compute the unit CM, the following formula was applied: price per UOS - VC per UOS. (See figure 1) To calculate the CM ratio, the following formula should be applied: unit CM / price per UOS. (See figure 1) To compute the CVP breakeven point, in sales ($$), you should apply the following formula: TFC / CM Ratio. (See figure 1). To compute the CVP breakeven point, in UOS, you should apply the following formula: TFC / Unit CM. (See figure 1). Completing the Cost Volume Profit Graphs Financial Data To create CVP graphs to visually display the breakeven point for each alternative, you will need the following financial data for X number of periods into the future (example, 10 years): anticipated UOS, Price per UOS $65.00 FC, TVC, TC, and total revenue (TR) (See figure 1). When anticipating the UOS, you may want to begin with "0" UOS, and then include evenly spaced intervals going forward (See figure 1). For example, you VC per UOs' $7.50 may start with "0" UOS, and then anticipate an increase of 100 UOS per year for the next 10 years (0, 100, 200, 300, 400, 500, 600, 700, 800, and 900) (See figure 1). You can use any interval you choose and CM per UOS(b-c 57.50 for any period of time into the future. The FC is simply FC you computed when calculating the CVP (See figure 1). Since FC don't change with changes in volume (or UOS), this value will be the same for each CM Ratio (d/b) 0.885 TFC $58,575.00 period (See figure 1). The TVC is computed by using the following formula: VC per UOS * each UOS (See figure 1). The TC is calculated using the following formula: FC + TVC for each UOS (See figure 1). TR is calculated by using the following formula: price per UOS * each UOS (See figure 1). Figure 1 to the left provides an example of data needed to compute CVP graphs. This illustrates the calculations needed to construct a graphical representation of the CVP breakeven in Microsoft Excel (See Figure TFC UOS/Patients c . UOS TO TR 1). b * UOS 0 $58,575.00 $0.00 $58,575.00 $0.00 100 $58,575.00 $750.00 $59,325.00 $6,500.00 Figure 2 provides an example of a CVP graph using the TC and TR data contained in Figure 1. 200 $58,575.00 $1,500.00 $60,075.00 $13,000.00 300 $58,575.00 $2,250.00 $60,825.00 $19,500.00 Figure 2: CVP Graph 400 $58,575.00 $3,000.00 $61,575.00 $26,000.00 500 $58,575.00 $3,750.00 $62,325.00 $32,500.00 600 $58,575.00 $4,500.00 $63,075.00 $39,000.00 Cost Volume Profit Graph 700 $58,575.00 $5,250.00 $63,825.00 $45,500.00 800 $58,575.00 $6,000.00 $64,575.00 $52,000.00 $140,000.00 900 $58,575.00 $6,750.00 $65,325.00 $58,500.00 1000 $58,575.00 $7,500.00 $66,075.00 $65,000.00 $120,000.00 1100 $58,575.00 $8,250.00 $66,825.00 $71,500.00 1200 $58,575.00 $9,000.00 $67,575.00 $78,000.00 $ 100,000.00 1300 $58,575.00 $9,750.00 $68,325.00 $84,500.00 1400 $58,575.00 $10,500.00 $69,075.00 $91,000.00 $80,000.00 Dollars 1500 $58,575.00 $11,250.00 $69,825.00 $97,500.00 TC $60,000.00 e + f 1600 $58,575.00 $12,000.00 $70,575.00 $104,000.00 1700 $58,575.00 $12,750.00 $71,325.00 $110,500.00 . TR 1800 $58,575.00 $13,500.00 $72,075.00 $117,000.00 $40,000.00 b * UOS $20,000.00 $0.00 Page 1 of 1 2056 Words x English (US) E Focus + 100%HSA525 Week 4 Case Study Q ~ Search in Document Home Insert Design Layout References Mailings Review View Acrobat "+ Share ~ Times New Ro... 16 A- A Aa A AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE Paste I U abe X2 X2 A & A E Normal No Spacing Heading 1 Heading 2 Styles Create and Share Request Pane Adobe PDF Signatures $0.00 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Units of Service / Patients Table 1: Cost Effective Analysis of CAM Alternatives Item Cost Per Patient Annual Cost Fixed Costs: Acupuncture Contracted, experienced, $343.75 $55,000.00 doctoral prepared Acupuncturist @ $110.00/hr. for a total of 10 dedicated bars/wk Clerical support @ $14.10/hr., $8.82 $1,410.00 including benefits, for a dedicated 2 hrs/wk Total Fixed C $56,410.00 Variable Costs & Price: Acupuncture Q&A Brochure $7.00 $1, 120.00 First Visit Brochure $7.00 $1,120.00 Steps of Care Brochure $6.50 $1,040.00 Acupuncture Needles $3.50 $560.00 Total Variable Cost (TVC) $3,840.00 Variable Cost per $24.00 Total Cost for Acup $107.82 $60250.00 (TC Price per UOS/Patient $376.57 Fixed Costs: Biofeedback Contracted, experienced, $234.38 $37,500.00 certified Biofeedback Therapist r. for a dedicated 10 brs/wk Clerical support @ 14.10/hr., $8.82 $1,410.00 inclusive of benefits, for a Page 1 of 1 2056 Words X English (US) E Focus + 100%HSA525 Week 4 Case Study Q ~ Search in Document Home Insert Design Layout References Mailings Review View Acrobat "+ Share ~ Times New Ro... 16 A- A Aa A AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE Paste B I U abe X2 X2 AL . A . E Normal No Spacing Heading 1 Heading 2 Styles Create and Share Request Pane Adobe PDF Signatures Clerical support @ 14.10/hr., $8.82 $1,410.00 inclusive of benefits, for a dedicated 2 hrs/wk Total Fixed Cost (TFC) $38,910.00 Variable Costs & Price: Biofeedback Various trifold brochures with $0.19 $30.40 display (anticipate one (1) per client) Consumable supplies per client $9.35 $1,496.00 Total Variable Cost (TVC) $1,526.40 Variable Cost per UOS $9.54 Total Cost for Biofeedback $252.74 $40,436.40 (TC Price per UOS/Patient $252.73 Fixed Costs: Yoga Therapy Contracted, experienced, $171.8 $27,500.00 certified Yoga Therapist @ $55/hr. for a dedicated 10hrs/wk Clerical support @ 14.10/hr., $8.82 $1,410.00 inclusive of benefits, for a dedicated 2 brs/ wk Total Fixed Cost ( $28,910.00 Variable Costs & Price: Yoga Therapy Patient educat $3.05 $488.00 (assume 5 per client) Total Variable Cost (TVC) $488.00 Variable Cost per UOS $3.05 Total Cost for Yoga Therapy $183.75 $29,398.00 (TC Price per UOS/Patient $183.74 Page 1 of 1 2056 Words X English (US) E Focus + 100%Copy of Copy of Strayer University HSA525 Week 4 DQ _Student Spreadsheet_ Q ~ Search Sheet "+ Share ~ Page Layout Formulas Data Review View Acrobat Home Insert Insert Calibri (Body) 1 " A - A - = Currency * Delete Create and Share $ ~ % 00 .00 Conditional Format Cell Sort & Paste B IU . A . E E ELLE Formatting as Table Styles Format Filter Adobe PDF N6 X V fx Q R S H K M N O P Financial Data Financial Data Financial Data B/E Point (Volume) = B/E Point (Volume) = #DIV/O! 3/E Point (Volume) = Formula: TFC/CM un Price per UOS' Formula: TFC/CM U #DIV/O! Price per UOS 2 Price per UOS Formula: TFC/CM un #DIV/O! B/E Point (Sales) = B/E Point (Sales) = #DIV/O! B/E Point (Sales) = Formula: TFC/CM Ratio VC per UOS Formula: TFC/CM Ratio #DIV/O! VC per UOS 3 VC per UOS' Formula: TFC/CM Ratio #DIV/O! $0.00 CM per UOS (b-c) $0.00 CM per UOS (b-c) CM per UOS (b-c) S #DIV/O! CM Ratio (d/b) #DIV/O! CM Ratio (d/b) 5 TFC TFC TFC 6 CM Ratio (d/b) #DIV/O! oga Therapy Biofeedback Therapy Acupuncture TVC TR TVC TFC TVC TFC TR TR TFC b * UOs UOS/Patients ( = a ) :* UOS b * UOS 9 c * UOS b * UOs ( = a ) * UO ( = a ) UOS/Patients UOS/Patients $0.0 50.00 $0.00 $0.OC $0.0 $34,835.0 $0.OC 0.00 $0.00 $0.00 $0.00 10 $34,835.00 $0.00 100 $0.00 $0.0 $0.00 $0.00 $0.0 $0.00 $34,835.00 $0.00 $34,835.00 $0.00 100 $0.00 11 100 200 $0.00 $0.0 $0.00 $0.00 $34,835.00 $0.00 $34,835.00 $0.00 200 $0.00 $0.0 $0.00 $0.00 12 200 $0.00 300 $0.00 $0.00 $0.00 $0.00 300 $0.00 $0.00 $0.0 $0.00 $0.00 ;0.00 13 300 $34,835.00 $0.00 $34,835.00 400 $0.00 $0.00 $0.00 $0.00 400 $0.00 $0.00 14 40 $34,835.00 $0.00 $34,835.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 500 $0.00 15 $34,835.00 500 500 $0.00 $34,835.00 $0.00 $0.00 600 $0.00 $0.00 $0.00 $0.00 16 600 $34,835.00 $0.0 $34,835.00 $0.00 600 $0.00 $0.0 $0.00 700 $0.00 $0.00 $0.00 $0.00 700 $0.00 $0.00 $0.00 $0.00 17 700 $34,835.00 $0.00 $34,835.00 $0.00 $0.00 $0.00 $0.0 $0.00 $0.00 $0.00 800 $0.00 $0.00 18 800 $34,835.00 $0.0 $34,835.00 $0.00 800 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 900 $0.00 90 19 90 $34,835.00 $0.00 $34,835.00 $0.00 $0.00 1000 $0.00 $0.00 $0.00 $0.00 1000 $0.00 $0.00 20 1000 $34,835.00 $0.00 $34,835.00 $0.00 $0.00 1100 $0.00 $0.0 $0.00 $0.00 1100 $0.00 $0.0 $0.00 1100 $34,835.00 $0.00 $34,835.00 $0.00 $0.00 120 $0.00 $0.0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 1200 $34,835.00 $34,835.00 1200 $0.00 $0.0 $0.00 $0.00 $0.00 1300 $0.00 $0.00 $0.00 $0.00 $34,835.00 $0.00 $34,835.00 $0.00 1300 1300 $0.00 1400 50.00 $0.00 $0.00 ;0.00 $34,835.00 1400 $0.00 1400 $0.00 $0.00 $0.00 $0.00 24 $34,835.00 1500 $0.00 $0.00 $0.00 $0.00 1500 $0.00 $0.00 $0.00 $0.00 $0.00 25 1500 $34,835.00 $0.00 $34 ,835.00 $0.00 1600 $0.00 $0.0 $0.00 $0.00 $0.00 1600 $34,835.00 $0.00 $34,835.00 $0.00 1600 $0.00 $0.00 26 $0.00 170 $0.00 $0.0 $0.00 $0.00 $34,835.00 $0.00 1700 $0.00 $0.00 $0.00 1700 $34,835.00 $0.00 $0.00 $0.00 $0.00 $34,835.00 $0.00 1800 $0.0 $0.00 $0.00 $0.00 1800 $0.0 28 1800 $34,835.00 $0.0 $0.00 $0.00 1900 $0.00 $0.00 $0.00 $0.00 90 $0.00 $0.00 29 1900 $34,835.00 $0.00 $34,835.00 $0.00 $0.00 $0.00 2000 $0.00 $0.00 $0.00 $0.0Ol $0.00 30 2000 $34,835.00 $0.00 $34,835.00 $0.00 2000 $0.00 2100 $0.00 $0.00 $0.00 $0.00 2100 $0.00 $0.00 $0.00 $0.00 2100 $34,835.00 $0.00 $34,835.00 $0.00 $0.00 2200 $0.00 $0.00 $0.00 $0.00 $0.00 32 $0.00 $34,835.00 $0.00 2200 $0.00 $0.00 2200 $34,835.00 $$ Breakeven-Yoga Therapy 33 $$ Breakeven-Biofeedback Therapy 34 $$ Breakeven: Acupuncture $1.00 35 $1.00 $40.000.00 Sheet1 + + 100% ReadyCopy of Copy of Strayer University HSA525 Week 4 DQ _Student Spreadsheet_ Q ~ Search Sheet Home Insert Page Layout Formulas Data Review View Acrobat "+ Share ~ Insert Calibri (Body) 1 . A - A - = = Currency * Delete Paste BIUVY. A. E E $ ~ % .00 Conditional Format Cell Sort & Create and Share Formatting as Table Styles Format Filter Adobe PDF N6 X v fx H K M N O P Q R S ---- 32 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 33 34 $$ Breakeven: Acupuncture $$ Breakeven-Biofeedback Therapy $$ Breakeven-Yoga Therapy 35 $1.00 $1.00 $40,000.00 36 $0.90 $0.90 37 $35,000.00 $0.80 $0.80 38 $30,000.00 $0.70 $0.70 39 $25,000.00 4 $0.60 $0.60 40 "TC $20,000.00 $0.50 TC TC $0.50 Dollars 41 e+ f $0.40 e+ f $0.40 e+ f 42 $15,000.00 TR TR TR $0.30 6 * UOS b * UOS $0.30 b * UOS 43 $10,000.00 $0.20 $0.20 44 $5,000.00 $0.10 $0.10 45 $0.00 $0.00 $0.00 46 1 2 3 4 5 6 7 8 9 1011121314151617181920212223 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 47 Volume (Units of Service) Units of Service / Patients Volume (Units of Service) 48 49 50 51 52 Sheet1 + + 100% Ready