Purchase Solution

Forecasting: 34. Apperson and Fitz - Develop a liner regression model

Not what you're looking for?

Ask Custom Question

34. Apperson and Fitz is a chain of clothing stores that caters to high school and college students. It publishes a quarterly catalog and operates a Web site that features provocatively attired males and females. The Web site is very expensive to maintain, and company executives are not sure whether the number of hits at the site relate to sales (i.e., people may be looking at the site's pictures only). The Web master has accumulated the following data for hits per month and orders placed at the Web site for the past 20 months:

Month Hits (1,000s) Orders (1,000s)
1 34.2 7.6
2 28.5 6.3
3 36.7 8.9
4 42.3 5.7
5 25.8 5.9
6 52.3 6.3
7 35.2 7.2
8 27.9 4.1
9 31.4 3.7
10 29.4 5.9
11 46.7 10.8
12 43.5 8.7
13 52.6 9.3
14 61.8 6.5
15 37.3 4.8
16 28.9 3.1
17 26.4 6.2
18 39.4 5.9
19 44.7 7.2
20 46.3 5.5

Develop a liner regression model for these data and indicate whether there appears to be a strong relationship between Web site hits and orders. What would be the forecast for orders with 50,000 hits per month?

26. The Steak and Chop Butcher Shop purchases steak from a local meatpacking house. The meat is purchased on Monday at $2.00 per pound, and the shop sells the steak for $3.00 per pound. Any steak left over at the end of the week is sold to a local zoo for $.50 per pound. The possible demands for steak and the probability of each are shown in the following table:

Demand (lb.) Probability
20 .10
21 .20
22 .30
23 .30
24 .10
___________
1.00

The shop must decide how much steak to order in a week. Using Excel, construct a payoff table for this decision situation and determine the amount of steak that should be ordered, using expected value.

Purchase this Solution

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.