Instructions: ProblemType

CELL

CELL

CELL

CELL

WorksheetName

Chapter $11$s ICA

Chapter $11$s ICA

Chapter $11$s ICA

C

Range

B$3$

C$20$

C$2$O

In cell $B3,$ enter your full name.

Problem:

Jamal Smith, the owner of Lobster Tail Inc., a seafood distributor, in Portland, ME$,$ likes to track inventory by inventory turnover.

In cell C$20,$ enter a formula that will calculate the number of inventory turns per year based on the data in B$15$:C$18.$

Note: You must only use cell references here. No hardcoding.