Buy ready-to-submit essays. No Plagiarism Guarantee
Note: Our papers are 100% human-written.
I’m having a hard time setting up an Excel solver model for the problem below:
Owens-Wheat uses two production lines to produce three types of fiberglass mats. The demand requirements for each type of mat (in tons) for the next four months are as follows:
WE WRITE ESSAYS FOR STUDENTS
Tell us about your paper and we will find the best writer for your essay.
Write My Essay For MeMonth Mat Type
1 2 3
1 200 300 400
2 300 100 300
3 200 400 200
4 300 200 100
If it were dedicated to simply producing a mat of a single type, a single line 1 machine could produce either 20 tons of a type 1 mat or 30 tons of a type 2 mat. Similarly, a single line 2 machine could produce either 25 tons of type 2 mat or 28 tons of type 3 mat. Note that mat type 1 cannot be produced on line2, while mat type 3 cannot be produced on line 1. If costs $ 5,000 per month to operate a single machine on line 1, and $ 5,500 to operate a single machine on line 2. A cost of $ 2,000 is incurred each time a new machine is purchased for either line, while a cost of $ 1,000 is incurred when a machine is retired from service. At the end of each month, Owens would like a minimum inventory of 50 tons of each mat type and the cost of holding one ton on inventory for a month of any mat type is $ 5. At the beginning of month 1, the company has 5 line 1 machines, and 8 line 2 machines. Determine a minimum cost production schedule for each mat type of each production line.
Let our team of professional writers take care of your essay for you! We provide quality and plagiarism free academic papers written from scratch. Sit back, relax, and leave the writing to us! Meet some of our best research paper writing experts. We obey strict privacy policies to secure every byte of information between you and us.
ORDER ORIGINAL ANSWERS WRITTEN FROM SCRATCH
