Question: Davenport Services provides basic marketing and public relations services in a town in the southeast. Lately, the growth in the business has been relatively

Davenport Services provides basic marketing and public relations services in a town in the southeast. Lately, the growth in the business has been relatively flat and the managers have been considering new services that might improve their prospects. The sales manager has suggested that adding some "enhanced" services (more personalized attention to the client, greater media access, and so on) might be the approach to pursue. He put together the analysis and was about to present it when he 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 Davenport would probably have to hire some additional employees to do the extra work. He estimated that would add about $21,795 to the monthly labor costs. Required: Fill in the blank cells. (Enter all amounts as positive values.) Sales revenue Costs Equipment lease Labor Rent Depreciation Other Total costs Operating profit Status Quo: $ DAVENPORT SERVICES Projected Income Statement For the Month % Increase (Decrease) $ Current Services 102,600 22,600 57,600 22,600 98,100 20 % Alternative: Enhanced Services $ 474,180 10 % $ 112,860 30 % 94,445 20 % 22,800 5 % 23,730 Difference $ 10,260 21,795 1,130 25,200
Step by Step Solution
3.44 Rating (147 Votes )
There are 3 Steps involved in it
Status Quo Current services Increase decrease Alternative Enhanced services Diff... View full answer
Get step-by-step solutions from verified subject matter experts
