(Note: express all answers using 4 decimal places) Exponential SmoothingThe following data shows the monthly sales (millions of pesos) of a product over the pastperiods.Actual25.60 24.70| 21.3013.90| 12.60| 18.00 | 21.50 | 22.3030.70 15.00| 13.80 22.DataMonth May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19(a) Compute the forecast sale using a = 0.20 and a = 0.35 respectively,(b) solve for MAD, SSE, MSE, and MSE(c) Forecast the next month's (May-19) sale, and(d) which forecast value is better to use in terms of MSE, explain why? (Note: express all answers using 4decimal places)%3D

Forecasting is the process of estimating the future demand using previous or historic data or…

(a) Compute the forecast sale using a = 0.20 and a = 0.35 respectively, (b) solve for MAD, SSE, MSE, and MSE (c) Forecast the next month's (May-19) sale, and (d) which forecast value is better to use in terms of MSE, explain why? (Note: express all answers using 4 decimal places) %3D

(a) Compute the forecast sale using a = 0.20 and a = 0.35 respectively, (b) solve for MAD, SSE, MSE, and MSE (c) Forecast the next month's (May-19) sale, and (d) which forecast value is better to use in terms of MSE, explain why? (Note: express all answers using 4 decimal places) %3D

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

Related questions

Q: What are the difficulties that firms face while attempting to migrate to a cloud-based platform? Wha...

A: The difficulties that most of the firms face while attempting to migrate to a cloud based platform a...

Q: a. A commercial project requires the installation of 1,856 square feet of acoustical ceiling. Using ...

A: Given- Area of acoustical Ceiling = 1,856 sq.ftProductivity Rate = 0.013 lhr / sq.ftProductivity Fac...

Q: State how does the long term capacity considerations differ from that of short term capacity conside...

A: To be determined: how does the long term capacity considerations differ from that of short term capa...

Q: 9.) you run a small bottle distributor, and youre trying to decide where to put the various items yo...

A: Number of red bottles = 11 Number of green bottles = 27 Number of yellow bottles = 49 Each type of b...

Q: The reliability of a system with n independent components equals:a) the sum of the individual reliab...

A: Reliability can be stated as the consistency of an exploration learning study or predicting test. Fo...

Q: Meet Matt. Matt runs a men’s clothing line. Matt needs to buy 12,000 shirts per year to fulfil deman...

Q: Consider the system composed of four processes linked by a conveyor belt. There is no storage betwee...

A: The market demand is 30 units per hour. Thus, for process 1, Inventory = 4 units Time taken = 60÷30×...

Q: Explain the things you would include in a monthly project report progress report

A: Project management is the management in which different types of skills and knowledge are required t...

Q: Yonsei Library requires different numbers of full-time employees on different days of the week. The ...

A: Employee Scheduling permits you to play out an assortment of scheduling exercises: Make and keep up...

Q: 4) If the range of profitable demand for a company producing digital pumps was D'1 = 8.5 units and D...

Q: a) Based on the given information, the best location for Marilyn Helm Retailers is to open the new r...

A: For deciding the best location, the weightage of each component should be first computed.

Q: ABC Inc is considering the possibility of building an additional factory that would produce a new ad...

A: Expected monetary value (EMV) = ∑(Probability of demand×Expected revenue) Net present value (NPV) = ...

Q: Question 1 (Stock Control) - Suyuti Auto purchases a component used in the manufacture of automobile...

Q: Give at least 3 examples of jobs that requires Work Measurement and give a brief explaination.

A: Work measurement is the use of methodologies to determine how long it takes an average worker to com...

Q: EFG Company provided you that during the year there will be 50 deliveries of material H. The carryi...

A: An annual volume of required material would be the some of EOQ multiplied by number of orders. An EO...

Q: a. Draw the network diagram b. What is the critical path? c How many dayswill it take to complete th...

A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for...

Q: Task 3: 100 trailers of a specific model are required by Sask Trailers to meet the demand at the beg...

A: A Small Introduction about Requirement Plan A prerequisite the board plan is an archive that is n...

Q: I need number 4 and 5 please

A: The amount of time required for during manufacturing process for converting raw materials into finis...

Q: You should benchmark a company that: O Is in a different business O Makes benches O Follows a differ...

A: Benchmarking refers to process of setting a standard by which one can compare the quality/efficiency...

Q: 1. The manager of a crew that installs carpeting has tracked the crew's output over the past several...

A: Productivity is the comparison between the output and input of the production factors used in the bu...

Q: What is level scheduling? What is the basic philosophy underlying it ?

A: Time study can be stated as the structured approach of directly monitoring and calculating human wor...

Q: Compare and contrast the focus on reducing the cost era with the focus on quality era within the ev...

A: Operations management is a wide field and has a long process chain from sourcing raw materials to de...

Q: What is the importance of a Project Charter?

A: A Small Introduction about Project Charter A venture sanction is a formal, normally short record ...

Q: ___ maintenance partners operators with maintenance personnel to observe, check, adjust, clean, and ...

A: Autonomous Maintenance is the first step of implementing Total Productive Maintenance. It covers the...

Q: 1. Calculate the loss for each unit. If required, round your answers to the nearest cent. $_______ P...

A: Taguchi defines the quality loss function as the damage inflicted on society by a product from the t...

Q: d. Steps involved in classification of ABC analysis?

A: ABC analysis - is the inventory management procedure that defines the value of inventory objects bas...

Q: Precedent Activity Length (week) Sequential |Sequential Task Туре A. High level analysis B. Selectio...

A: Given-

Q: Question 12 Which of the following project team members typically decides on the delivery and paymen...

A: A delivery and payment methods is the key in any project because the delivery of the project or the ...

Q: briefly explain the difference between planning and scheduling

A: Thorough production planning and optimum utilization of the resources are the primary goals of plann...

Q: Littlefield Labs has three stations to process blood testing jobs. Fill out the following table on y...

A: The Bottleneck Rate of a directing is the rate (parts per unit time or assignments per unit season) ...

Q: Cedric assembles computers for an electronic factory. He is paid $17.50 per hour, plus $4.90 for eac...

A: Piecework system indicating a payment system which calculating the payment based on the number of pi...

Q: UNIQLO is a Japanese clothing company, often described as a Japanese version of the GAP, or “the Ike...

A: SUMMARY- UNIQLO is regularly depicted as a Japanese adaptation of the GAP, or "the Ikea of garments"...

Q: Using the LOT heuristic, assign the tasks to the windows to produce the desired service rate making ...

Q: Identify the four most typical types of basic data.

A: Data types are significant ideas in statistics, they empower us to apply factual estimations accurat...

Q: Explain to Mr. Ferdinand two ways in which he can benefit from doing forecast for his beef.

A: Forecasting is a method that is used on historical data as inputs to make the estimates that are est...

Q: Page No. youvA Date Paoblem:1 2A companyis planning aonk foxce level feo Foue month.company has 20 w...

A: here, zero inventory is not possible since production per worker per day is in decimals. We cannot h...

Q: Assuming your company is producing Apple and Samsung phone cases. It is required to process in the a...

A: Decision variables: Suppose-A = No. of Apple phone cases to be producedS = No. of Samsung phone ca...

Q: Quarterly boat sales over a two-year period are provided in the table below. Suppose we expect year ...

A: Year 1: Average demand = 8+10+12+94=9.75 Year 2: Average demand = 8+11+14+104=10.75

Q: Destination the way of organisations that how they manage the supply chain in a more effective way.

A: The cornerstone of supply chains includes people, processes, technology, and information, which conn...

Q: solution. Determine the following: a. The optimal order size b. The total annual inventory costs c. ...

A: Note: As per the Bartleby guidelines, only the first three parts have been answered.

Q: Question 1 a) Explain what a “supply chain” is. b) Explain why practioneers of supply chain manageme...

A: Supply chain management is the management related to the flow of goods and services. It includes all...

Q: Dunder Mifflin, of Scranton, PA, is the leading manufacturer of office furniture and related items. ...

A: At its center, market segmentation is the act of partitioning your objective market into receptive g...

Q: Question 1 UMU has demand for 1400 water pumps each year. The cost of a water pump to UMU is $400. I...

A: Given data Annual demand of water pump (D) = 1400 units Cost of a water pump = $400 Inventory carr...

Q: A process or system is deemed feasible if it satisfies which two dimensions of sustainability? ...

A: Social sustainability can be defined as identifying and managing the business impacts on the process...

Q: Tasty Bread Company has monthly demand for one of its products as follows: March= 520; April=490; M...

Q: c. Using simple exponential smoothing, what would your forecast be for this month if the exponential...

Q: Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applic...

A: Fixed cost F= $150,000 Variable cost c= $4 per book Selling price p= $43 per book Demand = 4000 - 6p...

Q: Q. Suppose you have to set up a manufacturing plant at any place. What are the things which you wil...

A: The manufacturing plant is a large production facilitated building where the product is prepared in ...

Q: Strategic Planning process, CEO wants to assign the budget to each business function for functional ...

A: A Small Introduction about Planning Process Arranging includes choosing missions and targets and ...

Q: Outline a common method to develop a schedule.

A: A schedule composed of all the exercises contained in the implementation & performance of a proj...

Question

(Note: express all answers using 4 decimal places)

Exponential Smoothing
The following data shows the monthly sales (millions of pesos) of a product over the past
periods.
Actual
25.60 24.70| 21.30
13.90| 12.60| 18.00 | 21.50 | 22.30
30.70 15.00| 13.80 22.
Data
Month May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19
(a) Compute the forecast sale using a = 0.20 and a = 0.35 respectively,
(b) solve for MAD, SSE, MSE, and MSE
(c) Forecast the next month's (May-19) sale, and
(d) which forecast value is better to use in terms of MSE, explain why? (Note: express all answers using 4
decimal places)
%3D

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 11 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

gnment 1.d X ment%202.pdf .xlsx HP Work & Supply Chain Marakane Sales JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Total - 1 / 2 - Question 1 The monthly demand of a company is showed below, please use the static method to forecast the demand for Year 6. Year 1 Q Search 2,000 3,000 3,000 3,000 4,000 6,000 7,000 6,000 10,000 12,000 14,000 8,000 78,000 Catherine Caramp....pdf Z Year 2 140% 3,000 4,000 3,000 5,000 5,000 8,000 3,000 8,000 12,000 12,000 16,000 10,000 89,000 LDE + @ I Assignment 2 Year 3 Question 2 Historical demand for Peeps is as displayed in the table. 2,000 5,000 5,000 3,000 4,000 6,000 7,000 10,000 15,000 15,000 18,000 8,000 98,000 T2202- 2022.pdf 0 Year 4 }}) 5,000 4,000 4,000 2,000 5,000 7,000 10,000 14,000 16,000 16,000 20,000 12,000 115,000 ! Year 5 5,000 2,000 3,000 2,000 7,000 6,000 8,000 10,000 20,000 20,000 22,000 8,000 113,000 Q☆ l EN US
DFC Company has recorded the past years sales for the company: Year(t) Sales(x) (in Million Pesos) 2011(1) 2012(2) 2013(3) 2014(4) 2015(5) 2016(6) 2017(7) 2018(8) 2019(9) 2020(10) 219 224 268 272 253 284 254 278 282 298 Use the naïve model. Compute for MAE and MSE Use a three period moving average. Compute for the MAE and MSE Use the simple exponential smoothing to make a forecasting table. Compute the MAE and MSE of the forecasts. Alpha = 0.1 Use the least square method to make the forecasting table. Compute the MAE and MSE *** Use excel or r programming
year quarterly sales (000 units) Q1 Q2 Q3 Q4 2016 1300 1500 1200 2000 2017 1600 1800 1100 2200 2018 1700 1900 1300 2300 2019 1800 2100 1400 2500 Using a simple regression analysis, determine the trend equation of the sales and use it to estimate the number of units of clothing sold throughout the fiscal year 2020. Assume that Q1 of 2016 is 1, Q2 of 2016 is 2, etc. Show all relevant cakculation detail
The following table shows the three-period moving average and five-period moving average for monthly sales of Budget Furniture's during 2019. Moving averages of Budget Furniture's Time period Months Sales Three-period moving average (rounded off to Five-period moving average four decimals) R'millions 1 Jan 7 5.0000 6.2 February 5.6667 6.6 March 5 7.0000 B 4 April 8.3333 8.2 May 7 9.3333 8.4 June 8.3333 9.6 7 July 12 8.6667 9.6 August 4 A 9.2 September 10 10.6667 10 October 13 10.6667 11 November 9 12 December 10 The seasonal index for the month of February in 2019 is: LO
From the following time series data of sale project the sales for the next three years. Year 2001 2002 2003 2004 2005 2006 2007 Sales (*000 units) 80 90 92 83 94 99 92
(4) The Great Northwest Outdoor Company is a catalog sales operation that specializes in outdoor recreational clothing. Demand for its items is very seasonal, peaking during the holiday season and during the spring. It has accumulated the following data for orders per season (quarter) during the past five years. Orders (1,000s) Year 1 Year 2 Year 3 Year 4 Year 5 Winter (Q 1) Spring (Q 2) Summer (Q 3) 18.6 18.1 22.4 23.2 24.5 23.5 24.7 28.8 27.6 31.0 20.4 19.5 21.0 24.4 23.7 Fall (Q 4) Total 41.9 46.3 45.5 47.1 52.8 104.4 108.6 117.7 122.3 132.0 Develop a seasonally adjusted forecast model for these order data. Forecast demand for each quarter for year 6, using the annual trend line as given: Y(t) = 96.33 + 6.89t (a) Find seasonal index for each quarter (b) Find seasonally adjusted demand forecast for each quarter for year 6 (c) Find MAD for seasonally adjusted forecasting for year 1 through 5.
Fill the following blanks with appropriate abbreviations supplied: ________ =mean absolute percentage error, ________ = fixed cost, _______ = slope, _______ = correlation coefficient, _______ = smoothing constant, ________ = intercept, _________ = trend smoothing constant, α FC β MAPE b r a
Forecast error is measured using the following formula. O a. Actual value = Forecast value O b. Forecast value = Actual value O C. Actual value - Forecast value o d. Forecast value - Actual value
Please do not give solution in image formate thanku. Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with α = 0.5 Forecast the number of calls for week 6, which is next week. WEEK ACTUAL SERVICE CALLS 1 28 2 32 3 40 4 27 5 30
3. Quarterly sales of a car dealer exhibit an almost constant mean over time, but sales fluctuate depending on the quarter of the year (exhibits seasonality). Quarter Q1 - Spring Q2 - Summer Q3 - Fall Q4 - Winter Mean Year 1 32 74 53 22 45.25 Year 2 30 71 63 15 44.75 Year 3 35 83 45 19 45.5 (a) Using three years' worth of quarterly data that is provided, develop a set of seasonal factors that could be used to forecast car sales (b) Forecast car sales in each of the four quarters (Q1-Q4) of the following year (Year 4), using these seasonal factors.
b. The mean absolute deviation as of the end of week 10 is___ rentals enter your response here. (Enter your response rounded to two decimal places.)
1. The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Part 2 Week Of Pints Used August 31 350 September 7 372 September 14 412 September 21 381 September 28 366 October 5 378 Part 3 a) The forecasted demand for the week of October 12 using a 3-week moving average LOADING... = _____________pints (round your response to two decimal places).