Question

Michelle runs a bakery that sells two kinds of cookies. Michelle knows the bakery must make at least 10 and at most 48 trays of the Nutty Squirrels. The bakery must also make between 3 and 72 trays of the Chocolate Decadence. The trays of Nutty Squirrels take 9 ounces of flour, while trays of Chocolate Decadence require 8 ounces of flour. The bakery only has 864 ounces of flour available. If trays of Nutty Squirrels generate $1.82 in profit, and trays of Chocolate Decadence generate $2.54, how many trays of the cookies should Michelle have the bakery make to get the most profit?

Nutty Squirrels:
Chocolate Decadence:
Best profit:

Answer 1

Enter the data into excel as follows:

The cells B2 and D2 are the variable cells which are the number of trays of each cookie. We do not need to enter anything into these cells at the start

The constraints and maximize function is written in the subsequent rows. We will use SOLVER to solve the linear programming model

Go to Data -> Solver and input the data as follows:

The results are as follows:

Nutty Squirrels: 32
Chocolate Decadence: 72
Best profit: 241.12