Glorious Accounting Information Analysts are a group of consultants who have been hired to advice a client who runs a manufacturing business which makes plastic containers for salads. You are hired to analyse the basic information as to what drives overheads.

Your assistant has gathered thirty months of data for production runs, machine hours and overhead costs for each month. Machine hours is the number of hours the machine runs for a month. Overhead is the total amount of indirect costs for the client factory

Production runs is the number of times the machine runs (starting, warming up, and shutting down).

Your assistant then runs two models:

Model 1: Overhead is the dependent variable and Machine Hours is the independent variable.

Model 2. Overhead cost is the dependent variable. There are TWO independent variables Machine Hours and Production runs

Required:

Write the equation for model 1. Use the equation in for Model 1 to estimate overhead if 1,850 machine hours are worked.

If the actual cost is $91,000, is this business losing control given the t value is 2.04 for 28 degrees of freedom at 95% confidence,

Write the equation for Model 2. What is the estimated overhead for 1,800 machine hours are worked and 50 production runs;

What is the confidence range for the cost per machine hour and the cost for production run for 95% where t = 2.04 for 28 degrees of freedom. Comment on this range for cost per production run as well as cost per machine hours

Model 1

Regression Statistics
Multiple R	0.860935717
R Square	0.74121031	74%
Adjusted R Square	0.731967821
Standard Error	5003.125148
Observations	30
ANOVA
	df	SS	MS	F	Significance F
Regression	1	2007406122	2007406122	80.19596	0.0001
Residual	28	700875314.8	25031261.24
	Coefficients	Standard Error	t Stat	P-value
Fixed cost	27901.22754	4828.568	5.778365	0.001	100.00%
Machine Hours variable cost	29.13414697	3.253315	8.95522	0.001

Then your assistant runs a second model (multiple regression) where overhead cost is the dependent variable. The independent variables are Machine Hours and Production runs

Model 2.