JoShop wants to assign four different categories of machines to five types of tasks. The numbers...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
JoShop wants to assign four different categories of machines to five types of tasks. The numbers of machines available in the four categories are 25, 30, 20, and 30. The numbers of jobs in the five tasks are 20, 20, 30, 10, and 25. Machine category 4 cannot be assigned to task type 4. The table below provides the unit cost (in dollars) of assigning a machine category to a task type. The objective of this problem is to determine the optimum number of machines in each category to be assigned to each task type. Use Excel Add-in Solve to solve the problem and interpret the result. (Hint: Put a big number, such as 100, in the cell at the intersection of machine 4 and task type 4) Machine category 1 2 3 4 1 10 5 15 20 2 20557 10 15 Task type 3 3 15 14 13 4 15 527 5 9 4 15 8 JoShop wants to assign four different categories of machines to five types of tasks. The numbers of machines available in the four categories are 25, 30, 20, and 30. The numbers of jobs in the five tasks are 20, 20, 30, 10, and 25. Machine category 4 cannot be assigned to task type 4. The table below provides the unit cost (in dollars) of assigning a machine category to a task type. The objective of this problem is to determine the optimum number of machines in each category to be assigned to each task type. Use Excel Add-in Solve to solve the problem and interpret the result. (Hint: Put a big number, such as 100, in the cell at the intersection of machine 4 and task type 4) Machine category 1 2 3 4 1 10 5 15 20 2 20557 10 15 Task type 3 3 15 14 13 4 15 527 5 9 4 15 8
Expert Answer:
Answer rating: 100% (QA)
SOLUTION The given problem can be formulated into exel as follows NOTE we are us... View the full answer
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these accounting questions
-
1 2 3 Let A = 5 1 2 Find 3x3 matrices X and Y such that A = XY-YX. 1 1 -2
-
A single machine work center has five jobs assigned to it. They are labeled, in the order of their arrival in the shop, as jobs A, B, C, D and E. The work center may work on only one job at a time...
-
Each numbered figure 14 represents a cell that provides an immune defense. Each lettered figure AD shows a pathogenic microbe. Name the cell and match it with its primary target microbe and effects....
-
Consider a property investment that you finance with 20% down payment. For the remaining, you borrow 2'300'000 at a 6% rate monthly amortized loan for 25 years. This property, with 2% of EBITDA as...
-
On January 1, 2013, Mixon Co. borrowed cash from First City Bank by issuing a $90,000 face value, three-year term note that had a 7 percent annual interest rate. The note is to be repaid by making...
-
An instrument has a failure rate of 0.015 failures per year. Failures are detected once per year when a periodic inspection is performed. Assuming perfect restoration, what is the PF avg ?
-
A vibration pickup has been designed for operation above a frequency level of \(100 \mathrm{~Hz}\) without exceeding an error of \(2 \%\). When mounted on a structure vibrating at a frequency of 100...
-
A vapor mixture of n-butane (B) and n-hexane (H) contains 50.0 mole% butane at 120C and 1.0 atm, A stream of this mixture flowing at a rate of 150.0 L/s is cooled and compressed, causing some but not...
-
The "Big Bang" is not repeatable, and therefore cannot be proven scientifically. What can be done is to examine the evidence, and then a case can be made for evidence pointing to a possible scenario....
-
A bank categorizes its customers into one of three groups based on their banking habits. A random sample of 30 customers from each group was selected, and the number of times each customer visited...
-
Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company's geologist, has just finished his analysis of the mine site. He has estimated...
-
Lane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It opened negotiations with...
-
Does the salinity measured by the refractometers confirm or counter the measurements made by the hydrometers?
-
A machine costing $210,800 with a four-year life and an estimated $16,000 salvage value is installed in Luther Company's factory on January 1. The factory manager estimates the machine will produce...
-
Wanting to explore new revenue streams, Chlo decides to start selling gourmet cookies and she starts off this new venture by selling (on average) 750 cookies/month at $1.50 each. Variable costs per...
-
what ways do anthropogenic perturbations such as habitat fragmentation and landscape degradation impede the efficacy of ecological corridors in facilitating species dispersal and gene flow ?
-
Design a system S that counts people that have entered a store. S increments the count value whenever a single-bit input P changes from 1 to 0, assuming P is a signal coming from some kind of sensor...
-
a. What is the cost of borrowing if Amarjit borrows $28 500 and repays it over a four-year period? b. How many shares of each stock would he get if he used the $28 500 and invested equally in all...
-
Consider the following set of activities: a. Draw the CPM network for this problem. b. Manually determine the earliest and latest start and finish times for each activity and the amount of slack for...
-
Refer to the previous problem. Suppose that the maximum time listed for each activity is actually its normal completion time. Further assume that the maximum number of crash days per activity and...
-
Consider the revised Coal Bank Hollow recycling problem discussed in section 5.5.4 of this chapter. We said that it is safest to assume the supply in a generalized network flow problem is capable of...
-
Describe the process of valuing the entrepreneurs ownership interest in a two-stage investment. Refer to Tables 13.10 and 13.13. Data from table 13.10 Data from table 13.13 Market potential...
-
Euro Exchange Rates. The exchange rate that we consider is the amount of euros that one can purchase for one U.S. dollar. We have \(T=699\) daily observations from the period April 1, 2005, through...
-
Evaluate the current yield curve level and structure using the following screens: a. YCRV or GC to access yield curves. b. FWCV to determine implied forward rates. c. USoo03M, USoo06M, USoo09M, and...
Study smarter with the SolutionInn App