Question

Assignment Brief
You have been appointed as a business analyst at Carlson Department Store. Your first project is to provide an analysis for an insurance claim for the company’s loss of sales for quarter 4 of last year due to a hurricane last summer. In your analysis, you are to make appropriate recommendations in relation to sales the company would have had.

A. Background
The Carlson Department Store suffered heavy damage after a hurricane struck late last summer. The store was closed for four months (September through December), and the company is now involved in a dispute with its insurance company about the amount of lost sales during the time the store was closed. Two key issues must be resolved: (a) The amount of sales Carlson would have made if the hurricane had not struck and (b) whether the company is entitled to any compensation for potential excess sales due to increase in business activity after the storm, which would have occurred if the store had not been damaged. This is because more than 8 billion dollars in federal disaster relief and insurance money came into the county, resulting in increased sales at department stores and numerous other businesses.
As a business analyst for the case, you are provided with 48 months of Carlson’s total sales data preceding the storm for their department store in the county; you are also given countywide total sales for all department stores in the months the Carlson Department Store was closed. The data file dataForProject.xlsx is available on Titanium.

B. Tasks
Carlson’s managers asked you to
o analyze these data and develop estimates of the lost sales at the Carlson Department Store for the months of September, October, November and December.
o determine whether a case can be made for excess storm-related sales during the same period. If such a case can be made, the company is entitled to compensation for excess sales it would have earned in addition to ordinary sales.

o From your analysis, you are to produce a managerial report that summarizes your findings, forecasts and recommendations. Your report must include the following:
a. An estimate of sales for Carlson Department Store had there been no hurricane.
b. An estimate of countywide department store sales had there been no hurricane.
c. An estimate of lost sales for the Carlson Department Store for September, October, November and December of last year.
d. Use the countywide actual department stores sales for September through December and the estimate in part (b) to make a case for or against excess storm-related sales.

C. Project Requirements
o You are to use appropriate forecasting technique(s) to analyze the sales data using Microsoft Excel (10 points)
a. The forecast should accurately represent the current situation and allow you to explore and evaluate the company’s lost sales.
b. The results should provide information to assist you in writing your report addressing the issues required above.
c. Using the submission section on Titanium, submit a copy of your Excel analyses.
o You are to produce one report (800 words) summarizing your evaluation of the analysis results for the company (10 points)
a. The report must address the questions listed under the Tasks section.
b. The report must be written in a narrative style. Do not use bullet points to answer the listed questions (points will be deducted if you do so).
c. Submit your report (in Microsoft Word) via Titanium using the assignment submission section.

1. 1. 2 4 1. 1. 2. 1. 222 2. 1. 2 2 4 2 1. 2 2 2 2 2. 2 1. 2 2 4 2 1: 2 2 2 2 2 2 2 2 2 4 2 2 2 2 2 2 2. Bel 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 444455555555 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 2 3 4 5 6 7 8 THE 40 40 60 80 00 00 60 80 20 40 00 60 40 40 00 60 40 20 60 00 80 80 60 40 00 80 60 60 40 40 80 60 40 60 80 20 00 60 60 20 00 00 60 80 00 00 20 80 55 56 71 112 46 48 60 57 61 58 63 ST 53 7 46 40, 59 60 55 51 8 4 54 65 4 5 5 5 56 5 5 6 7 5 6 48 51 5 8 6 7 5 6 63 75 85 izi e11112222222222223333333333334444444444445555555555u ,-5 6 7 8⑦ 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 3 4 4 2 3 4 5 6 7 8 9 50 553E

Answer 1

B Tass to eaamine the feittear) of sles to uteamive 'ew best 5 4.5 3 2.5 r.s o.S an average of the galeg of these nomHy 7n pasca o1.592 November 1274 | 2.56 | 2.82| 2 222.78

sales data fas all depsatmert trxes oppeaas to are a seasonal pattern bct ret a clea toend ne γ→lp no huas icane by ging the cumny vauiable wethed mon情 56.40 53-40 Sy. 6054.60 Sy7 ve frseast of lost Sales fes depostirent c; compore the actual outayout de Sale fo tte lost four months of yeay 5 uth he Roeasted soles aming nd hostcane. The dょfeecos cared form 12% up to 37 Bon the huaaicane. duicave Anemvel 2-M | 2.56 | 2.82 4.69

As per HomeworkLib policy we need to solve one question per post. Please post the remaining questions in another post.