You have had your small bakery running for a couple years now and are ready to try optimizing your productior to maximize revenue. You have determined the minimum number of cakes, cookies, and pies to produce this month (shown below) and the ingredients for each product is also known. Unfortunately, you are limited by how much inventory you have. With that information, maximize your revenue and enter the total number of ounces of Oil used (keep one decimal place). Use Scenario 1 Note: This is a much larger problem than will be on any quiz or exam. It will use the same template with the same SUMPRODUCT function - it just has more constraints. But it lets you get a feel for the work it takes to properly set up a more complicated problem. \begin{tabular}{|l|l|r|r|r|r|} \hline Cookie & Sugar & .25 & .33 & .5 & 1 \\ \hline Pie & Flour (cups) & 1.5 & 1 & 1 & 1.5 \\ \hline Pie & Eggs & 1 & 1 & 1 & 1 \\ \hline Pie & Oil & .75 & .5 & .75 & .75 \\ \hline Pie & Sugar & 1 & 1 & 1 & 1 \\ \hline & Flour (max) & 2,000 & 2,000 & 1,500 & 2,250 \\ \hline & Eggs (max) & 1,600 & 1,600 & 1,100 & 1,200 \\ \hline & Oil (max) & 650 & 500 & 700 & 800 \\ \hline & Sugar (max) & 500 & 800 & 700 & 1,400 \\ \hline Cakes & & 100 & 100 & 125 & 125 \\ \hline Cake Price & & 19.95 & 23.95 & 14.95 & 11.95 \\ \hline Cookies & & 1,200 & 1,200 & 1,000 & 1,000 \\ \hline Cookie & & 0.79 & 0.99 & 1.99 & 2.50 \\ \hline Price & & 16.95 & 19.95 & 19.95 & 17.95 \\ \hline Pies & & 50 & 50 & 120 & 120 \\ \hline Pie Price & & & & & \\ \hline \end{tabular} You have had your small bakery running for a couple years now and are ready to try optimizing your productior to maximize revenue. You have determined the minimum number of cakes, cookies, and pies to produce this month (shown below) and the ingredients for each product is also known. Unfortunately, you are limited by how much inventory you have. With that information, maximize your revenue and enter the total number of ounces of Oil used (keep one decimal place). Use Scenario 1 Note: This is a much larger problem than will be on any quiz or exam. It will use the same template with the same SUMPRODUCT function - it just has more constraints. But it lets you get a feel for the work it takes to properly set up a more complicated problem. \begin{tabular}{|l|l|r|r|r|r|} \hline Cookie & Sugar & .25 & .33 & .5 & 1 \\ \hline Pie & Flour (cups) & 1.5 & 1 & 1 & 1.5 \\ \hline Pie & Eggs & 1 & 1 & 1 & 1 \\ \hline Pie & Oil & .75 & .5 & .75 & .75 \\ \hline Pie & Sugar & 1 & 1 & 1 & 1 \\ \hline & Flour (max) & 2,000 & 2,000 & 1,500 & 2,250 \\ \hline & Eggs (max) & 1,600 & 1,600 & 1,100 & 1,200 \\ \hline & Oil (max) & 650 & 500 & 700 & 800 \\ \hline & Sugar (max) & 500 & 800 & 700 & 1,400 \\ \hline Cakes & & 100 & 100 & 125 & 125 \\ \hline Cake Price & & 19.95 & 23.95 & 14.95 & 11.95 \\ \hline Cookies & & 1,200 & 1,200 & 1,000 & 1,000 \\ \hline Cookie & & 0.79 & 0.99 & 1.99 & 2.50 \\ \hline Price & & 16.95 & 19.95 & 19.95 & 17.95 \\ \hline Pies & & 50 & 50 & 120 & 120 \\ \hline Pie Price & & & & & \\ \hline \end{tabular}