Please open this spreadsheet and compute: (1) The number of units needed to be sold in order to attain $100,000 in net income. (2) The number of units needed to be sold in order to break even. Please submit your response as a spreadsheet. If possible, please leave any formulas intact so that I can review them.

Show work on excel spreadsheet.

F G H I 2 Acme Medical Supply desires a target operating income amount of $100,000 with the assumptions listed below. 3 4 Assumptions: Desired (target) operating income amount: Unit price for sales: Variable cost per unit: Total fixed cost: 9 $ 100,000 $ 80 $ 60 $ 60,000 10 11 Calculate the required revenue to achieve the target operating income: 12 13 Complete the Contribution Income Statement to prove the totals: 14 Revenue: $ 640,000.00 Variable cost: $ 480,000.00 Contribution margin: Fixed costs: $ $ 160,000.00 60,000.00 Target operating income: $ 100,000.00 Number of unites needed: 640,000