MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
8th Edition
ISBN: 9781337274876
Author: Cliff Ragsdale
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 17QP
a)
Summary Introduction
To formulate: An LP model for the problem.
b)
Summary Introduction
To sketch: The feasible region for the problem.
c)
Summary Introduction
To calculate: The optimal solution using corner points.
d)
Summary Introduction
To determine: If the additional wiring time must be acquired or not.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
PROBLEM 1b
An automobile ignition connected to a Battery is
modeled by the circuit below.
C=F
R = 3 Ω
3
V(0) 30V
L=60mH
i(0) = 2A
+
20V
C
V(t)
L
ww
R
ww
The switch has been open for a long time Find the
voltage V(t) for t≥ 0
Show all work including all necessary characteristic
equations and Boundary conditions
Which of the following would be most
appropriate basis for apportioning machinery
insurance costs to cost centers within a
factory?
Select one:
a. The flor area occupied by the
machinery in each cost Centre
b. Number of machine in each cost
Centre
c. The operating hours of each
machinery in each cost center
d. The value of machinery in each cost
center
A consumer product company makes two types of dishwasher detergents: regular and concentrate. The company has two
manufacturing facilities for making detergent products. The first facility has an operating cost of $120 an hour and can produce 300
ounces of regular detergent products per hour and 220 ounces of concentrate detergent per hour. The second facility has an hourly
operating cost of $220 and produces 350 ounces of regular detergent and 450 ounces of concentrate detergent per hour. The
company received wholesale orders totalling 4.500 ounces of regular detergent and 5.200 ounces of concentrate detergent.
a. Formulate and solve the LP model that minimizes costs given the constraints. How many hours should the company operate each
facility in order to fulfill the orders and minimize the operating cost?
Note: Round your answers to 2 decimal places.
The number of hours the company should operate the first facility
The number of hours the company should operate the second facility…
Chapter 2 Solutions
MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
Ch. 2 - Prob. 1QPCh. 2 - Prob. 2QPCh. 2 - Prob. 3QPCh. 2 - Prob. 4QPCh. 2 - Prob. 5QPCh. 2 - Prob. 6QPCh. 2 - Prob. 7QPCh. 2 - Prob. 8QPCh. 2 - Prob. 9QPCh. 2 - Prob. 10QP
Ch. 2 - Prob. 11QPCh. 2 - Prob. 12QPCh. 2 - Prob. 13QPCh. 2 - Prob. 14QPCh. 2 - Prob. 15QPCh. 2 - Prob. 16QPCh. 2 - Prob. 17QPCh. 2 - Prob. 18QPCh. 2 - American Auto is evaluating their marketing plan...Ch. 2 - Prob. 20QPCh. 2 - Prob. 21QPCh. 2 - Prob. 22QPCh. 2 - Prob. 23QPCh. 2 - Prob. 24QPCh. 2 - Prob. 25QPCh. 2 - Prob. 26QPCh. 2 - Prob. 1.1CCh. 2 - Prob. 1.2CCh. 2 - Prob. 1.3CCh. 2 - Prob. 1.4CCh. 2 - Prob. 1.5CCh. 2 - Prob. 1.6CCh. 2 - Prob. 1.7CCh. 2 - Prob. 1.8CCh. 2 - Prob. 1.9CCh. 2 - Prob. 1.10C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- A recruiter for a job placement agency is considering whether to pay $50,000 per year to lease a new recruiting facility in a prime location in Washington D. C. He estimates it will cost $50 per recruit to process the paperwork at this new location. He receives a $75 commission for each new recruit he processes. Part A - If the office space at this new location has design and effective capacities of 10,000 and 8,000 recruits processed annually, respectively, and 6,000 recruits will be processed per year, what will be the utilization of the office space?Part B - If his office space at this new location has design and effective capacities of 10,000 and 8,000 recruits processed annually, respectively, and he plans to be 90% efficient in his use of this space, how many recruits does he plan to process per year?arrow_forwardJosh Randall, a sales representative for WAI, has convincedhis customer (order #2 in Problem 9) to reschedule. Order #2 hasagreed to accept delivery of 25 units in week 2 as long as WAIcan also guarantee delivery of an additional 25 units in week 5.If WAI cannot meet both delivery requirements, the customerhas threatened to withdraw its entire order. You have alreadypromised orders 1, 3, and 4. Can you assure Josh that WAI willdeliver on time? Show your calculations.arrow_forwardA massive network of seawalls is possibly going to be constructed right in the middle of Miami Beach's South Beach, which has beachfront property owners in the area concerned about the seawalls' effects on their property values. To monetize the effects of the seawalls on property values, one could use the nonmarket valuation technique. а. travel cost b. averting behavior С. hedonic d. contingent valuationarrow_forward
- 4. Optimal Rental Decisions in Cloud Computing Assume that AWS has the following 3 options for renting servers. Fraction of Job in one Server Description Rental Low Power Medium Power High Power $2/hr. $4/hr. $9/hr. Hour 1/8 1/6 1/3 L M Note that if you rent a server for less than one hour, you still must pay the rent for the entire hour. You have a job that must finısh in at most 5 hours. The low-power server can finish 1/8th of the job in 1 hour, the medium-power server can finish 1/6 of the job in one hour, and the high- power server can finish 1/3rd of the job in one hour. (a) The typical practice used by most firms is to find a single server that can do the work at the least cost and within the available time. Find the best sıngle server solution-that is, which single server should you use and for how many hours will you rent this server?arrow_forwardUse the following information to answer the question(s) below. Cerebro Manufacturing produces four types of structural support fittings-plugs, rails, rivets, and clips-which are machined on two CNC machining centers. The machining centers have a capacity of 250,000 minutes per year. The gross margin per unit and machining requirements are shown in the spreadsheet below. D E F 11 2 3 A Cerebro Manufacturing Model 6 17 8 Product 14 Gross margin/unit Minutes/unit 15 Gross margin/minute Maximum production Profit B O 125,000 O 250,000 O None of the above C Machine Rivets Clips Capacity (mins./year) Plugs Rails $0.40 $ 1.20 $0.80 $1.10 13 1.5 250,000 Assuming that one half of the machine capacity is used for the production of plugs. What is the maximum possible production of plugs based on this capacity? O 166,666.67 83,333.33arrow_forwardHMO has 40 doctors to be apportioned among four clinics. The HMO decides to apportion the doctors based on the average weekly patient load for each clinic, given in the following table. Clinic A B C D Average Weekly 275 392 611 724 Patient Load Find the apportion of A and C using using Adam's Method. Use modified divisor 52. Doctors for clinic A Doctors for clinic B = %3D Doctors for clinic C= Doctors for clinic D =arrow_forward
- A fixed cost of $50 thousand was incurred in setting up an operation. At time t months thereafter, the operation yields income at the rate of (20 - 0.3t) and incurs expense at the rate of (10 - 0.1t), where both rates are in thousands of dollars per month. What is the optimal time to terminate the operation? What will total profit be at the optimal time of termination?arrow_forwardThe subject property has a pool valued at $30,000 and two bathrooms valued at $10,000 each. Comp 1 does not have a pool and has one less bathroom than the subject property. What adjustments should be made to Comp 1's value? subtract $40,000 from Comp 1's value add $40,000 to Comp 1's value add $20,000 to Comp 1's value subtract $20,000 from Comp 1's valuearrow_forwardAn industrial system has two industries with the following input requirements. (a) To roduce $1.00 worth of output, Industry A requires $0.20 of its own products and $0.50 of industry B's products. (b) To produce $1.00 worth of output, industry B requires $0.40 of its own product and $0.30 of industry A's product. Find D, the input-output matrix for this system. D = ? Solve for the output matrix X in the equation X = DX + E where E is the external demand matrix E= [10,000] [20,000] (Round to the nearest whole number.)arrow_forward
- A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 Note: This question requires Solver.Formulate the problem in Solver and find the optimal solution. What is the optimal quantity to ship from Factory B to Customer 3? Multiple Choice 25 units 50 units 75 units 100 units 125 unitsarrow_forwardAt a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a minimum cost flow problem by showing the…arrow_forwardAt a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i B 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a shortest-path problem by drawing a…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,