please provide with solutions

Bailey Nickles, managing director of the Regina Reviewers Company, is examining how overhead costs behave with changes in monthly professional labour-hours billed to clients. Assume the following historical data: (Click the icon to view the data.) Required Requirement 1. Compute the linear cost function, relating total overhead cost to professional labour-hours, using the representative observations of 3,000 and 5,500 hours. Plot the linear cost function. Does the constant component of the cost function represent the fixed overhead costs of the Regina Reviewers Company? Why? Select the labels for the cost function using the representative observations of 3,000 and 5,500 hours. Historical data Required 1. Compute the linear cost function, relating total overhead cost to professional labour-hours, using the representative observations of 3,000 and 5,500 hours. Plot the linear cost function. Does the constant component of the cost function represent the fixed overhead costs of the Regina Reviewers Company? Why? 2. What would be the predicted total overhead costs for (a) 4,000 hours and (b) 6,500 hours using the cost function estimated in requirement 1 ? Plot the predicted costs and actual costs for 4,000 and 6,500 hours. 3. Nickles had a chance to accept a special job that would have boosted professional labour-hours from 3,000 to 4,000 hours. Suppose Nickles, guided by the linear cost function, rejected this job because it would have brought a total increase in contribution margin of $39,000, before deducting the predicted increase in total overhead cost, $44,000. What is the actual total contribution margin forgone? Bailey Nickles, managing director of the Regina Reviewers Company, is examining how overhead costs behave with changes in monthly professional labour-hours billed to clients. Assume the following historical data: (Click the icon to view the data.) Required Requirement 1. Compute the linear cost function, relating total overhead cost to professional labour-hours, using the representative observations of 3,000 and 5,500 hours. Plot the linear cost function. Does the constant component of the cost function represent the fixed overhead costs of the Regina Reviewers Company? Why? Select the labels for the cost function using the representative observations of 3,000 and 5,500 hours. Historical data Required 1. Compute the linear cost function, relating total overhead cost to professional labour-hours, using the representative observations of 3,000 and 5,500 hours. Plot the linear cost function. Does the constant component of the cost function represent the fixed overhead costs of the Regina Reviewers Company? Why? 2. What would be the predicted total overhead costs for (a) 4,000 hours and (b) 6,500 hours using the cost function estimated in requirement 1 ? Plot the predicted costs and actual costs for 4,000 and 6,500 hours. 3. Nickles had a chance to accept a special job that would have boosted professional labour-hours from 3,000 to 4,000 hours. Suppose Nickles, guided by the linear cost function, rejected this job because it would have brought a total increase in contribution margin of $39,000, before deducting the predicted increase in total overhead cost, $44,000. What is the actual total contribution margin forgone