Question: please help me quickly.!! Suppose we have a cute and in our cat we serve three types of food. W.Y and 2 We use three

please help me quickly.!! please help me quickly.!! Suppose we have a cute

Suppose we have a cute and in our cat we serve three types of food. W.Y and 2 We use three type of ingredients (mugur, lour and butter) in cooking those foods. The cato manager wants decide the optimal food production by using the given inear programming model that consider the food profits resource requirements and resource available Besides, you are given the Excel answer and sensitivity reports below. Answer the following questions by analyzing the reports, MAX Z10W+147-20 . 4W.YOX s 56 Sugar (grams) 18W.168.22X 160 Flour (grams) sw.BY 4X 136 Butter (grama) WXY0 Answer Report Obiective CM) Cell Name 58510 Palit Ornal Value Final Value 0 145 1428571 Name Variable Cal Call 3057 W 5858 Central Value Final Value 0 0857142857 Canton o Contin 06571428571 Contin Contents Cell Name SH512 Flour Cel Value Formula Status Stack 56 SH 15111 Binding O 160 54512051512 Binding O 11.14285714 515151511 Not Binde 102.571429 Sensitivity report Variable Calls Cell Name $A$7 w sess Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0.857142857 0 16 0.363636364 0 0.571428571 14 0.571428571 1E30 6571428571 0 20 12 0 444444444 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price RH. Side Inverse Decrease SHS11 Sugar 56 0 142857141 562 181818182 20.44444444 5512 Flour 160 0857142857 160 92 SHS11 Butter 1114285714 D 10 102.3573429 State the optimal number of food W. X and Y production, and optimal prolit I the cabo manager wants to increase the available grams for one of their constraints (sugar, flour, or butter), which one the manager should choose? Why? Support your answer by the relevant information in the report State the optimality range for profit of food W. Suppose we increase the available capacity for flour by 50 grams. What can be said about the objective? Compute the new objective by using report information Suppose we increase the profit of food X by 510. What can be said about the objective? Compute the new objective by using report information

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question 1 Suppose we have a cute and in our cat: we serve three types of food. W Y and Z We use three type of ingredients (sugar flour and butter) in cooking those foods. The cafe manager wanti...

Fehruary 20, 2019, Brian was standing in front of his newly opened winery and restaurant in Kelowna, Canada: Sandalwood Winery (Sandals). The business was a dream come true for him, and Brian...

Unit 2: Designing the Operations Designing the operations of an organization or your department - precedes operational management. For .ll _ . example, suppose a wallet manufacture's mission is to '...

WHAT YOU NEED TO DO 1 Choose to complete two of the following three analyses: 1) SWT Finish 2) PESTEL 3) Porter's Five Forces Each Analysis is worth 24 marks. Prepare your analysis based on two marks...

Hello can you please help with this case study, that's an exercice given by the teacher in order for us to get ready for the mid-term, he said he is going to give something like that, so we should...

www.chipotle.com, CMG Headquartered in Denver, Colorado, Chipotle is a fast food Mexican restaurant chain operating predominantly in the United States, but also with locations in Canada, United...

Answer the following questions according to the case (Supply Chain Management in STARBUCKS and its Impact on Company Performance) provided below the asked questions: What are the main issues that...

Business and Social Customs Objectives Upon completion of this chapter, you will learn customary verbal expressions of persons of various countries. understand the importance of a knowledge of...

Torts Law 1. (1) What are the key principals of a defamation lawsuit by a public figure and why it is more difficult to succeed? (2) What are the key differences between trespass to chattel and...

Identify each of the following as a cost center, a discretionary cost center, a revenue center, a profit center, or an investment center: 1. The manger of center A is responsible for generating cash...

Assuming the target reflects 10% of the incident power, the working frequency of an ultrasound range finder system with transmitter power 1.5kW and receiver sensitivity 0.15mW operating in medium of...

E4.10 (LO 1, 2) (Current Liabilities) Mary Pierce is the controller of Arnold Corporation and is responsible for the preparation of the year-end financial statements. The following transactions...

The effectiveness of a quality management program is largely dependent upon The effectiveness of a quality management program is largely dependent upon the capability and motivation of the employees....