Use the following problem statement to answer questions 1-6. Gale wants to determine the values of X1 and X2 to maximize total profit. The two types of biscuits require the following resources: sausage, ham, flour, and labor. The linear model and the sensitivity report are given as below. Round to two decimal places. XI no. of sausage biscuits X2 no. of ham biscuits Max Z-50X1+20X2 CI: X1 +2X2 ≤ 50. Sausage (lb.) C2: 4X1 +4X2 ≤90. Ham (lb.) C3: 2X1 + X2 ≤ 30. Flour (lb.) C4: X1 + X2 ≤ 20. Labor (hr.) CS: X1, X220 Variable Cells Final Cell Name Value $B$3 X1 $C$3 X2 Constraints 15 0 Final Cell Name Value $M$6 C1 SMS7 C2 $M$8 C3 $M$9 C4 15 60 30 15 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 1E+30 5 0 -5 Shadow Price 0 0 25 0 50 20 Constraint R.H. Side 50 90 30 20 10 1E+30 Allowable Allowable Increase Decrease 1E+30 1E+30 10 1E+30 35 30 30 5

Use the following problem statement to answer questions 1-6. Gale wants to determine the values of X1 and X2 to maximize total profit. The two types of biscuits require the following resources: sausage, ham, flour, and labor. The linear model and the sensitivity report are given as below. Round to two decimal places. XI no. of sausage biscuits X2 no. of ham biscuits Max Z-50X1+20X2 CI: X1 +2X2 ≤ 50. Sausage (lb.) C2: 4X1 +4X2 ≤90. Ham (lb.) C3: 2X1 + X2 ≤ 30. Flour (lb.) C4: X1 + X2 ≤ 20. Labor (hr.) CS: X1, X220 Variable Cells Final Cell Name Value $B$3 X1 $C$3 X2 Constraints 15 0 Final Cell Name Value $M$6 C1 SMS7 C2 $M$8 C3 $M$9 C4 15 60 30 15 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 1E+30 5 0 -5 Shadow Price 0 0 25 0 50 20 Constraint R.H. Side 50 90 30 20 10 1E+30 Allowable Allowable Increase Decrease 1E+30 1E+30 10 1E+30 35 30 30 5

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

%24 wP NWP Assessment Builder UI App X WP NWP Assessment Player UI Appli X A Player A Player Chapter 13 Wiley Assignment - H x A education.wiley.com/was/ui/v2/assessment-player/index.html?launchld%3Da67db8cb-3f9b-4d0b-ae91-9b01aaada0c5#/question/7 e Chapter 13 Wiley Assignment - Homework Question 8 of 8 View Policies Current Attempt in Progress The concession stand at the Shelby High School stadium sells slices of pizza during boys' and girls' soccer games. Concession stand sales are a primary source of revenue for the high school athletic programs, so the athletic director wants to sell as much food as possible; however, any pizza not sold is given away free to the players, coaches, and referees or it is thrown away. Thus, the athletic director wants to determine a reorder point that will meet the demand for pizza. Pizza sales are normally distributed with a mean of 6 pizzas per hour and a standard deviation of 3.70 pizzas. The pizzas are ordered from Pizza Beth's restaurant, and the…
Do not use chatgpt.
Product-Profitability Analysis; Scarce Resources Creighton Corporation produces a varietyof consumer electronic products. Unit selling prices and costs for three models of one of its productlines are as follows:[LO 11-7]No Frills Standard Options SuperSelling price $40 $70 $86Direct materials 10 14 16Direct labor (@ $20/hour) 10 20 30Variable overhead 3 6 9Fixed overhead 3 6 6Variable overhead is charged to products on the basis of direct labor dollars; fixed overhead isallocated to products on the basis of machine hours.Required2. Calculate for each product both the gross profit per unit and the contribution margin per unit. (Roundanswers to 2 decimal places, e.g., $15.459 = $15.46.) Are either of these profitability measures usefulfor planning the optimum short-term product mix? Explain.
A comprehensive portfolio includes which of the following All of the above Letter of recommendation Proof of the skills achieved Certificates of awards Example of work completed in each courses
List products or services that do not exist, but you would like to see made available. 1. 2. 3. 4. 5.
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Pls help ASAP on both questions I HUMBLY REQUEST
4
身 Inbox (6,303) - x sf Your sesslon h. x sf Career Opport x Birdledon Writ x Brussels Airline x. myAU Portal zto.mheducation.com/ext/map/index.html?_con%3Dcon&external_browser%=D0&launchUrl=https%253A%252F%252Flms.mheduca erviews (Chapter 8) i Saved In an IT system segregation of duties is best maintained through the use of: Multiple Choice Access controls, such as passwords. O Locking cabinets containing sensitive records. Organizational charts. Job descriptions. Prev 2 3 Next > Finacial Account...pdf Finacial Account....pdf Finacial Account....pdf. MacBookAr