The National Oceanic Research Institute is planning a research study on global warming In Antarctica. The 16-month network schedule is presented below. It is followed by budgets for each activity. Create a time-phased budget for the research project. 0 A O Pelmhary plan 0 3 385 Detal plan 325 0 Task A Preliminary plan B Detail plan C Hire staff D Select equipment E Train F Purchase clothing G Plane transportation H Get custom equipment I Additional equipment J Test equipment K Ship all supplies L Travel Total budget Preliminary plan Detail plan Hire staff Select equipment Train Task Purchase clothing Plane transportation Test equipment Ship all supplies Travel Total budget Global Warming Antarctic Research Project Months.... (5000) 7 Get custom equipment Additional equipment 5 0 C staff 527 7 5D6 0 51 equipment 1 2 5 3 1 5 Global Warming Antarctic Research Project Activity Time Phased Work Packages by Month ($000) Duration Budget 1 2 3 4 11 443 2 7 34 8 8 9 3 3 2 2 1 1 3 6 13 2 15 2 7 F10 0 Purchase clothing 3 10 7 5 3 1 5 1 G9 Pare bransportation 7 E 6 6 H 11 0 Get custom equipment 6 5 11 16 9 3 Toh 12 3 69 9 60 36 6 28 12 9 7 7 16 3 8 8 222 Enter the appropriate values for budget and cumulative budget in the following table. 11 195 7 16 9 3 12 69 36 28 7 16 8 222 10 K 15 sap 0 suppiles 10 5 15 14 J 15 0 equipment 14 1 15 11 14 Addon equipment 11 3 14 9 Global Warming Antarctic Research Project Activity Time-Phased Work pckages by Month ($000) Duration Budget 1 2 3 4 5 6 7 8 8 12 5 7 3 0 1 15 L 16 0 Travel 15 1 16 9 10 11 12 13 14 15 16
The National Oceanic Research Institute is planning a research study on global warming In Antarctica. The 16-month network schedule is presented below. It is followed by budgets for each activity. Create a time-phased budget for the research project. 0 A O Pelmhary plan 0 3 385 Detal plan 325 0 Task A Preliminary plan B Detail plan C Hire staff D Select equipment E Train F Purchase clothing G Plane transportation H Get custom equipment I Additional equipment J Test equipment K Ship all supplies L Travel Total budget Preliminary plan Detail plan Hire staff Select equipment Train Task Purchase clothing Plane transportation Test equipment Ship all supplies Travel Total budget Global Warming Antarctic Research Project Months.... (5000) 7 Get custom equipment Additional equipment 5 0 C staff 527 7 5D6 0 51 equipment 1 2 5 3 1 5 Global Warming Antarctic Research Project Activity Time Phased Work Packages by Month ($000) Duration Budget 1 2 3 4 11 443 2 7 34 8 8 9 3 3 2 2 1 1 3 6 13 2 15 2 7 F10 0 Purchase clothing 3 10 7 5 3 1 5 1 G9 Pare bransportation 7 E 6 6 H 11 0 Get custom equipment 6 5 11 16 9 3 Toh 12 3 69 9 60 36 6 28 12 9 7 7 16 3 8 8 222 Enter the appropriate values for budget and cumulative budget in the following table. 11 195 7 16 9 3 12 69 36 28 7 16 8 222 10 K 15 sap 0 suppiles 10 5 15 14 J 15 0 equipment 14 1 15 11 14 Addon equipment 11 3 14 9 Global Warming Antarctic Research Project Activity Time-Phased Work pckages by Month ($000) Duration Budget 1 2 3 4 5 6 7 8 8 12 5 7 3 0 1 15 L 16 0 Travel 15 1 16 9 10 11 12 13 14 15 16
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question

Transcribed Image Text:EX8-15 (Algo) The National Oceanic Research Institute is...
The National Oceanic Research Institute is planning a research study on global warming In Antarctica. The 16-month network schedule
is presented below. It is followed by budgets for each activity. Create a time-phased budget for the research project.
0
0
0
A 3
Preliminary
plan
3 3
3 B 5
0
3
Task
A Preliminary plan
B Detail plan
Detall
plan
2 5
C Hire staff
D Select equipment
E Train
F Purchase clothing
G Plane transportation
H Get custom equipment
I Additional equipment
Test equipment
K Ship all supplies.
L Travel
Total budget
Task
Preliminary plan
Detail plan
Hire staff
Select equipment
Train
Test equipment
Ship all supplies
Travel
Total budget
Global Warming Antarctic Research Project
Months.... ($000)
Purchase clothing
Plane transportation
Get custom equipment
Additional equipment
5
0
5
C 7
Hiro
staff
2 7
5
0
D 6
Select
equipment
5 1 6
2
2
1
1
3
2
5
3
1
5
1
7 G 9
6
Plane
transportation
13 2 15
7
0
7
7
6
13
Global Warming Antarctic Research Project
Activity Time Phased Work Packages by Month ($000)
Duration Budget 1 2 3
3
4 4 3
3 4
8 8
3
2
2
1
1
3
2
5
3
1
5
1
11
7
16
9
3
6
H 11
O Get custom
equipment
o
6 5 11
16
8
222
F 10
Purchase
clothing
3 10
9
3
12
3
8
69 9 68
36 6
5
28 12
7
7
3 3
8
E
11
Tal
7
16
9
3
8
12
69
36
28
7
16
8
1 14
222
10 K 15
Ship
0
suppiles
10 5 15
11 14
I
Additional
0
equipment
11 3 14
9
14
J 15
0
Test
equipment
14 1 15
8
7
Enter the appropriate values for budget and cumulative budget in the following table.
4 5
12
5
1 9
Global Warming Antarctic Research Project
Activity Time-Phased Work pckages by Month ($000)
Duration Budget 1 2 3 4 5 6 7 8
9
15
0 Travel
15
L 16
1 16
10
11
12 13 14 15 16
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.