Share
Explore BrainMass

Regression Analysis and Control Chart Analysis

1. Quality Control

Eastsound operates round-trip flights between two cities using a fleet of three planes: the Viper, the Tiger, and the Eagle. The budgeted quantity of fuel for each round trip is the average fuel usage, which over the past 12 months has been 150 gallons. Eastsound has set the upper control limit at 180 gallons. The operations manager received the following report for round-trip fuel
Usage for the period by the three planes.

a. Create quality control charts for round-trip fuel usage for each of the three planes for the period. What inferences can you draw from them?

b. Some managers propose that Eastsound present its quality control charts in monetary terms rather than in physical quantities (gallons). What are the advantages and disadvantages of using monetary fuel costs rather than gallons in the quality control charts?

2. Cost behavior when costs are semi variable

Data from the payroll department of Dominguez Company for the past two months follow:

a. Sketch a line describing these costs as a function of the number of employees paid.

b. What is the apparent variable cost per employee paid?

c. The line should indicate that these costs are semi-variable. What is the apparent fixed cost per month of running the payroll department during November and December?

3. Cost Estimation using Regression Analysis:

Milky Chocolates has observed the following overhead costs for the past 12 months:

The results of the regression analysis are:
TC ¬ = $8,781 + ($0.63 X Number of Boxes)

a. Plot the data and the regression line--see sample graph below:

b. Estimate total monthly costs for a month when 10,200 boxes of chocolate are
Produced.

Attachments

Solution Summary

Control chart is used to determine if a process is within statistical control. Also, regression analysis is used to create a total cost function and to determine the total cost based on changing the x variable, fixed cost and variable cost.

$2.19