Use the Data Given Below to Answer the Following Question(s)

question 16

Essay

Use the data given below to answer the following question(s).
Following is an extract from a firm's database detailing the number of hours spent on the job by employees and their corresponding pay. (Note: Assume a level of significance of 0.05 wherever necessary.) $$\begin{array} { | l | l | } \hline \begin{array} { l } \text { Hours spent } \\\text { on the job }\end{array} & \text { Salary (\$) } \\\hline 4 & 340 \\\hline 12 & 850 \\\hline 7 & 570 \\\hline 5 & 470 \\\hline 11 & 820 \\\hline 8 & 610 \\\hline 9 & 630 \\\hline 13 & 900 \\\hline 10 & 800 \\\hline 6 & 480 \\\hline\end{array}$$
-Construct a scatter diagram and use the Excel Trendline tool to find the best-fitting simple linear regression model.

---

Definitions:

Direct Labor Quantity Variance

This refers to the difference between the actual labor hours worked and the standard labor hours that should have been worked for the actual level of production, multiplied by the standard hourly wage rate.

Direct Labor Cost

The expense incurred by a company for wages, benefits, and other costs for employees who work directly on the manufacturing of products.

Produced

Refers to the quantity of goods or services created by a company during a specific time period.

Predetermined Overhead Rate

A rate calculated before a period begins, used to apply manufacturing overhead costs to products based on a specified activity base.