Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

De. Chiand belped XYZ company optimine its production deciuion to maxamize the firm't profit. His solver reports are provided belowi Please ase these feports to

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
De. Chiand belped XYZ company optimine its production deciuion to maxamize the firm't profit. His solver reports are provided belowi Please ase these feports to answer the following queitions Variable Cells (Sensitivity report) Allowable Allowable Cell Name SBS1 X1 Ham and cheese sandwiches (HECC) SB52 X2 Bologna sandwiches (B) SB53 X3 Chicken Salad Sandwiches (CS) Constraints (Seasitivity report) SBS11Cl(storagesize,units)Cell SB\$12 C2 (Production mix, units) SBS7 C3 (labor time, minutes) \$BS8: C4 (H\&C production, units) 5B59 C5 (B productioti, units) \$\$B510 C6 (CS production, units) Q1: How many chicken salad sandwichs 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? Q5. What is the upper boundary value of the range of the optimality of the Chicken salad sandwiches? (Provide your answer in two decimal places in a format of . Q6. What is the reduced cost of Bologna sandwiches? Q7. When the storage size decrease by 1 unit, how much profit is changed? (use a positive number to show an increase and a negative number to show a decrease. Provide your answer in two decimal places in the format of =. ) Q8. If all other information stays the same, when the profit rate of H\&C sandwiches (coefficient of X1 ) reduces by 0.05 , what is the optimal number of bologna sandwiches company XYZ should produce to maximize the profit? De. Chiand belped XYZ company optimine its production deciuion to maxamize the firm't profit. His solver reports are provided belowi Please ase these feports to answer the following queitions Variable Cells (Sensitivity report) Allowable Allowable Cell Name SBS1 X1 Ham and cheese sandwiches (HECC) SB52 X2 Bologna sandwiches (B) SB53 X3 Chicken Salad Sandwiches (CS) Constraints (Seasitivity report) SBS11Cl(storagesize,units)Cell SB\$12 C2 (Production mix, units) SBS7 C3 (labor time, minutes) \$BS8: C4 (H\&C production, units) 5B59 C5 (B productioti, units) \$\$B510 C6 (CS production, units) Q1: How many chicken salad sandwichs 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? Q5. What is the upper boundary value of the range of the optimality of the Chicken salad sandwiches? (Provide your answer in two decimal places in a format of . Q6. What is the reduced cost of Bologna sandwiches? Q7. When the storage size decrease by 1 unit, how much profit is changed? (use a positive number to show an increase and a negative number to show a decrease. Provide your answer in two decimal places in the format of =. ) Q8. If all other information stays the same, when the profit rate of H\&C sandwiches (coefficient of X1 ) reduces by 0.05 , what is the optimal number of bologna sandwiches company XYZ should produce to maximize the profit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions