Question: Please provide the Excel formulas for the below A A B D D E F 3 4 5 6 7 8 9 10 11 Your

Please provide the Excel formulas for the below

Please provide the Excel formulas for the below A

A A B D D E F 3 4 5 6 7 8 9 10 11 Your bakery makes a variety of products: cookies, cupcakes, muffins, and donuts. You want to maximize your profit by optimizing the mix of products you make. You cannot use any more materials or labor than is available, nor do you want to make more goods than the amount that is demanded because the excess would go to waste. You only make batches of a complete dozen, so make sure the changing cells are integers. Use Solver to calculate the optimal number of dozens of product to make. Cookies Cupcakes Muffins 125 163 400 600 500 400 Donuts 293 Produced in dozens Demand in dozens 300 Price/Dozen Cost/Dozen Profit/Dozen $2.50 $1.80 $0.70 $3.25 $1.50 $1.75 $3.50 $2.00 $1.50 $5.00 $2.70 $2.30 0.5 1.75 0.3 3.25 0.75 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Materials used per dozen Flour Sugar Eggs Butter Chocolate Chips Labor Hours N 0.3 0.4 0.2 0.5 0.5 1.25 0.75 1 0.3 0 0.4 1 0.25 0.5 0.4 0.25 0 0.6 Flour Sugar Eggs Butter Chocolate Chips Labor Hours Used 1920 500 1200 247 262 464 Available 2000 500 1200 500 600 800 Profit $1,648.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!