Question: Objective Cell (Max) Cell Final Value Name Max Profit Original Value 0 760 SBSS Original Value 0 Final Value 1000 Integer Contin Variable Cells Cell

Objective Cell (Max) Cell Final Value Name Max Profit Original Value 0 760 SBSS Original Value 0 Final Value 1000 Integer Contin Variable Cells Cell Name SBS1 X1 Ham and cheese sandwiches (H&C) $B$2X2 Bologna sandwiches (B) $B$3 X3 Chicken Salad Sandwiches (CS) 0 Contin 800 200 0 Contin Cell Value Status Slack 2000 0 0 Constraints Cell Name $B$II CI (storage size, units) SBS12 C2 (Production mix, units) $B$7 C3 (labor time, minutes) $B$8 04 (H&C production, units) $B$9 C5 (B production, units) $B$10 C6 (CS production, units) Formula $B$11C=SDS11 $B$12=$D$12 SBS7=$D$8 0 82 878 1000 800 800 600 SB$9>$DS9 $B$10>$D$10 200 0 Q1: How many bologna sandwiches should company XYZ produce? Q2: What is company XYZ maximized profit? (No $ needed and no comma) Constraints Cell Name Cell Value Formula Status Slack 2000 $B$11=$D$8 1000 800 800 $B$9>=$D$9 600 200 $B$10>$D$10 0 Q1: How many bologna sandwiches should company XYZ produce? Q2: What is company XYZ maximized profit? (No $ needed and no comma) Q3: How many constraints are the binding constraints? (Provide your answer as one of the following choice: 1, 2, 3, 4, 5, 6) Q4: How many labor minutes have been used for production to get the optimal solution? Objective Cell (Max) Cell Final Value Name Max Profit Original Value 0 760 SBSS Original Value 0 Final Value 1000 Integer Contin Variable Cells Cell Name SBS1 X1 Ham and cheese sandwiches (H&C) $B$2X2 Bologna sandwiches (B) $B$3 X3 Chicken Salad Sandwiches (CS) 0 Contin 800 200 0 Contin Cell Value Status Slack 2000 0 0 Constraints Cell Name $B$II CI (storage size, units) SBS12 C2 (Production mix, units) $B$7 C3 (labor time, minutes) $B$8 04 (H&C production, units) $B$9 C5 (B production, units) $B$10 C6 (CS production, units) Formula $B$11C=SDS11 $B$12=$D$12 SBS7=$D$8 0 82 878 1000 800 800 600 SB$9>$DS9 $B$10>$D$10 200 0 Q1: How many bologna sandwiches should company XYZ produce? Q2: What is company XYZ maximized profit? (No $ needed and no comma) Constraints Cell Name Cell Value Formula Status Slack 2000 $B$11=$D$8 1000 800 800 $B$9>=$D$9 600 200 $B$10>$D$10 0 Q1: How many bologna sandwiches should company XYZ produce? Q2: What is company XYZ maximized profit? (No $ needed and no comma) Q3: How many constraints are the binding constraints? (Provide your answer as one of the following choice: 1, 2, 3, 4, 5, 6) Q4: How many labor minutes have been used for production to get the optimal solution

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!

Given the following answer and sensitivity reports Cell SE$12 Objective Cell (Max) Name profit per board Total Profit Original Value $0.00 Final Value $4,320.00 Variable Cells Name boards X boards Y...

Cell SE$12 Objective Cell (Max) Name profit per board Total Profit Original Value $0.00 Final Value $4,320.00 Final Value Variable Cells Name boards X boards Y boards Z Cell SB$9 $C$9 $D$9 Original...

For a product mix linear programming problem, we use three materials (A, B and C) to make two products (X and Y) to maximize total profit. The following screenshot are the Answer and Sensitivity...

1. Based on the provided optimal solution, how many pounds of pine bark will be used? 2. Based on the provided optimal solution, what is the amount of unused labor time (in minutes)? Objective Cell...

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...

24 \fCH # 8 P 2 Obj fun Max Z =6*1+4*2 Variable Value Profit Sub to: Ass 1 Ass 2 X1 X2 Product 1 Product 2 6 X1 4 X2 10 7 10 3 Logical Model Max Z =6*1+4*2 10*1+10*2=0 CH # 8 P 6 Obj Fun Max Z=...

1. (a) What is the maximum profit per market day if Dean paid $1.2 per litre for milk and cream and $45 for sugar? Note that Dean also draws a $100 salary per market day. Which Solver report allows...

EM 605 Spring 2021 Midterm Exam 3/17/2021 The linear programming problem whose output follows is used to determine how many bottles of Hell-bound red nail polish (x1), Blood red nail polish (x2),...

BUS 220 - Introduction to Decision Sciences Fall 2015 Assignment 2 due on Thursday, October 8, 2015 NOTE: 10% of your grade will be deducted if the work is not presented in a clear and neat manner....

Microsoft Excel 14.0 Answer Report Worksheet: [CoffeeBlending data.xlsx]CoffeeBlending Report Created: 1/15/2014 8:22:41 PM Result: Solver found a solution. All Constraints and optimality conditions...

A cable company provides a 0 dBmV signal at 843 MHz via a 75-2 coaxial cable to a cable modem which is located in a residence. This modem uses this downstream signal to produce the downloaded data...

The Check Clearing for the 21st Century Act (Check 21 Act) allows recipients of paper checks to create a digital image of the original check, eliminating the need for further handling of the actual...

Please make the statement of cashflows for this using T - table or journal entry and show me working! I NEED HELP!

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...