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
Videos
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
On Monday evenings in April 2015, each episode of WWE Entertainment was typically watched by 3.8 million viewers, while each episode of American Dad was typically watched by 1.5 million viewers.† Your marketing services firm has been hired to promote Gauss Jordan sneakers by buying at least 30 commercial spots during episodes of WWE Entertainment and American Dad. You have been quoted a price of $4,000 per spot for WWE Entertainment and $1,000 per spot for American Dad. Gauss Jordan, Inc.'s advertising budget for TV commercials is $130,000, and it would like at least 75% of the total number of spots to appear on WWE Entertainment. How many spots should you purchase on each show to maximize exposure? HINT [Calculate exposure as Number of ads ✕ Number of viewers.] (If an answer does not exist, enter DNE.)
WWE ______ Spots
American Dad _______ spots
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
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…
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
- 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 notarrow_forwardGreenLawns 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…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_forward
- Thorne Estates Limited advertises and sells residential property on behalf of its customers. The company has been in business for only a short time and is preparing a cash budget for first four months of 2021. Expected sales of residential properties are as follows: 2020 2021 Month Dec Jan Units Sold 10 10 2021 2021 2021 Feb Mar Apr 15 25 30 The average price of each property is £180,000 and Thorne Estates charges a fee of 3% of the value of each property sold. Thorne Estates receives a 1% in the month of sale and the remaining 2% in the month after sale. The company has nine employees who are paid on a monthly basis. The average salary per employee is £35,000 per year. If more than 20 properties are sold in a given month, each employee is paid in that month a bonus of £140 for each additional property sold. Variable expenses are incurred at the rate of 0.5% of the value of each property sold and these expenses are paid in the month of sale. Fixed overheads of £4,300 per…arrow_forwardthec Technologies Corporation (RTC) manufactures two radar models to monitor the speed of missiles. Deluxe model has an accuracy of plus or minus 2 km per hour, whereas standard model has an accuracy of plus or minus 3 km per hour. For the next week, the company has orders for 160 units of deluxe model and 240 units of standard model. Although RTC purchases all the electronic components used in both models, the plastic cases for both models are manufactured at a RTC plant in Chicago. Each deluxe model case requires 4 minutes of injection-molding time and 6 minutes of assembly time. Each standard model case requires 3 minutes of injection-molding time and 8 minutes of assembly time. For next week the Chicago plant has 960 minutes of injection-molding time available and 1728 minutes of assembly time available. The manufacturing cost is $10 per case for deluxe model and $6 per case for standard model. Depending upon demand and the time available at the C plant, RTC occasionally purchases…arrow_forwardPls help ASAP for botharrow_forward
- 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…arrow_forwardManagement of AG Travel and Tour has identified two groups of individuals that would be interested in the vacation package consisting of room and board and/or entertainment. The maximum amount that group 1 is willing to pay for room and board is GHC 2500 and for entertainment is GHC 500. For group 2, the maximum amount they are willing to pay for room and board is GHC 1800 and for entertainment is GHC 750. Although AG Travel and Tour is not able to identify members of either group, it does know that each group values the components of the package differently. Assuming there are an equal number of members in each group and that the total membership in each group is a single individual. If the marginal cost of providing the service (room and board and/or entertainment) to each group is GHC 1000. What will be the profit for AG Travel and Tour in the case of (iii) above?arrow_forwardThe 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)arrow_forward
- Sales The Marketing Club at your college has decided to raise funds by selling three types of T-shirt: one with a single-color "ordinary" design, one with a two-color "fancy" design, and one with a three-color "very fancy" design. The club feels that it can sell up to 320 T-shirts. "Ordinary" T-shirts will cost the club $6 each, "fancy" T-shirts $8 each, and "very fancy" T-shirts $10 each, and the club has a total purchasing budget of $3,200. It will sell "ordinary" T-shirts at a profit of $2 each, "fancy" T-shirts at a profit of $5 each, and "very fancy" T-shirts at a profit of $2 each. How many of each kind of T-shirt should the club order to maximize profit? "ordinary" T-shirt(s)"fancy" T-shirt(s)"very fancy" T-shirt(s) What is the maximum profit the club can make?arrow_forwardThe 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_forwardPorter 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_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,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License