Given the data below for the monthly sales data at each branch in your region for...
| Given the data below for the monthly sales data at each branch in your region for 6 months, create a bar graph to describe your data. | ||||||||
| Store Number | January | February | March | April | May | June | ||
| 2568 | $ 481,233 | $ 526,911 | $ 572,589 | $ 618,267 | $ 663,945 | $ 709,623 | ||
| 2487 | $ 132,478 | $ 158,974 | $ 127,179 | $ 190,768 | $ 247,999 | $ 272,799 | ||
| 2573 | $ 852,145 | $ 1,193,003 | $ 1,169,143 | $ 1,134,069 | $ 1,020,662 | $ 918,596 | ||
| 2689 | $ 235,478 | $ 235,893 | $ 283,308 | $ 311,639 | $ 314,755 | $ 330,493 | ||
| 2487 | $ 687,153 | $ 824,584 | $ 832,829 | $ 866,143 | $ 952,757 | $ 1,000,395 | ||
Homework Answers
Add Answer to:
Given the data below for the monthly sales data at each branch in
your region for...
You are given the following budgeted and actual data for the Grey Company for each of...
You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 93 units; February, 88 units; March, 95 units; April, 100 units; May, 107 units; June, 115 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 83 units; March, 95 units, April, 95 units;...
You are given the following budgeted and actual data for the Grey Company for each of...
You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 97 units; February, 92 units; March, 99 units; April, 104 units; May, 111 units; June, 119 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 87 units; March, 99 units; April, 99 units;...
using R program. please show everything The following data concerns monthly sales of an electronic device...
using R program. please show everything
The following data concerns monthly sales of an electronic device for the last year a) Plot sales (y) versus time (t). Is it reasonable to use a least squares trend line to relate y tot b) Use a least squares trend line to predict calculator sales for the next three months (January, February, and March of the next year). Device sales, y Month January February 197 211 March 203 April May June 247 239...
Problem 1 The table below presents data for tire sales in the Costco Branch at South...
Problem 1 The table below presents data for tire sales in the Costco Branch at South Dakota Avenue, Washington D.C. from the months of January through December of the Year 2019. 5983 Automobile Month Year Tire Sales January 5610 2019 February 5790 2019 March 2019 2019 April 6202 6460 2019 May 6608 2019 June July 2019 August 2019 9110 September 2019 8690 October 2019 8799 November 2019 8896 December 2019 9210 a. Compute a two-month moving average. What is the...
2. Describe how you would construct a purely seasonal model for the following monthly series. In...
2. Describe how you would construct a purely seasonal model for the following monthly series. In partic- ular, what dummy variable() would you use to capture the relevant effects? (a) A sporting goods store finds that detrended monthly sales are roughly the same for each month in a given 3-month season. For example, sales are similar in the winter months of January, February, and March, in the spring months of April, May, and June, and so on. (b) A campus...
The past sales history for Store 7 is provided in the table below. Adjust this data...
The past sales history for Store 7 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years. Report the MAD value for the re-seasonalized forecast. Month Year Period Store 7 January 1 1 54483 February 1 2 66981 March 1 3 87332 April 1 4 90292 May 1 5 82586 June 1 6 78925 July 1 7 68756 August 1 8 58782 September 1 9 32654 October 1 10 33480 November...
The past sales history for Store 7 is provided in the table below. Adjust this data...
The past sales history for Store 7 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years. Report the MAD value for the re-seasonalized forecast. Month Year Period Store 7 January 1 1 54483 February 1 2 66981 March 1 3 87332 April 1 4 90292 May 1 5 82586 June 1 6 78925 July 1 7 68756 August 1 8 58782 September 1 9 32654 October 1 10 33480 November 1...
A. Carmen’s Beauty Salon has estimated monthly financing requirements for the next six months as follows:...
A. Carmen’s Beauty Salon has estimated monthly financing requirements for the next six months as follows: January $ 9,100 April $ 9,100 February 3,100 May 10,100 March 4,100 June 5,100 Short-term financing will be utilized for the next six months. Projected annual interest rates are: January 5.0 % April 12.0 % February 6.0 % May 12.0 % March 9.0 % June 12.0 % -Compute total dollar interest payments for the six months. (Round your monthly interest rate to 2...
The monthly sales for Telco Batteries Inc. were as follows:
Problem # 1The monthly sales for Telco Batteries Inc. were as follows: SalesMonth (000 units)January 20February 21March 15April 14May 13June 16July 17August 18September 20October 20November 21December 23Plot the monthly sales data.Forecast coming January sales using each of the following:The naïve approachA 6-month moving averageA 6-month weighted average using 0.1, 0.1, 0.1, 0.2, 0.2 and 0.3, with the heaviest weights applied to the most recent months.Calculate the mean absolute deviation (MAD) and the mean squared error (MSE) for each of...
Use the following sales data to answer the questions. Month Sales January 
Use the following sales data to answer the questions. Month Sales January $250,000 February $200,000 March $300,000 April $350,000 May $450,000 Using a two month moving average, what are the expected sales for June? Using a three month moving average, what are the expected sales for June? Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six months are shown below, along with the results of two different...
You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 93 units; February, 88 units; March, 95 units; April, 100 units; May, 107 units; June, 115 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 83 units; March, 95 units, April, 95 units;...
using R program. please show everything
The following data concerns monthly sales of an electronic device for the last year a) Plot sales (y) versus time (t). Is it reasonable to use a least squares trend line to relate y tot b) Use a least squares trend line to predict calculator sales for the next three months (January, February, and March of the next year). Device sales, y Month January February 197 211 March 203 April May June 247 239...
Problem 1 The table below presents data for tire sales in the Costco Branch at South Dakota Avenue, Washington D.C. from the months of January through December of the Year 2019. 5983 Automobile Month Year Tire Sales January 5610 2019 February 5790 2019 March 2019 2019 April 6202 6460 2019 May 6608 2019 June July 2019 August 2019 9110 September 2019 8690 October 2019 8799 November 2019 8896 December 2019 9210 a. Compute a two-month moving average. What is the...
2. Describe how you would construct a purely seasonal model for the following monthly series. In partic- ular, what dummy variable() would you use to capture the relevant effects? (a) A sporting goods store finds that detrended monthly sales are roughly the same for each month in a given 3-month season. For example, sales are similar in the winter months of January, February, and March, in the spring months of April, May, and June, and so on. (b) A campus...
Most questions answered within 3 hours.
-
9.) You are buying a car that cost $26,500. You make payments of
$412 each month...
asked 15 minutes ago -
. Suppose a discrete random variable has probability
distribution
P(x) = .2 if x = 0...
asked 1 hour ago -
Problem #1
The area between Z = 0 and Z = 2.50
The area between Z...
asked 31 minutes ago -
Under the influence of its drive force, a snowmobile is moving
at a constant velocity along...
asked 1 hour ago -
Why do organizations decline? What steps can top
management take to halt, decline, and restore organizational...
asked 1 hour ago -
What mechanisms Drive speciation??
(I.e. what was Dawins theory on the orgin of species, and how...
asked 3 hours ago -
The manager at a car assembly plant believes that the mean
assembly time for a car...
asked 4 hours ago -
Which of the following is true of electron capture?
A) It decreases the nuclide's mass number...
asked 5 hours ago -
Assuming an efficiency of 43.10%, calculate the actual yield of
magnesium nitrate formed from 114.9 g...
asked 6 hours ago -
The highly pathogenic bacterium Clostridium
perfringens causes gangrene, a disease that results in the
destruction of...
asked 8 hours ago -
In the context of situation analysis, which of the following is
a category for analysis in...
asked 8 hours ago -
In a study of the gas phase decomposition of sulfuryl chloride
at 600 K SO2Cl2(g)SO2(g) +...
asked 8 hours ago