Both correlate to the problem in the 1st photo (b) Known an autoregressive (AR) model with a two-day lag as follows:XAR = 3.7 + 0.9xt-1 +0.1xt-2Use the above AR model to forecast the stock prices of Apple Inc. on November 19, November 20, and (November 21. Note that t represents the number of trading days instead of theactual calendar date. (Hint:calculate the stock price on November 19 first, and then use the estimated stock price of November 19 toforecast the stock price on November 20.)(c) Calculate MAPE for the MA(3), MA(5) and AR(2) model given that the true valueon November 19, 20 and21 are 267.3, 267.8 and 268.6 respectively. Then conclude which model gives the best forecasting resultsbased on MAPE. (NO SPECIFIC ROUNDING RULE) A Problem Set 3-edited – Saved to my MacReviewViewO Tell me处TAaBbCcDAaBbCcDdE AABEAaBbCcDdEeAaBbCcDdEeAaBbCcDdEeAaBbCcDdEeAaBbCcDdEeList ParagraphHeading 1Heading 2TiNormalBody TextNo SpacingTable Paragr..5. Table 1 shows the daily stock price of Apple Inc. (AAPL) in the past few trading days.Table 1. Daily stock prices of Apple Ic.1-4-5-6-7-8-11-12-13-14-15-18-DateNovNovNovNovNovNovNovNovNovNovNovNovStock255.1 256.7 256.4 256.5 259.4 260.1 262.2262264.5 262.6 265.8 265.7PriceSince the stock market closes on weekends, Table 1 only shows stock prices during weekdays. Pleaseanswer the following questions based on the given information.(a) Apply the moving average (MA) model with a three-day lag (g = 3) and a five-day lag (q =5) to forecast%3DApple Inc.'s stock price in the following three trading days (i.e., its stock price on November 19, 20 and 21).(Hint: calculate the stock price on November 19 first, and then use the estimated stock price of November19 to forecast the stock price on November 20.) (ROUND TO ONE DECIMAL)

Answered: (a) Apply the moving average (MA) model…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section7.6: Models For Rating Sports Teams

Problem 28P

See similar textbooks

Similar questions

I need explaination and spreadsheet with formulas and step to step interpretation please.....The attached are first two pages of required assisance and below is the rest of instructions please consider all of them:c. Suppose the CEO says, “Projects 3 and 4 must be undertaken but not both.”Describe the constraint.d. Suppose the CEO says, “Projects 4 cannot be undertaken unless projects 1 and 3also are both undertaken.” Describe the constraints. Hint: You may need to add more than one constraint for this part.3. Multi-product Production Planning. Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows:Department Product 1 Product 2 Product 3A 1.50 3.00 2.00B 2.00 1.00 2.50C 0.25 0.25 0.25During the next production period, the labor-hours…
Please solve using Excel @Risk add-in the question is Textbook Problem from Practical Management Science 6th Edition Chapter 11.4 Problem 30P. In the solution please provided step-by-step excel formulas used. The full Question is attached in the image. Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the company’s mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. Thefollowing data are available:-> If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog.-> If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives.-> If a customer…
I need help with everything, please. Formulate the problem and submit formulation - no need to solve. 1. An investment advisor at Shore Financial Services wants to develop a model that can be used to allocate investment funds among four alternatives: stocks, bonds, mutual funds, and cash. For the coming investment period, the company developed estimates of the annual rate of return and the associated risk for each alternative. Risk is measured using an index between 0 and 1, with higher risk values denoting more volatility and thus more uncertainty. Because cash is held in a money market fund, the annual return is lower, but it carries essentially no risk. The objective is to determine the portion of funds allocated to each investment alternative in order to maximize the total annual return for the portfolio subject to the risk level the client is willing to tolerate. Total risk is the sum of the risk for all investment alternatives. For instance, if 40% of a client’s funds are…
This section contains questions regarding the 2nd part of the Unit 1 with the following topics: 1. Financial Planning2. Savings and budgeting3. Investing 1.Mutual Fund is when an investor directly acquires a claim on a security or property True False 2. The "Rule of 75" is used to determine the number of yearss needed to double the value of your money * True False
Write “True” if the statement is true and write “False” if the statement is false.1. With the emergence of the information era, companies need to create value from theirintangible assets as well as their physical and financial assets.2. The primary purpose of balanced scorecard is to obtain increased operating profits for thecurrent year.3. To achieve success, it is important to set non-financial objectives as well as financial objectives.4. Different value propositions lead to different balanced scorecards.5. A properly constructed balanced scorecard tells the story of a business unit’s strategy.6. Strategy is about selecting the set of activities in which the organization will excel to create asustainable difference in the market.7. The vision and mission statement set the general direction for the organization.8. To create the balanced scorecard, first measures are identified and then translated intoobjectives.9. One valuable measure for the customer perspective of the balanced…
Finally, due to budget constraint, your inititial budget of $100,000 has been reduced to $75,000. SET YOUR CONSTRAINTS, DECIDE WHICH AREAS/TASKS BUDGET TO BE ADJUSTED AND USE EXCEL SOLVER TO CREATE YOUR FINAL BUDGET. Submit your plan and your reasoning behind the decisions and why your plan will make the event a success. Excel spreadsheet must show the distribution of your initial budget of $100,000 and your final budget of $75,000 with the constraints you set. Use the the excel spreadsheet image and show constraints.
Answer the following questions. Make sure to number your answers when you upload your response. Suppose Alphonso’s town raised the price of bus tickets to $2.50 per trip (while the price of burgers stayed at $3.50 and his budget remained $11.50 per week.) Draw Alphonso’s new budget constraint. What happens to the opportunity cost of bus tickets? Suppose Alphonso’s town raises the price of bus tickets from $2.50 to $5 and the price of burgers rises from $3.50 to $7. Why is the opportunity cost of bus tickets unchanged? Suppose Alphonso’s weekly spending money increases from $11.50 to $23. How is his budget constraint affected from all three changes? Explain. Use this information to answer the following 4 questions: Marie has a weekly budget of $24, which she likes to spend on magazines and pies. If the price of a magazine is $4 each, what is the maximum number of magazines she could buy in a week? If the price of a pie is $12, what is the maximum number of pies she could buy in a…
11. For a product mix linear programming problem, we use three materials (A, B and C) to make two products (X and Y) to maximize total profit. The following screenshot is the Answer Report generated by Excel. Given above report, which statement is FALSE? Select one: a. The Material C is used up given the optimal solution. b. The optimal solution is making 5 units of Product X only. c. The Material B is used up given the optimal solution. d. The optimized (maximum) profit is $60
Please only anser part b & show steps to computing the optimal solution using excel solver.
Problem 3: Let L(x, y) be the statement “x loves y”, where the domain for both x and y consists of all people in the world. Use quantifiers to express each of the following statements.1. Everybody loves Jerry.2. Everybody loves somebody.3. There is somebody whom everybody loves.4. Nobody loves everybody.5. There is somebody whom Lydia does not love.6. There is somebody whom no one loves.7. There is exactly one person whom everybody loves.8. There are exactly two people whom Lynn loves.9. Everybody loves himself or herself.10. There is someone who loves no one besides himself or herself.
Using the attached template answer the following question. (Note that the data from P06_40.xlsx is already in the excel sheet) You are given a group of possible investment projects for your company’s capital. For each project, you are given the NPV the project would add to the firm, as well as the cash outflow required by each project during each year. Given the information in the file P06_40.xlsx, determine the investments that maximize the firm’s NPV. The firm has $25 million available during each of the next five years. All numbers are in millions of dollars.
SOLVE STEP BY STEP IN DIGITAL FORMAT A company that manufactures household appliances carries out its strategic planning with its main suppliers of raw materials. To do this, you must make a sales projection for the next month, since the prices you obtain depend on the volume that is manufactured. Historical sales data for the last 12 months of 20XX are given below in millions of dollars. 10.5, 9.4, 8.5, 9.8, 11.1, 9.2, 9.7, 10.3, 7.5, 8.7, 9.0, 9.1. a. Lists the time series components present in the company's sales. b. Forecast the first month of the year 20XY with the moving average technique with k= 2. c. Forecast sales for the first month of the year 20XY using the simple average technique. d. Write the strategies that the appliance manufacturer must implement with suppliers.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS