In an Excel spreadsheet, create a schedule that shows your projected surgical volumes for 20232025.

Annual Volume Projections:

Use the data given below to calculate projected volumes for the ASC for the first three years of operation (20232025). Therefore, all cells should contain formulas with links that will update automatically when copied forward, and no cells should contain hard-coded numbers.

Each product line performs five different surgeries in the ASC, and CPT codes and Procedure Descriptions for each surgery are included in the chart below. Also included for each CPT code is the ASCs charge amount and the average number of surgeries per week for 2023. For each CPT Code, calculate the annualnumber of surgeries for 2023; as noted above, the ASC will be open for 50 weeks per year. Then, project the volume of procedures forward for 2024 and 2025 using these expected growth rates: Gastroenterology3% per year, Orthopedics5% per year, and Urology2% per year.

Display your answers with a comma and no decimals and round to zero decimal places. Sum each product line and sum the three product lines to obtain a total number of surgeries for the year.

HCPCS Outpatient Facility Primary Procedure codes		Outpatient Facility Reimbursement Method		2023	2023
CPT code	Procedure Description	APC Code	APC Description	Charge/ case	Average # Surgeries Per Week
43235	Upper Stomach-Intestine Scope for Diagnosis	5301	Level 1 Upper GI Procedures	2,000	11
43239	Upper Stomach-Intestine Scope for Biopsy	5301	Level 1 Upper GI Procedures	2,000	9
45378	Diagnostic examination of large bowel using an endoscope	5311	Level 1 Lower GI Procedures	2,000	15
45380	Diagnostic examination of large bowel using an endoscope with biopsy	5312	Level 2 Lower GI Procedures	2,500	12
45385	Removal of polyps or growths of large bowel using an endoscope	5312	Level 2 Lower GI Procedures	2,500	8
Total					55
Orthopedics
29881	Removal of one knee cartilage using an endoscope	5113	Level 3 Musculoskeletal Procedures	7,000	4
29824	Partial removal of collar bone at shoulder using an endoscope	5113	Level 3 Musculoskeletal Procedures	7,000	5
29877	Debridement and shaving of knee cartilage using an endoscope	5113	Level 3 Musculoskeletal Procedures	7,000	8
29848	Release of wrist ligament using an endoscope	5112	Level 2 Musculoskeletal Procedures	3,500	3
29880	Removal of both knee cartilages using an endoscope	5113	Level 3 Musculoskeletal Procedures	7,000	2
Total					22
Urology
50590	Lithotripsy of kidney stones	5375	Level 5 Urology and Related Services	10,500	5
52000	Scope of Bladder and Urethra for diagnosis	5372	Level 2 Urology and Related Services	1,500	7
52332	Scope of Bladder and Urethra, insert stent into Ureter	5374	Level 4 Urology and Related Services	7,000	5
52353	Scope of Bladder and Urethra, break up kidney stone	5375	Level 5 Urology and Related Services	9,500	4
55700	Biopsy of prostate gland	5373	Level 3 Urology and Related Services	4,500	4
Total					25