(2 points) The honorary business fraternity at Tech is planning an all-day bake sale on Saturday...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(2 points) The honorary business fraternity at Tech is planning an all-day bake sale on Saturday of a home football game as a charity fund-raising project. The members will bake cakes and cupcakes in one of the member's apartment oven. All the items bake at the same temperature (350 degrees) but for different times-45 minutes for a cake and 20 minutes for cupcakes-so they will bake one item at a time. The oven has enough space to bake one batch of cakes or one batch of cupcakes at a time. The recipe for a batch of cake calls for 8 eggs, 10 cups of butter, 12 cups of flour, and 6 cups of sugar. One batch of cupcakes requires 12 eggs, 6 cups of butter, 10 cups of flour, and 8 cups of sugar. A local grocery store has donated 96 eggs, 84 cups of butter, 200 cups of flour, and 120 cups of sugar. The members plan to sell one batch of cakes for $18 and one batch of cupcakes $15. The members want to know the number of batches of cakes and cupcakes to bake in order to maximize the money they make. We formulated the following linear programming model and solved it using excel solver. max 18x + 15x 8x + 12 x 96 (eggs) 10x + 6x2 84 (butter) 12x + 10 x < 200 (flour) 6x +8 x 120 (sugar) 45x + 20x 400 (baking time) X1, X 20 Variable Cells Final Cell Name Value $C$6 Cakes 6 $D$6 Cupcakes 4 Constraints Final Cell Name Value $F$8 Eggs $F$9 Butter $F$10 Flour $F$11 Sugar $F$12 Baking 96 84 112 68 350 Reduced Cost Shadow Price 0 0 0.58 1.33 0 0 0 Objective Allowable Allowable Coefficient Increase Decrease 18 15 Constraint R.H. Side 96 84 200 120 400 7 12 Allowable Allowable Increase Decrease 72 9.4 8 4.2 1E+30 1E+30 1E+30 28.8 36 88 52 50 Answer the following questions using excel solver sensitivity report. Show your work. a. (0.1 points) What is the sensitivity range for profit from cakes? b. (0.1 points) What are the optimal numbers of cakes and cupcakes to produce to maximize the money the team makes? c. (0.1 points) What is the sensitivity range for baking time? (2 points) The honorary business fraternity at Tech is planning an all-day bake sale on Saturday of a home football game as a charity fund-raising project. The members will bake cakes and cupcakes in one of the member's apartment oven. All the items bake at the same temperature (350 degrees) but for different times-45 minutes for a cake and 20 minutes for cupcakes-so they will bake one item at a time. The oven has enough space to bake one batch of cakes or one batch of cupcakes at a time. The recipe for a batch of cake calls for 8 eggs, 10 cups of butter, 12 cups of flour, and 6 cups of sugar. One batch of cupcakes requires 12 eggs, 6 cups of butter, 10 cups of flour, and 8 cups of sugar. A local grocery store has donated 96 eggs, 84 cups of butter, 200 cups of flour, and 120 cups of sugar. The members plan to sell one batch of cakes for $18 and one batch of cupcakes $15. The members want to know the number of batches of cakes and cupcakes to bake in order to maximize the money they make. We formulated the following linear programming model and solved it using excel solver. max 18x + 15x 8x + 12 x 96 (eggs) 10x + 6x2 84 (butter) 12x + 10 x < 200 (flour) 6x +8 x 120 (sugar) 45x + 20x 400 (baking time) X1, X 20 Variable Cells Final Cell Name Value $C$6 Cakes 6 $D$6 Cupcakes 4 Constraints Final Cell Name Value $F$8 Eggs $F$9 Butter $F$10 Flour $F$11 Sugar $F$12 Baking 96 84 112 68 350 Reduced Cost Shadow Price 0 0 0.58 1.33 0 0 0 Objective Allowable Allowable Coefficient Increase Decrease 18 15 Constraint R.H. Side 96 84 200 120 400 7 12 Allowable Allowable Increase Decrease 72 9.4 8 4.2 1E+30 1E+30 1E+30 28.8 36 88 52 50 Answer the following questions using excel solver sensitivity report. Show your work. a. (0.1 points) What is the sensitivity range for profit from cakes? b. (0.1 points) What are the optimal numbers of cakes and cupcakes to produce to maximize the money the team makes? c. (0.1 points) What is the sensitivity range for baking time?
Expert Answer:
Related Book For
Posted Date:
Students also viewed these programming questions
-
The honorary business fraternity at Tech is planning an all-day bake sale on Saturday of a home football game as a charity fund-raising project. The members will bake cakes, cupcakes, and cookies in...
-
The Beta Upsilon Sigma honorary business fraternity at Tech wants to open a food booth at the football stadium for the upcoming season as a project to raise money to tutor students in management...
-
Life Science Incorporated (LSI) is a firm with no debt and its 20 million shares are currently trading for $16 per share. Based on the prospects for one of LSI's new drugs, management feels the true...
-
Suppose the spinner shown is spun once. Find the probability of each event. 1. The result of the spin is 3. 2. The result of the spin not 3. 3. The result of the spin is an even number. 2) 3.
-
List and explain the steps in the marketing research process. Trace a hypothetical study through the stages in this process.
-
The National Bureau of Economic Research (NBER) determines the dates when recessions begin and end. Most economists and policymakers accept these dates when analyzing recessions. On its website, the...
-
Cherry Cotta makes custom ordered clay pots for residential gardens. Below is cost information regarding its latest job. a. Materials were purchased on account. $18,996 purchased b. A materials...
-
12.Indicate, by clicking on the relevant boxes, whether the following statements are true or false?
-
You're the CFO of Phish Oil Company, and you've just finished a hastily prepared summary of a highly visible and very exciting company named Golgi Apparatus, Inc. Your analysis was conducted in...
-
Identify the effective internal control(s) over notes payable, notes receivable, and drafts. (Check all that apply.) Multiple select question. Store notes receivable securely in a safe or fireproof...
-
As a BCBA what plans do you have currently to assess the problem behavior as a is a single test condition for Vocal outburst and elopement? What are your plans for the control condition for vocal...
-
How do role transitions, such as those associated with life course events or social mobility, impact individuals' sense of identity, belonging, and well-being ?
-
Assuming Just Right Services' fiscal year (FY) runs from January 01 to December 31 each year, which months have actual balances to compare to the operating budget thus far for FY 2021?
-
The text discusses some of the factors necessary for a bargaining cooperative to be effective.Read or skim the "Next Big Thing" in the Rural Cooperative magazine edition on Canvas. Which of the...
-
An international News Network organization the like of CNN, BBC or Blomberg News has called upon you to design a notification system that is capable of notifying 5000 employees worldwide. The system...
-
Why do bars offer free peanuts?
-
Foxcomp in Problem 31 estimates that the probabilities of the severity of events in each of the countries are as follows: Determine the best decision for Foxcomp using expected value. Event Severity...
-
In Problem 14, what would be the effect on the optimal solution if the available labor were increased from 200 to 240 hours?
-
Suntrek in Problem 27 manufactures denim fabric at its factories in Shanghai, Karachi, and Saigon and ships it to its denim jeans manufacturing facilities in China, India, Japan, Turkey, and Italy. A...
-
The day after the incident described in Problem 44, the instructor finds herself in the same situation. This time, she tries a harder physics exercise. She keeps running at a constant \(6.0...
-
The \(x\) component of the velocity of a car changes from \(-10 \mathrm{~m} / \mathrm{s}\) to \(-2.0 \mathrm{~m} / \mathrm{s}\) in \(10 \mathrm{~s}\). (a) Is the car traveling in the positive or...
-
(a) A car is speeding up in the negative \(x\) direction. In what direction do \(\vec{a}\) and \(\vec{v}\) point? (b) To which of the four graphs in Figures 3 . 2 and 3 . 3 does the situation...
Study smarter with the SolutionInn App