Information:

Monroe Outpatient Surgery Center $($MOSC$)$ is developing an operating budget for the month ending October $31,2025.$ MOSC

expects to perform $95$ surgical procedures during the month. MOSC's average charge $($price$)$ per surgical procedure is $$3,750.$ The

cost of disposable surgical supplies is $$375$ per surgical procedure. MOSC also contracts with orthopedic surgeons at a fee of $$1,950$

per surgical procedure. The monthly salaries for MOSC's receptionist, bookkeeper, and two surgical nurses total $$14,150.$ MOSCS's

occupancy costs, which include space rental, insurance, and all utilities, are $$11,200$ per month. Average monthly communication

costs are $$1,875.$ Office and operating room equipment was installed at a cost of $$395,125.$ The equipment is expected to have a $5-$

year life and has no salvage value.

Task:

In Excel, prepare MOSC's operating budget for the month of October $2025.$ Use formulas to drive calculations.

Save file as lastname.firstname.hw$21$ and upload the file here

Use the editor to format your answer