Consider the following time series data.Week12346Value191416111814a. Construct a time series plot.1Time Series Value20104Week2Time SeriesValue20-104WeekTime SeriesValue TimeSeriesValue-20F10245Week- Select your answer - vWhat type of pattern exists in the data?- Select your answer - vb. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 7 (to 2 decimals if necessary).MSEThe forecast for week 7c. Use a = 0.2 to compute the exponential smoothing forecasts for the time series. Compute MSE and a forecast for week 7 (to 2 decimals).MSEThe forecast for week 7d. Compare the three-week moving average approach with the exponential smoothing approach using a = 0.2 Which appears to provide more accurate forecasts based onMSE? Explain.The three-week moving average provides aSelect your answer - v forecast than the exponential smoothing approach since it has aSelect your answer - v MSE.e. Use a smoothing constant of a = 0.4 to compute the exponential smoothing forecasts. Compute MSE (to 2 decimals).Does a smoothing constant of 0.2 or 0.4 appear to provide more accurate forecasts based on MSE? Explain.The exponential smoothing forecast using a = 0.4 provides aSelect your answer - v forecast than the exponential smoothing forecast using a = 0.2 since it has a- Select your answer - v MSE.

1) plot 1 horizontal b) Time period Actual Value(A) Moving avg. Forecast(F) Forecast error…

Answered: Week 1 2 3 4 5 6 Value 19 14 16 11 18…

Week 1 2 3 4 5 6 Value 19 14 16 11 18 14 . Construct a time series plot. Time Series Value 20 F10 4 5 Week Time Series Value 20 F10 4 Week

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

b. Based on this extrapolation, when would Amazon be predicted to equal Walmart in revenue?c. Why has Amazon been growing faster than Walmart? Is the slow growth of Walmart related to the rapid growth of Amazon?
Costs Previous quarter's output Beginning inventory Stockout cost for backorders Inventory holding cost 1,500 units O units $50 per unit $10 per unit for every unit held at the end of the quarter $40 per unit $80 per unit $30 per unit $15 extra per unit Not available Hiring workers Layoff workers Unit cost Overtime Subcontracting a) Use Chase Demand Strategy b) Use Level Production Strategy with Backordering
please answerthis question in 20 minutws. i will upvote!
Part B Three-period Four-period Units Units Demanded Period weighted moving weighted moving Demanded Three-period weighted moving average forecast average forecast average forecast Four-period weighted moving average forecast 24 2 25 60 28 50 49 S50 4 32 26.33 46 4.90 39,80 40 41 5 35 29.50 28.6 38 35 38 32.83 31.7 30 32 28 25 26,93 250 es 7 41 36.00 34.9 24 20 8 46 39.00 38 49 43.00 41.8 10 10 53 46.67 45.4 50.50 49.2 1 2 3 4 5 6 7 8 9 10 11 1. Make a comparative analysis out of your answers in the plotted data. (3-5 sentences)
W AutoSave Off H PGDPM AA Calendar JULY 2022 Final No Label ✓ File Home Insert Draw Design Layout References 5 X U Undo Paste Clipboard Page 27 of 32 5110 words Q Search Arial BI U U ab 12 ab x₂ A A Aa A x² A D. A Font English (South Africa) Mailings experts on the domain as a: . 4.1 4.2 Search Review View Help 15-16-15 ₁ ← 三三三 2↓¶ Paragraph Simple list Hierarchical structure and taxonomy of factors Semantic network Database or knowledge base Normal A global performance indicator for the bid competitive value is calculated using the competitive factors as parametric variables. The calculation algorithm depends on the number of parameters, the type of ranking or the knowledge structure complexity. This problem may be effectively approached by a Multi-Attribute Decision Making model, such as, for instance, Saaty's Analytic Hierarchy Process, which is in fact a prioritization technique. Source: https://www.pmi.org/learning/library/external-internal-risks-project-early-phase-1135 QUESTIONS…
Assume an initial starting Ft of 200 units, a trend (Tt ) of 8 units, an alpha of 0.30, and a delta of 0.40. If actual demand turned out to be 288, calculate the forecast including trend for the next period.
A 5. O - BJMP2033 FINAL QUESTIONS SEMESTER SEPT 2019 A191 QUESTIONS REPLACEMENT EZANEE - Word FILE НОМЕ INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW Microsoft account X Cut A Find - -11 - A A Aa - E- EE T Arial AaBbCcDc AaBbCcDc AaBbC AaBbCcC AABI AaBbCcC AaBbCcD AaBbCcD 响Copy ac Replace Paste BIU I U - abe X, x* A - aly - A HE - I Normal I No Spac. Heading 1 Heading 2 Subtitle Subtle Em. Emphasis Title Format Painter A Select- Clipboard Font Paragraph Styles Editing B. Berdasarkan maklumat sebuah projek di bawah, jawab semua soalan berikut Based on a project information below, answer all the following questions: Activity Predecessor Activity Time Estimation (Weeks) A B A A 4 В 7 E В. С 9 F C 6 G D, E, F i) Apakah durasi projek (dalam minggu)? What is the project duration (in weeks)? ii) Apakah jalan kritikal projek? What is the project's critical path? iii) Bina satu rangkaian nod konfigurasi AON bagi projek itu. Construct the AON node configuration network for the…
On Week a) Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Customer Orders 13 8 4 PAB 20 Available to Promise MPS b) Determine if each customer order will be accepted. Order Amount Week Accept (Y/N) 1 40 2 30 3 4 30 25 462M 3 Update the MPS time-phased record for accepted orders. Item: P24 Forecast Customer Orders Problem 3: The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. a) Complete the MPS time-phased record for product P24. Use the table on the left. b) Determine if Murphy Motors can accept each of the following customer orders. Update the MPS time- phased record for accepted orders. Order 1234 Amount 40 Desired Week 4 30 30 25 623 8 4 On Week hand 1 2 3 4 5 6 30 30 30 40 40 40 74 45 45 PAB 20 Available to Promise MPS On hand = 20
Subject: Quantitative research method Which items load onto which factors? Can you name them based on the items that load onto them? (150 words) Rotated Factor Matrix Items Factors 1 2 3 4 5 The appearance of the physical facility .695 -.054 .153 .119 .193 Personnel appearance and equipment .823 -.012 .096 .045 -.002 Ability to perform the promised services .052 .193 .718 .210 -.023 Willingness to help customers .270 -.013 .052 .232 .586 Knowledge and courtesy of employees .018 .769 -.046 .187 .005 Ability to convey trust and confidence -.028 .678 .035 .024 .090 Caring .172 .160 .215 .604 .155 Ability to accurately accomplish .174 .009 .640 .107 .127 Provide prompt services .170 -.210 .188 -.044 .720 Individual attention to customer .249 .093 .200 .638 .298
3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Week On hand 30 30 30 1 2 3 4 5 6 7 8 40 40 40 45 45 13 8 4 Item: P24 Forecast Orders Projected available balance 20 Available-to-promise MPS a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Amount 40 Order Desired Week 1 4 2 6 3 30 2 4 25 3 30 4882 7623
Q7. The president of Rose Bowl Enterprises, Desmond Howard, projects the firms aggregate DEMAND requirements over the next 8 months as follows: These are the monthly DEMAND, not production. MONTH JAN FEB MAR APR MAY JUN JULY AUG DEMAND 1,400 1,600 1,800 1,800 2,200 2,200 1,800 1,800 PRODUCTION 1,600 from December INVENTORY 200 from Dec plus 200 His operations manager is considering a new plan, which begins in January with 200 units on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle time costs. The plan is called plan A. Plan A: Vary the workforce level to execute a strategy that produces the quantity demanded in the prior month. The December demand was given as 1,600 units per month. Therefore, the production for JAN will be 1,600. However, only 1,400 are needed. Therefore, the extra 200 produced go into inventory and there is a holding cost for inventory. Also, per the above, you already have 200 units in inventory…
Q4) Define the following concepts with example. Market Potential Sales Potential Market Share