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
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Lawrence is a Chief Financial Officer of an E-Sports company. One of his main duties is to take care of financial reporting. He is concerned about how to improve the financial performance of the whole company. He is considering engaging a consultancy firm to develop Robotic Process Automation for accounting functions. He hopes that he can help the company to reduce the staff cost of the accounting function by laying off one-third of the accounting staff once the Robotic Process Automation is completed. Lawrence expects to lay off those staff who got more over-time salary before.Identify the ethical issue(s), if any, involved in this case.Who are the stakeholders in this situation? How are they affected?What are Lawrence’s alternatives?What course of action will you suggest Lawrence take? Justify your suggestion
In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of
1,000
radials each year. In the past 2 years,
220
and
250,
respectively were sold in fall,
360
and
320
in winter,
145
and
175
in spring, and
300
and
230
in summer. With a major expansion planned, Kelle projects sales next year to increase to
1,200
radials.
Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers):
Season
Demand
Fall
nothing
GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special
aeration treatment as a low-cost extra service option, which it hopes will help attract new
customers. Management is planning to promote this new service in two media: radio and direct-mail
advertising. A media budget of $4 (in thousands)is available for this promotional campaign. Based on-
past experience in promoting its other services, GreenLawns has obtained the following estimate of
the relationship between sales and the amount spent on promotion in these two media:
S-2R2-12M2-9RM
+ 20R +37M,
Where
S = total sales
R = amount spent on radio advertising
M = amount spent on direct-mail advertising
GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to
the restriction provided by the media budget.
The problem is formulated as below:
Max
-2R2-12M²-9RM+20R+37M
s.t.
1R+1M=0
Using Excel Solver, solve the above nonlinear optimization model.
(a) What…
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_forwardTrips Logistics, a third-party logistics firm that provides warehousing and other logistics services, is facing a decision regarding the amount of space to lease for the upcoming three-year period. The general manager has forecast that Trips Logistics will need to handle a demand of 100,000 units for each of the next three years. Historically, Trips Logistics has required 1,000 square feet of warehouse space for every 1,000 units of demand. For the purposes of this discussion, the only cost Trips Logistics faces is the cost for the warehouse. Trips Logistics receives revenue of $1.22 for each unit of demand. The general manager must decide whether to sign a three-year lease or obtain warehousing space on the spot market each year. The three-year lease will cost $1 per square foot per year, and the spot market rate is expected to be $1.20 per square foot per year for each of the three years. Trips Logistics has a discount rate of k = 0.1.arrow_forwardThe metes and bounds system primarily relies on which of the following to describe land? section, lot, and block numbers within a subdivision a readily identifiable point of beginning and the boundaries of a property in terms of distances and compass directions checks, correction lines, and tiers meridians, base lines, townships, and rangesarrow_forward
- Ohio Swiss Milk Products manufactures and distributes ice cream in Ohio, Kentucky, and West Virginia. The company wants to expand operations by locating another plant in northern Ohio. The size of the new plant will be a function of the expected demand for ice cream within the area served by the plant. A market survey is currently under way to determine that demand. Ohio Swiss wants to estimate the relationship between the manufacturing cost per gallon and the number of gallons sold in a year to determine the demand for ice cream and, thus, the size of the new plant. The following data have been collected: Plant ITT Thousands of Gallons Sold (X) 434.7 Cost per Thousand Gallons (Y) 1 $1,024 2 962 466.4 3 1,065 1,006 1,045 1,068 251.3 372.1 5 245.0 6. 258.6 7 988 614.9 414.0 8 997 9 1,063 1,000 $10,218 267.5 380,4 3,704.9 10 Total a. Develop a regression equation to forecast the cost per thousand gallons as a function of the number of thousands of gallons produced. The forecasting model…arrow_forwardOhio Swiss Milk Products manufactures and distributes ice cream in Ohio, Kentucky, and West Virginia. The company wants to expand operations by locating another plant in northern Ohio. The size of the new plant will be a function of the expected demand for ice cream within the area served by the plant. A market survey is currently under way to determine that demand. Ohio Swiss wants to estimate the relationship between the manufacturing cost per gallon and the number of gallons sold in a year to determine the demand for ice cream and, thus, the size of the new plant. The following data have been collected: ITT Cost per Thousand Gallons (Y) $1,024 Thousands of Gallons Sold (X) 434.7 Plant 962 466.4 251.3 372. 1,065 1,006 1.045 245.0 258.6 1,068 988 997 1,063 1,000 $10.218 614.9 414.0 267.5 380,4 3 704 9 9 10 Total a. Develop a regression equation to forecast the cost per thousand gallons as a function of the number of thousands of gallons produced. The forecasting model is given by the…arrow_forwardOhio Swiss Milk Products manufactures and distributes ice cream in Ohio, Kentucky, and West Virginia. The company wants to expand operations by locating another plant in northern Ohio. The size of the new plant will be a function of the expected demand for ice cream within the area served by the plant. A market survey is currently under way to determine that demand. Ohio Swiss wants to estimate the relationship between the manufacturing cost per gallon and the number of gallons sold in a year to determine the demand for ice cream and, thus, the size of the new plant. The following data have been collected: ITT Plant 1 Cost per Thousand Gallons (Y) $1,024 Thousands of Gallons Sold (X) 434.7 2 962 466.4 3 1,065 1,006 1,045 1,068 251.3 372.1 5 245.0 258.6 614.9 7 988 8. 997 414.0 267.5 380.4 3,704.9 9 1,063 1,000 $10,218 10 Total a. Develop a regression equation to forecast the cost per thousand gallons as a function of the number of thousands of gallons produced. The forecasting model is…arrow_forward
- Problem-solving is a critical technique used in many businesses to overcome challenges and improve services. In the case of CoffeeVille, they faced a limitation in their delivery service which was affecting their business operations. The problem-solving process was used to find a solution to this issue. Steps in the Problem-Solving Process Identify the Problem: The first step in problem-solving is to identify the problem. In CoffeeVille's case, the problem was a limitation in their delivery service. Analyze the Problem: The next step is to analyze the problem. This involves understanding the problem in detail, its causes, and its effects. For CoffeeVille, they needed to understand why their delivery service was limited and how it was affecting their business. Generate Possible Solutions: Once the problem is understood, the next step is to generate possible solutions. CoffeeVille would have brainstormed different ways to improve their delivery service. Evaluate and Select a Solution:…arrow_forwardThe Reeves twins are in the yard maintenance business. They want to start doing snow removal during the winter season because they practically don't have any yards to maintain. The twins are trying to determine how much equipment they need to purchase. The twins plan to do most of the work themselves and then hire some part-time workers on an individual job basis to help out. The twins gathered some data on past weather. Based on the information, they predict that there will be six big snowstorms in the coming winter. Most of their clients want the snow removed no more than two days after the snow stops falling. If the twins work for 10 hours a day, they can remove the snow from the driveway of a home in about 1 hour. However, for commercial parking lots and public sidewalks, it will take 4 hours. The variable cost per job is $12 for home driveways and $47 for commercial parking lots. The twins estimated that they will have no more than 40 homeowners and 25 businesses who would like…arrow_forwardCompare interior-point algorithms with the simplex method?arrow_forward
- Double Tree Hilton is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business. The profit per night for each type of room and rental class is as follows: Rental Class Super Saver Deluxe Business Room Type I $30 $35 $50 Type II $20 $30 $40 Double Tree's management makes a forecast of the demand by rental class for each night in the future. A linear programming model developed to maximize profit is used to determine how many reservations to accept for each rental class.The demand forecast for a particular night is 130 rentals in the Super Saver class, 60 in the Deluxe class, and 50 in the Business class. (These demands are the maximum numbers to accept for each rental class. The actual reservation may be less.) Double Tree has 100 Type I rooms and 130 Type II rooms. 1. Question text How many decision variables are there in your model? What is the maximum profits($)? What is the number of…arrow_forwardMillie wants to install a new carpet in the living room of her house. She calculated the square footage of the room and then multiplied it by a set cost factor to estimate the cost. This is an example of_________ Group of answer choices Parametric estimating Three-point estimating Bottom-up estimating Analogous estimatingarrow_forwarde Petit Fleur is a French style bakery that specializes in creating gourmet pastries, cakes and sweets for celebrations and events. They are quite well known for having high prices and equally high quality produce. Lily-Mae is getting married and is organizing the food for the celebration. She’s visited a few cake shops, bakeries and specialist event caterers, but she hasn’t found anything she likes. As she is driving home from a tasting appointment, she passes Le Petit Fleur and notices an enormous sign in the window that reads, “Today only - 50% off all orders!” Lily-Mae cannot believe her luck. Quickly she turns into the carpark belonging to Le Petit Fleur and hurries inside. The smell of sweet aromas hits her the moment she walk into the door. She’s never even tried to get in touch with Le Petit Fleur, knowing that they are very high priced, but with a 50% discount she might just be able to do it. She immediately spots a cake on display and is enchanted. The color, decorations and…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,