?? A company was awarded a contract that will require a total of 150 labor hours and
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company was awarded a contract that will require a total of 150 labor hours and involve three workers. 'Worker A' must be assigned at least 40% of the total number of hours assigned to the other two workers but is available a maximum of 50 hours for the project. 'Worker C must be assigned at least 15% of the total contract hours but must not exceed 25% of the total number of hours assigned to the other two workers. Workers A, B, and C earn $30, $25, and $18 per hour, respectively. The objective is determine the optimal number of hours to be assigned to each worker in order to minimize cost. The resulting linear model for this problem is given below. Min 30A +258 +18C S.T.: A + B + C = 150 A-0.4B -0.4C >= 0 A = 0.15(150) C-0.25A -0.25B = 0 Run Excel Solver and generate the Answer and Sensitivity Report What is the optimal allocation of hours? A hours hours hours B C What is the total cost? A company was awarded a contract that will require a total of 150 labor hours and involve three workers. 'Worker A' must be assigned at least 40% of the total number of hours assigned to the other two workers but is available a maximum of 50 hours for the project. 'Worker C must be assigned at least 15% of the total contract hours but must not exceed 25% of the total number of hours assigned to the other two workers. Workers A, B, and C earn $30, $25, and $18 per hour, respectively. The objective is determine the optimal number of hours to be assigned to each worker in order to minimize cost. The resulting linear model for this problem is given below. Min 30A +258 +18C S.T.: A + B + C = 150 A-0.4B -0.4C >= 0 A = 0.15(150) C-0.25A -0.25B = 0 Run Excel Solver and generate the Answer and Sensitivity Report What is the optimal allocation of hours? A hours hours hours B C What is the total cost?
Expert Answer:
Related Book For
Statistics for Management and Economics Abbreviated
ISBN: 978-1285869643
10th Edition
Authors: Gerald Keller
Posted Date:
Students also viewed these accounting questions
-
An advertising company was awarded the contract to design advertising for Rolls Royce auto-mobiles. An executive in the firm decided to pitch the product not only to the affluent in the United States...
-
An advertising company was awarded the contract to design advertising for Rolls Royce automobiles. An executive in the firm decided to pitch the product not only to the affluent in the United States...
-
(1 point) Which of the following is a correct recursive definition for f(n) = 3n+ 5? OA. f(0) = 5,f(n + 1) = 3f(n) OB. f(0) = 5,f(n + 2) = f(n) +6 Oc.f(0) = 5,f(n + 1) = f(n) + 3 D. f(0) = 3,f(n + 1)...
-
: Transcellular fluid is Specialized type of intercellular fluid O Found in confined space O includes fluid in synovial C 2+3 None of the following O
-
Classify each of the following costs for a jeans manufacturing company as a variable cost, committed fixed cost, or discretionary fixed cost. a. The cost of buttons b. The cost to lease warehouse...
-
Explain why the blackboard architecture is an effective way to combine information from a number of knowledge sources. Describe the main components of the blackboard architecture.
-
What are the advantages to making a CCP 998 offer?
-
At the beginning of November, Yoshi Inc.s inventory consists of 60 units with a cost per unit of $94. The following transactions occur during the month of November. November 2 Purchase 90 units of...
-
a) A Business organization has to make a choice between two competing projects requiring an initial investment outlay of ach one expected to generate net-cash flow i.e. after tax and before...
-
B52 Skate Training prepares adjustments annually and showed the following on its June 30, 2020, year-end: Additional information available at year-end: a. The Prepaid Arena Rental of $182,000 was...
-
Sketch the following region on a cylindrical coordinate system. Label your axes! Also describe in words what the figure looks like. 1 r 2,0 0 2, 0 z 1
-
3. A mountain climber is about to haul up a 50-m length of hanging rope. The rope weighs 0.6 N/m. (a) Express the work required to lift up the rope as an integral. (b) Find the work required to lift...
-
We began this lesson wondering who, on average, was faster: Usain Bolt, in a competitive 100-yard foot race, or Marcel Hug, in a competitive 26-mile wheelchair race. You might expect Bolt to be...
-
File: The file Corruption.xls contains country-level data on two variables. One of these is a measure of perceptions of political corruption. (This data is assembled by the organization...
-
Recall the definition of an independent set from the lecture slides: "A set of vertices X is called an independent set of a graph G=(V, E) if for all contained pairs v, w from X there is no edge (v,...
-
REI sells snowboards. Assume the following information relates to REI's purchases of snowboards during September. During the same month, 110 snowboards were sold. Date Explanation Units Unit Cost...
-
Vulcan Flyovers offers scenic overflights of Mount Saint Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company's operations in July appear below:...
-
Question 2 For an n x n matrix A = form) via (aij)
-
Setting premiums for insurance is a complex task. If the premium is too high, the insurance company will lose customers; if it is too low, the company will lose money. Statistics plays a critical...
-
Find the probabilities. P(Z < 2.84)
-
The natural remedy echinacea is reputed to boost the immune system, which will reduce the number of flu and colds. A 6-month study was undertaken to determine whether the remedy works. From this...
-
Van Morrison would like to use QuickBooks Accountant for his new company, Central Coast Cellular. You choose to use QuickBooks Accountant EasyStep Interview. The companys federal tax ID is...
-
What is the purpose of setting preferences in QuickBooks Accountant?
-
Do all businesses use account numbers?
Study smarter with the SolutionInn App