The two gifts under consideration are an umbrella

Assignment Help Operation Management
Reference no: EM131037544

Please create the spreadsheet and word document for the following.

You work for a public television station. You are running a week-long campaign in an effort to get donations. You run spots (sales pitches for money) and offer promotional gifts. The two gifts under consideration are an umbrella, and a one-year magazine subscription to a popular magazine. If a viewer donates $40 they will get the umbrella, and if they donate $50 they will get the one-year magazine subscription.

The campaign will last for 7 days, and will run for 12 hours each day. You will do one sales pitch each hour and will offer either the umbrella or the magazine subscription, but not both during the same pitch. Each sales pitch can be considered a spot. The pitches will only last about 30 seconds.

One problem is that you much purchase the gifts (umbrellas and magazine subscriptions) in advance. The cost is $20 for each umbrella, and $25 for each magazine subscription. You cannot store leftover umbrellas and must give away every item you buy.

The question for you is how many magazine spots and how many umbrella spots should the station air during the campaign, given the goal of maximizing net income?

Important facts:

Typical audience size during any hour is expected to be 100,000 homes (different homes each hour, but 100,000 on average). Your marketing experts say that 1% of the homeowners will respond positively to an umbrella spot (they will purchase an umbrella) and 1.5% of the homeowners will respond positively to a magazine spot (they will purchase a magazine subscription). For example, if 10 umbrella spots are run, 100,000 people see each spot and you will have 100,000 * 10 * .01 umbrella purchases.

Based on prior campaigns, management knows some viewers who make a donation for a gift will spontaneously donate money again at a later time (not for a gift, but just because they are great people). This gift is $20. Management estimates that 25% of the umbrella recipients will do this, and 15% of the magazine recipients will do this.

Management wants at least 30 spots to be run for each gift.

Management wants to earn as much net income as possible.

How many of each spot should be run?

The first part of your deliverable is the spreadsheet showing how you would maximize net income, given the above situation and constraints. The second part is a word document with your recommendation(s) on how management should proceed. 

When you make your first recommendation, plug that back into the spreadsheet and show how much it increases net income. Include that increase in your recommendation. If it doesn’t increase net income, don’t make that recommendation.

You should be able to plug your recommendation back into your spreadsheet.

Reference no: EM131037544

Questions Cloud

Calculate the exact elasticity of demand : When the price of a deluxe car wash rises from $10.00 to $11.00, the number of daily customers falls from 60 to 48
Formal orientation programmer : Q1) Does the company have an orientation programmer? Q2) If yes how effective is it? Q3) how is formal Orientation programmer conducted? Q4) If you were Navin what would have you done?
Do you know your organizations mission statement : It’s hard to accomplish anything without a plan. Whether you’re coaching a football team, cooking Thanksgiving dinner, or running a small business, you need a strategic plan. Strategic planning is a process that brings to life the mission and vision ..
Which business owes more to creditors : Which business owes more to creditors? In which business has the owner invested more? Which business brought in more revenue? Which business is more profitable?
The two gifts under consideration are an umbrella : You work for a public television station. You are running a week-long campaign in an effort to get donations. You run spots (sales pitches for money) and offer promotional gifts. The two gifts under consideration are an umbrella, and a one-year magaz..
What impact does the change in ppi have on production : what mathematical module can be used to test the hypothesis?
How much cash did the buyer need at closing to pay the fee : A buyer of a $50,000 home has paid $2,000 in earnest money and has a loan commitment for 70 percen of the purchase price. How much more cash does the buyer need to complete the transaction provided there are no other closing costs?
Concept of inventory management : While John Smith considers your recommendations of his company's service-level issues, explain the concept of inventory management as it relates to service operations management. Create an e-mail to him in reference to this topic.
Social class divisions in society are relatively unstable : Leverage opportunities are those areas of service where the business exceeds customer’s expectations but they are not very important. Social class divisions in society are relatively unstable. Industrial buyer behavior differs from consumer behavior ..

Reviews

Write a Review

 

Operation Management Questions & Answers

  What style of leadership is jim using to run the seminar

According to the SLII Model, What style of leadership is Jim using to run the seminar? At what level are the managers? From a leadership perspective, what is Jim doing wrong? What specific changes could Jim implement to improve the seminars?

  Prepare a report for discussion at the management discussing

As the company's Operating Manager prepare a report for discussion at the management discussing calculating the cost of the special order and if the considering the following items.

  Prepare all food items to the proper internal temperature

Your processes are designed to prepare all food items to the proper internal temperature with a desirable external appearance. Which of the following items would you most likely deem as defective?

  Developing retail packaging for a new product

Instructions: Assume you are given the task of developing retail packaging for a new product. The product and package will be produced in a small town in China and then shipped and sold in the United States.

  Determine the critical path for the project

Using the View Network Diagram functionality within MS Project, determine the critical path for this project. In a MS Word document, list the activities that are on the critical path. Considering the risks identified in the risk table below, ident..

  Illustrate what kinds of things would likely requisite

Illustrate what scheduling must she do? Illustrate what things might occur to disrupt schedules also cause hazel to reschedule. Elucidate how important is quality assurance to hazel's business.

  Case study: forecasting at hard rock cafe

Case Study: Forecasting at Hard Rock Café

  What is the difference between a lean and an agile supply ch

What is the difference between a lean and an agile supply chain? Under which circumstances is each an appropriate supply chain approach to pursue

  Assuming that a new battery has just been installed

Assuming that a new battery has just been installed, what is the probability that the battery will FAIL during a 2 hourexam?

  Difference between mission and vision statement

What is the difference between a mission and vision statement. Discuss why mission statements are important in performance improvement and why a solid mission statement (describing your goals) should be in place in the quality of health care manageme..

  Elements of the risk-assessment paradigm

What are the elements of the risk-assessment paradigm? How can these elements be applied in a workplace setting in which an emergency responder is addressing a large spill of trichloroethylene? Describe how risk assessment can be used in industria..

  Determine the optimal quantities of the decision variables

Determine the optimal quantities of the decision variables and which resources are not completely used by your solution? How much of each resource is unused?

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