Section $3-$ Short Answer with Calculation Questions

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 profit, 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:

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$,$G$],[1,$Test $1-$ Section $3,,,,,,],[2,,,,,,,],[3,$Inputs,,,,,,$],[4,,$Astro,Bling,Curious,Total used,,Availability$],[5,$Machine time $($minutes$),2,2\mathrm{.}5,3,$$$00,,300],[6,$Labor $($minutes$),20,30,45,3750,,3750]]$