Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
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
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
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_forward4. 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_forwardA9)arrow_forward
- Josh 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_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
- The 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_forwardA gold mining area in Lanao contains on average 1 ounce of gold per ton. Two methods of processing are available; method a cost 1.5m per ton and recovers 90% of gold: method b cost 1.3m per ton and recovers 80% of the gold. If gold can be sold for 2.4m per ounce which method is better and by how mucharrow_forward14arrow_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_forwardHERO Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of pesos) depends on demand as follows: Demand Demand Demand Staffing Options High Medium Low Own staff 352 325 300 Outsider vendor 450 300 150 Combination 400 325 250 If the decision maker knows nothing about the probabilities of the four states of nature, what is the recommended decision using:i. the optimistic approach and the conservative approach iii. the minimax regret approach iv. the Laplace methodarrow_forwardPROBLEM The management of the Book Warehouse Company wishes to apply the Miller-Orr model to manage its cash investment. They have determined that the cost of either investing in or selling marketable securities is $100. By looking at Book Warehouse’s past cash needs, they have determined that the variance of daily cash flows is $20,000. Book Warehouse’s opportunity cost of cash, per day, is estimated to be 0.03%. Based on experience, management has determined that the cash balance should never fall below $10,000. 1. How much is the cost per transaction?(Use a number, no decimal value, no commas, no currency, no space) * 2. How much is the return point based on the Miller-Orr model of cash management? (Use a number, no decimal value, no commas, no currency, no space) * 3. How much is the upper limit based on the Miller-Orr model of cash management?(Use a number, no decimal value, no commas, no currency, no space) * PLEASE ANSWER ALL QUESTIONS. THANKS!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,