Question Four: ABC Company sells home appliances. Daily sales for a six-day period were as follows: Day Sales Saturday 20 Sunday 24 Monday 30 Tuesday 40 Wednesday 36 Thursday 44 a. Forecast Friday sales volume using each of the following methods: i. A three-day moving average. ii. A four day weighted average using weights of 0.1, 0.2, 0.3 and 0.4 iii. Exponential smoothing with a smoothing constant equal to 0.2, assuming Wednesday forecast of 42. b. Determine a linear trend line equation for ABC Company. c. Use the trend equation to forecast Friday sales volume.

Question Four: ABC Company sells home appliances. Daily sales for a six-day period were as follows: Day Sales Saturday 20 Sunday 24 Monday 30 Tuesday 40 Wednesday 36 Thursday 44 a. Forecast Friday sales volume using each of the following methods: i. A three-day moving average. ii. A four day weighted average using weights of 0.1, 0.2, 0.3 and 0.4 iii. Exponential smoothing with a smoothing constant equal to 0.2, assuming Wednesday forecast of 42. b. Determine a linear trend line equation for ABC Company. c. Use the trend equation to forecast Friday sales volume.

Name: A noha sayeesignLayoutReferencesMailingsReviewViewDeveloperHelpR Tell
Uploaded: 2024-03-20T07:07:12.000Z
Channel: Bartleby
Description: A noha sayeesignLayoutReferencesMailingsReviewViewDeveloperHelpR Tell me what you want to doQuestion Four:ABC Company sells home appliances. Daily sales for a six-day period were asfollows:DaySalesSaturday20Sunday24Monday30Tuesday40Wednesday36Thursd

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast. b. Using a simple 3-month moving average, find the July forecast. c. Using single exponential smoothing with α = 0.2 and a June forecast ≈ 13, find the July forecast. Make whatever assumptions you wish. d. Using simple linear regression analysis, calculate the regression equation for the demand data. e. Using the regression equation in d, calculate the forecast for July.
A company has the following monthly sales for the past year. Plot the data points on a line graph and describe the results. Month Sales 1 145 2 146 3 145 4 150 5 148 6 150 7 156 8 160 9 158 10 153 11 152 12 154
If you want to use the build-down method to test a model using age (in number of years) and sex (male or female) to predict income, how large a data set would you need to collect: 8 8 8 8 20 50 40
TABLE:3 Period Demand forecast Weights Weighted Moving average Exponential Smoothing forecast X2 xy 1 1600 2 2200 3 2000 4 1600 5 2500 6 3500 7 3300 8 3200 9 3900 10 4700 11 4300 12 4400 13 a. Calculate the forecast for the data using a four-year moving average. b. Use the data to calculate the forecast for period 5 using a four-period weighted average moving average. The weights of .4, .3,.2, and .1 are assigned to the most recent, second most recent, third most recent and the fourth most recent respectively. c. Based on the data,…
Given the following data : Year: 1992 1993 1994 1995 1996 1997 1998 Weekly take home Pay (Rs.): 105 110 115 125 135 140 145 Consumer Price index : 113 118 127 138 144 150 160 (i) What was the real average of weekly pay for each (ii) In which year did the employee have the greatest buying power ? (iii) What percentage increase in the weekly pay for the year 1998 is require (if any) to compensate him with the purchasing power in the yearda his highest real pay ? year
Given the data below: Month Laptops Sold January 35 February 47 March 31 April 39 Predict the sales for May using a. weighted three-month moving average with weights 5, 3, and 2, where 5 is the weight for last month’s sale, 3 is the weight for the sales two months ago, and 2 is the weight for sales three months ago. b. exponential smoothing with α = 0.4. Assume the forecast for January was 25 laptops.
Given the following data on the number of pints of ice cream sold at a local ice cream store for a 10-period time frame: Period Demand 1 230 2 220 3 200 4 270 5 300 6 300 7 330 8 340 9 360 10 300 Use a 2-period moving average to forecast demand for period 11 Group of answer choices 350 225 330 335
The following is the data of the production of corona vaccine (Pfizer) for last few months. Using the moving average of 5 months determine the trend of production of corona vaccine. Month February March April Мay June July Production (units) 400 600 500 600 700 600 O a. 560 and 600 O b. 450 and 550 O C. 500 and 600 O d. 500 and 560
The Agri-Food Company has been in business for five years. Brian, the firm's owner, wants to develop a forecast of olive oil sales for the coming year (i.e., 2025) based on the following historical data: Year 2020 2021 2022 2023 2024 Sales 10 20 40 55 75 1. Forecast sales for 2025 using the 3-year moving average method. 2. Forecast sales for 2025 using the simple exponential smoothing method with a smoothing constant of a=0.6. 3. Forecast sales for 2025 using the simple linear trend method.
(a) The Marino Company in Ventura County, southern California sells swimming pool equipment. The sales for swimming pool motors in southern California over the last 12 months is given in Table Q4(a). Forecast the demand from March to December of the current year using the following forecasting models. Use excel for the tabulation. (1) Three-month simple moving average; (i)Three-month weighted moving average. Use 0.7, 0.2, and 0.1 for the weights, with 0.7 for the most recent period, and 0.1 for the oldest period. (ii) Simple linear regression; (iv) Determine the MAD, and SE for all the models, and choose which model is most appropriate. Table Q4(a) Marino Company Sales of Swimming pool motors Quantity (units) 11,596 Month January February March 14,438 16,861 10,002 April May 15,106 June 17,941 July August September October 11,877 14,290 17,363 12,430 14,858 November December 16,833
The below data represent the advertising expenditure and sales of Liu Liu Ltd from year 2010 to 2019. Table: Advertising Expenditure vs. Sales from 2010 to 2019 Year Advert. Expenditure Sales Growth rate of Ad. Expenditure Growth rate of Sales (x, £000) (y, £000) 2010 19 84 2011 22 108 18% 29% 2012 32 82 46% -24% 2013 42 86 32% 6% 2014 47 84 11% -3% 2015 46 94 -2% 11% 2016 58 103 27% 10% 2017 63 115 8% 12% 2018 70 106 11% -8% 2019 80 142 15% 34% Total 479 1004 a. What is the statistical relationship shown in the table and list out 3 characteristics of this relationship?
The following table present quarterly sales for a company over the three years (a) Fit the trend as a linear function of time t and predict the sales for the 4th year? Year 2 Year 3 309 405 326 429 369 446 416 465 quarter 1 2 3 4 Year 1 241 263 273 292