RequiredPage 92The 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.Use a spreadsheet program to perform a regression analysis. Use office support costs as the dependent variable (Y) and the professional hours as the independent variable (X). Determine the total fixed cost per office and variable cost per professional hour.Identify the R2 statistic provided by the Excel program and explain what it means.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?Explain how multiple regression analysis could be used to improve the accuracy of the cost estimates. *You will use excel to setup a worksheet with your data and run regression analysis.* Problem 2-28A Estimating fixed and variable cost using the regression methodDean and Powell Tax Services Company has 31 branch offices in the nation. Each office has about three to sixprofessional accountants and one to two secretaries. In a busy season, the office manager, who is also aprofessional 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 CostsA1225$4,241F2165$3,856A21133,435G13585,936АЗ3876,398G24718,615A44126,502G34929,639B12584,140G43285,968B21463,368G53597,115B32753,820G61743,287D13646,396H13947,515D21903,946H23867,374D34848,189122795,376D42514,506153145,784D53776,744J22835,426E12644,645J31984,418E21696,073J42264,506ЕЗ3386,290J53416,488F14379,113

Hello! As you have posted more than 3 sub parts, we are answering the first 3 sub-parts. In case…

Answered: The company uses the number of…

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

Related questions

Question

RequiredPage 92

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.
Use a spreadsheet program to perform a regression analysis. Use office support costs as the dependent variable (Y) and the professional hours as the independent variable (X). Determine the total fixed cost per office and variable cost per professional hour.
Identify the R² statistic provided by the Excel program and explain what it means.
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?
Explain how multiple regression analysis could be used to improve the accuracy of the cost estimates.