How you would allocate budget

Assignment Help Finance Basics
Reference no: EM131306233

Question 1 - Planning and strategic input

Brief:

Company X is a department Store with 100outlets, selling a wide range of household and clothing products. Traditionally they have used Press advertising to drive awareness and footfall.  In store activity has allowed them to develop a database of 250,000 customers. This database is fully marketing permissioned for all email, phone and postal channels.  The store has a no cost loyalty card which it can use to supply customer offers. Average product spend on the card per visit is £70. Gross profit per customer is 20%.  80% of its marketing database have a card and of these, a further 60% are active users.   They currently have approximately 200,000 customers per week over the 100 stores.  Each customer visits the store an average of once a month. They currently have a good direct sell website that can capture enquiries and shoppers and their own email platform.

They have a recruitment budget of £250K to gain new customers using the Loyalty card as the principal campaign hook. They would like to see an integrated campaign to drive new customers into the store over the autumn months.

Requirement - is a short proposal indicating channels/media you would suggest and how you would allocate budget? We want to see which channels would you consider/reject/select and why, and some high level mechanics of the campaign.

Once you have decided upon your campaign structure, please create a top-line budget allocation and calculate Return on Investment for your proposal.  The budget must detail estimates for all aspects of the campaign; Agency, Media and Production costs.

Question 2- Presentation and interpretation of Analysis

a. Below is a cross tab of customer counts based on total spend and year last bought.

Please summarise the learning's to be found within this data and then recommend a communication plan for the customers. All customers are permissioned and have mailing and email addresses available.

 

Up to £2,000

£2k-£4k

£4k-£6k

£6k-£8k

£8k- £10k

£10k- £12.5k

£12.5k- £15k

£15k-£20k

Over £20k

Total

2003

157

214

330

341

296

215

151

125

94

1923

2004

545

1711

1060

680

500

503

428

341

226

5994

2005

995

3500

1731

910

582

508

282

333

282

9123

2006

1201

3322

2124

1148

747

699

509

585

591

10926

2007

547

2653

2210

1377

867

755

506

565

697

10177

2008

1152

2215

1418

936

716

653

346

457

598

8491

2009

894

3149

2170

1103

740

660

429

448

848

10441

20010

563

2632

2433

1375

1004

905

656

786

1313

11667

20011

514

1465

1647

1142

773

830

587

736

1289

8983

Total

6568

20861

15123

9012

6225

5728

3894

4376

5938

77725

Reference no: EM131306233

Questions Cloud

What is the role of the radio layer in bluetooth : What is the actual bandwidth used for communication in a Bluetooth network?
Which will give him the better return : Dave has $20,000 excess cash to invest. He can purchase a $20,000 T-bill for $19,400 or two $10,000 T-bills for $9,600 each. Which will give him the better return?
What is the spread spectrum technique used by bluetooth : What is the modulation technique in the radio layer of Bluetooth? In other words, how are digital data (bits) changed to analog signals (radio waves)?
What will her annualized rate be : Brenda purchased a $30,000, 90-day T-bill for $29,550. What will Brenda's return be when the T-bill matures? What will her annualized rate be?
How you would allocate budget : Requirement - is a short proposal indicating channels/media you would suggest and how you would allocate budget? We want to see which channels would you consider/reject/select and why, and some high level mechanics of the campaign
What mac protocol is used in the baseband layer of bluetooth : In an 802.11, give the value of the address 1 field in each of the following situations (left bit defines To DS and right bit defines From DS).
Which investment will provide a higher return : Which investment will provide a higher return? In addition to return, what else should Thomas consider when making his investment decision?
Draw dc equivalent circuits of this unloaded amplifier : Given a BJT unloaded amplifier shown in figure 1 below with β=100. Draw DC equivalent circuits of this unloaded amplifier. Draw the DC load line of the circuit. Determine the following dc values for the amplifier.
Comment on the ethics of the banker : Comment on the ethics of the banker in not fully discussing all the risks of money market investments.- Is Jason correct in his thinking that he can find a totally risk-free investment?

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money 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