Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 18QP
a)
Summary Introduction
To formulate: An LP model for the problem.
b)
Summary Introduction
To sketch: The feasible region for the problem.
c)
Summary Introduction
To calculate: The optimal solution using corner points.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
As part of a campaign to promote its annual clearance sale, Excelsior Company decided to buy television advertising time on Station KAOS. Excelsior's television advertising budget is $111,000. Morning time costs $3000/min, afternoon time costs $1000/min, and evening (prime) time costs $12,000/min. Because of previous commitments, KAOS cannot offer Excelsior more than 6 min of prime time or more than a total of 25 min of advertising time over the 2 weeks in which the commercials are to be run. KAOS estimates that morning commercials are seen by 200,000 people, afternoon commercials are seen by 100,000 people, and evening commercials are seen by 600,000 people. How much morning, afternoon, and evening advertising time should Excelsior buy to maximize exposure of its commercials?
morning
min
afternoon
min
evening
min
A home improvement store sells hydrangea plants during the spring planting season. The hydrangeas cost the store $15 per unit, and sell to customers for $45, but any leftovers at the end of the season are salvaged to a local landscaper for $7/unit. A competitor has advertised that it guarantees 99% of customers find the product they’re looking for in stock. The competitor’s posted price for hydrangeas is $50, and they salvage to the same local landscaper for $7/ hydrangea plant. If the competitor’s advertised service level is correct for hydrangeas and they follow an optimal stocking policy, what does it imply their cost per hydrangea is?
Formulate and then solve a linear programming model of this problem, to determine how manycontainers of each product to produce tomorrow to maximize profits. The company makes fourjuice products using orange, grapefruit, and pineapple juice.Product Retail Price per QuartOrange juice $1.00Grapefruit juice .90Pineapple juice .80All-in-One 1.10The All-in-One juice has equal parts of orange, grapefruit, and pineapple juice. Each product isproduced in a one-quart size (there are four quarts in a gallon). On hand are 400 gallons of orangejuice, 300 gallons of grapefruit juice, and 200 gallons of pineapple juice. The cost per gallon is$2.00 for orange juice, $1.60 for grapefruit juice, and $1.40 for pineapple juice.In addition, the manager wants grapefruit juice to be used for no more than 30 percent of thenumber of containers produced. She wants the ratio of the number of containers of orange juice tothe number of containers of pineapple juice to be at least 7 to 5.
Chapter 2 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
Ch. 2 - Prob. 1QPCh. 2 - Prob. 2QPCh. 2 - Prob. 3QPCh. 2 - Prob. 4QPCh. 2 - Prob. 5QPCh. 2 - Prob. 6QPCh. 2 - Prob. 7QPCh. 2 - Prob. 8QPCh. 2 - Prob. 9QPCh. 2 - Prob. 10QP
Ch. 2 - Prob. 11QPCh. 2 - Prob. 12QPCh. 2 - Prob. 13QPCh. 2 - Prob. 14QPCh. 2 - Prob. 15QPCh. 2 - Prob. 16QPCh. 2 - Prob. 17QPCh. 2 - Prob. 18QPCh. 2 - American Auto is evaluating their marketing plan...Ch. 2 - Prob. 20QPCh. 2 - Prob. 21QPCh. 2 - Prob. 22QPCh. 2 - Prob. 23QPCh. 2 - Prob. 24QPCh. 2 - Prob. 25QPCh. 2 - Prob. 26QPCh. 2 - Prob. 1.1CCh. 2 - Prob. 1.2CCh. 2 - Prob. 1.3CCh. 2 - Prob. 1.4CCh. 2 - Prob. 1.5CCh. 2 - Prob. 1.6CCh. 2 - Prob. 1.7CCh. 2 - Prob. 1.8CCh. 2 - Prob. 1.9CCh. 2 - Prob. 1.10C
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
- In the financial world, there are many types of complex instruments called derivatives that derive their value from the value of an underlying asset. Consider the following simple derivative. A stocks current price is 80 per share. You purchase a derivative whose value to you becomes known a month from now. Specifically, let P be the price of the stock in a month. If P is between 75 and 85, the derivative is worth nothing to you. If P is less than 75, the derivative results in a loss of 100(75-P) dollars to you. (The factor of 100 is because many derivatives involve 100 shares.) If P is greater than 85, the derivative results in a gain of 100(P-85) dollars to you. Assume that the distribution of the change in the stock price from now to a month from now is normally distributed with mean 1 and standard deviation 8. Let EMV be the expected gain/loss from this derivative. It is a weighted average of all the possible losses and gains, weighted by their likelihoods. (Of course, any loss should be expressed as a negative number. For example, a loss of 1500 should be expressed as -1500.) Unfortunately, this is a difficult probability calculation, but EMV can be estimated by an @RISK simulation. Perform this simulation with at least 1000 iterations. What is your best estimate of EMV?arrow_forwardClippers Inc. (CI) manufactures two types of garden clippers. A light-duty model, called the “half-inch,”is intended for clipping branches and stems up to one-half inch thick. The “one-inch” model is designedfor heavier stems and branches. To boost sales, CI decided at the beginning of the current year to reducethe price of the half-inch model to better position its price relative to some key competitors. On the otherhand, CI felt that the one-inch model was technically superior to competitors’ models and decided that asmall price increase was appropriate. The data for the current and prior year are as follows:Current Year Prior YearSales units 7,200 6,500Sales mix for each productHalf-inch model 50% 30%One-inch model 50% 70%PriceHalf-inch model $12.00 $14.00One-inch model $36.00 $32.00Variable cost per unitHalf-inch model $6.00 $6.00One-inch model $8.00 $8.00Fixed cost $35,000 $35,000Required1. Prepare a comparative contribution income statement for CI for the current year that shows…arrow_forwardTom is a habitual shopper at garage sales. Last Saturday he stopped at one where there were several types of used building materials for sale. At the low prices being asked, Tom knew that he could resell the items in another town for a substantial gain. Four things stood in his way: he could only make one round trip to resell the goods; his pickup truck bed would hold only 1200 pounds; the pickup truck bed could hold at most 80 cubic feet of merchandise; and he had only $190 cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them. Formulate (define objective function and constraints) and solve this problem (using excel solver) as a linear program.arrow_forward
- Yoda just got a job offer. The job is located in Awayville. Awayville is 70 miles north of Binghamton. Yoda wants to accept the job offer, still live in Binghamton, and commute to Awayville on a daily basis. This will result in travel expense relates to approximately 700 miles per week. To make this plan work, Yoda needs a car that will get at least 25 miles per gallon of gasoline. Yoda goes to Darth's Used Car Dealership. Yoda tells Darth that Yoda needs a car that gets at least 25 miles per gallon of gasoline. Yoda explains the Awayville job situation and Darth says, "I understand - I will check my inventory - I will be right back." Darth goes into his office and looks through two different files of used car inventory. One file contains all cars that get over 25 miles per gallon of gasoline and the other file contains all cars that get under 25 miles per gallon of gasoline. Darth selects a used car from the file that indicates that the cars get over 25 miles per gallon of gasoline…arrow_forwardBruin Properties is in escrow to buy a 175,000 square foot shopping center in Camarillo, California for $35,000,000. Bruin Properties can borrow $24,000,000 fixed rate fully amortizing over 30 years at a 6.0% annual interest rate with equal monthly payments of principal and interest or it can borrow $28,000,000 fixed rate fully amortizing over 30 years at a 7.0% annual interest rate with equal monthly payments of principal and interest. What is the incremental annual borrowing cost for the additional $4,000,000 loan amount if each loan would be outstanding for the full 30 year term? a.13.0% b.12.4% c.11.5% d. 7.0%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_forward
- Jerry takes out a mortgage at 5.2%. After a few years, his payment increases and he sees that the interest rate of his mortgage is now 6.1%. Which of these mortgage types does Jerry most likely have? ARM loan home equity loan fixed-rate loan package mortgagearrow_forwardBarbara Flynn sells papers at a newspaper stand for $0.40. The papers cost her $0.30, giving her a $0.10 profit on each one she sells. From past experience Barbara knows that: a) 20% of the time she sells 150 papers. b) 20% of the time she sells 200 papers. c) 30% of the time she sells 250 papers. d) 30% of the time she sells 300 papers. Assuming that Barbara believes the cost of a lost sale to be $0.05 and any unsold papers cost her $0.30 and she orders 250 papers. Use the following random numbers: 14, 4, 13, 9, and 25 for simulating Barbara's profit. (Note: Assume the random number interval begins at 01 and ends at 00.) Based on the given probability distribution and the order size, for the given random number Barbara's sales and profit are (enter your responses for sales as integers and round all profit responses to two decimal places): Random Number Sales Profit 14 4 13 9 25arrow_forwardCWD Electronics sells Televisions (TV), which it orders from the USA. Because of shipping and handling costs, each order must be for 5TVs. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 TVs. It costs $50 to place anorder. It costs the company $500 in lost sales when a customer asks for a TV and the warehouse is out of stock. It costs $100 to keep each TV stored in the warehouse. If a customer cannot purchase a TV when it is requested, the customer will not wait until one comes in but will go to a competitor.The following probability distribution for demand for TV has been and the time required to receive an order once it is placed (lead time) has the following probability distribution: (Attached) The company has 3 TVs in stock. Orders are always received at the beginning of the week.Note that a lead time of 2 weeks imply that an order placed in week one will arrive in week 4. The time required to receive an order…arrow_forward
- A purchasing agent for a particular type of silicon wafer used in the production ofsemiconductors must decide among three sources. Source A will sell the siliconwafers for $2.50 per wafer, independently of the number of wafers ordered. Source Bwill sell the wafers for $2.40 each but will not consider an order for fewer than3,000 wafers, and Source C will sell the wafers for $2.30 each but will not acceptan order for fewer than 4,000 wafers. Assume an order setup cost of $100 and anannual requirement of 20,000 wafers. Assume a 20 percent annual interest rate forholding cost calculations.c. If the replenishment lead time for wafers is three months, determine the reorderpoint based on the on-hand level of inventory of wafersarrow_forwardA purchasing agent for a particular type of silicon wafer used in the production ofsemiconductors must decide among three sources. Source A will sell the siliconwafers for $2.50 per wafer, independently of the number of wafers ordered. Source Bwill sell the wafers for $2.40 each but will not consider an order for fewer than3,000 wafers, and Source C will sell the wafers for $2.30 each but will not acceptan order for fewer than 4,000 wafers. Assume an order setup cost of $100 and anannual requirement of 20,000 wafers. Assume a 20 percent annual interest rate forholding cost calculations.a. Which source should be used, and what is the size of the standing order?arrow_forwardA bhaliyaarrow_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,