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 21P
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,