M20 1 2 674 OWN 3 4 5 6 8 9 10 12 13 14 15...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
M20 1 2 674 OWN 3 4 5 6 8 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 A > B X fx C Wage Rate Monday 6 K.C. $20.00 D.H. $20.20 H.B. $19.80 S.C. $19.60 K.S. $21.60 N.K. $22.60 Hours Needed 0 4 5 3 0 14 060 Hours Available Tuesday Wednesday Thursday 6 0 8 5 0 0 14 E Hours Worked 609 4 5 3 - 0 F 14 60 0 co co 8 6 14 G Friday Total hours worked Total Pay 6 18 0 12 4 20 5 20 14 8 NO 2 14 H Oxbridge University maintains a powerful mainframe computer for research use by its faculty, Ph.D. students, and research associates. During all working hours, an operator must be available to operate and maintain the computer, as well as to perform some programming services. Beryl Ingram, the director of the computer facility, oversees the operation. It is now the beginning of the fall semester and Beryl is confronted with the problem of assigning different working hours to her operators. Because all the operators are currently enrolled in the university, they are available to work only a limited number of hours each day. There are six operators (four undergraduate students and two graduate students). They all have different wage rates because of differences their experience with computers and in their programming ability. The following table shows their wage rates, along with the maximum number of hours that each can work each day. Operators K.C. D.H. H.B. S.C. K.S. N.K. Wage Rate. $20.00 per hour per hour $20.20 $19.80 per hour $19.60 per hour $21.60 per hour $22.60 per hour Click here for the Excel Data File Total cost Determine the total cost. Monday 6 0 4 5 3 0 Tuesday 0 6 8 5 0 0 Hours Available Wednesday 6 0 4 5 3 0 Thursday 0 6 0 0 8 6 Each operator is guaranteed a certain minimum number of hours per week that will maintain an adequate knowledge of the operation. This level is set arbitrarily at 6 hours per week for the undergraduate students (K. C., D. H., H. B., and S. C.) and 6 hours per week for the graduate students (K. S. and N. K.). The computer facility is to be open for operation from 8 AM to 10 PM Monday through Friday with exactly one operator on duty during these hours. On Saturdays and Sundays, the computer is to be operated by other staff. Because of a tight budget, Beryl has to minimize cost. She wishes to determine the number of hours she should assign to each operator on each day. Formulate and solve a spreadsheet model for this problem. Friday 6 0 4 5 0 2 M20 1 2 674 OWN 3 4 5 6 8 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 A > B X fx C Wage Rate Monday 6 K.C. $20.00 D.H. $20.20 H.B. $19.80 S.C. $19.60 K.S. $21.60 N.K. $22.60 Hours Needed 0 4 5 3 0 14 060 Hours Available Tuesday Wednesday Thursday 6 0 8 5 0 0 14 E Hours Worked 609 4 5 3 - 0 F 14 60 0 co co 8 6 14 G Friday Total hours worked Total Pay 6 18 0 12 4 20 5 20 14 8 NO 2 14 H Oxbridge University maintains a powerful mainframe computer for research use by its faculty, Ph.D. students, and research associates. During all working hours, an operator must be available to operate and maintain the computer, as well as to perform some programming services. Beryl Ingram, the director of the computer facility, oversees the operation. It is now the beginning of the fall semester and Beryl is confronted with the problem of assigning different working hours to her operators. Because all the operators are currently enrolled in the university, they are available to work only a limited number of hours each day. There are six operators (four undergraduate students and two graduate students). They all have different wage rates because of differences their experience with computers and in their programming ability. The following table shows their wage rates, along with the maximum number of hours that each can work each day. Operators K.C. D.H. H.B. S.C. K.S. N.K. Wage Rate. $20.00 per hour per hour $20.20 $19.80 per hour $19.60 per hour $21.60 per hour $22.60 per hour Click here for the Excel Data File Total cost Determine the total cost. Monday 6 0 4 5 3 0 Tuesday 0 6 8 5 0 0 Hours Available Wednesday 6 0 4 5 3 0 Thursday 0 6 0 0 8 6 Each operator is guaranteed a certain minimum number of hours per week that will maintain an adequate knowledge of the operation. This level is set arbitrarily at 6 hours per week for the undergraduate students (K. C., D. H., H. B., and S. C.) and 6 hours per week for the graduate students (K. S. and N. K.). The computer facility is to be open for operation from 8 AM to 10 PM Monday through Friday with exactly one operator on duty during these hours. On Saturdays and Sundays, the computer is to be operated by other staff. Because of a tight budget, Beryl has to minimize cost. She wishes to determine the number of hours she should assign to each operator on each day. Formulate and solve a spreadsheet model for this problem. Friday 6 0 4 5 0 2
Expert Answer:
Related Book For
Linear Algebra And Its Applications
ISBN: 9781292351216
6th Global Edition
Authors: David Lay, Steven Lay, Judi McDonald
Posted Date:
Students also viewed these general management questions
-
A road building company is purchasing an excavator for $500,000. The corporate tax rate is 45% and the expected after-tax rate of return is 12%. What would be the present value of the future tax...
-
(20 points)Write a program that prompts the user to input five decimal numbers. The program should then add the five decimal numbers, convert the sum to the nearest integer, and print the result....
-
What functions are normally associated with the production cycle?
-
A 5 kg sphere is dropped from a height y=3 m to test a new spring floor used in gymnastics. The mass of the floor section B is 12 kg, and the sphere bounces back upwards a distance of 44 mm. Knowing...
-
Find fx, fy, and fx. The symbol 2 is the Greek letter lambda. f(x, y, ) = x + y - 2(3x + 7y-17) = fx - = fx =
-
This text indicates that one of the roles of managers is to make decisions about organising resources. How can a human resource manager use differential analysis in deciding the appropriate number...
-
Brilles offered to sell his used automobile to Nevarro for $12,600 cash. Nevarro agreed to buy the car, gave Brilles a check for $12,600, and drove away in the car. The next day Nevarro sold the car...
-
Imagine that you oversee quality control for a production line in a candy company. The production line is responsible for filling 12 ounces of candy in packages labeled with weight of 12 oz. Package...
-
Macarrys Bicycle Company makes and sells high-quality bicycles, primarily to larger North American bicycle retail outlets and to some wholesalers for smaller retail shops. They have several models,...
-
answer the question: 1. What are your perceptions of another person's integrity that may impact your view of an organization's ethical foundation? 2. What can an organization to do bridge these two...
-
What is the purpose of an intermediate error event? a. Indicates a change in flow due to a process exception b. Indicates the end of a process c. Indicates the start of a collapsed subprocess d....
-
Which of the following is not an example of business process documentation? a. Business process models b. Training manuals c. Organization charts d. Internal audit e. All of these are examples of...
-
Which activity results in an increase to accounts payable? a. Request prices b. Place purchase order c. Receive items d. Return rejected items e. Send payment
-
Which of the following best describes the value of business models? a. A communication tool b. A planning tool c. A process improvement tool d. A tool for managing complexity e. All of these describe...
-
Which of the following is true about intermediate timer events? a. The process delays until a specific date or time. b. The process delays until a message is thrown. c. The process delays for an...
-
What are the units of the slope (1915) (b) If the capacitance is 2 nanofarads nF, what is the area ( A ) of the plates (c) What is the relative static permittivity of the insulating layer (d) If the...
-
Explain how two samples can have the same mean but different standard deviations. Draw a bar graph that shows the two samples, their means an standard deviations as error bars. T S
-
Determine which sets are bases for R 2 or R 3 . Justify each answer. -2 -5 - 1 2 7 -5
-
Consider the mouse in the following maze from Section 10.1, Exercise 18. What fraction of the time does it spend in room 3? Data From Section 10.1 Exercise 18 The mouse is placed in room 3 of the...
-
Mark each statement True or False (T/F). Justify each answer on the basis of a careful reading of the text. (T/F) If S is a linearly dependent set, then each vector is a linear combination of the...
-
solve the given problem using PSO method \[f(X)=1200\left(2 x_{1} x_{3}+2 x_{2} x_{3} ight)+2500 x_{1} x_{2}+500\left(\frac{1000}{x_{1} x_{2} x_{3}} ight)+100\left(\frac{1000}{10 x_{1} x_{2} x_{3}}...
-
Solve the optimization problem using SA \[\min f(X)=100\left(x_{1}^{2}+x_{2} ight)^{2}+\left(1-x_{1} ight)^{2}\] subject to $X \in[0,7]$
-
Discuss the perturbation mechanism of simulated annealing.
Study smarter with the SolutionInn App