Get in touch with us
Send us an e-mail
Question
Maxine’s Hat Company produces three distinct hat styles. The operations manager has modeled the operations using linear programming. He is using x1, x2, x3 to represent each hat style. Below is his formulation:
Maximize Z = 70 x1 + 80 x2 + 60 x3
Subject to:
Machine A: 2 x1 + 4 x2 + 2 x3 < 120 hours
Machine B: 5 x1 + 3 x2 + 2 x3 < 400 hours
Machine C: 2 x1 + 2 x2 + 4 x3 < 110 hours
x1 > 0; x2 > 0; x3 > 0
a. Use Excel and Solver to find the optimal solution for this problem. Provide printouts of worksheets for the final solution and the sensitivity report. Then consider the statements below independently, state whether they are true or false and explain each answer.
b. If the price of Hat 3 were to be increased by $55, it would be part of the optimal product mix.
c. The capacity of Machine B can be reduce to 280 hours without affecting profits.
d. If machine C had a capacity of 115 hours, the production output would remain unchanged.
Summary
The question belongs to Operations Management and it is about using linear programming for modeling three alternatives for production with machine A, machine B and machine C. The calculations have been given in the excel sheet attached along with the question.
Total Word Count NA
Download Full Solution
The prices for the assignment help at HwA are very reasonable and the quality of electric field assignment writing that I received was of a very high quality. There is never any compromise in the quality of work by the electric field assignment experts and they are extremely professional in their approach to any kind of electric field assignment questions.
After I moved to Australia to study Computer Science and Engineering, I found out that the things are quite different than what it used to be in the Indian universities. The course structure is much more practical oriented and thus the numbers of assignments are also more. I was clueless and was struggling to cope when I came across HwA. Thanks to them I got through my first two semesters with good grades and that boosted my confidence. Now I am pursuing my post-graduation from a Queensland based reputed technology university and still taking help from HwA.
When I saw that the dissertation writers are from Canada itself it was such a big relief. They are aware of the structural requirements and also at the same time got the citations and the referencing exactly as demanded.
The earlier service I was using only used to provide me with the codes for the Programming assignment help requested from them. At TheReliableTutor the online Singapore Programming tutors provide notes along with the codes which have helped me understand how the code actually works and explain it to the professor too. It has now become a habit with me too.
I hugely owe to HwA for clearing my concepts as far as accounting entries are concerned. Previously I was not sure in which side of the balance sheet I need to put things like “labour overheadâ€, “capital investmentâ€, etc. But now, thanks to HwA, everything is crystal clear.
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.