Assignment on Binary Programming

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?

GRADING $-$ Algebraic Modeling $-25$

Points

Solving Using Excel $-25$ Points