Coal Town ltd are a small book publishing firm based in Salford. The company is considering...

Transcribed Image Text:

Coal Town ltd are a small book publishing firm based in Salford. The company is considering launching a new imprint - Ghost Town specialising in ghost and horror stories. The outcome of the project depends on the marketing campaign the firm is planning. There is a 65% probability that the campaign is effective, and a 35% probability that it will not be effective. An effective marketing campaign will generate a cash flow of £500,000, whilst a 'failed' marketing campaign will result in a negative cash flow of (£100,000). A firm called Delph ltd. claim they can predict the success or failure of the marketing campaign. Delph ltd for the forecast require a fee of £50,000. When the Market Right ltd forecast says it is an effective marketing campaign, they are correct 95% of the time. A forecast of a 'failing' marketing campaign is correct 90% of the time. Delph have some data from previous firm involvement (anonymised for confidentiality) below. The same Delph predication variables apply: success 95% and failure 90%. Marketing fee Cash flow high low Percentage success failure Firm A 45 000 350000 (50000) 60% 40% Firm B 60 000 Firm C 95 000 750000 965000 (125000) (175000) 70% 30% 55% 45% Firm D 50 000 Firm E 75 000 65% 35% Firm F 55 000 575000 805000 620000 795000 (110000) (140000) (90000) (130000) 50% 50% Firm G 80 000 80% 20% 75% 25% REQUIRED: Should the business pay the fee to Delph ltd for a marketing forecast? Show all workings and cell functions using excel. a) b) Use Excel and create a spreadsheet to calculate the benefits/costs of Delphs advice to firms using the data in the table. Use and show formula in working out the results. Comment on the data and spreadsheet. Coal Town ltd are a small book publishing firm based in Salford. The company is considering launching a new imprint - Ghost Town specialising in ghost and horror stories. The outcome of the project depends on the marketing campaign the firm is planning. There is a 65% probability that the campaign is effective, and a 35% probability that it will not be effective. An effective marketing campaign will generate a cash flow of £500,000, whilst a 'failed' marketing campaign will result in a negative cash flow of (£100,000). A firm called Delph ltd. claim they can predict the success or failure of the marketing campaign. Delph ltd for the forecast require a fee of £50,000. When the Market Right ltd forecast says it is an effective marketing campaign, they are correct 95% of the time. A forecast of a 'failing' marketing campaign is correct 90% of the time. Delph have some data from previous firm involvement (anonymised for confidentiality) below. The same Delph predication variables apply: success 95% and failure 90%. Marketing fee Cash flow high low Percentage success failure Firm A 45 000 350000 (50000) 60% 40% Firm B 60 000 Firm C 95 000 750000 965000 (125000) (175000) 70% 30% 55% 45% Firm D 50 000 Firm E 75 000 65% 35% Firm F 55 000 575000 805000 620000 795000 (110000) (140000) (90000) (130000) 50% 50% Firm G 80 000 80% 20% 75% 25% REQUIRED: Should the business pay the fee to Delph ltd for a marketing forecast? Show all workings and cell functions using excel. a) b) Use Excel and create a spreadsheet to calculate the benefits/costs of Delphs advice to firms using the data in the table. Use and show formula in working out the results. Comment on the data and spreadsheet.

Answer rating: 100% (QA)

a Should the business pay the fee to Delph Itd for a marketing forecast Show all workings and cell functions using excel To determine whether the business should pay the fee to Delph Itd for a marketi... View the full answer