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?
I need solve this please fast
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_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
- Please show tha solutions to the corresponding answer stated in the problem.arrow_forwardComfort-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_forwardThe Mechanical Engineering department has a student team that is designing a formula car for national competition. The time required for the team to assemble the first car is 100 hours. Their improvement (or learning rate) is 0.8, which means that as output is doubled, their time to assemble a car is reduced by 20%. Use this information to determine: the time it will take the team to assemble the 10th car. Create an excel spreadsheet having the following table. You must show the formula used in the excel sheets to calculate values in the columns. Plot Number of Units vs Time (in hours) and Number of Units vs Cumulative Time (in hours) in the same plot. N (no of Units) Time to Produce Nth Cumulative Time (1 to N) 1 2 3 4 5 6 7 8 9 10arrow_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. Question: 1. Which Process…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_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 bottleneck method,…arrow_forwardA 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_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,