Reference no: EM131180449
Use Excel spreadsheet file for the calculation and explanation.
Problems
1. The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each fan must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hours of drilling time may be used. Each air conditioner sold yields a profit of $25. Each fan assembled may be sold for a $15 profit. Formulate and solve this LP production mix situation to find the best combination of air conditioners and fans that yields the highest profit. Use the corner point graphical approach.
2. Electrocomp's management realizes that it forgot to include two critical constraints (see Problem 1).
In particular, management decides that there should be a minimum number of air conditioners produced.
3. The dean of the Western College of Business must plan the school's course offerings for the fall semester. Student demands make it necessary to offer at least 30 undergraduate and 20 graduate courses in the term. Faculty contracts also dictate that at least 60 courses be offered in total. Each undergraduate course taught costs the college an average of $2,500 in faculty wages, and each graduate course
costs $3,000. How many undergraduate and graduate courses should be taught in the fall so that total faculty salaries are kept to a minimum?
in order to fulfill a contract. Also, due to an oversupply of fans in the preceding period, a limit should be placed on the total number of fans produced.
(a) If Electrocomp decides that at least 20 air conditioners should be produced but no more than 80 fans should be produced, what would be the optimal solution? How much slack or surplus is there for each of the four constraints?
(b) If Electrocomp decides that at least 30 air conditioners should be produced but no more than 50 fans should be produced, what would be the optimal solution? How much slack or surplus is there for each of the four constraints at the optimal solution?
Attachment:- Excel -Spread-Sheet.rar
|
How to better the company to your boss
: In this paper you're proposing ideas on how to better the company to your boss. You are a supervisor at UPS (United Parcel Service) and are talking about how to improve the company from your position.
|
|
Discuss the overall manner in which using technology
: Use Internet to research articles (no older than five [5] years) on using technology to prevent medical malpractices. discuss the overall manner in which using technology can help prevent malpractices. Speculate on the most damaging consequences o..
|
|
Privately-held manufacturer of industrial equipment
: Frazz Corporation is a privately-held manufacturer of industrial equipment. For calendar year 2009, Frazz reported a net income before taxes of $684,300. However, because of turnover in the accounting department, some errors were made. Given the f..
|
|
Expected annual return
: In order to expect that it will fund her retirement, Glenda needs her portfolio to have an expected return of 13.5 percent per year over the next 30 years. She has decided to invest in Stocks 1, 2, and 3, with 25 percent in Stock 1, 50 percent in Sto..
|
|
What would be the optimal solution
: If Electrocomp decides that at least 20 air conditioners should be produced but no more than 80 fans should be produced, what would be the optimal solution?
|
|
Explain the major effects that government policies have
: Examine the major effects that government policies have on production and employment. Predict the potential effects that government policies could have on your company.
|
|
What is the present value
: (a) What is the Present Value (PV) of this investment (at 12%)? (b) What is the NET Present Value (NPV) of this investment? If you need 12% should you buy the equipment?
|
|
New goal for professional and personal development
: Action Plan: Write a detailed Action Plan for one new goal for professional and personal development (you will continue to build on the list of goals you selected in your previous courses). Include the following in your Action Plan:
|
|
Calculate cost of common equity and after-tax cost of debt
: The following table gives Foust Company's earnings per share for the last 10 years. The common stock, 6.7 million shares outstanding, is now (1/1/15) selling for $68 per share. The expected dividend at the end of the current year (12/31/15) is 60% of..
|