How many washing machines the company should produce

Assignment Help Business Management

Reference no: EM13218233

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.

Reference no: EM13218233

Questions Cloud

Weathering and erosion : Description of difference between weathering and erosion. Graphical representations and descriptions of the following: mechanical weathering

Determine the response of the system : Determine the response of the system when aunit step is applied at input.

Define and contrast the marketing activities : Provide an example of each type of offering. Compare and contrast the marketing activities for two types of offerings.

Compare the impact of the ax cut on income and interest rate : Two identicial countries Alpha and Beta can be described by the IS-LM model in the short run. The governments of both countries cut taxes by the same amount. The Central Bank of Alpha follows a policy of holding a constant money supply.

How many washing machines the company should produce : How many Vacuum cleaners and how many Washing machines the company should produce in next month in order to achieve the maximum profit?

Determine what digits each colour band represents : Using many resistors and the DMM, try to determine what digits each colour band represents. Briefly explain your method and your findings in the space below.

Issues or challenges between the middle ages : identify five issues or challenges between the middle ages and the french revolution that will shed light on a contemporary problem faced by society today.

What is the multiplier for government spending : What is equilibrium Y What are equilibrium consumption, private saving, public saving, and national saving How much does equilibrium income decrease when G is reduced to 200 What is the multiplier for government spending

Appropriate fiscal policy : If the economy is at potential output, and consumption spending suddenly decreases due to a fall in consumer confidence, the appropriate fiscal policy is?

User Account

All Pages