Jo Anna will bake some brownies for the next Work day.

She will make two different kinds: oatmeal and chocolate chip. Everyone knows

that the chocolate is a crowd favorite, so she wants the number of chocolate chip

cookies to be twice as much the number of oatmeal cookies. Additionally, she

needs at least eight dozen cookies. She estimates she will spend $0.25 per

oatmeal cookie and $0.35 per chocolate chip cookie. Additionally, she has

limited amount of butter, sugar, and flour in her kitchen and she does not have

time to go back to the grocery store. She estimates the amount of material

required for each cookie and measures her available material:

Amount Required in grams Availability in grams

oatmeal chocolate

Butter 9.46 6.31 700

Sugar 8.33 5.55 1000

Flour 5.00 10.00 850

(she is comfortable with the Standard!)

a. (Linear Programming) How many cookies of each type she should bake to

minimize her cost?

b. (Integer Programming) If she has to batch her cookies as a dozen, how

many dozen of each type she should bake?

Please show in exel show formulas and use solver