Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Linear Programming Assignment Your Task Stoneware Pottery Company wants to deter

ID: 3198606 • Letter: L

Question

Linear Programming Assignment Your Task Stoneware Pottery Company wants to determine how many bowls and m r and I constraints. The unit profit value for Bowls is $40 per unit, for mugs the unit profit value is $50 per unit. There are 40 hours of labor and 120 pounds of clay available per day. Each bowl requires 1 hour of labor and 4 pounds of clay to produce, each mug requires 2 hours of labor and 3 pounds of clay to produce. Based on the above information, provide answers for the following statements and questions 1. Formulate a linear programming model for this problem to determine how many bowls and how many mugs should be produced in order to 2. 3. 4. maximize the total profit. Solve this problem by using the graphing method OR by using Excel Solver. What is the optimal solution? Which constraints are binding? MGMT 430: Management Science End Pgup PrtScn Home ?, F7 F8 FS F6 F3 F4

Explanation / Answer

Variables - Bowls and Mugs are B and M

constraints -

1. B and M are non-negative integers

2. available labor is 40. B + 2M <=40

3. available material is 120. 4B + 3M <=120

objective

max profit = 40B+50M

solution

answer is 24 bowls and 8 mugs.

per item total vehicles optimal no. labor material profit labor material profit bowl 24 1 4 40 24 96 960 mug 8 2 3 50 16 24 400 total 40 120 1360 constraint 40 120 check 0 0
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote