A franchise operation that sells frozen custard

intends to open one or more new stores in a

medium$-$sized metropolitan area. Three sites

are under consideration. Each site has

somewhat different projected profit

contribution and different supervision

requirements. The first site has an estimated

daily profit of $$200$ and a weekly supervision

requirement of $48$ hours; the second site has a

projected profit of $$100$ per day and a weekly

supervision requirement of $30$ hours; and the

third site has an estimated daily profit of $$150$

and a weekly supervision requirement of $20$

hours. The firm will have $65$ hours available for

per week for supervision.

Use Excel to determine which site or sites

should be selected in order to obtain the

highest projected daily profit?