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...
icon
Related questions
Question
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.