PLZ PLZ PLZ COMPLETE SOLUTION I VILL DEFINITELY UPVOTEPLZ COMPLETE IT A TO D A linear programming computer package is needed.Kilgore's Deli is a small delicatessen located near a major university. Kilgore does a large walk-in carry-out lunch business. The deli offers two luncheon chili specials, Wimpy and Dial 911. At the beginning of the day, Kilgore needs to decide how much of each special tomake (he always sells out of whatever he makes). The profit on one serving of Wimpy is $0.44, on one serving of Dial 911, $0.57. Each serving of Wimpy requires 0.25 pound of beef, 0.25 cup of onions, and 5 ounces of Kilgore's special sauce. Each serving of Dial 911requires 0.25 pound of beef, 0.4 cup of onions, 2 ounces of Kilgore's special sauce, and 5 ounces of hot sauce. Today, Kilgore has 18 pounds of beef, 13 cups of onions, 86 ounces of Kilgore's special sauce, and 58 ounces of hot sauce on hand.(a) Develop an LP model that will tell Kilgore how many servings of Wimpy and Dial 911 to make in order to maximize his profit today. (Let W = the number of servings of Wimpy to make and let D = the number of servings of Dial 911 to make.)Maxs.t.BeefOnionsSpecial SauceHot SauceW, D 20(b) Find an optimal solution. (Round your answers to two decimal places.)(W, D) =Profit = $(c) What is the dual value for special sauce? (Round your answer to two decimal places.)$Interpret the dual value.For every 1 ounce increase in--Select--, the profit will -Select- by s(d) Increase the amount of special sauce available by 1 ounce and re-solve. (Round your answers to two decimal places.)(W, D) =O NoProfit = $Does the solution confirm the answer to part (c)?Yes

For this question, I will formulate the LP, Then, Solve using the Solver tool, The solving method is…

(a) Develop an LP model that will tell Kilgore how many servings of Wimpy and Dial 911 to make in order to maximize his profit today. (Let W= the number of servings of Wimpy to make and let D = the number of servings of Dial 911 to make.) Max s.t. Beef Onions Special Sauce Hot Sauce W, D 20 (b) Find an optimal solution. (Round your answers to two decimal places.) (W, D)=( Profit S (c) What is the dual value for special sauce? (Round your answer to two decimal places.) S Interpret the dual value. For every 1 ounce increase in-Select- , the profit will -Select- by s (d) Increase the amount of special sauce available by 1 ounce and re-solve. (Round your answers to two decimal places.) (W, D) = Profit= $ Does the solution confirm the answer to part (c)? O Yes O No

(a) Develop an LP model that will tell Kilgore how many servings of Wimpy and Dial 911 to make in order to maximize his profit today. (Let W= the number of servings of Wimpy to make and let D = the number of servings of Dial 911 to make.) Max s.t. Beef Onions Special Sauce Hot Sauce W, D 20 (b) Find an optimal solution. (Round your answers to two decimal places.) (W, D)=( Profit S (c) What is the dual value for special sauce? (Round your answer to two decimal places.) S Interpret the dual value. For every 1 ounce increase in-Select- , the profit will -Select- by s (d) Increase the amount of special sauce available by 1 ounce and re-solve. (Round your answers to two decimal places.) (W, D) = Profit= $ Does the solution confirm the answer to part (c)? O Yes O No

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

AutoSave Module 7 Excel Quiz Excel Search Sebastian Beltran 回 X Off SB File Home Insert Page Layout Formulas Data Review View Help A Share Comments Insert Calibri v 11 ab Delete Paste $ • % 9 58 28 Conditional Format as Cell Sort & Find & Ideas Sensitivity BI U A K0 .00 00 0 v Format Formatting v Table v Styles v Filter Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity C23 fx A В C D E F G H K M Q R U 7 Perpetual Inventory Using FIFO 8 Beginning inventory, purchases,and sales data for Keurig coffee machines are as follows: 9. 10 June 1 Inventory 50 units at $10 11 6. Sale 20 units 12 14 Purchase 90 units at $11 13 19 Sale 60 units 14 25 Purchase 40 units at $13 15 30 Sale 50 units 16 17 The business maintains a perpetual inventory system, costing by the first-in, first-out method. 18 Using the chart below, determine the cost of ending inventory. 19 20 Sales Date Purchases Inventory 21 (Cost of goods) 22 Unit Cost Total Unit Cost Total Unit Cost Total 23 24…
Question 9
Question 5
2. Beech Company made the following expenditures relating to Product FG. Legal cost to file a patent on Product FG. Production of the finished product would not have been undertaken without the 25,000 patent. Special equipment to be used for development of Product FG. The equipment has an estimated useful life of four years. Labor and material costs incurred in producing a prototype model Cost of testing the prototype Trouble shooting breakdown during production. Cost of routine on-going effort to refine, enrich or improve quality 200,000 750,000 78,000 38,000 86,000 of Product FG. Required: a) What is the total cost that should recorded as research and development cost? b) What is the total cost that should be part of Intangible assets? c) What is the total cost that should be part of operating expense?
W AutoSave Off H 2.0 = PDPMT_PL102_06 June 2023_1 No Label ✓ Mailings Review File Home Insert Draw Design X (6 Paste Clipboard F Page 7 of 7 ■ Arial B I U U 79 of 954 words Q Search V ✓11 ab ab X₂ X x² A A Layout References A A Aa A A D Font English (South Africa) 10° View Help E✓ F✓ ≤ = AT ==== 스 1:15-16- E G QUESTION FOUR 4.2 Text Predictions: On Search Paragraph 5 Normal Ethical behaviour is necessary within a project organisation and is crucial in project business relationships with the customer, suppliers and subcontractors. Customers and suppliers want to do business with a project organisation that they can trust. Throughout any project, situations may arise that can provide an opportunity for unethical behaviour. With regard to the above statements: 4.1 Provide five examples of unethical behaviour in a project context. Accessibility: Unavailable No Spacing END OF QUESTION PAPER Styles Heading 1 Discuss the ways in which project managers can promote ethical behaviour. R A Thembi…
Customer Interarrival Service Time of Time Number Time Arrival 22 74 22 89 105 3 21 34 4 26 38 80 23 6. 81 26 7 78 90 8. 20 26 9. 32 37 10 13 88 11 28 38 12 18 73 13 29 93 14 19 25 15 20 93 16 23 5 17 78 37 18 20 5T 19 109 28 20 78 85 You're given a table of ice-cream shop customers. 20 customers have arrived starting from 22. second of the opening. Interarrival times and service times are given in seconds. a) Calculate the arrival times of all customers. b) Calculate the service start time of each customer. c) Calculate the queue lengths. d) Calculate the idle times of the shop. e) Calculate the utilization ratio. f) Calculate the mean waiting time (including the first and the last customers)
Article: SpaceX By: David R. King 1. Write two paragraph of internal analysis (Five Foces analysis)
Exhibit 1. Solver Sensitivity Report. A В E F H 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease $B$25 kg x1 $C$25 kg x2 9. 8. 300 200 300 10 4 500 1E+30 200 11 12 Constraints 13 Final Shadow Constraint Allowable Allowable 14 Cell Name Value Price R.H. Side Increase Decrease 15 ŞE$20 N 1320 600 720 1E+30 16 $E$21 P 1080 3.333333333 1080 1E+30 432 17 SE$22 K 60 13.33333333 60 90 60 Referring to Exhibit 1, if the right-hand side of the K constraint changes to 30, then the objective function value: will decrease by 13.3333 will decrease by 400. O will decrease by 133.3333. O will remain the same.
topic: Restaurant b. design concept
Question 15 $1 h $0.50 $0.75 Estimate the cost of a stock-out if the margin is $1 and half the time the customer simply doesn' buy anything. $0.25 B Question 16 nwacc.instructure.com TH 2 mond of 6. Unfortunatel:
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?