Gene Monteagudo is a district manager for the Pizza Time chain of pizzerias. His promotion to regional manager means he must select one of his current unit managers to fill his district manager$$s $($now vacant$)$ position. Gene will choose from among the managers in the six units that make up his district. He wants to promote the unit manager who is most effective at generating revenue using his target of $$290\mathrm{.}00$ annual revenue per square foot of operation size and a $$45\mathrm{.}00$ revenue goal for each hour of variable labor utilized. Each unit$$s size in square feet $($SF$)$ as well as its average monthly variable labor hour usage and revenue has been calculated and placed in the Monteagudo District Results chart below. Review the operating information Gene has collected and then design and complete a spreadsheet that can help you answer the questions that follow.

Unit Location Unit SF Variable Labor Hours Per Month Average Revenue Per Month Annual Revenue Per Square foot Revenue Per Variable Labor Hour

Chippewa Falls $78071019,750$ Q$1$

Altoona $110058026,750$ Q$4$

White Creek $155080030,500$ Q$2$

Cadot $12007309,750$ Q$5$

Augusta $140091031,750$ Q$3$

Clair $122549523,750$

Average Q$6$ Q$7$