An author just signed a lucrative contract with a publisher that offers to pay her the amount
Fantastic news! We've Found the answer you've been seeking!
Question:
An author just signed a lucrative contract with a publisher that offers to pay her the amount of $800 at the end of year 9 when the book is scheduled to be released. The author, being profligate, desires to receive a different package: an immediate payment of $100 that is followed by an annuity (an equal amount) to be paid at the end of each year for 9 consecutive years. What annuity will make his package equivalent to the publisher's advance. Use an interest rate is 6%.
Transcribed Image Text:
In this assignment, you will use Excel's "what if" capabilities to help Lifetime Fitness's marketing management decide how to conduct an effective marketing campaign. The question is: What mix of media should be used to maximize the net income? The decision variables are the numbers of ads spots for each type of media. You will perform three exercises in this assignment: 1. What if analysis. Change the number of ads manually and observe the changes in total cost and net income. Note that there are constraints on the variables. Your inputs must be valid. Find out the net income resulting from each strategy suggested by Lifetime Fitness Center. 2. Optimization: Use Excel Solver add-in to find the optimal solution for this problem. 3. Goal seeking: Given that the company wants to achieve $400,000 net income, what should be the input values? Create an answer worksheet in which you list the answers to the three problems above. Document your analysis in a business memo addressed to Ellen Goldstain, VP of Marketing at LFC. Note that you need to submit both this Excel file with Excel Solver setup and the memo. DSS for Marketing Mix Strategies (Enter number of ads in column D) Inputs: Results: Number of ads(spots) placed: $ Sunday Paper Radio Spots Infomercial $ Internet Portal Total 55552 20 Inputs Valid? Total Costs: Net Income Yes 115,200.00 59,360.00 Maximum Audiences: Sunday Paper Radio Spots Infomercial Internet Portal %% Actually see the ad: Sunday Paper Radio Spots Infomercial Internet Portal %% Effective Exposure: Sunday Paper Radio Spots Infomercial Internet Portal %% Actually ACT on exposure: Sunday Paper Radio Spots Infomercial Internet Portal Cost of placing one ad/spot: Sunday Paper Radio Spots Infomercial Internet Portal Cost of developing ads/spots: Sunday Paper Radio Spots Infomercial Internet Portal Minimum Number of ad/spots: Sunday Paper Radio Spots Infomercial Internet Portal Maximum Number of ad/spots: Sunday Paper Radio Spots Infomercial Internet Portal Overlap Constant Value of a one year sign-up Max number of all ads 30% 100,000 10,000 100,000 25,000 50% 30% 1% 10% 3% 20% 20% 10% 1% 5% 5% 10% $1,000 $2,000 $3,000 $7,500 $200 $500 $5,000 $2,000 5555 52 52 25 30 10000 $500 90 Number of Signups Sunday paper Radio spots Infomercial Internet portal Overlap factor Are Inputs Valid? Income Statement Revenue: Sunday paper Radio spots Infomercial Internet portal Total Costs: Cost of placing ads/spots: Sunday paper Radio spots Infomercial Internet portal Overlap cost Cost of developing ads/spots $ Total costs Pre-tax revenue Income tax expense Net income $ SSSSSS $ $ $ $ 5,000.00 10,000.00 15,000.00 37,500.00 40,000.00 7,700.00 $ $ $ $ $ LA LA LA LA LA 5555 $ $ $ $ 75 150 50 125 4 Yes 37,500.00 75,000.00 25,000.00 62,500.00 200,000.00 115,200.00 84,800.00 25,440.00 59,360.00 In this assignment, you will use Excel's "what if" capabilities to help Lifetime Fitness's marketing management decide how to conduct an effective marketing campaign. The question is: What mix of media should be used to maximize the net income? The decision variables are the numbers of ads spots for each type of media. You will perform three exercises in this assignment: 1. What if analysis. Change the number of ads manually and observe the changes in total cost and net income. Note that there are constraints on the variables. Your inputs must be valid. Find out the net income resulting from each strategy suggested by Lifetime Fitness Center. 2. Optimization: Use Excel Solver add-in to find the optimal solution for this problem. 3. Goal seeking: Given that the company wants to achieve $400,000 net income, what should be the input values? Create an answer worksheet in which you list the answers to the three problems above. Document your analysis in a business memo addressed to Ellen Goldstain, VP of Marketing at LFC. Note that you need to submit both this Excel file with Excel Solver setup and the memo. DSS for Marketing Mix Strategies (Enter number of ads in column D) Inputs: Results: Number of ads(spots) placed: $ Sunday Paper Radio Spots Infomercial $ Internet Portal Total 55552 20 Inputs Valid? Total Costs: Net Income Yes 115,200.00 59,360.00 Maximum Audiences: Sunday Paper Radio Spots Infomercial Internet Portal %% Actually see the ad: Sunday Paper Radio Spots Infomercial Internet Portal %% Effective Exposure: Sunday Paper Radio Spots Infomercial Internet Portal %% Actually ACT on exposure: Sunday Paper Radio Spots Infomercial Internet Portal Cost of placing one ad/spot: Sunday Paper Radio Spots Infomercial Internet Portal Cost of developing ads/spots: Sunday Paper Radio Spots Infomercial Internet Portal Minimum Number of ad/spots: Sunday Paper Radio Spots Infomercial Internet Portal Maximum Number of ad/spots: Sunday Paper Radio Spots Infomercial Internet Portal Overlap Constant Value of a one year sign-up Max number of all ads 30% 100,000 10,000 100,000 25,000 50% 30% 1% 10% 3% 20% 20% 10% 1% 5% 5% 10% $1,000 $2,000 $3,000 $7,500 $200 $500 $5,000 $2,000 5555 52 52 25 30 10000 $500 90 Number of Signups Sunday paper Radio spots Infomercial Internet portal Overlap factor Are Inputs Valid? Income Statement Revenue: Sunday paper Radio spots Infomercial Internet portal Total Costs: Cost of placing ads/spots: Sunday paper Radio spots Infomercial Internet portal Overlap cost Cost of developing ads/spots $ Total costs Pre-tax revenue Income tax expense Net income $ SSSSSS $ $ $ $ 5,000.00 10,000.00 15,000.00 37,500.00 40,000.00 7,700.00 $ $ $ $ $ LA LA LA LA LA 5555 $ $ $ $ 75 150 50 125 4 Yes 37,500.00 75,000.00 25,000.00 62,500.00 200,000.00 115,200.00 84,800.00 25,440.00 59,360.00
Expert Answer:
Answer rating: 100% (QA)
To calculate the value of annuity we first need to calculate the present value of 800 recei... View the full answer
Related Book For
Posted Date:
Students also viewed these organizational behavior questions
-
This task requires you to apply your knowledge to the start-up business you will establish as part of your final business plan. Part A enables you to prepare budgets for a business in Australia. ...
-
Use the Price-earnings Ratio and the DuPont Model to perform an equity analysis for The ABC firm for the years 2012 and 2013. The following financial information is available for your use: Revenue:...
-
In this assignment you will use the Income Statement and Balance Sheet information of Triple B Company to meet the following requirements: Part 1: Use the worksheet titled Horizontal Analysis to...
-
The following report was prepared for evaluating the performance of the plant manager of Miss-Take Inc. Evaluate and correct thisreport. Miss-Take Inc. Manufacturing Costs For the Quarter Ended March...
-
The records of Parker Company indicate a July 31 cash balance of $10,400, which includes undeposited receipts for July 30 and 31. The cash balance on the bank statement as of July 31 is $10,575. This...
-
The Durham Insurance Company sells a five-year term insurance policy with face value of $100,000 to a 47-year-old man for a monthly premium of $63. The mortality table is given below. d. What is the...
-
Why is it necessary to sometimes redact portions of a document that is produced to the opposing side?
-
Seeing Double Corporation purchase land for $510,000. Later in the year, the company sold land with a book value of $217,500 for $165,000. How are the effects of these transactions reported on the...
-
a) If your savings account earns 6% per annum, compounded annually, how much do you have in your account at the end of 10 years if you deposit $10,000 per year into the account? b) How much will you...
-
You, CA, are the audit senior of Ball Construction Corporation (BC), a small public company. It is September 19, 2013, and the year-end audit fieldwork has just been completed. The audit partner,...
-
1) The principal-agent problem would not occur if ________ of a firm had complete information about actions of the _____. A) Owners; customers B) Owners; managers C) Managers; customers D) Managers;...
-
Design a linear-time algorithm to sort an array of Comparable objects that is known to have at most two distinct values. Hint: Maintain two pointers, one starting at the left end and moving right,...
-
Given a list of web pages, create a symbol table of words contained in those web pages. Associate with each word a list of web pages in which that word appears. Write a program that reads in a list...
-
A double-ended queue or deque (pronounced "deck") is a collection that is a combination of a stack and a queue. Write a class Deque that uses a linked list to implement the following API: public...
-
Show how to implement a queue using two stacks. Hint: If you push items onto a stack and then pop them all, they appear in reverse order. Repeating the process puts them back in FIFO order.
-
Use statistical sampling to estimate the average path length and clustering coefficient of a graph. For example, to estimate the clustering coefficient, pick trials random vertices and compute the...
-
The payroll register includes sections for recording: A. gross pay, deductions, and net pay. B. marital status, number of years of employment, job title, and gross pay. C. employee home address and...
-
XYZ Inc. a calendar year, accrual basis corporation, had the following items during 2021: Gross revenue from operations Cost of goods sold $420,000 ($180,000) $9,000 LT capital gain .LT capital...
-
One argument for giving discretion to central bankers is that sometimes emergencies come along that a simple rule cant solve. Suppose theres a massive, permanent negative shock to velocity....
-
a. The average person doesnt like working the night shift. According to the theory of compensating differentials, are night shift wages probably higher or lower than day shift wages? b. Most...
-
When the cause of death is suicide, life insurance policies typically pay out only when the suicide occurred after an exclusionary period has passed, usually around a year after purchasing the life...
-
Typically most large scale commercial developments require an environmental impact assessment to be undertaken as part of the planning process. While more a regulatory requirement, such an assessment...
-
Use the data presented in 12.13. The probability of the monthly contribution from the new product exceeding 13 500 is: (a) 24.5% (b) 30.5% (c) 63.0% (d) 92.5% 12.13: A company expects to sell 1000...
-
Most businesses will try to minimize risk through a combination of risk assessment, risk management and, where possible, transfer the risk to another party. For businesses, risks like theft, fire...
Study smarter with the SolutionInn App