A furniture cabinet maker produces two types of cabinets that house and hide plasma televisions. The Mission$-$style cabinet requires $$340$ in materials and $15$ labor hours to produce, and it yields a profit of $$910$ per cabinet. The Rustic$-$style cabinet requires $$430$ in materials and $20$ hours to produce, and it yields a profit of $$1,200.$ The firm has a budget of $$30,000$ to spend on materials. To ensure full employment, the firm wishes to plan to maximize its profit but at the same time to keep all $30$ workers fully employed, so all $1,200$ available labor hours available must be used. What is the best combination of furniture cabinets to be made?

In addition to uploading the solution in the solutions view, take a screenshot or PDF of the formula view and upload it as well.

You are required to provide a written answer to the specific questions asked, to show that you understand how to interpret the spreadsheet solution. Failure to do so will result in a deduction of $10$ points. An example of the written answer is: The number of units needed to breakeven is $10,000$ units and the breakeven dollar amount is $$50,000$

PLEASE ANSWER THIS IN EXCEL WITH THE FORMAT REQUIRED. I PUT ZEROS SO YOU CAN SEE WHEN THERE IS A DOLLAR SIGN OR NOT. ALSO, MAKE SURE YOU INCLUDE THE FORMULA VIEW I NEED TO ALSO UPLOAD.

Thank you so much, I will vote you!

Problem $2-26$

$\backslash$table$[[,0,0,,,],[,0\mathrm{.}00,0\mathrm{.}00,,,],[,$$$0,$$$0,$$$0\mathrm{.}00,,],[,0,0,0,0,0],[,0,0,0\mathrm{.}00,0,0],[,0,0,0\mathrm{.}00,0,0],[,,,$LHS$,$Sign,RHS$]]$