Question: Please help me figure out this problem using the excel template below. Given the above information, use the Week 6 Assignment 2 Break Even Excel

Please help me figure out this problem using the excel template below.

Given the above information, use the Week 6 Assignment 2 Break Even Excel Template to answer these items:

Solve for monthly volume to break even.

Solve for monthly volume needed to break even at desired $5,000 per month profit level.

Solve for volume needed to break even at new reimbursement of $55 per mammography and no profit.

Solve for volume needed to break even with an additional technologist aide.

Please help me figure out this problem using the excel template below.Given the above information, use the Week 6 Assignment 2 Break Even

Break-Even Point Part d. Part a Dollars No. Dollars NoDollars NoDollars No Part b. Part c. Givens: B Equipment cost per month per mac C Intentionally left blank D Technologist cost per mammography E Technologist alde cost per mammography F Variable cost per mammography G Monthly maintanence H Indirect costs I Desired profit hine per machine a. Solve for monthly volume to break even: Total Variable Volume Cost per Unit Volume Indirect Costs Desired Profit Price Fixed Cost Setup: $0.00 x Volume $0.00 x Volume + $0 $0 $0 $0.00 xVolume +$0 $0 Solution: $0 $0.00 Volume $0.00 x Volume VolumeDIVIO! Break-Even Point Part d. Part a Dollars No. Dollars NoDollars NoDollars No Part b. Part c. Givens: B Equipment cost per month per mac C Intentionally left blank D Technologist cost per mammography E Technologist alde cost per mammography F Variable cost per mammography G Monthly maintanence H Indirect costs I Desired profit hine per machine a. Solve for monthly volume to break even: Total Variable Volume Cost per Unit Volume Indirect Costs Desired Profit Price Fixed Cost Setup: $0.00 x Volume $0.00 x Volume + $0 $0 $0 $0.00 xVolume +$0 $0 Solution: $0 $0.00 Volume $0.00 x Volume VolumeDIVIO

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!