Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 10QP
Summary Introduction
To develop: A spreadsheet model for the problem and solve it using solver.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Five to six times a year, Kicker puts on tent sales in various cities throughout Oklahoma and the surrounding states. The tent sales are designed to show Kicker customers new products, engender enthusiasm about those products, and sell soon to be out-of-date products at greatly reduced prices. Each tent sale lasts one day and requires parking lot space to set up the Kicker semitrailer; a couple of show cars; a disc jockey playing music; a tent to sell Kicker merchandise, distribute brochures, and so on.
Last year, the Austin, TX tent sale was held in a corner of the parking lot outside the city exhibition hall where the automotive show was in progress. Because most customers were interested more in the new model cars than in the refurbishment of their current cars, foot traffic was low. In addition, customers did not want to carry speakers and amplifiers all the way back to where they had originally parked. Total direct costs for this tent sale were $14,300. Direct costs…
Green Vehicle Inc. manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/50 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold.
a) Define the objective function and constraint equations.
b) Graph the feasible region.
c) What is a maximum-profit daily production plan at the new factory?
d) How much profit will such a plan yield, assuming whatever is produced is sold?
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 3 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Prob. 7QPCh. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 18QPCh. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 27QPCh. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 45QPCh. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
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
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?arrow_forwardgreen vehicule Inc. manufactures electric cars and small delivery trucks. it has just opened a new factory where the C1 car and the T1 truck can both be manufactured. to make either vehicle, processing in the assembly shop and the paint shop are required. It takes 1/40 of a day and 1/60 of a paint a truck of type T1 and a car of type C1 in the paint shop, respectively. it takes 1/50 of a day to assemble either type of vehicule in the assembly shop. A t1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicule soldarrow_forwardHaving trouble setting up the problem using excel solver and inputting the constraintsarrow_forward
- A company has one machine which can be used to make product Alpha and product Beta. Each unit of product Alpha requires 45 minutes of machine time, while each unit of product Beta requires 37 minutes of machine time. The machine can be used for 8 hours per day and 5 days per week. Next week the company will produce 23 units of product Alpha. After completing the production of Alpha, the company will produce product Beta. How many units of product Beta can be produced next week? Use at least 4 decimals.You must showm your calculation steps and brief explanation on your Excel spreadsheets.arrow_forwardAuthor: Leo A. Ruggle, Professor, Department of Accounting, Mankato State University Arnie Armstrong has been with Pierce Auto Parts Manufacturing Company for 23 years. Recently, he was appointed Director of Manufacturing Computer Services. In just six weeks in this new position, [he] has moved to reduce the amount of information provided to manufacturing department managers by 60 percent. He argues that excess data is distracting, unused, and expensive to provide. Willy McClean has been department manager for 12 years. During a coffee break with some of his department production supervisors, Willy is quite vocal about the change. “Who’s this guy Armstrong to tell us what data we need? He needs to be out here for a few weeks to find out what it’s like. Keep it quiet, but I’ve got a contact in Computer Services who’ll get me all the data analyses I want for just a $20 bill each month. It’s a good deal, and Armstrong will never know. How does he expect us to make good decisions about…arrow_forwardA producer has three products, A, B, and C, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product A uses 15 units of Raw Material X, one Purge System Subassembly, one Case, one Power Cord, three Labour Hours in the Assembly Department, and one Labour Hour in the Finishing Department.  Each unit of product B uses 10 units of Raw Material X, five units of Raw Material Y, two Purge System Subassemblies, one Case, one Power cord, five Labour Hours in the Assembly Department, and 90 minutes in the Finishing Department.  Each unit of product C uses five units of Raw Material X, 25 units of Raw Material Y, two Purge System Subassemblies, one Case, a Power Cord, seven Labour Hours in the Assembly Department, and Three Labour Hours in the Finishing Department.  Labour between the Assembly and Finishing departments is not transferable, but workers within each department work on any of the three products. There are three…arrow_forward
- A producer has three products, A, B, and C, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product A uses 15 units of Raw Material X, one Purge System Subassembly, one Case, one Power Cord, three Labour Hours in the Assembly Department, and one Labour Hour in the Finishing Department.  Each unit of product B uses 10 units of Raw Material X, five units of Raw Material Y, two Purge System Subassemblies, one Case, one Power cord, five Labour Hours in the Assembly Department, and 90 minutes in the Finishing Department.  Each unit of product C uses five units of Raw Material X, 25 units of Raw Material Y, two Purge System Subassemblies, one Case, a Power Cord, seven Labour Hours in the Assembly Department, and Three Labour Hours in the Finishing Department.  Labour between the Assembly and Finishing departments is not transferable, but workers within each department work on any of the three products. There are three…arrow_forwardA company makes four products that have the following characteristics: Product A sells for $75 but needs $40 of materials to produce; Product B sells for $90 but needs $65 of materials to produce; Product C sells for $110 but needs $80 of materials to produce; Product D sells for $135 but needs $105 of materials to produce. The processing requirements for each product on each of the four machines are shown in the table. Work centers W, X, Y, and Z are available for 5 days per week, 1 shift per day (8 hrs.) and have no setup time when switching between products. Market demand is 50 As, 60 Bs, 70 Cs, and 80 Ds per week. In the questions that follow, the traditional method refers to maximizing the contribution margin per unit for each product, and the bottleneck method refers to maximizing the contribution margin per minute at the bottleneck for each product. Each worker is paid $15 per hour and is paid for an entire week, regardless of how much the worker is used. Answer the following…arrow_forwardA company makes four products that have the following characteristics:Product A sells for $75 but needs $40 of materials to produce; Product B sells for $90 but needs $65 ofmaterials to produce; Product C sells for $110 but needs $80 of materials to produce; Product D sells for$135 but needs $105 of materials to produce. The processing requirements for each product on each ofthe four machines are shown in the table.  Work centers W, X, Y, and Z are available for 5 days per week, 1 shift per day (8 hrs.) and have no setuptime when switching between products. Market demand is 50 As, 60 Bs, 70 Cs, and 80 Ds per week. In thequestions that follow, the traditional method refers to maximizing the contribution margin per unit foreach product, and the bottleneck method refers to maximizing the contribution margin per minute at thebottleneck for each product. Each worker is paid $15 per hour and is paid for an entire week, regardlessof how much the worker is used.  Using the bottleneck method,…arrow_forward
- A company makes four products that have the following characteristics:Product A sells for $75 but needs $40 of materials to produce; Product B sells for $90 but needs $65 ofmaterials to produce; Product C sells for $110 but needs $80 of materials to produce; Product D sells for$135 but needs $105 of materials to produce. The processing requirements for each product on each ofthe four machines are shown in the table.  Work centers W, X, Y, and Z are available for 5 days per week, 1 shift per day (8 hrs.) and have no setuptime when switching between products. Market demand is 50 As, 60 Bs, 70 Cs, and 80 Ds per week. In thequestions that follow, the traditional method refers to maximizing the contribution margin per unit foreach product, and the bottleneck method refers to maximizing the contribution margin per minute at thebottleneck for each product. Each worker is paid $15 per hour and is paid for an entire week, regardlessof how much the worker is used.  Using the bottleneck method,…arrow_forwardA company makes four products that have the following characteristics:Product A sells for $75 but needs $40 of materials to produce; Product B sells for $90 but needs $65 ofmaterials to produce; Product C sells for $110 but needs $80 of materials to produce; Product D sells for$135 but needs $105 of materials to produce. The processing requirements for each product on each ofthe four machines are shown in the table.  Work centers W, X, Y, and Z are available for 5 days per week, 1 shift per day (8 hrs.) and have no setuptime when switching between products. Market demand is 50 As, 60 Bs, 70 Cs, and 80 Ds per week. In thequestions that follow, the traditional method refers to maximizing the contribution margin per unit foreach product, and the bottleneck method refers to maximizing the contribution margin per minute at thebottleneck for each product. Each worker is paid $15 per hour and is paid for an entire week, regardlessof how much the worker is used.  Using the traditional…arrow_forwardA company makes four products that have the following characteristics:Product A sells for $75 but needs $40 of materials to produce; Product B sells for $90 but needs $65 ofmaterials to produce; Product C sells for $110 but needs $80 of materials to produce; Product D sells for$135 but needs $105 of materials to produce. The processing requirements for each product on each ofthe four machines are shown in the table.  Work centers W, X, Y, and Z are available for 5 days per week, 1 shift per day (8 hrs.) and have no setuptime when switching between products. Market demand is 50 As, 60 Bs, 70 Cs, and 80 Ds per week. In thequestions that follow, the traditional method refers to maximizing the contribution margin per unit foreach product, and the bottleneck method refers to maximizing the contribution margin per minute at thebottleneck for each product. Each worker is paid $15 per hour and is paid for an entire week, regardlessof how much the worker is used.  Using the bottleneck method,…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,