Calculate the forecast for week 16 using - a 2-period moving avergage- a 3-period moving average 1234567891011121314151617AWeek12345678910111213141516CActual Sales 2-period MA148613451455136812091178158113321245152115441502185617531789B1415.514001411.51288.51193.51379.51456.51288.513831532.5152316791804.51771ErrorD39.5-32-202.5-110.5387.5-47.5-211.5232.5161-30.533374EError²F3-period MA Error134413861366G1560.251024 1428.66667 -60.666667 3680.44444-16641006.25 1389.33333 -180.33333 32520.111112210.2527556150156.25 1251.66667 329.333333 108460.4442256.25 1322.66667 9.33333333 87.111111144732.25 1363.66667 -118.66667 14081.777854056.251634135178HError²11925921930.25 1436.66667 65.3333333 4268.44444110889 1522.33333 333.666667 111333.444547614161-15.5 240.25 1703.66667 85.3333333 7281.77778-1771 3136441 1799.33333 -1799.3333 3237600.441822531684

Forecasting means predicting in advance the future sales.

Answered: Calculate the forecast for week 16…

Business

Operations Management

Calculate the forecast for week 16 using - a 2-period moving avergage - a 3-period moving average

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

A mathematical expression that describes a breakeven point of a company is a.Sales Revenue = Variable expenses - Fixed expenses b.Sales Revenue < Variable expenses + Fixed expenses c.Sales Revenue = Variable expenses + Fixed expenses d.Sales Revenue > Variable expenses - Fixed expenses
Manchester United Soccer Club Nicolette Larson was loading the dishwasher with her husband, Kevin, and telling him about the first meeting of the Manchester United Tournament Organizing Committee. Nicolette, a self-confessed “soccer mom,” had been elected tournament director and was responsible for organizing the club’s first summer tournament. Manchester United Soccer Club (MUSC), located in Manchester, New Hampshire, was formed in 1992 as a way of bringing recreational players to a higher level of competition and preparing them for the State Olympic Development Program and/or high school teams. The club currently has 24 boys and girls (ranging in age from under 9 to 16) on teams affiliated with the New Hampshire Soccer Association and the Granite State Girls Soccer League. The club’s board of directors decided in the fall to sponsor a summer invitational soccer tournament to generate revenue. Given the boom in youth soccer, hosting summer tournaments has become a popular method for…
Manchester United Soccer Club Nicolette Larson was loading the dishwasher with her husband, Kevin, and telling him about the first meeting of the Manchester United Tournament Organizing Committee. Nicolette, a self-confessed “soccer mom,” had been elected tournament director and was responsible for organizing the club’s first summer tournament. Manchester United Soccer Club (MUSC), located in Manchester, New Hampshire, was formed in 1992 as a way of bringing recreational players to a higher level of competition and preparing them for the State Olympic Development Program and/or high school teams. The club currently has 24 boys and girls (ranging in age from under 9 to 16) on teams affiliated with the New Hampshire Soccer Association and the Granite State Girls Soccer League. The club’s board of directors decided in the fall to sponsor a summer invitational soccer tournament to generate revenue. Given the boom in youth soccer, hosting summer tournaments has become a popular method for…
1. Construct a 2-by2 contingency table to determine the total number of people who fail the screening test and will be referred for diagnostic testing in the hearing centers. 2. Construct a 2-by-2 contingency table to determine the total number of people who fail the diagnostic test, which represents the target market for hearing aid sales.
Nicolette Larson was loading the dishwasher with her husband, Kevin, and telling him about the first meeting of the Manchester United Tournament Organizing Committee. Nicolette, a self-confessed “soccer mom,” had been elected tournament director and was responsible for organizing the club’s first summer tournament. Manchester United Soccer Club (MUSC), located in Manchester, New Hampshire, was formed in 1992 as a way of bringing recreational players to a higher level of competition and preparing them for the State Olympic Development Program and/or high school teams. The club currently has 24 boys and girls (ranging in age from under 9 to 16) on teams affiliated with the New Hampshire Soccer Association and the Granite State Girls Soccer League. The club’s board of directors decided in the fall to sponsor a summer invitational soccer tournament to generate revenue. Given the boom in youth soccer, hosting summer tournaments has become a popular method for raising funds. MUSC teams…
The IMA definition of management accounting states thata. management accounting is the process of gathering, reporting, and analyzing information for management decision making.b. management accounting is a profession that involves preparation and analysis of cost information,budgeting, and performance measurement and analysis to assist managers in decision making.c. management accounting involves partnering in management decision making, planning, and performance measurement to assist in the formulation and implementation of an organization’s strategy.d. management accounting is a set of practices in which accountants, working within companies,help managers to make better decisions based on accurate financial information.
Links for reference are shown below https://hpu.blackboard.com/bbcswebdav/pid-2170562-dt-content-rid-18923038_1/xid-18923038_1 https://hpu.blackboard.com/bbcswebdav/pid-2170562-dt-content-rid-18923038_1/xid-18923038_1
Suppose menu messageQ&A notifications account_circle Business FinanceQ&A LibraryYou have just been employed as the New chief executive officer of a medium sized company that is listed on the Ghana stock exchange. At the maiden board meeting,the chairman advised you and your management team to avoid what he termed as "Agency Problem" Explain the term "agency proAm blem " and identify (4) way by which shareholders can deal with it. You have just been employed as the New chief executive officer of a medium sized company that is listed on the Ghana stock exchange. At the maiden board meeting,the chairman advised you and your management team to avoid what he termed as "Agency Problem" Explain the term "agency proAm blem " and identify (4) way by which shareholders can deal with it.…
4-2 Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 80,000 80,000 90,000 100,000 100,000 110,000 120,000 120,000 130,000 140,000 Sales ($) 499,000 477,000 546,000 614,000 623,000 653,000 747,000 714,000 785,000 858,000 What is the predicted sales quantity for an advertising budget of $108,000? Please round your answer to the nearest integer. Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.
The _______________ stage of the AIDA model is most important when we want to influence customers to feel that they simply can’t do without the item.A. DecodingB. InterestC. DesireD. ActionE. Attention
Often we read news related to the recall of several products that have been circulating in themarket. One example is what was done by PT Toyota Astra Motor (TAM) and PT AstraDaihatsu Motor (ADM) some time ago. They officially announced the recall or recall of severalproduct models. The following are excerpts of news published in Kompas related to the recallof TAM and ADM products: A few days ago, PT Toyota Astra Motor (TAM) and PTAstra Daihatsu Motor (ADM), officially announced the recall or recall of severalproduct models.The source of the problem is indicated by a malfunctioning fuel pump impeller. ForDaihatsu, there are three models that experience this problem, namely Sirion, Xenia,and Terios with a total of 97,290 units in Indonesia.For Toyota, the fuel pump problem is even wider in its lineup of units, from Rush,Avanza, Voxy, Alphard, Camry, Hilux, Corolla, Fortuner, Innova, to the C-HR. Thetotal is approximately 286,000 units.Well, it is important to know that recall is a form…
We all hate to keep track of small change. By us-ing random numbers, it is possible to eliminate the need for change and give the store and the customera fair deal. This problem indicates how it couldbe done.a. Suppose that you buy something for $0.20. Howcould you use random numbers (built into the cashregister system) to decide whether you should pay$1.00 or nothing?b. If you bought something for $9.60, how wouldyou use random numbers to eliminate the need forchange?c. In the long run, why is this method fair to both thestore and the customers? Would you personally (asa customer) be willing to abide by such a system?