Question

Prestige Press
1st Quarter Sales Report
		January		February		March		Total
	Price	Units Sold	Sales	Units Sold	Sales	Units Sold	Sales	Units Sold	Sales	Percent Sales
Northeastern	9.25	13,000	$         120,250	20,000	$         185,000	45,000	$         416,250	78,000	$         721,500	25%
Midwestern	9.25	9,250	$            85,563	15,000	$         138,750	35,000	$         323,750	59,250	$         548,063	19%
Southeastern	9.25	7,980	$            73,815	13,250	$         122,563	37,000	$         342,250	58,230	$         538,628	19%
Southern	9.25	7,575	$            70,069	15,000	$         138,750	36,500	$         337,625	59,075	$         546,444	19%
Western	9.25	6,250	$            57,813	15,000	$         138,750	35,000	$         323,750	56,250	$         520,313	18%
Total		44,055	$         407,510	78,250	$         723,813	188,500	$     1,743,625	310,805	$     2,874,948	100%

1. What is wrong with the sales for each month and in total, the percentage of sales breakdown, and the total row. 50words

2. Address one way that you can quickly look at any file your coworker creates and see visually every formula they entered in the file. Hint, try it on this one, and you'll immediately see where numbers were hard keyed. 50words

Answer 1

1. The contribution of Northeastern has been more in the month of January than other February and March months. The other reasons has improved through the sales after January month. The total sale of the company has been improving from January month to March month. Regions has been improving every month further. The gap of sales distribution has been reduced month by month.

2. The formula set in the first row is being checked with the other rows of the sales figures and the final distribution of the sales between the month can be checked with the individual sales and distribution to find out the difference in sales. The individual sales of each region in the same month can be checked with each month’s sales and distribution to find out difference in calculation.