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 16QP
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
Trending nowThis is a popular solution!
Students have asked these similar questions
Sapphire Farm is a business that trains and boards horses and educates young riders about horse care, nutrition, and riding. The farm provides both a learning and a fun environment for young equestrians and their families. It also hosts horse shows for beginning riders to help them build confidence in the show ring and to prepare them for local horse shows by running shows in accordance with the rules and regulations of the National Hunter Jumper Association. Feedback from the horseshow judges are provided to all riders so they can do better at their next meet. In addition, all warm-up and training areas are fenced and monitored by adults for the children's safety.
If the farm unintentionally hired someone to teach riding who was unable to deal effectively with small children, then a _____ would occur.
A.
service divergence
B.
quality underperformance
C.
performance breakdown
D.
product variation
E.
customer aberration
Sapphire Farm is a business that trains and boards horses and educates young riders about horse care, nutrition, a product focusand riding. The farm provides both a learning and a fun environment for young equestrians and their families. It also hosts horse shows for beginning riders to help them build confidence in the show ring and to prepare them for local horse shows by running shows in accordance with the rules and regulations of the National Hunter Jumper Association. Feedback from the horseshow judges are provided to all riders so they can do better at their next meet. In addition, all warm-up and training areas are fenced and monitored by adults for the children's safety.According to the service-profit chain, the high-value service offered by Sapphire Farm LLC should lead to:
A.
congruent market response
B.
positive framing
C.
customer autonomy
D.
customer satisfaction
E.
a product focus
Kenton Coffee Roasters blends three types of coffee beans (Brazilian, Colombian, and Peruvian) into ground coffee that is sold at retail. Each kind of bean has a distinctive aroma and taste, and the company has a chief taster who can rate the fragrance of the aroma and
the strength of the taste on a scale of 1-100. The features of the beans are stated below.
Brazilian
Colombian
Peruvian
Aroma
Rating
75
60
85
Strength
Rating
15
20
18
Cost/Pound
(5)
3.55
4.26
4.97
Pounds
Available
1500
1200
2000
Kenton would like to create a blend that has an aroma rating of at least 78 and a strength rating of at least 16. Using the available coffee Kenton wants to create 4000 pounds of blended coffee with the fragrance and taste ratings stated at the lowest possible cost.
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
- The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.arrow_forwardPort Ormond Carpet Company manufactures carpets. Fiber is placed in process in the Spinning Department, where it is spun into yarn. The output of the Spinning Department is transferred to the Tufting Department, where carpet backing is added at the beginning of the process and the process is completed. On January 1, Port Ormond Carpet Company had the following inventories: Finished Goods $8,200 Work in Process-Spinning Department 1,800 Work in Process-Tufting Department 2,900 Materials 4,800 Departmental accounts are maintained for factory overhead, and both have zero balances on January 1. Manufacturing operations for January are summarized as follows: Jan. 1 Materials purchased on account, $82,700 2 Materials requisitioned for use: Fiber-Spinning Department, $43,800 Carpet backing-Tufting Department, $34,900 Indirect materials-Spinning Department, $3,200 Indirect materials-Tufting Department, $2,800 31 Labor used: Direct…arrow_forwardThomas has eight horses averaging 1,400 pounds. They are on 20 acres of orchard grass and clover. Each year, Thomas applied 30-30-30 units of fertilizer per acre using 46-0-0 urea at $408 per ton, 18-46-0 DAP at $496 per ton, and 0-0-60 muriate of potash at $506 per ton. He reseeded with 10 pounds per acre of orchard grass at $1.19 per pound and 2 pounds per acre of clover at $3.18 per pound. The horses are housed in a barn 34 feet wide with stalls 12 by 12 feet on each side and a 10-foot aisle down the center. He needs at least one fifth of the barn, not including the center, for hay and tack room. What did it cost to fertilize and reseed the pasture? How long must he barn be in even number of feet?arrow_forward
- Chris Zhang is the food and beverage manager for XTreme Fit. His company is fielding a team to compete at this years' Fitness Olympics. Xtreme Fit decided to put their team on a diet to prepare them for the competition. Mr. Zhang was tasked to determine the menu for the team. The head coach of the team set the following nutritional guidelines for each meal: • At least 5 mg of iron • At least 30 g of protein • At least 40 g of carbohydrates • At least 20 but no more than 60 g of fat • No more than 30 mg of cholesterol • Between 1,500 and 2,000 calories Mr. Zhang prepares the meals from a few basic food groups. These items are listed below with the nutritional content per pound. The cost of the item per pound are as follows: Red meat: $2.30 White meat: $0.80 Seafood: $3.70 Legumes: $0.90 Leafy greens: $0.75 Starch: $0.40 Dairy: $0.83arrow_forwardComfort-Air produces 3 types (Type 1, Type 2 and Type 3) thermostats for household temperature control. Three limited resources are required for the production. These resources are available time (R1) of a Robotic Insertion Machine (RIM), workforce hours (R2) and certain type of electronic components (R3). Profits generated from each unit of the thermostats are shown in the first row of the following table. The amount of resources required to produce one unit of the thermostats are also given in the table. The last column of the table shows the available amount of the resources. Comfort-Air needs to decide the numbers of thermostats of each type (x,,x, and x,) to produce in order to maximize its total profit. Table: Production Related Data Туре 2 115 Thermostat Туре 1 Туре 3 Available Amount of Profit per unit product Amount of required resources to produce each unit product 80 70 Resource 1840 (hour) 2100 (hour) 3500 (units) R1 5 8 7 R2 4 7 R3 8. 10 12 1) Based on the given…arrow_forwardBags & Box Cereals produces two types of cereals: basic and premium. Each type is sold in box of 100 grams and bags of 200 grams. The company has 4 machines that can package 200,000 boxes, and each machine requires three operators. The company has 5 machines that can package 150,000 bags, and each machine requires four operators. The table below shows the forecasted demand for the next four years. 2 3 4 Вох 100g Bag 200g Вох 100g 50000 70000 100000 120000 Cereal Basic 45000 60000 80000 100000 Cereal 40000 50000 60000 70000 Premium Bag 200g 35000 40000 45000 50000 What is the labor requirement for production of boxes in year 3?arrow_forward
- Grass MixMix RequirementsWrigleyNo more than 50% tall fescue At least 20% mustang fescuePastureAt least 30% bluegrass At least 30% mustang fescue No more that 20% tall fescueDuroTurfAt least 50% but no more than 70% tall fescue At least 10% bluegrass Ed's Feed and Seed creates three custom grass mixes it sells in their retail stores. These mixes are made from three types of seed they purchase from a supplier: tall fescue, mustang fescue, and bluegrass. Requirements for the custom mixes are in the table at the left. Ed's want to produce 1200 lbs of the Wrigley Mix,900 lbs of the Pasture Mix, and 2400 lbs of the DuroTurf Mix for the coming growing season. Ed's costs for the purchased seeds are $1.70/lb for tall fescue, $2.80/lb for mustang fescue, and $3.25 for bluegrass.Ed wants to know how many pounds of each seed type to purchase to minimize cost. Create a spreadsheet model and use Solver to determine how much seed of each type to purchase. Write a sentence to summarize the…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_forwardA mixture of pellets is to be made containing x regular pellets, y large pellets and z extra large pellets. Cost, weight and volume data for each type of pellet are shown in the table. Is it possible to make mixture of 55 pellets at a cost of $0.85 if the mixture is to have 120 weight units and 130 volume units? If so, how many each type of pellet should be in the mixture? Pellet Type 5. Number of Cost per Pellet in Cents Weight Units per Pellet Volume Pellets Units per Pellet Regular Large Extra large 2 1 4 y 1 4 3arrow_forward
- Hudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: DemandStaffing Options High Medium LowOwn staff 650 650 600Outside vendor 900 600 300Combination 800 650 500(a) If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? Outside vendorWhat is the expected annual cost associated with that recommendation? Enter your answer in thousands dollars. For example, an answer of $200 thousands should be entered as 200,000. Expected annual cost = $570000(b) Construct a risk profile for the optimal decision in part (a). The input in the box below will…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_forwardThe following data structure and constraints exist for a magazine publishing company:a. The company publishes one regional magazine in each of four states: Florida (FL), South Carolina (SC), Georgia (GA), and Tennessee (TN).b. The company has 300,000 customers (subscribers) distributed throughout the four states listed in Problem 2a.c. On the first day of each month, an annual subscription INVOICE is printed and sent to each customer whose subscription is due for renewal. The INVOICE entity contains a REGION attribute to indicate the customer's state of residence (FL, SC, GA, TN):The company is aware of the problems associated with centralized management and has decided to decentralize management of the subscriptions into the company's four regional subsidiaries. Each subscription site will handle its own customer and invoice data. The management at company headquarters, however, will have access to customer and invoice data to generate annual reports and to issue ad hoc queries such…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,