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 3, Problem 11QP
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 solution
Students 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 & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 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 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 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 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 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 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 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 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_forward
- Comfort-Air produces 3 types (Type 1, Type 2 and Type 3) thermostats for household temperature control. Three limited resources are required for the production. These resources are available time (R1) of a Robotic Insertion Machine (RIM), workforce hours (R2) and certain type of electronic components (R3). Profits generated from each unit of the thermostats are shown in the first row of the following table. The amount of resources required to produce one unit of the thermostats are also given in the table. The last column of the table shows the available amount of the resources. Comfort-Air needs to decide the numbers of thermostats of each type (x,,x, and x,) to produce in order to maximize its total profit. Table: Production Related Data Туре 2 115 Thermostat Туре 1 Туре 3 Available Amount of Profit per unit product Amount of required resources to produce each unit product 80 70 Resource 1840 (hour) 2100 (hour) 3500 (units) R1 5 8 7 R2 4 7 R3 8. 10 12 1) Based on the given…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_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 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_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_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,