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 15QP
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
Port 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…
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
- 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_forwardKenton 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.arrow_forwardChris 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_forward
- Thomas 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_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_forwardLuxury Awnings makes custom awnings for homes and businesses. The company uses an activity-based costing system for its overhead costs. The company has provided the following data concerning its annual overhead costs and its activity cost pools: Overhead Costs: Production overhead $200,000 Office expense 100,000 Total $300,000 Distribution of resource consumption: Activity Cost Pools Making Awnings Job Support Other Total Production overhead 55 % 35 % 10% 100% Office expenses 8% 75% 17% 100% The "Other" activity cost pool consists of the costs of idle capacity and organization-sustaining costs. The amount of activity for the year is as follows: Activity Cost Pool Annual Activity Making awnings 5,000 metres Job support 200 jobs Other Not applicable Required: a) Prepare the first-stage allocation of overhead costs to the activity cost pools by filling in the table below: Making Awnings Job Support Other Total Production overhead Office expense Total b) Compute the activity rates (i.e.,…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_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_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_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_forwardGeorgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here: Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3 Hours required to complete all the oak cabinets 50 44 32 Hours required to complete all the cherry cabinets 61 46 34 Hours available 35 25 30 Cost per hour $36 $43 $56 For example, Cabinetmaker 1 estimates that it will take 50 hours to complete all the oak cabinets and 61 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 35 hours available for the final…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,