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 26QP
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Denmark Corporation sells computer equipment to businesses in the western region of the United States. Each month, the IT division at Demark Corporation prints monthly statements and sends them to the accounts receivable (AR) department, where
a clerk mails them to the customers. This corporation's customers mail their payments back to Denmark, where a clerk in AR batches the checks and sends them to the cashier. The AR clerk then uses the payment stub to enter the payments into the
computer, where the AR master data are updated to record the payment. Please use this to complete the diagrams and charts below. Please use excel or word for the diagrams.
Problem 1. Please create a table of entities and activities
Problem 2. Draw a context diagram to support the entities in problem 1.
Problem 3. Draw a physical DFD. Please use MS products i.e. word or excel to create this diagram
A large building may require an automated alarm system which monitors and controls all fire and security alarms in the building. Normally, the building is divided into zones and a number of alarms are associated with each zone. Alarms alert a central manned control area who may pass these on to the emergency services or may respond personally.Factors which have to be taken into account in building such a system are:Ø If the control area is unmanned and an alarm is activated this alarm should not be ignored if it is potentially serious. Emergency services should be automatically called.Ø Some but not all parts of the building may be equipped with sprinkler systems or systems to shut down electrical equipment. These should be activated if a fire alarm is confirmed. They should not be activated if there are people in the same room.Ø The building may be equipped with direction indicators which illuminate the route to the nearest exit. These should be activated when a fire alarm is…
The Decision Sciences Department is trying todetermine whether to rent a slow or a fast copier. Thedepartment believes that an employee’s time is worth$15 per hour. The slow copier rents for $4 per hour,and it takes an employee an average of 10 minutes tocomplete copying. The fast copier rents for $15 per hour,and it takes an employee an average of six minutes tocomplete copying. On average, four employees per hourneed to use the copying machine. (Assume the copyingtimes and interarrival times to the copying machineare exponentially distributed.) Which machine shouldthe department rent to minimize expected total cost perhour?
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
- The Decision Sciences Department is trying to determine whether to rent a slow or a fast copier. The department believes that an employee’s time is worth $15 per hour. The slow copier rents for $4 per hour, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15 per hour, and it takes an employee an average of six minutes to complete copying. On average, four employees per hour need to use the copying machine. (Assume the copying times and interarrival times to the copying machine are exponentially distributed.) Which machine shouldthe department rent to minimize expected total cost per hour?arrow_forwardThe Decision Sciences Department is tyring to determine whether to rent a slow or fast copier. The department believes that an employee's time is worth $15/hour. The slow copier rents for $4/hr, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15/hr, and it takes an employee an average of 6 minutes to complete copying. On average, four employees per hour need to use the copying machine. (Assume the copying times and interarrival times to the copying machine are exponentially distributed.) Which machine should the department rent to minimize expected total cost per hour? Please note this class revolves around Microsoft Excel so the answer I need needs to show the formulas in Excel, along with any corresponding graphs, etc. Thank you in advance!arrow_forwardDuring an eight-hour shift, 750 non-defective parts are desired as a result of a manufacturing operation. The default operation time is 15 minutes. As the operators of machine are inexperienced, the actual time they take to perform the operation is 20 minutes, and, on average, a fifth of the parts that start to be manufactured are lost. Assuming that each one of the machines used in this operation will not be available for one hour in each shift, determine the number of machines needed.arrow_forward
- FRUIT COMPUTER COMPANY Fruit Computer Company manufactures memory chips in batches of ten chips. From past experience, Fruit knows that 80% of all batches contain 10% (1 out of 10) defective chips, and 20% of all batches contain 50% (5 out of 10) defective chips. If a good (that is, 10% defective) batch of chips is sent to the next stage of production, processing costs of $4000 are incurred, and if a bad batch (50% defective) is sent on to the next stage of production, processing costs of $16000 are incurred. Fruit also has the alternative of reworking a batch at a cost of $4000. A reworked batch is sure to be a good batch. Alternatively, for a cost of $400, Fruit can test one chip from each batch in an attempt to determine whether the batch is defective. QUESTIONS 1.Determine a strategy so Fruit can minimize the expected total cost per batch. 2.Compute the EVSI and EVPI.arrow_forwardMeritor, a company that makes muffler assemblies for the automotive industry, is committed to the use of kanban to pull material through its manufacturing cells. Meritor has designed each cell to fabricate a specific family of muffler products. Fabricating a muffler assembly involves cutting and bending pieces of pipe that are welded to a muffler and a catalytic converter. The mufflers and catalytic converters are pulled into the cell based on current demand. The catalytic converters are made in a specialized cell. Catalytic converters are made in batches of 10 units and are moved in special hand carts to the fabrication cells. The catalytic converter cell is designed so that different types of catalytic converters can be made with virtually no setup loss. Meritor hires a team of consultants. The consultants suggest a partial robotic automation as well as the safety stock to be 9 percent. Meritor implements these suggestions. The result is an increase in efficiency in both the…arrow_forwardA manufacturing facility stores spare parts for maintenance in a storage facility. Throughout theworking day, manufacturing personnel go to the storage facility to pick up supplies needed for theirjobs. The storage facility employees receive a request for supplies, on average, every five minutes fromthe manufacturing personnel. The average request requires 3.2 minutes to fill a request. Manufacturingpersonnel are paid $29.50 per hour and storage facility employees are paid $18.75 per hour. The storagefacility operates 8 hours per day. Base your costs on an 8-hour workday, the given arrival and servicerates, and the fact that when the manufacturing personnel are at the storage site picking up parts – theyare unable to complete their normal job in manufacturing.a) What is the system cost per day (to the nearest $) if there is only 1 storage facility employeeworking?b) What is the system cost per day (to the nearest $) if there are 2 storage facility employeesworking?c) What is the system…arrow_forward
- Laredo Leather Company’s production manager, Jack Murray, has been under pressure from the company president to reduce the cost of conversion. In spite of several attempts to reduce conversion costs, they have remained more or less constant. Now Murray is faced with an upcoming meeting with the company president, at which he will have to explain why he has failed to reduce conversion costs. Murray has approached his friend, Jeff Daley, who is the corporate controller, with the following request: “Jeff, I’m under pressure to reduce costs in the production process. There is no way to reduce material cost, so I’ve got to get the conversion costs down. If I can show just a little progress in next week’s meeting with the president, then I can buy a little time to try some other cost-cutting measures I’ve been considering. I want you to do me a favor. If we raise the estimate of the percentage of completion of October’s inventory to 60 percent, that will increase the number of equivalent…arrow_forwardThe ore of a gold mine in the province contains, on average, 0,5 ounce of gold per ton Method A of processing costs 150Photon and recovers 93% of the gold, while Method B costs only 120Php/ton and recovers 81% of the gold. If gold can be sold at 1,200/ounce, which method is better and by how much?arrow_forwardThe Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Orders 145 70 115 85 120 54 82 141 123 94 Compute the…arrow_forward
- The Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Orders 145 70 115 85 120 54 82 141 123 94 Compute the…arrow_forwardThe Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Orders: 1230 1155 1263 1159 1361 1273 1147 1250 1356 1155 Create tables to support your answer: a. Compute the monthly…arrow_forwardA manufacturer has a production facility that requires 10,237 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 6 days. The unit purchase cost is $31.4 per unit. The cost to place and process an order from the supplier is $168 per order. The unit inventory carrying cost per year is 12.2 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 1,053 units per order, what is the annual holding cost? Use at least 4 decimal places.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,