Question: Please make an algebraic model for this question and solve on lingo or excel solver. thanks 5. A metalworking company buys sheet metal from which

Please make an algebraic model for this question and solve on lingo or excel solver. thanks
Please make an algebraic model for this question
Please make an algebraic model for this question
5. A metalworking company buys sheet metal from which they make swings and slides for children's playgrounds. They then outsource the rustproofing of the swings and slides, and sell the finished products. They buy the metal at a cost of $5 per kilogram (kg). Each swing requires 3kg of metal, while each slide requires 6kg. Each product spends time in three operations; cutting; polishing; and assembly. The times in minutes per unit are: Each day, the shop is available for 6.5 hours of productive time. There are four cutting machines, one polisher, and one person to do the assembly. However, up to an extra 80 minutes of assembly time can be purchased for $2 per minute. The rust-proofing firm charges $30 per hour. When rust-proofing swings, they can rustproof 5 swings per hour: when rust-proofing slides, they can rust-proof 16 slides per hour. The metalworking company sells its products to a wholesaler at $190 per swing and $75 per slide. The market requires that at least two slides be made for every swing made. We define (all variables are on a daily basis): (a) Formulate an algebraic model for the problem. If you wish to solve the models in Excel Solver, you will have to write them in standard form, i.e. all variables on the left-hand side, and a number of the right-hand side. If you use LINGO, you are not bound by this restriction. Submit the algebraic model in the single Word or pdf file. (b) Use LINGO or the Excel Solver to solve this model. Imbed the LINGO model and solution report files, or tabs of the model and Answer Report from the Excel file, into the single Word or pdf submission file

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!