Solve the given model using solver

Assignment Help Operation Management

Reference no: EM13918859

The weekly box office revenues (in $ millions) for Terminator 3 are given here. Use these data in the Bass forecasting model given by equations (8.21) through (8.23) to estimate the parameters p, q, and m. Solve the model using Solver and see whether you can duplicate the results in Table 8.8.

Week 1	*Terminator 3* 72.39
2	37.93
3	17.58
4	9.57
5	5.39
6	3.13
7	1.62
8	0.87
9	0.61
10	0.26
11	0.19
12	0.35

The Bass forecasting model is a good example of a "hard" nonlinear program and the answer you get may be a local optimum that is not nearly as good as the result given in Table 8.8. If you find your results do not match those in Table 8.8, use the Multistart option as described in Appendix 8.2. Use a lower bound of -1 and an upper bound of 1 on both p and q. Use a lower bound of 100 and an upper bound of 1000 on m.

Text Book: An Introduction to Management Science: Quantitative Approaches to Decision. By David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Camm, James Cochran.

Reference no: EM13918859

Questions Cloud

Farey fractions of level one : Write a program that for a number n entered by the user creates-by constantly extending it-a linked list of fractions at level n and then displays them.

Consider the production cost information : Consider the production cost information for Mama Italiano Sauce given below: Mama Italiano Sauce Production Cost Budget April 2008 Production - Jars of sauce 20,000 Ingredient cost (variable) $16,000 Labor cost (variable) 9,000 Rent (fixed) 4,000 De..

Brief overview of the health care organization : Provide a brief overview of the health care organization that you have selected for your Senior Project including a summary of the challenges and/or opportunities impacting the balance between health care costs, quality, and access to services tha..

Consider two projects with the cash flows : Consider two projects with the following cash flows: Project S is a 4 year project with initial (time 0) cash outflow of 3000 and time 1 through 4 cash inflows of 1500, 1200, 800 and 300 respectively. Project L is a 4 year project with initial (time ..

Solve the given model using solver : Use these data in the Bass forecasting model given by equations (8.21) through (8.23) to estimate the parameters p, q, and m. Solve the model using Solver and see whether you can duplicate the results in Table 8.8.

Yield to maturity-coupon bond : 7.05 percent coupon bond with 20 years left to maturity is priced to offer a 6.3 percent yield to maturity. You believe that in one year, the yield to maturity will be 7.0 percent.

Sales analysis of a product : The sales analysis of a product revealed that profits were highest when it was initially introduced into the market with a high selling price. However, the price was gradually reduced as it started facing competition as substitutes entered the mar..

What is the buzz on smart grids : What's the Buzz on Smart Grids? Collaboration and Innovation at Procter & Gamble, How Much Do Credit Card Companies Know About You'?

Write a proposal for a design of a new technological system : Designing Media Project: You will write a proposal for a design of a new technological system, or new application of an old system. The proposal will describe the system, and the reason for the system

User Account

All Pages