Question

In: Operations Management

Jo Anna will bake some brownies for the next Work day. She will make two different...

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

Solutions

Expert Solution

(a)

Excel model:

Solver inputs:

Solution:

Oatmeal cookies Chocolate cookies
Dozens of 2.49 5.51
Cost $3.00 $4.20 $30.61
s.t.
Ratio -2 1 0.521 >= 0
Min total 1 1 8.000 >= 8
Butter 113.52 75.72 700.000 <= 700
Sugar 99.96 66.60 615.971 <= 1000
Flour 60.00 120.00 810.413 <= 850

So,

The no. of oatmeal cookies = 2.49 doz = 29.88 units
The no. of chocolate cookies = 5.51 doz = 66.12 units

(b)

Keep everything else the same and only add the integer constraint in Solver as follows:

Solution:

Oatmeal cookies Chocolate cookies
Dozens of 2 6
Cost $3.00 $4.20 $31.20
s.t.
Ratio -2 1 2.000 >= 0
Min total 1 1 8.000 >= 8
Butter 113.52 75.72 681.360 <= 700
Sugar 99.96 66.60 599.520 <= 1000
Flour 60.00 120.00 840.000 <= 850

So,

The dozens of oatmeal cookies = 2
The dozens of chocolate cookies = 6


Related Solutions

1. Anna knows that she is fat, she should work out but she is often lazy...
1. Anna knows that she is fat, she should work out but she is often lazy and does not want to go to gym. What should Anna experiencing in her mind and why ? Explain 3 things Anna might be motivated to do because of it
CASE #5 APR vs EAR Mary Jo plans to invest some money so that she has...
CASE #5 APR vs EAR Mary Jo plans to invest some money so that she has $8,000 at the end of three years. Option A Option B Option C Option D APR 5.19% 5.11% 5.20% 5.40% m/per year 365 12 4 1 How much should she invest today given the choices above? What is her best choice? What is the EAR for each account? Support your decision in question 2. Physical therapy equipment purchase Your firm needs to buy additional...
Stan is going to work for the next 30 years and then retire. Starting the day...
Stan is going to work for the next 30 years and then retire. Starting the day he retires, he would like to withdraw $90,000 per year (in monthly installments) from an investment account for a twenty-five year retirement. At the end of his retirement, he would like to leave a bequest of $100,000 to his heirs. He currently has $10,000 in his investment account for these purposes. Stan plans to save for retirement by making monthly deposits into the investment...
Some businesses actively work to make it clear that the business owners are devoutly religious (two...
Some businesses actively work to make it clear that the business owners are devoutly religious (two fast food restaurants come to mind: In-n-Out Burger, which puts Bible verses on cups and plates, and Chik Fil A - which goes so far as to be closed on Sundays). For this question, let’s specifically look at devoutly Christian businesses, for whom both Heaven and Hell are possible afterlife outcomes. Explain how the bold proclamation of their Christianity might be a strategic move...
Patricia was called at work by a woman at the local day care center. She told...
Patricia was called at work by a woman at the local day care center. She told Patricia to come and pick up her son because he was not feeling well. Her son, 3½-year-old Marshall, had been feeling tired and achy when he woke up. While at day care, his cheeks had become red, and he was warm to touch. He did not want to play with his friends, and by the time Patricia arrived, he was crying. Later that afternoon,...
Margie has had a tough month. First, she had dental work that cost $700. Next, she...
Margie has had a tough month. First, she had dental work that cost $700. Next, she had her car transmission rebuilt, which cost $1,400. She put both of these unexpected expenses on her credit card. If she does not pay her credit card balance when due, she will be charged 15% interest. Margie has $15000 in a money market account pays 5% interest. How much interest would she pay (annualized) if she does not pay off her credit card balance?...
. A person has two meetings schedule in a day. The probability she is late for...
. A person has two meetings schedule in a day. The probability she is late for the first meeting is 0.4, the probability she is late for the second is 0.5, and the probability she is late for both meetings is 0.3. Please explain with where each number comes from and the meaning of formulas used if possible, thank you! a) Is the event that she is late for the first meeting independent of the event that she is late...
Managers are required to make many tough decisions over the course of a work day. One...
Managers are required to make many tough decisions over the course of a work day. One of the tough decisions a manager may be faced with is the decision to drop an existing customer from their portfolio. Some companies refuse to drop customers (including non-profitable customers) in the hopes that these unprofitable customers will become profitable in the future. Other companies do not want unprofitable customers impacting their bottom line year after year and choose to drop them. In your...
Gretchen wants to take the next six years off work to travel around the world. She...
Gretchen wants to take the next six years off work to travel around the world. She estimates her annual cash needs at $29,000 (if she needs more, she will work odd jobs). Gretchen believes she can invest her savings at 10% until she depletes her funds. Requirements: 1. How much money does Gretchen need now to fund her travels? 2. After speaking with a number of banks, Gretchen learns she will only be able to invest her funds at 6%....
Martha decided to make some delicious homemade baked mac and cheese. She placed it in the...
Martha decided to make some delicious homemade baked mac and cheese. She placed it in the oven that was really hot and when it was ready she took it out. While she left for a second, her son Elijah came in the kitchen and immediately went to grab the hot dish and yelled “OOWWW I BURNT MY HAND” his pain receptors screamed. 1. Which of the following correctly described the afferent pathway? a) Transduction of the pain occurred outside the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT