Linear program-solution using excel QM
Not what you're looking for?
Using Excel QM show and solve the following problem:
The dean of Western college of business must plan the school's course offerings for the fall semester. Student demand makes 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 $2500 in faculty wages, and each graduate course costs $3000. How many undergraduate and graduate courses should be taught in the fall so that total faculty salaries are kept to a minimum?
Purchase this Solution
Solution Summary
This solution illustrates the use of Excel-QM for solving a linear programming problem.
Solution Preview
** Please see the attachments for the complete solution **
I have done the problem using Excel QM. Thanks.
Solution
The decision variables are
X1 = Number of Undergraduate courses
X2 = Number of ...
Purchase this Solution
Free BrainMass Quizzes
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.