Shows the marketing expenditure and corresponding sales

Assignment Help Project Management
Reference no: EM13537411

The table below shows the marketing expenditure and corresponding sales figures on a month by month basis for SM Heating Products.

You are asked to produce an analysis of these figures for inclusion in a report to be presented to the board of directors. In doing this you will need to establish trends over the period shown for both expenditure and revenue and determine the relationship between these. This will require the use of statistical analysis tools available in Excel.

You will need to select appropriate trend-lines and relationship functions to bring the data into an understandable form. You must justify your selection.

Finally you should write a summary of the techniqueused in the analysis and critically evaluate your results.

Month

Marketing Expenditure (£000's)

Sales (£000's)

Jul-08

300

530

Aug-08

346

635

Sep-08

834

1000

Oct-08

723

938

Nov-08

130

274

Dec-08

624

793

Jan-09

345

536

Feb-09

768

1450

Mar-09

464

800

Apr-09

624

826

May-09

270

373

Jun-09

389

403

Jul-09

917

1592

Aug-09

836

1632

Sep-09

613

804

Oct-09

741

1064

Nov-09

456

582

Dec-09

246

425

Jan-10

734

903

Feb-10

824

946

Mar-10

234

306

Apr-10

423

623

May-10

682

835

Jun-10

234

352

Table of Results

Reference no: EM13537411

Questions Cloud

Calculate what is the average power : In mid-nineteenth century England horses were often used to pull barges along canals. What is the average power
New millennium thought: perspectives and trends : Download the attached word document (Discussion Chapters 10-11.doc) and read "New Millennium Thought: Perspectives and Trends".
Explain what is the empirical formula of vitamin c : Vitamin C contains 40.92% C, 4.58% H, and 54.5% O by mass. What is the empirical formula of Vitamin C
What is the magnification of the mirror : A convex spherical mirror, whose focal length has a magnitude of18.8cm, is to form an image11.2cm behind the mirror. Where should the object be placed? What is the magnification of the mirror?
Shows the marketing expenditure and corresponding sales : Shows the marketing expenditure and corresponding sales figures on a month by month basis for SM Heating Products.
Explain oxygen gas react and which is the limiting reagent : If 62.0 g of NH3 and 35.0 g of oxygen gas react, which is the limiting reagent.  How much NO2 is produced
Using the concept of sustainable competitive advantage : Using the concept of sustainable competitive advantage
What is the magnitude of the kinetic frictional force : A 68.4-kg skier coasts up a snow-covered hill that makes an angle of 25.5 ° with the horizontal. TWhat is the magnitude of the kinetic frictional force
What is the cyclotron frequency : A cyclotron designed to accelerate protons has a magnetic field of magnitude0.260T over a region of radius2.40m. What is the cyclotron frequency?

Reviews

Write a Review

Project Management Questions & Answers

  Step-by-step answer to cost of capital

The Essentials of corporate finance by Ross Westerfield Jordan 6e Book for my finance class

  Effectiveness of the project manager

Evaluation form after project termination for effectiveness of the project manager

  Importance of enabling skills in project management

Explain in scholarly detail and relate your thoughts on the term "enabling skills" and give a relationship to importance of project management.

  Discuss main factors that influence choice of manufacturing

Example an organization or a product from an industry that you are familiar with, critically discuss the main factors that influence the choice of a manufacturing/service process design.

  Explaining importance ethical and legal responsibilities

Explain the importance ethical and legal responsibilities in the research project.

  Describing project management

The project is moving along with the normal set-backs?nothing major, though, until today. In your regular status meeting with one of your project vendors, the account manager, George, closed your door and told you that you have a problem.

  Relationship of process to organization-s strategic

Describe the relationship of the process to the organization's strategic plan.

  Initial cost of project

When evaluating the expansion option, what value, if any, should Wilbert's assign to this equipment as an initial cost of the project?

  What cycle time would match capacity and demand

What cycle time would match capacity and demand if demand is 133 units a day, there are two shifts of 435 minutes each, and workers are given three half-hour breaks during each shift

  Setting up costs in microsoft project 2000 for project

setting up costs in microsoft project 2000 for project management include costs?microsoft project 2000 has templates

  Describe different ways to develop a wbs and how activity

Describe different ways to develop a WBS and how activity definition and activity sequencing correlate to the project network? Why is slack important to the project manager and what is the difference between free slack and total slack?

  Explaining importance of slack in terms of project schedules

Explain the importance of slack in terms of project schedules. When you are working in MS Project, where can you go to see how much slack is in your project?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd