Solve on Computer using the included excel file

Please see the attached Excel file. The provided MS Excel workbook with the information for Constant Workforce with subcontracting method to be performed.

Before moving ahead $-$ SAVE THE FILE and rename it$.$ Replace the "LASTNAME$-$FIRSTNAME" portion in the file name with your first and last name.

There are $2$ parts to this question $-$ First answer Part A using the excel spreadsheet. Apply the Constant Workforce with subcontracting method. Then enter your answers BEFORE CONTINUING TO PART B$,$ where you will use the excel sheet as well.

PART A

What is the workforce for each quarter of $2015$ :

emp$/$quarter

Total units produced in $2015$: units

Total units subcontracted in $2015$: units

Total Cost for $2015$: $

PART B

Given the cost of Constant Workforce with NO subcontracting is $$175,000,$ what is the break even cost for subcontracting each unit? $