1. Using the schedule below, enter the numerator and denominator of each of the six ratios to be calculated. Enter the numerator and denominator in yellow highlighted areas. You must show the numerator and denominator to earn the points.
2. Calculate the ratio and enter under the store name. Enter the ratios in the green cells. Consider using Excel formulas to calculate the ratios.
		This is a fraction
($ in millions)		numerator
		denominator
				Kohls					Dillards
Gross profit ratio	=		=		percent			=		percent
Inventory turnover	=		=		times			=		times
Average days in inventory	=		=		days			=		days