! Please All problems must be solved using Excel formulas !

Question Set 1. A manager has tracked days worked and Donuts sold as given below.

	Days Worked
Seasons	Winter		Spring			Summer			Autumn			Winter
Cashier	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Larry	35		29	16	2			13	9		12
Brenda		28			12		22			19		13
Gene			22	15	7	21	21	21		20
Tim		26			11				26		14
George			26				34			20		22
Karen		28		12	18				24
	Donuts Sold
Seasons	Winter		Spring			Summer			Autumn			Winter
Cashier	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Larry	478		124	472	23			235	162		274
Brenda		601			289		288			565		156
Gene			376	127	38	547	414	72		276
Tim		534			412				159		264
George			345				396			266		298
Karen		572		364	45				252

1. For each cashier, compute his or her overall productivity (in Donuts sold per day) for Spring and Summer. You should have one number per cashier.

2. For each cashier, compute his or her productivity (in Donuts sold per day) for Autumn. Using the MAX function, find the highest productive cashier for the Autumn among the cashiers.

3. Compute the overall productivity for each cashier (in Donuts sold per day) for the entire year. Use the MIN function to find the lowest productive cashier for the year among the cashiers.

4. Which month has the lowest overall productivity?