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 27QP
a)
Summary Introduction
To formulate: An linear programming model for the problem.
b)
Summary Introduction
To develop: A spreadsheet model and solve using solver.
c)
Summary Introduction
To identify: The optimal solution.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The Fish House (TFH) in Norfolk, Virginia, sells fresh fish and seafood. TFH receives daily shipments of farm-raised trout from a nearby supplier. Each trout costs $2.45 and is sold for $3.95. To maintain its reputation for freshness, at the end of the day TFH sells any leftover trout to a local pet food manufacturer for $1.25 each. The owner of TFH wants to determine how many trout to order each day. Historically, the daily demand for trout is: Demand 10 11 12 13 14 15 16 17 18 19 20 Probability 0.02 0.06 0.09 0.11 0.13 0.15 0.18 0.11 0.07 0.05 0.03 a. Construct a payoff matrix for this problem. b. How much should the owner of TFH be willing to pay to obtain a demand forecast that is 100% accurate? give a clear explanation for (b)
Tropicana is a major producer of orange juice. Different consumers have different valuations for Tropicana orange juice. Twenty-five percent of consumers value a 64 oz carton of juice at $6; while the remaining seventy-five percent value the same carton at $4. In common with many producers of consumer products, Tropicana often distribute coupons. The first group of consumers (the $6 valuation group) dislike the hassle associated with coupons; their disutility from keeping track of a coupon is $1. In contrast, the second group do not greatly mind dealing with coupons, and suffer a disutility of only 15c.(Here, "disutility" is simply a fancy way of saying dislike, with dislike measured in dollar terms.)Tropicana’s marginal cost of producing and distributing the juice is $3.
Part (a)What pricing strategy do you suggest that Tropicana adopt
Part (b) Tropicana doesn’t distribute coupons in an electronic form that could be stored by a smart phone. Briefly explain why not
Long-Life Insurance has developed a linear model that it uses to determine the amount of term life Insurance a family of four should
have, based on the current age of the head of the household. The equation is:
y=150 -0.10x
where
y= Insurance needed ($000)
x = Current age of head of household
b. Use the equation to determine the amount of term life Insurance to recommend for a family of four of the head of the household is
40 years old. (Round your answer to 2 decimal places.)
Amount of term life insurance
thousands
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
- Emily works for a small software company and oversees software quality assurance. The company recently developed an inventory control system for a national clothing manufacturer. The system gathers sales information on an hourly basis from clothing retailers nationwide. This information is then used by all departments (including the accounting, shipping, and ordering departments) to control the functions of the clothing manufacturer. Emily suspects that the inventory functions of the system are not sufficiently tested, although they have passed all their contracted (legal) tests. However, she is pressured by her employers to sign off on the software. Whilst she is only required to perform tests which have been agreed to in the original contract, her considerable experience in software testing has led her to be concerned over the quality of the system. Her employers say that they will go out of business if they do not deliver the software on time. Emily knows that if any section of…arrow_forwardA 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 ofarrow_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
- The XYZ Corporation has been engaged in the manufacture of electronic components for automobiles for the last 5 years. The company employs 350 employees and about 30 supervisors and managers. The increase in technology requires that employees be sent to training to cope with the increasing demand for updated new products consistent with the demand of local and foreign customers. The HR manager suggested that 3 of the managers and 8 supervisors be sent to the mother company in Japan for updates in technology on car electronics. The Vice President for Finance and the Operation Manager opposed the recommendation on the basis of cost-cutting and lack of personnel to handle the operations while they were away for 2 months. They suggested that technicians from the mother company be invited instead to handle the training in the Philippines. The cost of training by the mother company would double the cost of training as they are paid higher allowances and salaries that will be…arrow_forwardModern 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…arrow_forwardCox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost = $7,000 Material cost per unit = $0.15 Labor cost per unit = $0.10 Revenue per unit = $0.65 Production Volume = 12,000 Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all it produces, build a spreadsheet model that calculates the profit by subtracting the fixed cost and total variable cost from total revenue, and answer the following questions. (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = total cost, yielding a profit of zero. Vary production volume from 5,000 to 50,000 in increments of 5,000. In which interval of production volume does breakeven occur? to units (b) Use Goal Seek to find the exact breakeven point.…arrow_forward
- Porter five forces model, developed by Michael E. Porter of Harvard University in 1979, holds the purpose to analyse the industry in order to determine the level of intensity regarding the competition and attractiveness of the industry. The attractiveness of an industry is measured in terms of profit; more profitability means a more attractive industry and low profitability means a low attractive industry. Porter’s Five Forces model is a powerful management tool for analysing the current industry profitability and attractiveness by using the outside-in perspective. Within the last decades, the model has attracted some criticism because of the developing Internet economy. Due to an increasing significance of Digitalization,Globalization and Deregulation, the industry structure of the ‘Old Economy’ changed fundamentally. The ‘New Economy’ is not comparable with the ‘Old Economy’, which is the basis of the Five Forces model. Moreover, the last decades have shown that Information…arrow_forwardDuring the year, Brownout Company experienced the following power outages:Number of Power Outages Per Month Number of Months 0 3 1 2 2 4 3 3 12Each power outage results in out of pocket costs of P400. For P500 per month, the company can lease an auxiliary generator to provide power during outages. If the company leases an auxiliarygenerator next year, the estimated savings (or…arrow_forwardTropics Limited has been making high quality Caribbean leisure and casual wears for over thirty years, in a rented premise located in the heart of the Port-of-Spain, Trinidad and Tobago. The company has a flexible labour force of about twenty employees and three directors, only one of whom, namely Mr. Mottley, the managing director, is fully active in the business. The company specializes in casual, leisure and swim wear garments. Their current range consists of tee shirts, shorts, skirts and bath suits in rich vibrant Caribbean colours and styles for men, women and children. The company capacity is 400-500 garments per week, depending on style and continuity of the production run, but additional floor space and machines could be brought in quickly to raise production levels to a maximum of 1000 garments weekly if required. The company operates as a wholesaler to store agents in a hyper-competitive mature market. It has limited involvement in the marketing of its products and only uses…arrow_forward
- Star Garage Limited provides motor vehicle accessories and services for a wide range of vehicles in Dominica. Customers purchase parts to take to their individual mechanics to complete vehicle repairs or they may choose to bring their vehicles to Star Garage for in-house repairs and servicing. This means that they pay for both the parts and the labour associated with the type of service required. Some services do not include any new parts, just the labour costs for that service. Individual customers must pay for all parts purchases in full at the time of sale. Individual customers must pay 50% down when they bring their vehicles in for servicing and pay the balance when they come to pick them up when the job is completed. Corporate customers, however, are billed monthly for all sales (parts or service). Although Star Garage Limited has several different banking accounts, all sales are deposited intact into its main chequing account. Star Garage Limited purchases its inventory of parts…arrow_forwardA retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold for $10.00 to the grocer, and the grape pies are sold for $8.00. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 1,500 cups of sugar and 2,400 cups of flour. Each apple pie requires 1½ cups of sugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour. a. Determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make an apple pie in 6 minutes and a grape pie in 3 minutes. They plan to work no more than 60 hours. (Round your answers to nearest whole number.) b. Determine the amounts of sugar, flour, and time that will be unused. (Leave no cells blank -…arrow_forwardTropical Leisure Limited has been making high-quality Caribbean leisure wears for over twenty-five years, in old rented premises located in the heart of the Barbadian capital of Bridgetown. The company has a flexible labor force of about twenty employees and three directors, only one of whom, namely Mr. Grant, the managing director, is fully active in the business. The company specializes in leisure and swimwear garments. Their current range consists of tee shirts, shorts, skirts, and bath suits in rich vibrant Caribbean colors and styles for men, women, and children. The company capacity is 400-500 garments per week, depending on style and continuity of the production run, but additional floor space and machines could be brought in quickly to raise production levels to a maximum of 1000 garments weekly if required. Trade sources estimated that the Barbadian market was valued at US$ 1.5 billion in 2010 but since then inflation and recession have deflated the market, resulting in…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,