Linear program help | Algebra homework help
Linear Program help travonl33Need help with these questions in this module
- a year ago
- 10
EN [email protected] ( Sign out) MNS407 Management Science, Fall 2024 407 Module 2: Homework#2 (Homework) INSTRUCTOR Vahid Keyhani National University, La Jolla CA Current Score
QUESTION
POINTS
1 2 3 4 5 6 TOTAL SCORE
0/8 0.0%
SAT, NOV 9, 2024
11:59 PM PST
Request Extension This homework covers material in Chapters 4 and 6, and some questions require the use of Excel and Solver. You have 5 attempts to get this right. Feel free to submit until you are satis�ed with the results. Do not forget to use the practice button and help hints in the process. Remember you have taken the "Getting Started in Web Assign for Mathematics" quiz in week one because the way you write your answers matters for homework, quizzes, and the �nal. Be careful with syntax again.
Assignment Submission & Scoring
Assignment Submission
For this assignment, you submit answers by question parts. The number of submissions remaining for each question part only changes if you submit or change the answer.
Assignment Scoring
Your last submission is used for your score. Home My Assignments Grades Communication Calendar My eBooks 0/1.33 –/1.35 –/1.33 –/1.33 –/1.33 –/1.33 Due Date
Instructions
11/3/24, 10:55 PM 407 Module 2: Homework#2 - MNS407 Management Science, Fall 2024 | WebAssign https://www.webassign.net/web/Student/Assignment-Responses/last?dep=35936171#question4526420_0 1/10 A linear programming computer package is needed. Greenville Cabinets received a contract to produce speaker cabinets for a major speaker manufacturer. The contract calls for the production of 3,300 bookshelf speakers and 4,100 floor speakers over the next two months, with the following delivery schedule. Model Month 1 Month 2 Greenville estimates that the production time for each bookshelf model is 0.7 hours and the production time for each floor model is 1 hour. The raw material costs are $10 for each bookshelf model and $12 for each floor model. Labor costs are $22 per hour using regular production time and $33 using overtime. Greenville has up to 2400 hours of regular production time available each month and up to 1000 additional hours of overtime available each month. If production for either cabinet exceeds demand in month 1, the cabinets can be stored at a cost of $5 per cabinet. For each product, determine the number of units that should be manufactured each month on regular time and on overtime to minimize total production and storage costs. Round your answers to the nearest integer. (Let BaR = regular bookshelf units for month 1, BbR = regular bookshelf units for month 2, FaR = regular floor units for month 1, FbR = regular floor units for month 2, BaO = overtime bookshelf units for month 1, BbO = overtime bookshelf units for month 2, FaO = overtime floor units for month 1, and FbO = overtime floor units for month 2) (BaR, BbR, FaR, FbR, BaO, BbO, FaO, FbO) = Total Production Cost = $ 268,320.00 Show My Work (Optional) Bookshelf 2,100 1,200 Floor 1,500 2,600 3300,0,0,4100,0,0,0,0