The president of a small manufacturing firm

Assignment Help Operation Management

Reference no: EM1381913

The president of a small manufacturing firm is concerned about the continual growth in manufacturing costs in the past several years. The data series of the cost per unit for the firm's leading product over the past eight years are given as follows:
Year Cost/Unit ($)
1 20
2 24.5
3 28.2
4 27.5
5 26.6
6 30
7 31
8 36

a) Use EXCEL's regression function to develop a simple linear regression model (i.e., write out the equation Y= intercept + slope*year) for these data. What is the average cost increase per year that the firm has been realizing?

b) What is the forecast for year 9?

c) What is MAPE?

Reference no: EM1381913

Questions Cloud

Determining phenomenon of reverse snobbery : What are we to make of the phenomenon of "reverse snobbery"? Reverse snobs feel they are better than others because they are "down to earth" and don't "put on airs."

Question about cytoskeleton : n a folded protein, most of the nonpolar amino acids are buried inside the protein fold, whereas the polar and charged side chains are exposed to the components in the cytosol.

State of israel-even prior to the establishment of israel : The state of Israel has been engaged with Islamic terrorists since its inception and recognition as a country. However, even prior to the establishment of Israel, Jewish and Arab fighters engaged in acts of violence in British-occupied Palestine. ..

Counselor professional identity : As a counselor, Consider what stands out as especially important to you from Counselor Professional Identity, Function, and Ethics.

The president of a small manufacturing firm : The president of a small manufacturing firm is concerned about the continual growth in manufacturing costs in the past several years. The data series of the cost per unit for the firm's leading product

Sequence to find surface area : If given this in this sequence to find surface area, 1 cm x 2 cm x 2 cm block, am I to assume it is written in LxWxH format?

Comparison of socialism and capitalism : Discuss what would be the best combined features of the economic systems of capitalism and socialism while minimizing the disadvantages of each.

Compute average of values contained in integer : Compute the average (as a double) of values contained in integer variables num1, num2, num3 and allot that average to double variable avg.

Xeroderma pigmentosum : The condition "xeroderma pigmentosum" is characterized by high rates of skin cancers like malignant melanoma. It is caused by mutations in any of many genes that encode enzymes that participate in:

User Account

All Pages