The next page provides the monthly sales data for Joe's Stone Crab. We have been hired...

The next page provides the monthly sales data for Joe's Stone Crab. We have been hired to develop a forecasting model that will predict future sales for 2018 using the time-series seasonal adjustment method. Assume that data is only available through the end of 2017.

Make sure to include the 2018 forecast by month, as well as the trend, the seasonal factors, and the error measurements!

Sales data are in thousands of dollars per month and the forecast should be in the same units. Do not add zeros to the data.

	2014	2015	2016	2017
Sales	in thousands of dollars	in thousands of dollars	in thousands of dollars)	in thousands of dollars
January	242	263	282	306
February	235	238	255	280
March	232	247	245	270
April	178	191	205	210
May	184	193	210	214
June	140	149	160	175
July	145	157	165	182
August	152	160	175	193
September	110	122	126	130
October	130	130	148	155
November	152	167	173	182
December	206	230	235	255

Expert Solution

I HOPE ITS HELPFUL TO YOU IF YOU HAVE ANY DOUBTS PLS COMMENTS BELOW..I WILL BE THERE TO HELP YOU...ALL THE BEST...

ANSWER:

As per question given

Joe Stone Carb
Annual Business Plan FY 2016							Month-wise seasonality FY2013-14			11.49%	11.16%	11.02%	8.45%	8.74%	6.65%	6.89%	7.22%	5.22%	6.17%	7.22%	9.78%	100.00%
Historcal Data - FY 2016							Month-wise seasonality FY2014-15			11.70%	10.59%	10.99%	8.50%	8.59%	6.63%	6.99%	7.12%	5.43%	5.79%	7.43%	10.24%	100.00%
Revenues - Retail ( INR, Gross inclusive of VAT, Net of Discounts)							Month-wise seasonality FY2015-16			11.85%	10.72%	10.30%	8.62%	8.83%	6.73%	6.94%	7.36%	5.30%	6.22%	7.27%	9.88%	100.00%
							Month-wise seasonality FY2016-17			11.99%	10.97%	10.58%	8.23%	8.39%	6.86%	7.13%	7.56%	5.09%	6.07%	7.13%	9.99%	100.00%
							Month-wise seasonality FY2017-18			11.30%	10.67%	10.49%	8.20%	8.02%	6.88%	7.17%	8.17%	5.22%	6.62%	7.14%	10.12%	100.00%
Sl.	Store Code	Brand	Mall	City	Carpet Area	Date of Opening	Avg Comp FY2014-15	Avg Comp FY2015-16	Avg Comp FY2016-17	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Sep-18	Oct-18	Nov-18	Dec-18	Full Year Total
1	001	Joe's Stone Carb	High Street	New York		1-Apr-11	-100.00%	0.00%	0.00%	307	290	285	223	218	187	195	222	142	180	194	275	2,718
	GRAND TOTAL				-					307	290	285	223	218	187	195	222	142	180	194	275	2,718

Joe Stone Carb
Annual Business Plan FY 2016					Month-wise seasonality FY2013-14	11.49%	11.16%	11.02%	8.45%	8.74%	6.65%	6.89%	7.22%	5.22%	6.17%	7.22%	9.78%	100.00%
Historcal Data - FY 2016					Month-wise seasonality FY2014-15	11.70%	10.59%	10.99%	8.50%	8.59%	6.63%	6.99%	7.12%	5.43%	5.79%	7.43%	10.24%	100.00%
Revenues - Retail ( INR, Gross inclusive of VAT, Net of Discounts)											Month-wise seasonality FY2015-16	11.85%	10.72%	10.30%	8.62%	8.83%	6.73%	6.94%	7.36%	5.30%	6.22%	7.27%	9.88%	100.00%
					Month-wise seasonality FY2016-17	11.99%	10.97%	10.58%	8.23%	8.39%	6.86%	7.13%	7.56%	5.09%	6.07%	7.13%	9.99%	100.00%
Sl.	Store Code	Brand	Mall	City	Avg Comp FY2016-17	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17	Oct-17	Nov-17	Dec-17	Full Year Total
1	001	Joe's Stone Carb	High Street	New York	0.00%	306	280	270	210	214	175	182	193	130	155	182	255	2,552
	GRAND TOTAL					306	280	270	210	214	175	182	193	130	155	182	255	2,552

Joe Stone Carb
Annual Business Plan FY 2016
Historcal Data - FY 2016									Month-wise seasonality FY2013-14			11.49%	11.16%	11.02%	8.45%	8.74%	6.65%	6.89%	7.22%	5.22%	6.17%	7.22%	9.78%	100.00%
Revenues - Retail ( INR, Gross inclusive of VAT, Net of Discounts)									Month-wise seasonality FY2014-15			11.70%	10.59%	10.99%	8.50%	8.59%	6.63%	6.99%	7.12%	5.43%	5.79%	7.43%	10.24%	100.00%
									Month-wise seasonality FY2015-16			11.85%	10.72%	10.30%	8.62%	8.83%	6.73%	6.94%	7.36%	5.30%	6.22%	7.27%	9.88%	100.00%
Sl.	Store Code	Brand	Mall	City	Carpet Area	Date of Opening	Avg SPSF FY2013-14	Avg SPSF FY2014-15	Avg SPSF FY2015-16	Avg Comp FY2014-15	Avg Comp FY2015-16	Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16	Oct-16	Nov-16	Dec-16	Full Year Total
1	001	Joe's Stone Carb	High Street	New York	-	1-Apr-11	0	-	-	-100.00%	0.00%	282	255	245	205	210	160	165	175	126	148	173	235	2,379
	GRAND TOTAL				-							282	255	245	205	210	160	165	175	126	148	173	235	2,379

I HOPE YOU UNDERSTAND...

PLS RATE THUMBS UP....ITS HELPS ME ALOT...

THANK YOU...!!

orchestra answered 1 year ago

What would be the project scope ? We have been hired to develop a sales training...

What would be the project scope ? We have been hired to develop a sales training course for 250 sales associates that will be working the floor of an electronics shop. This will be our first endeavor in retail training, sowe must adapt one of our existing training models and customize it to meet the needs of the customer. The company’s electronic shop department has a high volume of sales. As a result they need to develop a training course...

You have been given the balance sheet (next page) for Roxbury Savings Bank and have been...

You have been given the balance sheet (next page) for Roxbury Savings Bank and have been asked for your assessment of its capital adequacy. You have been told it has no off-balance sheet activities. What is its: Tier 1 capital? Tier 1 and 2 capital? Risk-weighted assets? (You can put your answer on the next page with the balance sheet.) Ratio of Tier 1 capital to its i) total assets and ii) total risk-weighted assets? Ratio of Tier 1 and...

You have been hired to promote the work of a local organization that provides services to...

You have been hired to promote the work of a local organization that provides services to troubled teenagers. Before beginning your job, you have been told that the organization cannot engage in advertising due to the sources of its funding. What other promotional options can you use in spite of the lack of budget?

You have been hired as the manager of a community health center. This health center provides...

You have been hired as the manager of a community health center. This health center provides medical care to children. One of your first tasks is to develop a static annual budget for the health center. In fact, the Board of Directors wants to see your budget by Saturday at midnight. In order to develop an accurate static budget you know you need to get some facts. You ask around to see what kind of information you can gather. *This...

You have been hired as the Controller at Coastline, Inc. to prepare the monthly adjusting journal...

You have been hired as the Controller at Coastline, Inc. to prepare the monthly adjusting journal entries, if necessary, as part of the accounting cycle. Your junior accountant asks you to explain: Why adjusting journal entries are important / necessary in the accounting cycle process? What are the four categories of adjusting journal entries per U.S. GAAP?

Phyton Question: You have been hired to create a program that computes that Monthly Net Pay...

Phyton Question: You have been hired to create a program that computes that Monthly Net Pay for a worker after acquiring from the user their Annual Gross Salary. The deductions that are to be considered are an Income Tax of 22.5%, a Social Security Tax of 6.2%, and a Medicare Tax of 1.45%. The program should end by displaying the Monthly Net Pay to the user. Design the algorithm for this program using your preferred method of representation (Pseudocode OR...

(Marketing in Healthcare) You have just been hired as the Executive Vice President of Sales and...

(Marketing in Healthcare) You have just been hired as the Executive Vice President of Sales and Marketing for a national HMO company that until recently was very successful (both revenue and profit growth) selling traditional HMO plans as its only product. During the last two years, revenue and profits declined, and new sales have slowed dramatically. The Board and CEO of the company recruited you to help the company achieve a strategic goal of 15% growth in revenue and profits...

You have just been hired as a management trainee by Cravat Sales Company, a nationwide distributor...

You have just been hired as a management trainee by Cravat Sales Company, a nationwide distributor of a designer’s silk ties. The company has an exclusive franchise on the distribution of the ties, and sales have grown so rapidly over the last few years that it has become necessary to add new members to the management team. You have been given responsibility for all planning and budgeting. Your first assignment is to prepare a master budget for the next three...

You have just been hired as a management trainee by Cravat Sales Company, a nationwide distributor...

You have just been hired as a management trainee by Cravat Sales Company, a nationwide distributor of a designer’s silk ties. The company has an exclusive franchise on the distribution of the ties, and sales have grown so rapidly over the last few years that it has become necessary to add new members to the management team. You have been given responsibility for all planning and budgeting. Your first assignment is to prepare a master budget for the next three...

assume you have been hired as the national sales manager for a newly formed electronics distributor....

assume you have been hired as the national sales manager for a newly formed electronics distributor. your salesforce will sell directly to electronics retailers. although the company is not widely known, it will use little other than the salesforce to promote its products in a highly competitive market. thus, salespeople’s skills are very important. salespeople will be responsible for providing complete customer service, including handling damage claims, helping with merchandising, providing advice, and following up after the sale to ensure...

Question

The next page provides the monthly sales data for Joe's Stone Crab. We have been hired...

Solutions

Expert Solution

Related Solutions

What would be the project scope ? We have been hired to develop a sales training...

You have been given the balance sheet (next page) for Roxbury Savings Bank and have been...

You have been hired to promote the work of a local organization that provides services to...

You have been hired as the manager of a community health center. This health center provides...

You have been hired as the Controller at Coastline, Inc. to prepare the monthly adjusting journal...

Phyton Question: You have been hired to create a program that computes that Monthly Net Pay...

(Marketing in Healthcare) You have just been hired as the Executive Vice President of Sales and...

You have just been hired as a management trainee by Cravat Sales Company, a nationwide distributor...

You have just been hired as a management trainee by Cravat Sales Company, a nationwide distributor...

assume you have been hired as the national sales manager for a newly formed electronics distributor....