Question: Linear optimization model formulation: Decision Variables: Let x = number of pizza slices Let y = number of hot dogs Let z = number of

Linear optimization model formulation: Decision Variables: Let x = number of pizza slices Let y = number of hot dogs Let z = number of barbecue sandwiches

Objective Function (Maximize Profit): Maximize P = 3x + 2y + 3.5z - 15(2x/8) - 2y - 3.5z - 500 - 1000/6

Subject to Constraints:

Space Constraints: 16y + 20z 1440 (oven space)

Demand Constraints: x 2(y + z) (twice as many pizza slices as hot dogs and barbecue sandwiches combined) y 1.5z (50% more hot dogs than barbecue sandwiches)

Non-negativity Constraints: x, y, z 0 Please show how to do this in excel. Thanks!

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!

please show equations ! thank you Module 12 Homework Prompt Introduction This is an individual assignment, while you are permitted to ask the instructor or a classmate specific questions if you get...

PLEASE: DO NOT OPEN TAB(s) ON YOUR BROWSER OTHE DO NOT SEND THE SOLUTION FILE TO YOUR EM DO NOT OPEN ANY COURSE MATERIAL . SAVE YOUR FILE AS: CIS623_FinalExam_YourName Refresh your browser before...

1 You would like to make a nutritious meal of eggs, edamame, and elbow macaroni. The meal should provide at least 40 g of carbohydrates, at least 20 g of protein, and no more than 50 g of fat. An egg...

1: Directions: 1) Read the entire selection below 2) Answer the questionssee additional notes below.... Selection: Bradley's Food Stand John Bradley is a senior at Tech, and he's investigating...

#3 Case Problem Julia's Food Booth A: Formulation of the LP Model X1(Pizza), X2(hotdogs), X3(barbecue sandwiches) Constraints: Cost: Maximum fund available for the purchase = $1500 Cost per pizza...

please help me answer the following in a step by step process 1. Which of the following is the correct illustration of the feasible region for the given LP model below? Minimize = = 4x + By subject...

please finish all these questions according to instructions and requirements. Management 3: Quantitative Methods in Business Extra Credit #2: Workload Balancing (20 points) For this assignment, you...

ADM 2302 Assignment 2 CASE STUDY (70 points) Report to Management Format (16 points) Professional traders can find investment opportunities from day-to-day financial markets. Very often an investment...

Dara Khoun is a senior at Tech and she's She estimates it will cost her $1.00 for each hot investigating different ways to finance her final dog and $2.50 for each barbecue sandwich if she year at...

Please show the work in Excel! We have been using the solver extension and data analysis extention in class Dara Khoun is a senior at Tech and she's She estimates it will cost her $1.00 for each hot...

Consider any job that you've held in the last five years. Describe the business process in which you played a part. Use the BPR model described in Section 2942 to recommend changes to the process in...

In the past, Taylor Industries has used a fixed time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs are forcing...

29. Mr. Prime Minister, I am certain you will want to release the members of our National Liberation Group whom you currently hold in prison. Aft er all, Im sure you will want to avoid having car...

9. To measure progress over time in a long-term contract, c include: companies use various methods that a. Output methods b. Input methods C combination of input and output methods d all of the above...