Solution-Shows the marketing expenditure and corresponding

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?

User Account

All Pages

Shows the marketing expenditure and corresponding sales

Reference no: EM13537411

Reference no: EM13537411

Questions Cloud

Reviews

Write a Review

Project Management Questions & Answers

Create a project schedule and align resources

Managerial roles and gap analysis

Questionaire on project management

Describe the market growth rate for product

Prepare a work plan and project schedule - gantt chart

Project risk management approach

Black-scholes options pricing model

Describe the features or characteristics of product

Write paper on inventory management system

Analysis of the overall project risk

Investment and performance analysis

Distribution strategy and project management

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT