1. The Tons of Fun Hobby Company general manager knows she can use sales and payroll data to do an estimated regression equation and forecast sales for next year. Her finance director gives her the following data table.
Year
|
Sales (millions)
y
|
Payroll (millions)
x
|
x2
|
xy
|
1
|
3
|
1
|
1
|
3
|
2
|
4
|
1.5
|
4
|
6
|
3
|
4
|
2
|
9
|
8
|
4
|
4.5
|
2.4
|
16
|
10.8
|
5
|
5
|
3
|
25
|
15
|
|
20.5
|
9.9
|
55
|
42.8
|
|
Ey
|
Ex
|
Ex2
|
Exy
|
Define the regression equation she is able to deduce from the table, and calculate her year six sales forecast if Year 6 payroll is $3.1 million
2. Consider the following decision table, which Sally Smith has developed for her firm, Production Enterprises.
|
|
|
|
|
|
Decision
|
|
Probability
|
0.2
|
0.6
|
0.2
|
Alternatives
|
|
|
Low
|
Medium
|
High
|
|
|
|
|
|
|
A
|
|
|
$60
|
$100
|
$85
|
B
|
|
|
$65
|
$75
|
$85
|
C
|
|
|
$80
|
$135
|
$90
|
D
|
|
|
$70
|
$90
|
$50
|
E
|
|
|
$70
|
$85
|
$75
|
Which decision alternative maximizes the expected value of the payoff?
3. The receipts for ZXY's proposed Project A are estimated to be $6,000 in the first year; $4,500 in the second, and $1,500 in the third. Another project on the ZXY docket, Project B, would bring in $4,000 a year over 3 years. Using an interest rate of 6% for both Projects A and B, calculate the net present value (NPV) of these expected receipts for Project A (15 points), and given that forgoing Project A would result in the equivalent of an inflow of $4,000 per year, what should the firm do: go with Project A or avoid the cost and/or look for a more profitable project.