Coal Town ltd are a small book publishing firm based in Salford. The company is considering...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
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
Related Book For
Managerial economics
ISBN: 978-1118041581
7th edition
Authors: william f. samuelson stephen g. marks
Posted Date:
Students also viewed these accounting questions
-
A large, dairy company is considering launching a new brand of yogurt. You are part of the team that is tasked with determining how the product should be marketed, including product features, package...
-
a chain of sandwich shops. The company is considering two possible expansion plans. Plan A would open eight smaller shops at a cost of $ 8,440,000. Expected annual net cash inflows are $ 1,600,000...
-
A firm is considering launching a new product. Launching the product will require an investment of $10 million (including marketing expenses and the costs of new facilities). The launch is risky...
-
March is a month of variable weather in the Northeast. The chart below records the actual high and low temperatures for a selection of days in March from the weather report for Pittsburgh,...
-
What is safety stock? What does safety stock provide safety against?
-
An engine with 200 mm cylinder diameter and 300 mm stroke works on theoretical Diesel cycle. The initial pressure and temperature of air used are 1 bar and 27C. The cut-off is 8% of the stroke....
-
How has the relative importance of the NYSE and LSE changed?
-
Illinois Soybeans operates a processing plant in which soybeans are crushed to create soybean oil and soybean meal. The company purchases soybeans by the bushel (60 pounds). From each bushel, the...
-
A U . S . firm borrowed euros at a variable rate several years ago, but now euro interest rates are rising along with the $ / euro exchange rate. To limit their risk, the firm could use a currency...
-
Gary Hudson was born and raised in Pensacola, Florida. He obtained his bachelors degree in business from Florida State University, where he enrolled in the NROTC (Naval Reserve Officers Training...
-
The net cash flows of project X that Keytech J . S plans to realize are shown in the table below. At the end of the economic life of the project, the scrap value is expected to be TL 2 , 0 0 0 ....
-
The propellers of a small airplane produce a forward thrust of 6.2 x 104 N on the plane which has a mass of 2.8 x 104 kg. The plane is in level flight. a. Draw a labeled force diagram for the...
-
The Sheriff's Department of Polk County Florida, run by Sheriff Grady Judd, has announced the arrest of three deputies for their involvement in evidence tampering. This egregious act did outrage the...
-
Q6 Using the Consumer Transportation Survey data below, develop 95% and 99% prediction intervals as described in parts a through d. a What is the upper limit for a 95% prediction interval for the...
-
9. You Invest $7500/year into a 401K earning 6 %/year Interest. a) How much is your 401K worth after 40 years? b) You are getting close to retiring and you want to collect $40,000/year for 30 years....
-
5. Mr. Brown, who is risk-averse and prefers to have a higher return for a given level of risk, currently invests $ 1 million on financial market. His portfolio includes three assets: Stock Google,...
-
(a) Develop a 1D Patran-Nastran Finite element model to determine the nodal (A, B, C, and D) displacements and element stresses. (b) Develop a 1D Patran-Nastran Finite element model to determine the...
-
1. Which of the four major types of information systems do you think is the most valuable to an organization? 2. How do you critically associate the ideas of business agility and business efficiency...
-
A manager has formulated the following LP problems. Use graphical methods to find the optimal solutions. (In each, all variables are nonnegative.) a. Maximize: 10x + 15y, subject to: 2x + 5y 40 and...
-
Consider the following simplified version of the television game show Lets Make a Deal. There is a grand prize behind one of three curtains; the other two curtains are empty. As a contestant, you get...
-
In the quantity-price contract example in Figure, we noted that the order quantity, Q = 20, is efficient. We can demonstrate that seemingly reasonable contracting methods can lead to inefficient...
-
What is a club good?
-
The market system fails to provide the efficient output of public goods because a. people place no value on public goods. b. private firms cannot restrict the benefits from those goods to consumers...
-
Why does the government provide public goods?
Study smarter with the SolutionInn App