Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 24QP
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 level
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
There are two companies manufacturing drones. Company A manufactures mass market drones, while company B manufactures customised drones according to customers’ requirements. In 2020, company A produces 3,200 drones, 3% of which were found to be defective and cannot pass the quality check. Company A employs 5 workers working an average of 8 hours a day in the drone production, and they worked 200 working days in 2020.In contrast, company B produces 900 drones, 10% of which were found to be defective and cannot pass the quality check. Company B employs 3 workers working an average of 6 hours a day in the drone production, and they worked 170 days in 2020.
(a) If the drone manufacturing is seen as a process, what is considered as the output of the production processes of companies A and B and why?
(b) Measure the single-factor manpower productivity for the two companies.
(c) Is it reasonable to compare the manpower productivity of the two companies and reach a conclusion that one company…
A retail store sold in the month of April 5,000 products that produced $45,000 in sales. In the month of
May the company sold 6,000 products. The store workforce consists of four full-time workers who work 40-hour week.
In April the store also had seven part-time workers at 10 hours per week, and in May the store had nine part-timers at 15
hours per week (assume four weeks in each month). Using sales dollars as the measure of output (assume the price of the
product was the same for both months), what is the percentage change in labor productivity from April to May?
Answer:
2.
4) The making of rivet holes in structural steel members can be done by 2 methods. The first method consists of laying out the
position of the holes in the members and using a drill press costing P100k. The machinist is paid P60 per hour and he can drill
80 holes per hour. The second method makes use of a multiple-punch machine costing P80k. The punch operator is paid P40
an hour and he can punch out 1 hole for 3 seconds. This method also requires an expense of P1.25 per hole to set the
machine. (a) if all other costs are assumed equal, what is the total cost for each machine for 10k holes, assuming the total cost
of each machine to be charged to these holes? (b) for how many holes will the costs be equal?
Chapter 2 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
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
- fi Auto mobile company manufactures cars and trucks. Each vehicle must be processed in the paint shop and body assembly shop. If the paint shop were only painting trucks, then 80 per day could be painted. If the paint shop were only painting cars, then 120 per day could be painted. If the body shop were only producing cars, then it could process 100 per day. If the body shop were only producing trucks, then it could process 100 per day. Each truck contributes GHS60,000 to profit, and each car contributes GHS40,000 to profit. Use linear programming to determine a daily production schedule that will maximize the company’s profits.arrow_forwardThere are 10 apples in a basket Each apple has 4 worms. HOW MANY Worms do the apples have have in allarrow_forwardAssuming your company is producing Apple and Samsung phone cases. It is required to process in the assembly and paint shops to make either phone case. It takes 1/60 of a day and 1/40 of a day to paint an Apple case and a Samsung case in the paint shop, respectively. It takes 1/50 of a day to assemble either type of case in the assembly shop. An Apple phone case and a Samsung phone case yield profits of $300 and $220, respectively, per case sold. What is a maximum-profit daily production plan for your company?arrow_forward
- Three methods can be used for producing heat sensors for high-temperature furnaces. Method A will have a fixed cost of $140,000 per year and a production cost of $62 per part. Method B will have a fixed cost of $210,000 per year and a production cost of $28 per part. Method C will require the purchase of equipment costing $500,000. It will have a life of five years and a 25% of first cost salvage value. The production cost will be $53 per part. At an interest rate of 10% per year, determine the breakeven annual production rate between the two lowest cost methods.arrow_forwardTyler bakes Cookies (C) and Breads (B) with the help of two ovens in his little bakery. The time taken by Oven A to bake each cookie batch is 14 minutes and the time taken by Oven B is 12 minutes. The time taken by Oven A to bake a batch of bread is 16 minutes and the time taken by Oven B is 17 minutes. Each week both Ovens can be used for 50 hours each to bake Cookies and Breads. The rest of the time is used for baking other products. Moreover, Tyler starts each week with a stock of 25 batches of Cookies and 30 batches of Breads because the Cookies and Breads he produces can be considered to be “fresh” for a maximum of 2 weeks. There is an average weekly demand of 70 batches of Cookies and 50 batches of Breads. For each batch of Cookies, Tyler makes $30 in profit and for each batch of Breads Tyler makes $25 in profit. If there are any “close to losing freshness” goods at the end of the week, Tyler sells them at heavily discounted prices on weekends with a profit of $5 per batch of…arrow_forwardThere is an upstream Picking department that feeds two downstream Packing departments: Pack Singles and Pack Multis. Those Packing departments feed to a Shipping department that loads the outgoing trucks. 40% of your Pick volume goes to Pack Singles and has a packing rate of 104 units per labor hour (uph). 60% of the Pick volume goes to Pack Multis and has a pack rate of 215 units per labor hour. Your pickers pick both Single and Multi items throughout the day at an overall average rate of 114 units per labor hour. All units that are packed in both processes go through the Ship process at a rate of 570 units per hour. You have 102 people today for all 4 departments and you absolutely must pack 47,880 units in Pack Multis Items to meet a customer promise metric. How do you allocate labor to balance the flow in your department if you work a 10 hour shift? Do not assume breaks or lunches in your answer. Redirect 1: You now need to process all of the Pack Singles Volume in the first 5…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_forwardHarvesting Fruit Toward the middle of the harvesting sea-son, peaches for canning come in three types, early, late, and extra late, depending on the expected date of ripening. During a certain week, the following data were recorded at a fruit delivery station:34 trucks went out carrying early peaches;61 carried late peaches;50 carried extra late;25 carried early and late;30 carried late and extra late;8 carried early and extra late;6 carried all three;9 carried only fgs (no peaches at all).(a) How many trucks carried only late variety peaches?(b) How many carried only extra late?(c) How many carried only one type of peach?(d) How many trucks (in all) went out during the week?arrow_forwardHarvesting Fruit Toward the middle of the harvesting sea-son, peaches for canning come in three types, early, late, and extra late, depending on the expected date of ripening. During a certain week, the following data were recorded at a fruit delivery station:34 trucks went out carrying early peaches;61 carried late peaches;50 carried extra late;25 carried early and late;30 carried late and extra late;8 carried early and extra late;6 carried all three;9 carried only fgs (no peaches at all). (a) How many trucks carried only late variety peaches?(b) How many carried only extra late?(c) How many carried only one type of peach?(d) How many trucks (in all) went out during the week? with a venn diagramarrow_forward
- Thomas has eight horses averaging 1,400 pounds. They are on 20 acres of orchard grass and clover. Each year, Thomas applied 30-30-30 units of fertilizer per acre using 46-0-0 urea at $408 per ton, 18-46-0 DAP at $496 per ton, and 0-0-60 muriate of potash at $506 per ton. He reseeded with 10 pounds per acre of orchard grass at $1.19 per pound and 2 pounds per acre of clover at $3.18 per pound. The horses are housed in a barn 34 feet wide with stalls 12 by 12 feet on each side and a 10-foot aisle down the center. He needs at least one fifth of the barn, not including the center, for hay and tack room. What did it cost to fertilize and reseed the pasture? How long must he barn be in even number of feet?arrow_forwardA political party is planning a half-hour television show. The show will have at least 3 minutos of direct requests for money from viowers Three of the party's politicians will be on the show-a senator, a congresswoman, and a governor The senator, a party "elder statesman," demands that he be on screen for at least twice as long as the governor The total time taken by the senator and the governor must be at least twice the time taken y the congresswoman Based on a pre-show survey, it is believed that 33, 38, and 43 (in thousands) viewers will watch the program for each minute the senator, congresswoman, and governor, respectively, are on the air. Find the time that should be allotted to each politician in order to get the maximum number of viewers Find the maximum number of viewers The quantity to be maximized, z, is the number of viewers in thousands. Let x, be the total number of minutes allotted to the senator, x, be the total number of minutes allottod to the congresswoman, and x,…arrow_forwardKAPC, a pharmaceutical company located in rural Kansas, is finding it difficult to retain its employees, who frequently leave after just six months of working at KAPC for jobs at pharmaceutical companies paying higher wages in Chicago. To address its problem with labor turnover, human resource officers at KAPC decide to run an experiment. Of their next 100 newly hired employees, 25 will randomly be selected to receive a housing voucher worth up to $4,000 per year to offset property taxes. To take advantage of this program, the employee must not only be randomly selected into the program but she must also purchase a home. Of the 25 employees selected into the housing voucher program, 7 leave KAPC within 12 months of starting. Of the 75 employees not selected into the program, 37 leave KAPC within 12 months of starting.a. Provide a difference-in-differences estimate of the effect the housing voucher program has on retention at KAPC.b. Suppose KAPC spends $10,000 in hiring costs each time…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill Education
Management (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSON
Business Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSON
Fundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON