15. The sales of a company for the years 2011 to 2017 are given below : 2013 65 2012 2017 275 2011 ear ales (in million) Find trend values by using the equation Ye= a b and estimate the value for 2020. 2014 92 2015 190 2016 132 32 47
Q: cosmetics manufacturer's marketing department has developed a linear trend equation that can be used…
A: Given: F t = 80 + 15t Ft = Annual sales (000 bottles) t is in years
Q: 11. A major source of revenue in Leyte is a state sales tax on certain types of goods and services.…
A: A Small Introduction About Forcast Management Forecasting is the method involved with making…
Q: Using the data given in the following table, if the seasonal index for quarter 3 is 1.12, what…
A: Find the Given details below: Given details: Year Quarter 2019 2020 1 120 113 2 135…
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: Given data - Month January February March April No. of Accidents 30 40 60 95
Q: Use the sales data given below to determine: (a) the least squares trend line, and (b) the predicted…
A: Formulas Used: Mean = Sum of values/ Number of values Equation: y = a + b x where, a = (Mean of y)…
Q: The following table shows the past two years of quarterly sales information. Assume that there are…
A: Quarter Sales 1 154 2 190 3 154 4 145 5 216 6 236 7 208 8 175
Q: The following is the actual sales for Manama Company for a particular good: t Sales 17 5 31 The…
A: Given data is
Q: Ralph Billett is the manager of a real estate agency. He now wishes to develop a forecast of the…
A: Find the Given details below: Given details: Sales (Year) Quarter 1 2 3 1 30 59 71 2…
Q: Regression line. A large midwestern retailer has developed a graph that summarizes the effect of…
A: The given linear equation is in the form of a refers to the value of y when x= 0 (it is the point…
Q: The sales of XYZ company for the previous three periods are 45, 42, and 43 respectively. Estimate…
A: Forecasting is the method of estimating future occurrences with the help of previous data and…
Q: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…
A: Yt= Value of Current yearFt=Yt-1+Yt-2+Yt-33
Q: 1. Consider the total production (and sales) of ice cream in Canada (in millions of liters) for the…
A: We are authorized to answer three subparts at a time since you have not mentioned which part you are…
Q: Apply the 3-years moving average method to forecast the required demand for the year 2021 from the…
A: Years Demand 2012 245 2013 325 2014 300 2015 350 2016 295 2017 400 2018 450 2019 380…
Q: The following equation summarizes the trend portion of quarterly sales of condominiums over a long…
A: Forecasting is a method that produces accurate estimates using historical data as inputs to…
Q: A cosmetic company wants to forecast the sales for the third month using the three period moving…
A: Forecasting is the process of predicting future data based on previous or past data and information.…
Q: Given the following historical data, what is the moving-average forecast for period 6 based on the…
A: Calculation of moving average forecast for period 6 based on the last three periods:The formula for…
Q: Calculate five –yearly moving averages of the number of students studying in a university and short…
A: The formula for calculating the forecast of the current month using a 5-month moving average is the…
Q: The following equation summarizes the trend portion of quarterly sales of condominiums over a long…
A:
Q: Q5: The following data represent the sales of the National Tigers Company for the period from…
A:
Q: Below is a table containing data on product demand for the most recent five months along with the…
A: The simple moving average forecasting method considers the latest values of the actual demand of a…
Q: The following gives the number of accidents that occured on Florida State Highway 101 during the…
A: Given data is
Q: a. Draw the scatter diagram b. With a ruler, draw rend line on your scatter diagram c. Solve for the…
A: A Scatter diagram shows the relationship between two variables whether they are positively…
Q: Consider the following from an estate agent’s business nationally: Month Houses Sold Jan 380…
A: Since you have submitted multiple questions, as per guidelines I have answered the first question…
Q: Community Federal Bank in Dothan, Alabama, recently increased its fees to customers who use…
A: Using trend projection with regression to forecast usage for weeks 13–16.
Q: The director of the Riley County, Kansas, library systemwould like to forecast evening patron usage…
A: The seasonal index refers to a measure of how a specific season amongst some cycle contrasts with…
Q: (a) Fit a straight line trend by the method of least square and calculate trend values. (b) What is…
A: FORMULAS USED IN THE LEAST SQUARE METHOD: STRAIGHT LINE TREND: Y=a+bX WHERE Y IS THE DEPENDENT…
Q: Consider the monthly sales data of a company for last year as well as first six-month data for…
A: Given information:
Q: The figures below show the sales of hairdryers in one shop over the last 3 months. Month 1: 140…
A: Exponential smoothing is a forecasting model which helps to identify the forecasting demand using…
Q: a - Find the equation of the general trend line using the ordinary least squares method? Then…
A: The least-square method is used to find the trend values to forecast future sales based on the past…
Q: YEAR 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 ARRIVAL ('000) 35.5 28 30.3 36 49.5 56 72.4…
A: Given information, Year Delayed Rate Arrival X Y 2010 4.2 35.5 2011 3.8 28.00 2012…
Q: Consider the following from an estate agent's business nationally: Month Houses Sold Jan Feb 380 360…
A: Find the Three-point moving average and seasonal Variation calculation below:
Q: The demand for a product of a company in each of the last twelve months is shown in the table below;…
A: Formula:
Q: c) If the forecasted demand for the week of August 31 is 345 and a = 0.20, using exponential…
A:
Q: Air travel on Mountain Airlines for the past 18 weeks was:Week Passengers1 4052 4103 4204 4155 4126…
A: a) The moving average technique would not be appropriate for the given data because the data is…
Q: Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in…
A: Given data is
Q: Quarterly sales of a local department store over a 4-year period are given below: Quarters 2016 Q1…
A: Formula:
Q: Use = 0.2 to compute the exponential smoothing values for the time series. Forecast for Month 8. The…
A: Given that , Forecast for 6 months is 21 The two month moving average for months two to five is…
Q: Sales volume of July was 390. Use exponential smoothing with a smoothing constant o.2 to find the…
A: Exponential smoothing is a rule of thumb technique for smoothing time series data using the…
Q: Income at the architectural firm Spraggins andYunes for the period February to July was as follows:…
A: Foretasted Income at time t Ft= FIT (t−1) +α(A(t−1)−FIT (t−1) ) Trend at time t…
Q: Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS…
A: Given: Weight for the recent quarter or (3rd quarter) = 0.50 Second most recent or (2nd quarter) =…
Q: Cell phone sales for a California-based firm over the last 10 weeks are shown in the following…
A: Formula:
Q: Community Federal Bank in Dothan, Alabama, recently increased its fees to customers who use…
A: Forecasting is the process of estimating the future demand based on previous information or historic…
Q: The number of bushels of apples sold at a roadside fruit stand over a 12-day period were as follows:…
A: Since you have asked a question with multiple subparts, we will answer the first three subparts for…
Q: Based on the information in the following table, use the Exponential Smoothing Approach (a = 0.3) to…
A: The question is related to the Exponential smoothing model. The Forecasted demand as per Exponential…
Q: Community Federal Bank in Dothan, Alabama, recently increased its fees to customers who use…
A: Trend projection with regression is a typical forecasting method in which relationship between…
Q: The actual demand for the patients at EYE OPD of KTH for the first six weeks of this year follows…
A: Given data is
Q: The following data show the demand (thousand units) of national cars for three seasons from year…
A: a) Step 1: In the first step, a group of beginning years (periods), which constitute cycle is…
Q: What is the forecast for this year using trend adjusted (double) smoothing with alpha(1) = 03 and…
A: Forecasting is the process of estimating future demand according to the previous demand and…
Q: Quarterly sales have a trend given by Y = 30,000t + 10,000, where Y is sales in pesos and t is the…
A: A trend shows the increase or decrease in values of data collected during long-term periods. A…
Step by step
Solved in 2 steps with 2 images
- The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.
- Management of a home appliance store wants to understand the growth pattern of the monthly sales of a new technology device over the past two years. The managers have recorded the relevant data in the file P13_05.xlsx. Have the sales of this device been growing linearly over the past 24 months? By examining the results of a linear trend line, explain why or why not.The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
- The management of a technology company is trying to determine the variable that best explains the variation of employee salaries using a sample of 52 full-time employees; see the file P13_08.xlsx. Estimate simple linear regression equations to identify which of the following has the strongest linear relationship with annual salary: the employees gender, age, number of years of relevant work experience prior to employment at the company, number of years of employment at the company, or number of years of post secondary education. Provide support for your conclusion.The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.
- The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?Cell phone sales for a California-based firm over the last 10 weeks are shown in the following table. Plot the data, and visually check to see if a linear trend line would be appropriate.Then determine the equation of the trend line, and predict sales for weeks 11 and 12.Week Unit Sales1 7002 7243 7204 7285 7406 7427 7588 7509 77010 775Answer in Excel: Consider the data below for the sales of widgets: 1. Using seasonal percentages or seasonal indexes, forecast the sales for each season in year 4, if the annual widgets sales is predicted to be 1500. 2. Develop a regression equation that captures both the trend and seasonality in this data. Use this equation to forecast the sales for each season in year 4. Season Year 1 Year 2 Year 3 Fall 505 240 210 Winter 555 460 365 Spring 400 310 204 Summer 560 450 394