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 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?
I need solve this please fast
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_forward4) 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?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_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_forwardPlease show tha solutions to the corresponding answer stated in the problem.arrow_forwardSolving Integer Programming - Number 2 onlyarrow_forward
- A library must build shelving to shelve 200 4-inch highbooks, 100 8-inch high books, and 80 12-inch high books. 8.3 Maximum-Flow Problems 419Each book is 0.5 inch thick. The library has several ways tostore the books. For example, an 8-inch high shelf may bebuilt to store all books of height less than or equal to 8inches, and a 12-inch high shelf may be built for the 12-inchbooks. Alternatively, a 12-inch high shelf might be built tostore all books. The library believes it costs $2,300 to builda shelf and that a cost of $5 per square inch is incurred forbook storage. (Assume that the area required to store a bookis given by height of storage area times book’s thickness.)Formulate and solve a shortest-path problem that couldbe used to help the library determine how to shelve thebooks at minimum cost. (Hint: Have nodes 0, 4, 8, and 12,with cij being the total cost of shelving all books of height i and j on a single shelf.)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_forwardHELParrow_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 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
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,