You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?

You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 133P

See similar textbooks

Similar questions

Please answer this using EXEL AND SOLVER ADD IN. Include and identify decision variables, objective, and constraints. Please also upload what the info in solver you added was!!!! It is summertime and your winter coat factory is trying to decide its production schedule and staffing level for the next season. You are forecasting demand of 5000 coats in October, 8000 coats in November, 8000 coats in December, 12000 coats in January, 12000 coats in February and 9000 coats in March. You want to manufacture these coats at the lowest cost possible during your production window (October-March). The first decision you need to make is how many people to hire. Each employee will cost $2500 a month. You don’t want to hire or fire any employees mid-season in order to minimize disruptions in your factory floor. You can have employees idle if there isn’t sufficient work for them to do. Employees still need to be paid even if they are idle. An employee works 20 business days a month and takes half a…
In a software project a task is scheduled to take 5 days to complete and each of the 5 days are equal. Each day of the 5-day task is scheduled to cost $100. At the end of the 5 days, you determine that only 3 days of the task are complete. A report tells you that he actual cost for the 5 days of effort but only 3 completed days of work was $400. Calculate the values in the following table using the given data of the project : The cost performance index The scheduled variance The schedule performance index At the current rate of progress, the task will complete at about (ETC) The estimated cost at completion (EAC)
A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.
Michael is the marketing executive of SHOPEE and he is planning to launch the 2.2.22 online SALE through price discounts, either 40% off or 20% off. He also learned that SHOPEE closest competitor LAZADA , is planning to promote also a 2.22.22 online SALE with price discounts , either 50% off or 30% off. If SHOPEE launches the 40% off, it will gain nothing. If LAZADA launches the 50% off or gain 8,000,000 if LAZADA launches the 30% off. If SHOPEE launches the 20% off, it will lose 2,000,000 if LAZADA launches the 50% off or lose 5,000,000 if LAZADA launches the 30% off. 1.Which strategy is dominated by SHOPEE depending on strategy of LAZADA? A. 50% OFF B. 40% OFF C. 20% OFF D. 30% OFF E. NONE 2.What should be the strategy of LAZADA? A. 50% OFF B. 40% OFF C. 30% OFF D. 20% OFF
For a table manufacturing company, selling price for a table is $183.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,380.00 per month and insurance is $296.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $254.00 per Unit, Variable cost to $43.00 per Unit, bigger area will have rent $5,235.00 per month and insurance is $362.00 per month At what point will the company be indifferent between the current mode of operation and the new option?
Type the linear program, optimal solution, and objective function value in a word document. Submit your excel file. An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commercial lender. The types of investments, the expected interest per year, and the maximum allowed percentage investment he will consider are shown on the following table. He wants at least 35% of his investments to be in nonmortgage instruments and no more than 60% to be in high-yield (and high-risk) instruments (i.e., expected interest > 8%). How should his investment be diversified to make the most interest income? Investment Expected Return Maximum Allowed Low-income mortgage loans 6.50% 20% Conventional mortgage loans 6.00% 30% Government sponsored mortgage loans 8.25% 25% Bond investments 5.75% 15% Stock investments 8.75% 18% Futures trading 9.25% 10%
A food company is considering three different salad dressings to introduce nationally, Dressing A, B, and C. They also have the option to not introduce any dressing this year. The profits from dressings A, B, and C are $1,144,712, $1,515,938, and $2,525,542 respectively if the national market is favorable. However, if the national market is unfavorable, the losses are $555,615, $758,875, and $912,435 respectively. Historical data shows a probability of 0.568 for a favorable national market. The company can test the market for salad dressings in selected geographic areas before introducing them nationally. The cost of the test market is $53,331. In the past, the probability of a negative test market was 0.354. Given a positive test market, a favorable national market was actually observed with a probability of 0.745. Given a negative test market, a favorable national market was actually observed with a probability of 0.304. Determine if the company should test the market before…
The book isn't in your list. but here's the question: Perry Enterprises is considering a number of investment possibilities. Specifically, each investment under consideration will draw on the capital account during each of its first three years, but in the long run, each is predicted to achieve a positive net present value (NPV). Listed are the investment alternatives, their net present values, and their capital requirements, and all figures are in thousands of dollars. In addition, the amount of capital available to the investments in each of the next three years is predicted to be $9.5 million, $7.5 million, and $8.8 million, respectively. (It shows a chart that I attached in the images) For the model, I am unsure of how the constraints are supposed to be applied. Do I have to purchase the investment for all three years if I choose to invest in that investment or can I choose to only invest in it one or two years? If I invest in it more than one year, do I still only recieve the NPV…
A company is considering a new product launch. There is a 0.6 chance that demand for the product will be strong and a 0.4 chance that demand will be weak. Two strategies for the launch are possible: 1 has high promotion costs and a net cash outflow of K120 000 if demand proves to be strong, and if demand proves weak a net cash outflow of (K30 000) will result. Strategy 2 has low promotion costs and if demand is strong will generate a cash inflow of only K80 000 but with weak demand a net cash inflow of K20 000. Draw a decision tree and advise which course of action generates the greatest expected profit. What is the maximum amount that should be paid for market research to determine with certainty whether demand will be strong or weak?
BIG company can advertize on three different websites-Yahoo, MSN, and Facebook. Cost and exposure of each advertisement on these sites are given below: Website Cost /ad Reach /ad Website Cost /ad Reach /ad Yahoo $5000 12000 MSN $5000 6000 Facebook $2500 10000 BIG needs to make sure they are reaching at least 500,000 viewers through these ads while keeping their cost to the minimum. There are few other things BIG marketing executives need to keep in mind while planning such as BIG needs to have at least two ads on each one of the websites. Moreover, BIG needs to reach at least 100, 000 people through Yahoo and MSN On the other hand, BIG does not want to have more than 200 ads on Facebook and the number of ads on Facebook needs to be at least 5% of the total ads. Solve using MS Excel Solver.
XYZ Co. has provided the following data seeking your advice on the optimum investment strategy: Investment at the beginning of the year Net return data of selected investments Amount P Q R S available (£) 1 95 80 70 60 70 2 75 65 60 50 40 3 70 45 50 40 90 4 60 40 40 30 30 Maximum Investment (£) 40 50 60 60 The following additional information is also provided: o P, Q, R and S represent the selected investments o The company has decided to have four years investment plan o The policy of the company is that the amount invested in any year will remain so until the end of the fourth year o The values in the table represent net returns on investment of £1 till the end of the planning horizon Determine the optimal investment strategy. You may use the transportation technique
The cost data for Evencoat Paint for the year 2019 is as follows: Month Gallons ofPaintProduced EquipmentMaintenanceExpenses January 110,000 $70,700 February 68,000 66,800 March 71,000 67,000 April 77,000 68,100 May 95,000 69,200 June 101,000 70,300 July 125,000 70,400 August 95,000 68,900 September 95,000 69,500 October 89,000 68,600 November 128,000 72,800 December 122,000 71,450 A. Using the high-low method, express the company’s maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Fixed cost $ Variable cost $