2. The College of Business and Economics chair at the University of Hawaii at Hilo looked...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. The College of Business and Economics chair at the University of Hawaii at Hilo looked over last year's class schedule and the Business Analytics major requirements. At the same time, she handled a lot of recent emails. The chair noticed that faculty members had specific courses they preferred to teach, and they generally wanted to avoid early morning classes. To solve this, she asked the professors to tell her how long they needed to prepare for the courses they could teach. Her goal was to make a fair teaching schedule where each professor would teach between two and three courses. She paid special attention to making sure certain elective courses like QBA 362; MGT 330, MGT 424, MKT 315, and MKT 318 were offered at least once, and that there were at least six sections of the QBA 300 class. The professors' estimated prep times for each course are listed in a table. a. Hong b. Sun c. Tien d. Zenk 1. QBA 2. QBA 3. MGT 4. MGT 5. MKT 6. MKT 300 362 330 423 315 318 3 10 12 16 12 7 4 19 2 10 8 18 5 4 14 14 B 4 4 15 17 15 a. Formulate the problem as an assignment problem. b. Find the optimal solution that minimizes the total prep time while meeting all college's requirements using Solver. c. Attach your formulation and Excel output. 2. The College of Business and Economics chair at the University of Hawaii at Hilo looked over last year's class schedule and the Business Analytics major requirements. At the same time, she handled a lot of recent emails. The chair noticed that faculty members had specific courses they preferred to teach, and they generally wanted to avoid early morning classes. To solve this, she asked the professors to tell her how long they needed to prepare for the courses they could teach. Her goal was to make a fair teaching schedule where each professor would teach between two and three courses. She paid special attention to making sure certain elective courses like QBA 362; MGT 330, MGT 424, MKT 315, and MKT 318 were offered at least once, and that there were at least six sections of the QBA 300 class. The professors' estimated prep times for each course are listed in a table. a. Hong b. Sun c. Tien d. Zenk 1. QBA 2. QBA 3. MGT 4. MGT 5. MKT 6. MKT 300 362 330 423 315 318 3 10 12 16 12 7 4 19 2 10 8 18 5 4 14 14 B 4 4 15 17 15 a. Formulate the problem as an assignment problem. b. Find the optimal solution that minimizes the total prep time while meeting all college's requirements using Solver. c. Attach your formulation and Excel output.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these general management questions
-
The city of Stanton was prosperous. It had a substantial and expanding middle class, manufacturing jobs paid well and provided good benefits for both "blue-collar" and "white-collar" employees. Yes,...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Question 13 Case Study - Little Pear Administration Pty Ltd (LPA) You are the payroll officer for Little Pear Administration Pty Ltd (LPA). Debra Foy is a company employee and has approached you with...
-
At the beginning of 2011, a parent company sold a patent, carried on its books at $4,000,000, to its subsidiary for $3,000,000. The patent had a remaining life of five years and straight-line...
-
On July 1, 2017, Agincourt Inc. made two sales: 1. It sold excess land in exchange for a four-year, non-interest-bearing promissory note in the face amount of $1,101,460. The land's carrying value is...
-
(Appendix) Recording Purchase and Sales Transactions Refer to the information for Raymond Company in Brief Exercise 6-30. and assume that the company uses the periodic inventory system. Required:...
-
The following section is taken from Mareskas balance sheet at December 31, 2017. Current liabilities Interest payable............ $ 40,000 Long-term liabilities Bonds payable (8%, due January 1,...
-
Part U 6 7 is used in one of Broce Corporation's products. The company's Accounting Department reports the following costs of producing the 1 5 , 1 0 0 units of the part that are needed every year. \...
-
Warf Computers, Inc., was founded 15 years ago by Nick Warf, a computer programmer. The small initial investment to start the company was made by Nick and his friends. Over the years, this same group...
-
Cady Salons leased equipment from Smith Co. on January 1, 2021, in an operating lease. The present value of the lease payments discounted at 11% was $103,300. Ten annual lease payments of $15,800 are...
-
1. Super Delicious Cakes is involved in selling cakes. You are required to classify the following costs according to their behaviour either fixed cost, variable cost,semi- fixed or semi-variable...
-
(a) If z = x + iy find coefficients a, b and c such that |sin(z)| ^2 = a cos^2 (x) + b sinh^2 (y) + c cosh^2 (y)
-
List 5 examples of people (job roles) you would circulate the draft budget to for feedback or approval
-
You have just moved into your first apartment. Opening the door you notice the studio apartment you just rented is completely empty. Other than the refrigerator, dishwasher, stove, washer and dryer...
-
When car has a lifetime distribution exp(1/4), the owner wants to change the car either it is broken or the car is 8 years old. If it is replaced at 8 years (not broken), the owner pays 20, 000...
-
Question 4 1 Point Riffa Company has the following account balances for the year ended 31st December 2020: beginning work-in-process inventory $140,400; Ending work-in-process inventory $171,000:...
-
In your readings, there were many examples given for nurturing close family relationships in this ever-evolving technological society we live in Based upon your readings and research describe three...
-
Sun trek, based in China, is a global supplier of denim jeans for apparel companies around the world. They purchase raw cotton from producers in Arkansas, Mississippi, and Texas, where it is picked,...
-
Solve the linear programming model for WeeMow Lawn Service in Problem 63 using the computer. a. Which resources constrain how many jobs the service can contract for? b. If WeeMow could increase its...
-
Formulate a linear programming model for Problem 34 in Chapter 1 and solve using the computer. How does this solution differ from the solution to Problem 34 in Chapter 1?
-
Develop brief answers to each of the following questions: 1. How does a lender assess the risk that a borrower may defaultthat is, not pay interest and principal when due? 2. If a company with a high...
-
What should Cliff do? IHD was an international hospital company with hospitals in three different Central and South American countries. Cliff, IHDs chief operating officer, had worked for the...
-
Develop brief answers to each of the following questions: 1. What determines whether bonds are issued at a discount, premium, or face value? 2. Why does the market price of a bond vary over time? 3....
Study smarter with the SolutionInn App