Question: Please show how to get the answer in excel. What is the objective function,decision function, and constraints for the optimization problem and what is the

Please show how to get the answer in excel.
What is the objective function,decision function, and constraints for the optimization problem and what is the optimal solution?
Please show how to get the answer in excel. What
Please show how to get the answer in excel. What
2. Geniue Antique Egyptian Artifacts, Inc. produces three varieties of antique artifacts for sale to tourists: statuettes, lamps, and urns. All of the artifacts include special clay. A statuette requires 13 ounces of clay, a lamp uses 18 ounces, and each urn takes 17 ounces. Existing capacity of clay is 28,000 ounces per month. A special material is also used to produce the three artifacts, with each statuette needing 0.8 ounces, each lamp 0.7 ounces, and a typical urn requiring 1.0 ounces. The company has inventory of 1,200 ounces of special material per month. The owner of the company wishes to maintain a balanced marketing program, and has ordered that production of statuettes to be limited to 275. The overall per unit profit for artifacts is the following: $199 per statuette, $99 per lamp, and $145 per urn. The owner wants to know how much of each type of antique to fabricate monthly in order to optimize profit. Genius Antique Egyptian Artifacts, Inc. Decision Variables Statuettes Lamps Ums X2 2 3 $ 199.00 $99.00 $145.00 Objective Value 2 What are the better decision variable and contrar tinition problem Objective Function Desi Yara Quantity Profit/Tub Describe the optimal wa Constraints Resource per Resource Statuettes Lamps Ums Clay 13 18 17 Special Material 0.8 0.7 1 LHS: Resource Used Type: RHS: Resource Available 28000 1200 Production Statuettes Quantity Type Limitation 275

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!