Detailed Instructions: You will use excel to set up a worksheet with financial statements. Be sure to include a header to indicate the assignment you are completing, as described below. Then, in a word document, please provide a header to indicate which assignment you are completing. For example, an appropriate header for your written case would be Module #: Assignment Case Name. Please include your name under the header, Number/letter your response to correspond to the specific question you are answering You will be graded based on following Instructions, critical thinking, well-developed response, clear and concise, and mechanics such as grammar, punctuation, and sentence structure. Please see the enclosed rubric for more details Save your excel and word documents as Module #: Assignment - Case Name and Your Name. It is acceptable to abbreviate the file name. 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. Branch Professional Hours Support Costs Branch Professional Hours Support Costs A1 225 $4,241 F2 165 $3,856 A2 113 3,435 G1 358 5,936 387 6,398 A3 G2 471 8,615 A4 412 6,502 G3 492 9,639 258 4,140 G4 B1 328 5,968 B2 3,368 359 146 G5 7,115 G6 3,820 174 B3 3,287 275 HI 6,396 394 D1 7.515 364 386 D2 7,374 190 H2 3,946 12 279 5,376 D3 484 8,189 314 15 5,784 D4 251 4,506 A2 113 3,435 G1 358 5,936 A3 387 6,398 G2 471 8,615 A4 412 6,502 G3 492 9.639 B1 258 4140 G4 328 5,968 B2 146 3,368 G5 359 7,115 B3 275 3,820 G6 174 3.287 01 364 6,396 H1 394 7,515 D2 190 3.946 H2 386 7,374 D3 484 8.189 12 279 5,376 D4 251 4,506 5,784 15 314 D5 377 6,744 J2 283 5,426 ET 264 4,645 198 J3 4,418 169 E2 226 6,073 J4 4,506 E3 341 338 6,290 J5 6,488 F1 437 9,113 Required Page 92 a. The company uses the number of professional hours as the cost driver for office support costs. Use an algebraic equation to describe how total office support costs can be estimated. b. Use a spreadsheet program to perform a regression analysis. Use office support costs as the dependent variable () and the professional hours as the independent variable (X). Determine the total fixed cost per office and variable cost per professional hour c. Identify the RP statistic provided by the Excel program and explain what it means d. Mr. Dean plans to open a new branch office in a Dallas suburb. He expects that the monthly professional hours will be 3.000. Estimate the total office support cost for Mr. Dean. What portion of the total cost is fixed and what portion is variable? e. Explain how multiple regression analysis could be used to improve the accuracy of the cost estimates