Question
Janette Douglas is coordinating a bake sale for a nonprofit organization. The organization has acquired $2,200 in donations to hold the sale. The table below
Janette Douglas is coordinating a bake sale for a nonprofit organization. The organization has acquired $2,200 in donations to hold the sale. The table below shows the amounts and costs of ingredients used per batch of each baked good:
Ingredient | Brownies | Cupcakes | Peanut Butter Cups | Shortbread Cookies | Cost/Unit |
---|---|---|---|---|---|
Butter (cups) | 0.67 | 0.33 | 1 | 0.75 | $1.44 |
Flour (cups) | 1.5 | 1.5 | 1.25 | 2 | $0.09 |
Sugar (cups) | 1.75 | 1 | 2 | 0.25 | $0.16 |
Vanilla (tsp) | 2 | 0.5 | 0 | 0 | $0.06 |
Eggs | 3 | 2 | 1 | 0 | $0.12 |
Walnuts (cups) | 2 | 0 | 0 | 0 | $0.31 |
Milk (cups) | 0.5 | 1 | 2 | 0 | $0.05 |
Chocolate (oz) | 8 | 2.5 | 9 | 0 | $0.10 |
Baking soda (tsp) | 2 | 1 | 0 | 0 | $0.07 |
Frosting (cups) | 0.5 | 1.5 | 0 | 1 | $2.74 |
Peanut butter (cups) | 0 | 0 | 2.5 | 0 | $2.04 |
One batch results in 10 brownies, 12 cupcakes, 8 peanut butter cups, and 12 shortbread cookies. Each batch of brownies can be sold for $6.00, cupcakes for $10.00, peanut butter cups for $12.00, and shortbread cookies for $7.50. The organization anticipates that a total of at least 4,000 baked goods must be made. For adequate variety, at least 30 batches of each baked good are required, except for the popular brownies, which require at least 100 batches. In addition, no more than 40 batches of shortbread cookies should be made. How can the organization best use its budget and make the largest amount of money?
Please show STEP-BY-STEP results, pictures would help me please.
If you could email the excel file you used to calix619@hotmail.com, that would be ideal since I am really bad at solver.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started