Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Analysing The Value Proposition Of The Audit Process In Africa The Case Of Malawi

Authors: Daniel Dunga

1st Edition

3659166286, 978-3659166280

More Books

Students also viewed these Accounting questions