Consider the scenario given below.Use Excel solver to answer the following question(s) .
Peca Inc.is a small manufacturer of two types of office chairs,the swivel and no-swivel models.The manufacturing process consists of two principal departments: fabrication and finishing.The fabrication department has 24 skilled workers,each of whom works 7 hours per day.The finishing department has 6 workers,who also work a 7-hour shift.A swivel type requires 7 labor hours in the fabricating department and 2 labor hours in finishing.The no-swivel model requires 8 labor hours in fabricating and 3 labor hours in finishing.Peca Inc.makes a net profit of $100 on the swivel model,and $130 on the no-swivel model.The company anticipates selling at least twice as many no-swivel models as swivel models.The company wants to determine how many of each model should be produced on a daily basis to maximize net profit.
-Determine the net optimal profit for the given data.
A) $525
B) $1,365
C) $1,890
D) $200
Correct Answer:
Verified
Q1: In the expression 3.0A + 3.5B +
Q3: Use the scenario given below to answer
Q4: Use the scenario given below to answer
Q5: In linear optimization models,an objective function is
Q6: If the Solver reports that "The Set
Q7: The _ is the difference between the
Q8: In linear optimization,the phrase "must contain exactly"
Q9: Use the scenario given below to answer
Q10: Use the scenario given below to answer
Q11: The shadow price _.
A)tells how much the
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents