PROBLEM 5 Brenda Mage, an undergraduate accountancy major at Ateneo de Zamboanga University, is attempting to determine her course schedule for the first semester. She is considering seven 3-credit- hour courses, which are shown in the following table. Also included are the average number of hours she expects to have to devote to each course each week (based on information from other students) and her minimum expected grade in each course, based on an analysis of the grading records of the teachers in each course: Course Management I Principles of Accounting Corporate Finance Quantitative Methods Marketing Management Java Programming English Literature Average Hours per week 510807108 12 Minimum Grade 3.0 2.0 2.0 1.0 2.0 1.0 3.0 Brenda wants to select a schedule that will provide at least a 2.0 grade point average. In order to remain a full-time student, which she must do to continue receiving financial aid, she must take at least 12 credit hours. Principles of Accounting, Corporate Finance, Quantitative Methods, and Java Programming all require a lot of computing and mathematics, and Brenda would like to take no more than two of these courses. To remain on schedule and meet prerequisites, she needs to take at least three of the following courses: Management I, Principles of Accounting, Java Programming, and English Literature. Brenda wants to develop a course schedule that will minimize the number of hours she has to work each week. Required: Solve this model by using the computer. Indicate how many total hours Brenda should expect to work on these courses each week and her minimum grade point average.
PROBLEM 5 Brenda Mage, an undergraduate accountancy major at Ateneo de Zamboanga University, is attempting to determine her course schedule for the first semester. She is considering seven 3-credit- hour courses, which are shown in the following table. Also included are the average number of hours she expects to have to devote to each course each week (based on information from other students) and her minimum expected grade in each course, based on an analysis of the grading records of the teachers in each course: Course Management I Principles of Accounting Corporate Finance Quantitative Methods Marketing Management Java Programming English Literature Average Hours per week 510807108 12 Minimum Grade 3.0 2.0 2.0 1.0 2.0 1.0 3.0 Brenda wants to select a schedule that will provide at least a 2.0 grade point average. In order to remain a full-time student, which she must do to continue receiving financial aid, she must take at least 12 credit hours. Principles of Accounting, Corporate Finance, Quantitative Methods, and Java Programming all require a lot of computing and mathematics, and Brenda would like to take no more than two of these courses. To remain on schedule and meet prerequisites, she needs to take at least three of the following courses: Management I, Principles of Accounting, Java Programming, and English Literature. Brenda wants to develop a course schedule that will minimize the number of hours she has to work each week. Required: Solve this model by using the computer. Indicate how many total hours Brenda should expect to work on these courses each week and her minimum grade point average.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter6: Optimization Models With Integer Variables
Section: Chapter Questions
Problem 100P
Related questions
Question
100%
PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.
I REPEAT, ONLY EXCEL
Transcribed Image Text:PROBLEM 5
Brenda Mage, an undergraduate accountancy major at Ateneo de Zamboanga University, is
attempting to determine her course schedule for the first semester. She is considering seven 3-credit-
hour courses, which are shown in the following table. Also included are the average number of hours
she expects to have to devote to each course each week (based on information from other students)
and her minimum expected grade in each course, based on an analysis of the grading records of the
teachers in each course:
Course
Management I
Principles of Accounting
Corporate Finance
Quantitative Methods
Marketing Management
Java Programming
English Literature
Average Hours per week
5
10
8
12
7
10
8
Minimum Grade
3.0
2.0
2.0
1.0
2.0
1.0
3.0
Brenda wants to select a schedule that will provide at least a 2.0 grade point average. In order to
remain a full-time student, which she must do to continue receiving financial aid, she must take at
least 12 credit hours. Principles of Accounting, Corporate Finance, Quantitative Methods, and Java
Programming all require a lot of computing and mathematics, and Brenda would like to take no more
than two of these courses. To remain on schedule and meet prerequisites, she needs to take at least
three of the following courses: Management I, Principles of Accounting, Java Programming, and
English Literature. Brenda wants to develop a course schedule that will minimize the number of hours
she has to work each week.
Required:
Solve this model by using the computer. Indicate how many total hours Brenda should expect to work
on these courses each week and her minimum grade point average.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 5 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,