What is an appropriate formula to insert in cell B$14?$

$=5SM(B12$:$D12)$

$=$ SUMPRODUCT$($B$7$:D$7,$B$12$:D$12)$

$=$SUMPRODUCT$($BS:DR$,$B$12$:D$12)$

None of the above are correct

Questiq $28(3$ po ints$)$

i

Which of the following statements is correct?

All th ree constraints are binding.

The constraint for cost is binding.

The constraints for labor and cost are binding.

The constraint for machine time is binding. Billy's company sells $3$ types of T$-$shirts: Astro, Bling, and Curious. Manufacturing Astros requires $2$ minutes of machine time and $20$ minutes of labor, and costs $$10.$ Brand Bling requires $2\mathrm{.}5$ minutes of machine time and $30$ minutes of labor, and costs $$14$ to produce. Brand Curious requires $3$ minutes of machine time and $45$ minutes of labor, and costs $$18$ to produce. There are $300$ machining minutes available per day, $3750$ labor minutes, and he has a budget of $$3000.$ Brand Astro sells for $$15,$ Brand Bling for $$18,$ and Brand Curious for $$25.$ To maximize daily revenue, Billy builds the following Excel spreadsheet model to help determine the optimal production plan. In addition, the sensitivity report is also generated to facilitate the analysis.Excel spreadsheet model: