Phillips Inc. produces two distinct products, A and B. The products do not compete with each other in the marketplace; that is, neither cost, price, nor demand for one product will impact the demand for the other. Phillips’ analysts have collected data on the effects of advertising on profits. These data suggest that, although higher advertising
where XA and XB are the advertising amount allocated to products A and B, respectively, in thousands of dollars, profit is in millions of dollars, and LN is the natural logarithm function. The advertising budget is $500,000, and management has dictated that at least $50,000 must be allocated to each of the two products.
(Hint: To compute a natural logarithm for the value X in Excel, use the formula = LN(X). For Solver to find an answer, you also need to start with decision variable values greater than 0 in this problem.)
- a. Build an optimization model that will prescribe how Phillips should allocate its marketing budget to maximize profit.
- b. Solve the model you constructed in part (a) using Excel Solver.
Want to see the full answer?
Check out a sample textbook solutionChapter 13 Solutions
Essentials of Business Analytics (MindTap Course List)
- With milk sales sagging of late, The Milk Processor Education Program (MPEP) decided to move on from the famous "Got Milk" ad slogan in favor of a new one, "Milk Life." The new tagline emphasizes milk's nutritional benefits, including its protein content. MPEP began collecting data on the number of gallons of milk households consumed weekly (in millions), weekly price per gallon, and weekly expenditures on milk advertising (in hundreds of dollars) for the period following the launch of the new campaign. These data are available via the link below. Use these data to estimate a linear regression. Suppose that the weekly price of milk is $3.40 per gallon and MPEP decides to ramp up weekly advertising by 35 percent to $150 (in hundreds). Use your regression model to estimate the weekly quantity of milk consumed after this advertising increase. Instructions: Round your intermediate calculations and enter your response rounded to three decimal places. ________ million gallons per weekarrow_forwardAlthough natural gas is currently inexpensive and nuclear power currently (and perhaps deservedly) does not have a good reputation, it is possible that more nuclear power plants will be constructed in the future. Table 4 presents data concerning the construction costs of light water reactor (LWR) nuclear power plants. The dependent variable, C, construction cost, is expressed in millions of dollars, adjusted to a 1976 base. Preliminary analysis of the data and economic theory indicate that variation in cost increases as cost increases. This suggests transforming cost by taking its natural logarithm. S Power plant capacity in MWe N Cumulative number of power plants built by the contractor Build a multiple regression model to predict ln(C) by taking S and N or their natural logarithms as the independent variables. Make sure to check for multicollinearity. Use residual analysis and R2 to check your model. State which variables are important in predicting the cost of constructing an…arrow_forwardThe manager Concerned about her current customer base, manager Andersen started to think of factors that might affect the attractiveness of an auditing firm. Of course, the service quality provided and the fees charged by the auditor seem two important factors. Next, she decides that the reputation of the auditing firm also needs to be included in the framework as an independent variable. As illustrated by the dramatic effects of recent auditing scandals, reputation seems especially important for large auditors (i.e., auditing firms that are large in size). Finally, manager Andersen also thinks that the proximity of the auditing firm to the customer is another variable to be included as an independent variable. Proximity very likely affects the possibility for the client to personally meet with the auditors on a regular basis and she knows from her own contact with customers that they perceive personal interactions as quite important. Consider the above scenario shown; answer the…arrow_forward
- The November 24, 2001, issue of The Economist published economic data for 15 industrialized nations. Included were the percent changes in gross domestic product (GDP), industrial production (IP), consumer prices (CP), and producer prices (PP) from Fall 2000 to Fall 2001, and the unemployment rate in Fall 2001 (UNEMP). An economist wants to construct a model to predict GDP from the other variables. A fit of the model GDP = , + P,IP + 0,UNEMP + f,CP + P,PP + € yields the following output: The regression equation is GDP = 1.19 + 0.17 IP + 0.18 UNEMP + 0.18 CP – 0.18 PP Predictor Coef SE Coef тР Constant 1.18957 0.42180 2.82 0.018 IP 0.17326 0.041962 4.13 0.002 UNEMP 0.17918 0.045895 3.90 0.003 CP 0.17591 0.11365 1.55 0.153 PP -0.18393 0.068808 -2.67 0.023 Predict the percent change in GDP for a country with IP = 0.5, UNEMP = 5.7, CP = 3.0, and PP = 4.1. a. b. If two countries differ in unemployment rate by 1%, by how much would you predict their percent changes in GDP to differ, other…arrow_forwardEconomist A.W. Phillips was one of the first economists to present compelling evidence of the correlation between unemployment and wage inflation. Since wages and salaries are a major input cost for companies, rising wages should lead to higher prices for products and services in an economy, ultimately pushing the overall inflation rate higher. As a result, Phillips graphed the relationship between general price inflation and unemployment, rather than wage inflation. Data on unemployment (independent) and inflation (dependent) from the Federal Reserve is on the Excel workbook. a) Find the equation for the regression line for this data.b) Find the correlation coefficient and R2.c) Using the data, is the correlation statistically significant at the 1% level? please do it in excelarrow_forwardTotal DVD and Blu-ray disc sales in 2009 were $8.72 billion. For the purposes of this problem, you will combine DVD and Blue-ray disk sales into one category of DVD sales. A study by In-Stat predicted that "physical disc sales will decline by $4.7 billion by 2014," and that "streaming, on the other hand, should grow from its current $2.2 billion to $6.3 billion over the same time period (2009–2014) a. What is the slope, including units, of the model for DVD sales? Write a statement interpreting the meaning of the slope in the context of the problem. b. Write an equation that represents the linear model for DVD sales. Let D = the sales of DVDs in billions of dollars, and t = the number of years after 2009. c. What is the slope, including units, of the model for streaming videos?arrow_forward
- Economist A.W. Phillips was one of the first economists to present compelling evidence of the correlation between unemployment and wage inflation. Since wages and salaries are a major input cost for companies, rising wages should lead to higher prices for products and services in an economy, ultimately pushing the overall inflation rate higher. As a result, Phillips graphed the relationship between general price inflation and unemployment, rather than wage inflation. Data on unemployment (independent) and inflation (dependent) from the Federal Reserve is on the Excel workbook. Find the equation for the regression line for this data. Find the correlation coefficient and R2. Using the data, is the correlation statistically significant at the 1% level? Federal Reserve Economic Data https://fred.stlouisfed.org/graph/?g=3obN Observation date Unemployment Rate Inflation Rate 1 1960-01-01 5.2 1.2 2 1961-01-01 6.6 1.6 3 1962-01-01 5.8 0.7 4…arrow_forwardTotal DVD and Blu-ray disc sales in 2009 were $8.72 billion. For the purposes of this problem, you will combine DVD and Blue-ray disk sales into one category of DVD sales. A study by In-Stat predicted that "physical disc sales will decline by $4.7 billion by 2014," and that "streaming, on the other hand, should grow from its current $2.2 billion to $6.3 billion over the same time period (2009–2014). d. Write an equation that represents the linear model for streaming videos. Let S = the total sales of streaming videos in billions of dollars, and t = the number of years after 2009. e. In what year do the models predict streaming video sales to exceed DVD sales?arrow_forwardUsing the actual sales (in units) over the past 15 months, a demand planner at a leading e-commerce firm has forecasted the demand for a popular consumer product as shown below. Forecast 1 and Forecast 2 represent the outputs of two comparative forecasting methods currently used by the sales and marketing, and operations departments of the firm. Month October 22 November 22 December 22 January 23 February 23 March 23 April 23 May 23 June 23 July 23 August 23 September 23 October 23 November 23 December 23 Actual sales (units) 120 000 138 000 172 000 120 000 114 000 98 000 118 000 112 000 132 000 138 000 108 000 126 000 144 000 162 000 189 000 QUESTION 24 Determine the mean absolute deviation of Forecast 1. A 234 290 units a 18 721 units c 19 524 units 22 670 units QUESTION 25 Determine the mean absolute deviation of Forecast 2. A 21 638 units a 35 280 units c. 19 330 units 23 600 units Forecast 1 (units) 133 280 130 620 127 300 121 440 120 750 119 000 121 600 124 900 121 500 122400 126…arrow_forward
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt