• NWT Ltd. has 150 employees and operates in 4 communities

• The fiscal year runs from April 1 to March 31.
• Sales are generated from 11 products with varying levels of success.
• Total sales at one location have suffered greatly over the past 4 years.
• Management shuffled some staff between locations in response to fluctuations in sales.
• Management is considering closing one of its locations
  • Based on total sales at that location
• Management is considering discontinuing sales of one product.
  • Based on the one product with the largest percentage decrease since 2014-15 (compare 2014-15 and 2017-18, only) for the entire company.

1. Propose to Management that one of its locations be closed and that one of its products be discontinued. Ensure to identify the proposed Location and Product Name.
2. Comment on data and observations and connections made within the data.
3. There was an error in product sales revenue; they were all overstated by 10%. Insert a new column in the “Historical Sales Data” Tab and use formulas to correct the 10% overstatement for each product sales and round each result to the “nearest dollar”

4. Create a table showing (corrected) location sales per fiscal year

5. Create a table showing each (corrected) totaled product sales per fiscal year

6. Create one table showing “Product Beta” (corrected) sales by location per fiscal year

Date	Location	Product	Sales	Fiscal Year
04/01/14	Yellowknife	Product Alpha	28,226.00	2014-15
05/01/14	Yellowknife	Product Alpha	38,492.00	2014-15
06/01/14	Yellowknife	Product Alpha	7,617.00	2014-15
07/01/14	Yellowknife	Product Alpha	27,680.00	2014-15
08/01/14	Yellowknife	Product Alpha	66,244.00	2014-15
09/01/14	Yellowknife	Product Alpha	24,507.00	2014-15
10/01/14	Yellowknife	Product Alpha	19,679.00	2014-15
11/01/14	Yellowknife	Product Alpha	54,597.00	2014-15
12/01/14	Yellowknife	Product Alpha	26,681.00	2014-15
01/01/15	Yellowknife	Product Alpha	38,071.00	2014-15
02/01/15	Yellowknife	Product Alpha	29,299.00	2014-15
03/01/15	Yellowknife	Product Alpha	54,738.00	2014-15
04/01/15	Yellowknife	Product Alpha	30,222.00	2015-16
05/01/15	Yellowknife	Product Alpha	29,460.00	2015-16
06/01/15	Yellowknife	Product Alpha	18,205.00	2015-16
07/01/15	Yellowknife	Product Alpha	40,533.00	2015-16
08/01/15	Yellowknife	Product Alpha	36,401.00	2015-16
09/01/15	Yellowknife	Product Alpha	23,216.00	2015-16
10/01/15	Yellowknife	Product Alpha	20,275.00	2015-16
11/01/15	Yellowknife	Product Alpha	158,941.00	2015-16
12/01/15	Yellowknife	Product Alpha	80,957.00	2015-16
01/01/16	Yellowknife	Product Alpha	67,917.00	2015-16
02/01/16	Yellowknife	Product Alpha	55,654.00	2015-16
03/01/16	Yellowknife	Product Alpha	32,975.00	2015-16
04/01/16	Yellowknife	Product Alpha	78,982.00	2016-17
05/01/16	Yellowknife	Product Alpha	60,084.00	2016-17
06/01/16	Yellowknife	Product Alpha	97,055.00	2016-17
07/01/16	Yellowknife	Product Alpha	40,576.00	2016-17
08/01/16	Yellowknife	Product Alpha	58,148.00	2016-17
09/01/16	Yellowknife	Product Alpha	93,661.00	2016-17
10/01/16	Yellowknife	Product Alpha	43,941.00	2016-17
11/01/16	Yellowknife	Product Alpha	91,028.00	2016-17
12/01/16	Yellowknife	Product Alpha	61,194.00	2016-17
01/01/17	Yellowknife	Product Alpha	88,888.00	2016-17
02/01/17	Yellowknife	Product Alpha	90,676.00	2016-17
03/01/17	Yellowknife	Product Alpha	28,369.00	2016-17
04/01/17	Yellowknife	Product Alpha	72,259.00	2017-18
05/01/17	Yellowknife	Product Alpha	94,382.00	2017-18
06/01/17	Yellowknife	Product Alpha	53,781.00	2017-18
07/01/17	Yellowknife	Product Alpha	84,728.00	2017-18
08/01/17	Yellowknife	Product Alpha	81,563.00	2017-18
09/01/17	Yellowknife	Product Alpha	85,673.00	2017-18
10/01/17	Yellowknife	Product Alpha	32,497.00	2017-18
11/01/17	Yellowknife	Product Alpha	139,354.00	2017-18
12/01/17	Yellowknife	Product Alpha	106,959.00	2017-18
01/01/18	Yellowknife	Product Alpha	71,450.00	2017-18
02/01/18	Yellowknife	Product Alpha	89,451.00	2017-18
03/01/18	Yellowknife	Product Alpha	48,489.00	2017-18
04/01/14	Yellowknife	Product Beta	33,895.00	2014-15
05/01/14	Yellowknife	Product Beta	27,467.00	2014-15
06/01/14	Yellowknife	Product Beta	34,792.00	2014-15
07/01/14	Yellowknife	Product Beta	28,815.00	2014-15
08/01/14	Yellowknife	Product Beta	47,453.00	2014-15
09/01/14	Yellowknife	Product Beta	12,408.00	2014-15
10/01/14	Yellowknife	Product Beta	7,558.00	2014-15
11/01/14	Yellowknife	Product Beta	16,568.00	2014-15
12/01/14	Yellowknife	Product Beta	31,414.00	2014-15
01/01/15	Yellowknife	Product Beta	23,540.00	2014-15
02/01/15	Yellowknife	Product Beta	56,701.00	2014-15
03/01/15	Yellowknife	Product Beta	16,867.00	2014-15
04/01/15	Yellowknife	Product Beta	24,918.00	2015-16
05/01/15	Yellowknife	Product Beta	25,662.00	2015-16
06/01/15	Yellowknife	Product Beta	18,976.00	2015-16
07/01/15	Yellowknife	Product Beta	13,778.00	2015-16
08/01/15	Yellowknife	Product Beta	15,473.00	2015-16
09/01/15	Yellowknife	Product Beta	21,612.00	2015-16
10/01/15	Yellowknife	Product Beta	13,507.00	2015-16
11/01/15	Yellowknife	Product Beta	521,143.00	2015-16
12/01/15	Yellowknife	Product Beta	200,866.00	2015-16
01/01/16	Yellowknife	Product Beta	118,437.00	2015-16
02/01/16	Yellowknife	Product Beta	148,669.00	2015-16
03/01/16	Yellowknife	Product Beta	112,100.00	2015-16
04/01/16	Yellowknife	Product Beta	121,038.00	2016-17
05/01/16	Yellowknife	Product Beta	236,200.00	2016-17
06/01/16	Yellowknife	Product Beta	232,111.00	2016-17
07/01/16	Yellowknife	Product Beta	135,498.00	2016-17
08/01/16	Yellowknife	Product Beta	236,968.00	2016-17
09/01/16	Yellowknife	Product Beta	196,433.00	2016-17
10/01/16	Yellowknife	Product Beta	191,507.00	2016-17
11/01/16	Yellowknife	Product Beta	199,323.00	2016-17
12/01/16	Yellowknife	Product Beta	75,292.00	2016-17
01/01/17	Yellowknife	Product Beta	154,490.00	2016-17
02/01/17	Yellowknife	Product Beta	261,841.00	2016-17
03/01/17	Yellowknife	Product Beta	62,965.00	2016-17
04/01/17	Yellowknife	Product Beta	558,201.00	2017-18
05/01/17	Yellowknife	Product Beta	294,389.00	2017-18
06/01/17	Yellowknife	Product Beta	236,429.00	2017-18
07/01/17	Yellowknife	Product Beta	393,363.00	2017-18
08/01/17	Yellowknife	Product Beta	465,991.00	2017-18

Transcribed Image Text:

Table 1: NWT Ltd. Location and Staffing Complement Location 2014-15 2015-16 2016-17 2017-18 Invuik 27 22 22 22 Yellowknife Fort Simpson 30 30 30 28 38 36 34 30 Hay River Number of employees 55 62 64 70 150 150 150 150 Table 1: NWT Ltd. Location and Staffing Complement Location 2014-15 2015-16 2016-17 2017-18 Invuik 27 22 22 22 Yellowknife Fort Simpson 30 30 30 28 38 36 34 30 Hay River Number of employees 55 62 64 70 150 150 150 150

Answer rating: 100% (QA)

PURPOSE Location to be Closed and products to be discontinued Hay River should be closed Based on Appendix A Hay River sales are stagnated since they rose to 92 073 37100 from 91085 73500 in 201415201... View the full answer