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 4QP
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
Please answer it immediately sir
Linear Programming
The Booboo sawmill in Batangas produces pine and oak boards for manufacturing firms. Each month the sawmill must deliver atleast 5 tons of wood to the manufacturer . It takes the sawmill 3 days to produce a ton of pine and a 2 days to produce a ton of oak and the sawmill can allocate 18 days out of a month for this contract. The sawmill can get enough pine to make atleast 4 tons of wood and enough oak to make atmost 7 tons of wood. Determine the number of tons of pine and oak in order to minimize cost, given that pine has a cost of $3 and oak $6 to produce
A company makes three types of candy and packages them in three assortments. Assortment I contains 4 cherry, 4
lemon, and 12 lime candies, and sells for a profit of $4.00. Assortment Il contains 12 cherry, 4 lemon, and 4 lime
candies, and sells for a profit of $3.00. Assortment III contains 8 cherry, 8 lemon, and 8 lime candies, and sells for a
profit of $5.00. They can make 5,200 cherry, 4,000 lemon, and 6,000 lime candies weekly. How many boxes of each
type should the company produce each week in order to maximize its profit (assuming that all boxes produced can
be sold)? What is the maximum profit?
Select the correct choice below and fill in any answer boxes within your choice.
OA. The maximum profit is $ when boxes of assortment 1. boxes of assortment II and
assortment III are produced.
OB. There is no way for the company to maximize its profit
boxes of
Modern Oak Furniture Limited had been in business for more than 40 years, serving customers in Southwestern Ontario. The business consists of three different divisions
Custom Designs Division
Manufacturers crafted items, such as dining room suites
Kitchen Cabinets Division
Manufactures kitchen cabinets
Banister Division
Manufactures and installs quality oak railings
Each division reports to a Vice-President, who in turn report to the President of the company, Mr. Frederick Johannsson, who was also to founder of the company. Total sales for all divisions are projected to reach 10,000,000.00 in the current fiscal year.
Mr. Johannsson has been quite pleased with the performance of two of the divisions, Custom Designs and Kitchen Cabinets, which together account for about 85% of the company’s sales revenue. He does however, have some concerns about the Banister Division based on the previous year’s profit performance and the first week of August’s sales report for the…
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
- 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…arrow_forwardWhat function does linear programming play in OR?arrow_forwardUse the Huntington-Hill numbers listed in the table to assign seats as indicated. (REVIEW UNIT 5 - CHAPTER 4) Eleven seats on a hospital board are to be apportioned between doctors, nurses, and administrators. Use the given table of Huntington-Hill numbers to list the order in which the seats on the board will be apportioned. Begin by apportioning one seat to each group. Current Representation 1 (D)octors (N)urses (A)dministrators 7,200 2,812 11,250 3,750 1,875 1,125 750 937 2,400 468 281 1,200 720 3 4 5. 187 480 O D. N, A, A, N, A, D, N, A, N, A O D. N. A, A. N, D. A, N, D. A, N O D, N, A, N, A, A, D, N, A, A, N O D, N, A, A, D, A, N, N, A, N, Darrow_forward
- Please answer all parts A Rhino cement company owns two production plants. Plant 1 costs 20977 per day to operate, and it can produce 330 bags of high-grade cement, 475 bags of medium-grade cement , and 508 bags of low-grade cement each day. Plant 2 is newer and more modern. It costs 22570 per day to operate, and it can produce 435 bags of high-grade cement,271 bags of medium-grade cement, and 274 bags of low-grade cement each day. The company has orders totaling 24539 bags of high-grade cement, 25248 bags of medium-grade cement, and 33749 bags of low-grade cement. How many days should it run each plant to minimize its costs and still produce enough cement to meet its orders? What is the value of the first dual variable? What is the value of the second dual variable? What is the value of the third dual variable? What is the value of dual optimal solution z?arrow_forwardEastern Chemicals produces two types of lubricating fluids used in industrial manufacturing. Both products cost Eastern Chemicals $1 per gallon to produce. Based on an analysis of current inventory levels and outstanding orders for the next month, Eastern Chemicals’ management specified that at least 30 gallons of product 1 and at least 20 gallons of product 2 must be produced during the next two weeks. Management also stated that an existing inventory of highly perishable raw material required in the production of both fluids must be used within the next two weeks. The current inventory of the perishable raw material is 80 pounds. Although more of this raw material can be ordered if necessary, any of the current inventory that is not used within the next two weeks will spoil—hence, the management requirement that at least 80 pounds be used in the next two weeks. Furthermore, it is known that product 1 requires 1 pound of this perishable raw material per gallon and product 2 requires 2…arrow_forwardEastern Chemicals produces two types of lubricating fluids used in industrial manufacturing. Both products cost Eastern Chemicals $1 per gallon to produce. Based on an analysis of current inventory levels and outstanding orders for the next month, Eastern Chemicals’ management specified that at least 30 gallons of product 1 and at least 20 gallons of product 2 must be produced during the next two weeks. Management also stated that an existing inventory of highly perishable raw material required in the production of both fluids must be used within the next two weeks. The current inventory of the perishable raw material is 80 pounds. Although more of this raw material can be ordered if necessary, any of the current inventory that is not used within the next two weeks will spoil—hence, the management requirement that at least 80 pounds be used in the next two weeks. Furthermore, it is known that product 1 requires 1 pound of this perishable raw material per gallon and product 2 requires 2…arrow_forward
- a.) Formulate a LP model of this problemarrow_forward) Creative Sports Design (CSD) manufactures a standard-size racket and an oversize racket.The firm’s rackets are extremely light due to the use of a magnesium-graphite alloy that wasinvented by the firm’s founder. Each standard-size racket uses 0.125 kilograms of the alloy andeach oversize racket uses 0.4 kilograms; over the next two-week production period only 80kilograms of the alloy are available. Each standard-size racket uses 10 minutes of manufacturingtime and each oversize racket uses 12 minutes. The profit contributions are $10 for eachstandard-size racket and $15 for each oversize racket, and 40 hours of manufacturing time areavailable each week. Management specified that at least 20% of the total production must be thestandard-size racket. How many rackets of each type should CSD manufacture over the next twoweeks to maximize the total profit contribution? Assume that because of the unique nature oftheir products, CSD can sell as many rackets as they can produce.arrow_forward3.4-15* A cargo plane has three compartments for storing cargo: front, center, and back. These compartments have capacity limits on both weight and space, as summarized below: Weight Саpacity (Tons) Space Сapacity (Cubic Feet) Compartment Front 7,000 9,000 5,000 12 Center 18 Back 10 Furthermore, the weight of the cargo in the respective compart- ments must be the same proportion of that compartment's weight capacity to maintain the balance of the airplane.arrow_forward
- 2. A firm makes two products X and Y and has a total production capacity of 9 tons per day.X and Y requiring the same production capacity. The same has a permanent contract to supply at least two tons of X and at least 3 tons of Y per day to another company. Each ton of X requires 20 machine hours of production time and each ton of Y requires 50 machine hours of production time. The daily maximum possible number of machine hours is 360. The entire firm's output can be sold and profit made is 80 R.O of X and 120 R.O per ton of Y. It is required to determine the production schedule for maximum profit and to calculate this profit. Formulate a LPP.arrow_forwardWhat is the nonlinear programming model (OMEGA) used by Texaco?arrow_forwardKellpost Cereal Company sells four products: (1)Special L (a low-calorie, high-nutrition cereal); (2)Corn Bran (another low-calorie, high-nutrition cereal);(3) Admiral Smacks (a sugary cereal pitched at thechildren’s market); and (4) Honey Pops (another sweetcereal pitched at the children’s market). Kellpost hassufficient production capacity to produce a total of10,000 boxes of cereal per month. For each of thepast 16 months, Kellpost has kept track of the priceand sales of each product. (These data are listed inthe file P07_72.xlsx.) Market executives believe thatSpecial L and Corn Bran might be substitutes for eachother, as might be Admiral Smacks and Honey Pops.For example, this means that an increase in the priceof Special L might raise the sales of Corn Bran. Thevariable cost of bringing a box of each cereal to mar-ket is as follows: Special L, $2.00; Corn Bran, $2.20;Admiral Smacks, $2.30; Honey Pops, $2.40.a. Use the given information to determine theprice for each cereal that…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