Detailed Question: Given the imaging center scenario and financial data, COMPLETE the "Assignment 2 Break Even Excel Template"
Scenario: Pacific Imaging Center is a small imaging center with two analogue film or screen units. As the director of the center, Juanita Hernandez has been asked to determine if the current staffing is correct for her place or should she add another technologist. She currently uses 2 mammography units, 2 technologists, and 1 aide.
She has analyzed the current costs and determined the following:
Reimbursement per screen $75
Equipment costs per month ($800 per machine) $1,600
Technologists costs per mammography $20
Technologists aide per mammography $4
Variable cost per mammography $10
Equipment maintenance per month per machine ($350 per machine) $700.
Attachment:- Break Even Excel Template.rar