problem
coolstudent1
project_1_problem.docxProject 1 Problem
For this project you can use EXCEL for calculations and then cut and paste into Word document.
|
|
MIAMI CAFÉ |
|
|
|
Year |
Miami Café Sales |
|
Payroll |
|
2010 |
$ 2,000.00 |
|
$ 120.00 |
|
2011 |
$ 3,000.00 |
|
$ 350.00 |
|
2012 |
$ 2,500.00 |
|
$ 400.00 |
|
2013 |
$ 2,250.00 |
|
$ 225.00 |
|
2014 |
$ 2,300.00 |
|
$ 115.00 |
a. Plot data to determine whether there is a straight- line (linear) relationship.
b. Using Microsoft Excel determine estimated regression equation (please show all necessary steps tin detail in order get to regression equation)
c. If management predicts that Miami Cafe's payroll next year will be $625, what will be the estimated sales?
d. Calculate standard error of the estimate (show all your work)
e. Calculate the coefficient of correlation (show your work)
Project 2 Problem:
A partially solved PERT problem is detailed in the table below. Times are given in weeks. You need to show your work!
|
Activity |
Preceding |
Optimistic Time |
Probable Time |
Pessimistic Time |
Expected Time |
Variance |
|
A |
-- |
7 |
9 |
14 |
|
1.361 |
|
B |
A |
2 |
2 |
8 |
|
1.00 |
|
C |
A |
8 |
12 |
16 |
|
1.778 |
|
D |
A |
3 |
5 |
10 |
|
1.361 |
|
E |
B |
4 |
6 |
8 |
|
0.444 |
|
F |
B |
6 |
8 |
10 |
|
0.444 |
|
G |
C, F |
2 |
3 |
4 |
|
0.111 |
|
H |
D |
2 |
2 |
8 |
|
1.000 |
|
I |
H |
6 |
8 |
16 |
|
2.778 |
|
J |
G, I |
4 |
6 |
14 |
|
2.778 |
|
K |
E, J |
2 |
2 |
5 |
|
0.250 |
a. Calculate the expected time for each activity. Enter these values in the appropriate column in the table above.
b. Which activities form the critical path?
c. What is the estimated time of the critical path?
d. What are the project variance and the project standard deviation?
