Question: A technical college department head must plan the course offerings for the next term. Student demands make it necessary to offer at least 20 core

A technical college department head must plan the course offerings for the next term. Student demands make it necessary to offer at least 20 core courses (each of which counts for 3 credit hours) and 20 elective courses (each of which counts for 4 credit hours) in the term. Faculty contracts dictate that a total of at least 60 core and elective courses and at least 205 total credit hours be offered. Each core course taught costs the college an average of $2,600 in faculty salaries and each elective course costs $3,000. How many each of core and elective courses should be scheduled so that total faculty salaries are kept to a minimum?

Step by Step Solution

★★★★★

3.47 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

718-M-S-L-P (1004).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

A college math department consisting of 10 faculty members must choose a department head, an assistant department head, and a faculty senate representative. In how many ways can this be done?

Kelly Spaugh, course scheduler of a technical colleges business department, needs to assign instructors to courses next semester. As a criterion for judging who should teach each course, Kelly...

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...

help 6.38 with spreadsheet please !!! minimized. The feed is used is e grains that contain the following us CHAPTER 6. LINEAR PROGRAMMING MODELS GRAPHICAL AND LOW pound of feed NUTRIENT ONCE POUND OF...

Please open a blank Excel file to answer the following questions. A technical college department head must plan the course offerings for the next term. Student demands make it necessary to offer at...

Must use simplex in solver 3) A technical college department head must plan the course offerings for the next term. Student demands make it necessary to offer at least 30 core courses (each of which...

1) A technical college department head must plan the course offerings for the next term. Stuplent demands make it necessary to offer at least 5 core courses (each of which counts for 3 credit hours)...

7 (Course planning) The dean of a business school in Saskatoon must plan the school's course offerings for the next term. Student demands make it necessary to offer at least 20 core courses (each of...

The following account appears in the ledger prior to recognizing the jobs completed in January: Work in Process Balance, January 1 $72,000 Direct materials 390,000 Direct labor 500,000 Factory...

The tensile strength of brittle materials may be determined using a variation of Equation 8.1. Compute the critical crack tip radius for an Al2O3 specimen that experiences tensile fracture at an...

Is book value per share ( answer to part b ) the amount common stockholders should expect to receive if Rothchild Corporation were to cease operations and liquidate? Explain.

Alternate problem G Following are data related to a product of Coen Company for the year 2010: Unit Units Cost Merchandise Inventory, January 1 2,100 @ $12.60 Purchases: March 10 1,500 @ 12.00 May 24...

13 Marc Hernandezs construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide for Hernandezs needs, but...

12 The Oconee County, South Carolina, superintendent of education is responsible for assigning students to the three high schools in his county. A certain number of students have to travel to and...

8 How can we manipulate a maximal-flow network model in order to set it up as a linear program?

Consider the following information: Portfolio Expected Return Standard Deviation Risk-free 12 % 0 Market 12.8 1.0 A 11.5 0.8 a. Calculate the expected return of portfolio A with a beta of 0.8. (Round...

Remaining Time: 23 minutes, 06 seconds. Question Completion Status: Clone Wind > Moving to another question will save this response. Question of 14 estion 6 Sara wants to open a current account....

Q 2 . Write the algorithm which sorts the array by using the merge sort algorithm. Then find the complexity of the algorithm as Big O notation. Q 2 . Write the algorithm which sorts the array by...