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...
The past sales history for Store 10 is provided in the table below. Adjust this data...
The past sales history for Store 10 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years. Report the MAPE value for the better of the two forecasts. That is, if the original trend projection forecast was better according to MAPE, then report that MAPE value. If however, the Re-Seasonalized forecast is better according to MAPE, then report the MAPE value for that forecast. Month Year Period Store 10 January 1 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...
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.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago