Q2. Selen is arranging a graduation party. She is expecting 120 guests to her party and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Q2. Selen is arranging a graduation party. She is expecting 120 guests to her party and she will make delicacies for them. Selen has decided to make only 3 kinds of delicacies: cake, cookies, and buns (a cake is enough for 10 people, a cookie for one person, and a batch of buns for 20 people). The LP formulation to minimize the total cost of preparing the delicacies and the corresponding Excel Sensitivity Report are provided below. Decision Variables: X = number of cakes Y = number of cookies Z = number of bun batches Minimize Costs ($) = 10X + 4Y + 15Z subject to 10X + Y + 20Z ≥ 120 10X ≥ 2Y 30X + Y + 40Z ≤ 600 10X ≥ 20 Y ≥ 20 20Z ≥ 20 X, Y, Z ≥ 0. (min. required demand) (min. required ratio of number of cakes to number of cookies) (available preparation time) (min. requirement for cakes) (min. requirement for cookies) (min. requirement for bun batches) (nonnegativity constraint) Cell $C$3 number of cakes $D$3 number of cookies $E$3 number of bun batches Name Cell $F$6 min. required demand $F$7 min. required ratio of number of cakes to number of cookies $F$8 available preparation time Name $F$9 min. requirement for cakes $F$10 min. requirement for cookies $F$11 min. requirement for bun batches Final Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease Value 4 20 3 0 0 0 10 4 15 0.75 0.25 0 0 3.75 0 1E+30 1E+30 5 Final Shadow Constraint Allowable Allowable Value Price 120 R.H. Side Increase Decrease 0 260 40 20 60 120 0 600 20 20 20 2.5 3.75 15 170 40 1E+30 20 13.33 40 40 20 340 1E+30 10 1E+30 Answer the following questions by showing all your calculations clearly: a. What is the impact on total cost if we increase the min. required demand to 150 units? b. What is the impact on total cost if we decrease the available preparation time by 250 units? c. If the objective function coefficient of cakes decreases by 5 units, will the optimal solution change? What about the value of the objective function? d. If the objective function coefficient of bun batches increases by 3 units, will the optimal solution change? What about the value of the objective function? e. We can increase the right-hand-side of the min. requirement for cookies constraint by 5 units, while decreasing the right-hand-side of the min. required demand constraint by 20 units. Is it worth the effort? Find the impact on total cost. Q2. Selen is arranging a graduation party. She is expecting 120 guests to her party and she will make delicacies for them. Selen has decided to make only 3 kinds of delicacies: cake, cookies, and buns (a cake is enough for 10 people, a cookie for one person, and a batch of buns for 20 people). The LP formulation to minimize the total cost of preparing the delicacies and the corresponding Excel Sensitivity Report are provided below. Decision Variables: X = number of cakes Y = number of cookies Z = number of bun batches Minimize Costs ($) = 10X + 4Y + 15Z subject to 10X + Y + 20Z ≥ 120 10X ≥ 2Y 30X + Y + 40Z ≤ 600 10X ≥ 20 Y ≥ 20 20Z ≥ 20 X, Y, Z ≥ 0. (min. required demand) (min. required ratio of number of cakes to number of cookies) (available preparation time) (min. requirement for cakes) (min. requirement for cookies) (min. requirement for bun batches) (nonnegativity constraint) Cell $C$3 number of cakes $D$3 number of cookies $E$3 number of bun batches Name Cell $F$6 min. required demand $F$7 min. required ratio of number of cakes to number of cookies $F$8 available preparation time Name $F$9 min. requirement for cakes $F$10 min. requirement for cookies $F$11 min. requirement for bun batches Final Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease Value 4 20 3 0 0 0 10 4 15 0.75 0.25 0 0 3.75 0 1E+30 1E+30 5 Final Shadow Constraint Allowable Allowable Value Price 120 R.H. Side Increase Decrease 0 260 40 20 60 120 0 600 20 20 20 2.5 3.75 15 170 40 1E+30 20 13.33 40 40 20 340 1E+30 10 1E+30 Answer the following questions by showing all your calculations clearly: a. What is the impact on total cost if we increase the min. required demand to 150 units? b. What is the impact on total cost if we decrease the available preparation time by 250 units? c. If the objective function coefficient of cakes decreases by 5 units, will the optimal solution change? What about the value of the objective function? d. If the objective function coefficient of bun batches increases by 3 units, will the optimal solution change? What about the value of the objective function? e. We can increase the right-hand-side of the min. requirement for cookies constraint by 5 units, while decreasing the right-hand-side of the min. required demand constraint by 20 units. Is it worth the effort? Find the impact on total cost.
Expert Answer:
Related Book For
Contemporary Business Mathematics with Canadian Applications
ISBN: 978-0133052312
10th edition
Authors: S. A. Hummelbrunner, Kelly Halliday, K. Suzanne Coombs
Posted Date:
Students also viewed these general management questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A curve C in three dimensions is given parametrically by (x(t), y(t), z(t)), where t is a real parameter, with a t b. Show that the equation of the tangent line at a point P on this curve where t...
-
For the beam and loading shown, (a) Draw the shear and bending-moment diagrams, (b) Determine the maximum absolute values of the shear and bending moment. |12 kN 9KN 22.5 KN m 27 kN-m E F 3 kN 45 m-...
-
Selected data for Austin Company follow: Current assets..... $50,000 Current liabilities......... $40,000 Capital assets...... 70,000 Long-term liabilities... 35,000 Total revenues.... 30,000 Total...
-
Virtuoso Transportation issued \(\$ 600,000\) of \(8 \%\) bonds payable at \(9^{-}\) on October 1, 2010. These bonds are callable at 100 and mature on October 1, 2018. Virtuoso pays interest each...
-
Major League Bat Company manufactures baseball bats. In addition to its goods in process inventories, the company maintains inventories of raw materials and finished goods. It uses raw materials as...
-
What is June\'s cash ratio? Your client June has the following financial profile: Liquid Assets $44,000 Investment Assets $140,500 Personal Assets $195,500 Total Assets $380,000 Total Liabilities...
-
On May 1, a petty cash fund was established for $150. The following vouchers were issued during May: Date Voucher No. Purpose Amount May 1 1 postage due $ 3.50 3 2 office supplies 11.00 5 3 auto...
-
A major faculty consisting of many Departments in the Whangarei University of Technology (WUT) has approached you for the design and implementation of a relational database system. The requirement...
-
Performance evaluation allows us to assess the performance of fund managers going beyond historical returns. In particular, we recognize that risk is an important factor when assessing the...
-
Suppose that a U.S. state decides to build some new schools in 2025. It does not have enough money to build a new school in every county, so only some counties receive a new school. The following...
-
How do you calculate PV of Cash Flows and PV of Terminal Year? (CS Millions, except per share amounts) WACC PV of Cash Flows PV of Terminal Year Enterprise Value Less Net Debt (12/31/18) Equity...
-
Consider the vectors u=2ij2k and v=2i+2j+4k. Find the vector components of u that are parallel and perpendicular to v.
-
Maria is self - employed and must submit estimated quarterly tax payments. Her predicted total tax liability for the current year will be $ 4 0 , 0 0 0 , and her current withholdings are $ 1 8 , 2 8...
-
Robert & Becky are married and file a joint return. They have a vacation home that they rent out for 196 days and use themselves for 49 days. Their gross rental income was $36,400. Their expenses...
-
1A. If the researcher is concerned about the number of variables, the nature of the analysis, and completion rates, then, he/she is at which stage of the sampling design process (Figure 11.1 in the...
-
A store located in Kelowna, B.C., sells a computer for $1868 plus GST and PST. If the same model is sold at the same price in a store in Kenora, Ontario, what is the difference in the prices paid by...
-
What nominal annual rate of interest was charged on a loan of $5600 repaid in end- of-month installments of $121.85 in four-and- a-half years?
-
Lunds Pro Shop purchased sets of golf clubs for $500 less 40% and 16 23%. Expenses are 20% of the regular selling price and the required profit is 17.5% of the regular selling price. The store...
-
Figure P18-39 shows two similar unit pulse waveforms. The only difference is that the first pulse is positive from \(-T / 2\) to \(T / 2\), while the second pulse goes from \(+\mathrm{A}\) to...
-
Describe the principal types of audits performed by independent auditors and indicate the established criteria and primary users of each tyr
-
Contrast the activities of independent, internal, and governmental auditors.
Study smarter with the SolutionInn App