Henderson Designs provides basic interior design services in a small town in the Rocky Mountain area. Lately, the growth in the business has slowed considerably and the managers have been looking at new services that might improve their prospects. The sales manager has suggested that adding some landscape design services would be a nice complement to their existing offerings. The manager put the analysis together and then suddenly quit.

You have been asked to reconstruct the analysis. The last known spreadsheet with the analysis is shown as follows. You recall that, in the last meeting, the sales manager estimated that Henderson would probably have to hire some additional employees to do the extra work. The analysis included an estimate that the new service would add about $$21,780$ to the annual labor costs.

Required:

Complete the below table by filling in the blank cells.

Note: Enter all amounts as positive values.

$\backslash$table$[[$Henderson Designs$],[$Projected Income Statement$],[$For the Year$],[,\backslash$table$[[$Status Quo:$],[$Current$],[$Services$]],\backslash$table$[[\%$ Increase$],[($Decrease$)]],\backslash$table$[[$Alternative:$],[$Enhanced$],[$Services$]],$Difference$],[$Sales revenue,,,,$\%,,472,320,,],[$Costs$],[$Equipment lease,$$,102,400,10,\%,,112,640,,10,240],[$Labor$,,,,\%,,94,380,,],[$Rent$,,,20,\%,,22,200,,],[$Depreciation$,,22,400,5,\%,,,,],[$Utilities$,,57,400,,,,,,],[$Other$,,22,400,,,,,,],[$Total costs,,,,,,,,$],[$Operating profit,$$,97,900,,,,,$$$,25,100]]$