XYZ is a manufacturer of both vacuum cleaners and washing machines. The management wants to make some adjustment to the production to improve its productivity for the next month. The decision making shall be based on the following conditions:
The making of each vacuum cleaner consumes 20 days of labour and $1000 of materials. The making of each washing machine consumes 50 days of labour and $1500 of materials. Each vacuum cleaner brings $800 profit to the company, while each washing machine brings $1200 profit to the company. The company has a capacity of 3,000 working days per month, and the material budget is $250,000 per month. The sales department requires that at least 50 units of vacuum cleaners and 20 units of washing machines be produced per month.
The question is: How many Vacuum cleaners and how many Washing machines the company should produce in next month in order to achieve the maximum profit?
Note: You should use MS Excel software to solve this LP problem. Submit your solution with the mathematical model. Compare the solution with that you obtain graphically and insert screenshots of your results.