Trying to understand how to put this into Excel... Thanks.

Problem 2-28A Estimating fixed and variable cost using the regression method Dean and Powell Tax Services Company has 31 branch offices in the nation. Each office has about three to six professional accountants and one to two secretaries. In a busy season, the office manager, who is also a professional accountant, can hire temporary employees for support work such as document filing and typing. Norman Dean, the president, is wondering whether he should expand his business by opening more offices. One of the factors that he is considering is how to estimate office support costs. Andrea Jones, the accountant, collected the following cost data for all 31 offices CHECK FIGURES b. VC/hr: $15.19 FC: $1,142 Branch Professional Hours Support Costs Branch Professional Hours Support Costs A1 A2 A4 B1 B2 B3 D1 D2 D3 D4 165 358 471 492 328 359 174 394 386 279 314 225 113 387 $4,241 3,435 6,398 6,502 4140 3,368 3,820 6,396 3,946 8,189 4,506 F2 G1 G2 G3 G4 G5 G6 H1 H2 12 15 $3,856 5,936 8,615 9,639 5,968 7,115 3,287 7,515 7,374 5,376 5,784 258 146 275 364 484 251