8. The following information (in AOA format) concerns progress at day 40 of an Internet marketing project. Deter- mine if the project is in control based on time and cost to date. If not, what is the cost overage or underage? Actual % Days Duration Budget Cost Activity Completed 1-2: Contact 10 300 250 100 sites 2–3: Solicit 8 400 450 100 costs 2-4: Design 12 350 380 100 ads 4-3: Evaluate budget 3-5: Shoot 18 405 400 70 ads 5–6: Place 16 450 ads

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
icon
Concept explainers
Question

need the answer using excel. thanks

89, 105; Cost: 92, 88, 93, 98, 85, 100. Compare this project
to the two in Exercise 6.
8. The following information (in AOA format) concerns
progress at day 40 of an Internet marketing project. Deter-
mine if the project is in control based on time and cost to
date. If not, what is the cost overage or underage?
Days
Duration Budget Cost
Actual %
Activity
Completed
1-2: Contact
10
300
250
100
sites
2–3: Solicit
8
400
450
100
costs
2-4: Design
12
350
380
100
ads
4–3: Evaluate
budget
3-5: Shoot
18
405
400
70
ads
5-6: Place
16
450
ads
9. Determine if the following test marketing project at week 6
Transcribed Image Text:89, 105; Cost: 92, 88, 93, 98, 85, 100. Compare this project to the two in Exercise 6. 8. The following information (in AOA format) concerns progress at day 40 of an Internet marketing project. Deter- mine if the project is in control based on time and cost to date. If not, what is the cost overage or underage? Days Duration Budget Cost Actual % Activity Completed 1-2: Contact 10 300 250 100 sites 2–3: Solicit 8 400 450 100 costs 2-4: Design 12 350 380 100 ads 4–3: Evaluate budget 3-5: Shoot 18 405 400 70 ads 5-6: Place 16 450 ads 9. Determine if the following test marketing project at week 6
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Introduction to Business messages
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar 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.