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
A West Indies tour service provider is considering marketing West Indies tours to the U.S., Canada and the U.K. The tour provider finds that there are a lot of tours being offered by existing providers in the U.S. and Canada and there are many flights connecting the markets. Few tours are being offered in the U.K., but there are only a small number of flights connecting it to the Bahamas. Research of West Indies accommodation data indicates there has been little growth in accommodation bookings from any of these countries. Given the data, should the tour service provider market tours in these countries?
Tasty Bread Company has monthly demand for one of its products as follows:
March= 520; April=490; May=550; June=580; July=600; August=420. Compute the three-month moving average for July.
The Burdell Wheel and Tire Company assembles tires on wheel rims for use on cars during the manufacture of vehicles by the automotive industry. Burdell wants to locate a low-cost supplier for the tires he uses in his assembly operation. The supplier will be selected based on the total annual cost to supply Burdell's needs. Burdell's annual requirements are for 25,000 tires, and the company operates 250 days a year. The following data is available for the two suppliers being considered. SUPPLIER SHIPPING QUANTITY PER SHIPMENT Annual SHIPPING COSTS PRICE / TIRE (p) INVENTORY HOLD COSTS (H) LEAD TIME (DAYS) Annual ADMIN. COSTS LEXINGTON TIRE 2,000 $18,000 $30 $6.00 6 $15,000 IRMO AUTO 1,000 $25,000 $29 $5.80 4 $18,000 Using the Total Cost Analysis for Supplier Selection, which supplier should Burdell choose? Provide details to justify your answer. The total costs are calculated as the sum of material costs, freight (shipping) costs, inventory costs, and administrative costs.
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
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?arrow_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardLocated in the picturesque Berkshire Mountains of Western Massachusetts, Ski Butternut has been a family-owned, family-oriented ski destination for more than 50 years. The resort includes 22 trails for downhill skiing and snowboarding, two terrain parks for riding, and a dedicated area for snow tubing. Although Ski Butternut hosts some non-ski events during summer and fall, its business goes into high gear when snowy weather arrives, bringing skiers and riders from across Massachusetts, Connecticut, New York, and New Jersey. Matt Sawyer, Ski Butternuts director of marketing, says the primary target market has always been families with young children who are seeking affordable skiing. Everything from the snack-bar menus to the ski-shop merchandise is presented with families in mind. So that parents can have fun in the snow without worry, the resort has a Childrens Center for children who are too young to ski or have no interest. Fifth-graders are invited to ski for free when accompanied by an adult who buys an adult lift ticket. The resort also created two terrain parks for young snowboarders who were clamoring for a more exciting riding experience. Without the terrain parks, Sawyer says, these boarders would have asked their parents to take them to competing mountains in Vermont. Ski Butternuts research shows that first-timers are a particularly important segment, because they tend to have a strong allegiance to the resort where they learn to ski. First-timers typically visit the resort seven times before seeking out more challenging mountains. As a result, Ski Butternut has made teaching first-timers to ski or snowboard one of its specialties. For this market, the resort bundles ski or board rentals, lift tickets, and also offers a wide range of individual and group lessons for all ages and abilities at a value price. Because Ski Butternut has trails for different skill levels, beginners can challenge themselves by changing trails within the resort once they feel confident. Ski Butternut also targets seniors and college students. Knowing that weekends are the busiest period, the resort offers special midweek prices to attract seniors who have free time to ski on weekdays. College students are particularly value-conscious, and they often travel to ski resorts as a group. As a result, Ski Butternut offers weekend and holiday discounts to bring in large numbers of students who would otherwise ski elsewhere. Thanks to Facebook, Twitter, and other social media, students quickly spread the word about special pricing, which enhances Ski Butternuts ability to reach this key segment. In addition, the resort highlights discount pricing for families when targeting specific segments, such as scout troops, military personnel, emergency services personnel, and members of local ski clubs. Another segment Ski Butternut has selected for marketing attention is ski racers. The resort features professional coaching, lessons, and programs for ski racers in the age group of 8 to 20. Sawyer notes that these ski racers are extremely dedicated to training, which means theyre on the slopes as often as possible, a positive for the resorts attendance and revenue. To stay in touch with racers, Ski Butternut has a special website and a dedicated Facebook page. Sawyer conducts up to 1,200 customer surveys every year to better understand who his customers are and what they need. He also compares the results with skiers who visit mountains of a similar size in other areas. Digging deeper, he analyzes data drawn from the ski shops rental business to build a detailed picture of customers demographics, abilities, and preferences. Based on this research, he knows that the typical family at Ski Butternut consists of two children under age 18 who ski or ride, and at least one parent who skis. Because they can obtain so much information from and about their customers, Sawyer and his team are able to make better decisions about the marketing mix for each segment. By better matching the media with the audience, they get a better response from advertising, e-mail messages, and other marketing communications. As one example, they found that 15 percent of the visitors to Ski Butternuts website were using a smartphone to access the site. Sawyer has now created a special version of the site specifically for mobile use and created a text-message contest to engage skiers who have smartphones.16 Of the four categories of variables, which one seems to be the most central to Ski Butternuts segmentation strategy, and why?arrow_forward
- Located in the picturesque Berkshire Mountains of Western Massachusetts, Ski Butternut has been a family-owned, family-oriented ski destination for more than 50 years. The resort includes 22 trails for downhill skiing and snowboarding, two terrain parks for riding, and a dedicated area for snow tubing. Although Ski Butternut hosts some non-ski events during summer and fall, its business goes into high gear when snowy weather arrives, bringing skiers and riders from across Massachusetts, Connecticut, New York, and New Jersey. Matt Sawyer, Ski Butternuts director of marketing, says the primary target market has always been families with young children who are seeking affordable skiing. Everything from the snack-bar menus to the ski-shop merchandise is presented with families in mind. So that parents can have fun in the snow without worry, the resort has a Childrens Center for children who are too young to ski or have no interest. Fifth-graders are invited to ski for free when accompanied by an adult who buys an adult lift ticket. The resort also created two terrain parks for young snowboarders who were clamoring for a more exciting riding experience. Without the terrain parks, Sawyer says, these boarders would have asked their parents to take them to competing mountains in Vermont. Ski Butternuts research shows that first-timers are a particularly important segment, because they tend to have a strong allegiance to the resort where they learn to ski. First-timers typically visit the resort seven times before seeking out more challenging mountains. As a result, Ski Butternut has made teaching first-timers to ski or snowboard one of its specialties. For this market, the resort bundles ski or board rentals, lift tickets, and also offers a wide range of individual and group lessons for all ages and abilities at a value price. Because Ski Butternut has trails for different skill levels, beginners can challenge themselves by changing trails within the resort once they feel confident. Ski Butternut also targets seniors and college students. Knowing that weekends are the busiest period, the resort offers special midweek prices to attract seniors who have free time to ski on weekdays. College students are particularly value-conscious, and they often travel to ski resorts as a group. As a result, Ski Butternut offers weekend and holiday discounts to bring in large numbers of students who would otherwise ski elsewhere. Thanks to Facebook, Twitter, and other social media, students quickly spread the word about special pricing, which enhances Ski Butternuts ability to reach this key segment. In addition, the resort highlights discount pricing for families when targeting specific segments, such as scout troops, military personnel, emergency services personnel, and members of local ski clubs. Another segment Ski Butternut has selected for marketing attention is ski racers. The resort features professional coaching, lessons, and programs for ski racers in the age group of 8 to 20. Sawyer notes that these ski racers are extremely dedicated to training, which means theyre on the slopes as often as possible, a positive for the resorts attendance and revenue. To stay in touch with racers, Ski Butternut has a special website and a dedicated Facebook page. Sawyer conducts up to 1,200 customer surveys every year to better understand who his customers are and what they need. He also compares the results with skiers who visit mountains of a similar size in other areas. Digging deeper, he analyzes data drawn from the ski shops rental business to build a detailed picture of customers demographics, abilities, and preferences. Based on this research, he knows that the typical family at Ski Butternut consists of two children under age 18 who ski or ride, and at least one parent who skis. Because they can obtain so much information from and about their customers, Sawyer and his team are able to make better decisions about the marketing mix for each segment. By better matching the media with the audience, they get a better response from advertising, e-mail messages, and other marketing communications. As one example, they found that 15 percent of the visitors to Ski Butternuts website were using a smartphone to access the site. Sawyer has now created a special version of the site specifically for mobile use and created a text-message contest to engage skiers who have smartphones.16 How is Ski Butternut applying behavioristic variables in its segmentation strategy? Explain your answer.arrow_forwardLocated in the picturesque Berkshire Mountains of Western Massachusetts, Ski Butternut has been a family-owned, family-oriented ski destination for more than 50 years. The resort includes 22 trails for downhill skiing and snowboarding, two terrain parks for riding, and a dedicated area for snow tubing. Although Ski Butternut hosts some non-ski events during summer and fall, its business goes into high gear when snowy weather arrives, bringing skiers and riders from across Massachusetts, Connecticut, New York, and New Jersey. Matt Sawyer, Ski Butternuts director of marketing, says the primary target market has always been families with young children who are seeking affordable skiing. Everything from the snack-bar menus to the ski-shop merchandise is presented with families in mind. So that parents can have fun in the snow without worry, the resort has a Childrens Center for children who are too young to ski or have no interest. Fifth-graders are invited to ski for free when accompanied by an adult who buys an adult lift ticket. The resort also created two terrain parks for young snowboarders who were clamoring for a more exciting riding experience. Without the terrain parks, Sawyer says, these boarders would have asked their parents to take them to competing mountains in Vermont. Ski Butternuts research shows that first-timers are a particularly important segment, because they tend to have a strong allegiance to the resort where they learn to ski. First-timers typically visit the resort seven times before seeking out more challenging mountains. As a result, Ski Butternut has made teaching first-timers to ski or snowboard one of its specialties. For this market, the resort bundles ski or board rentals, lift tickets, and also offers a wide range of individual and group lessons for all ages and abilities at a value price. Because Ski Butternut has trails for different skill levels, beginners can challenge themselves by changing trails within the resort once they feel confident. Ski Butternut also targets seniors and college students. Knowing that weekends are the busiest period, the resort offers special midweek prices to attract seniors who have free time to ski on weekdays. College students are particularly value-conscious, and they often travel to ski resorts as a group. As a result, Ski Butternut offers weekend and holiday discounts to bring in large numbers of students who would otherwise ski elsewhere. Thanks to Facebook, Twitter, and other social media, students quickly spread the word about special pricing, which enhances Ski Butternuts ability to reach this key segment. In addition, the resort highlights discount pricing for families when targeting specific segments, such as scout troops, military personnel, emergency services personnel, and members of local ski clubs. Another segment Ski Butternut has selected for marketing attention is ski racers. The resort features professional coaching, lessons, and programs for ski racers in the age group of 8 to 20. Sawyer notes that these ski racers are extremely dedicated to training, which means theyre on the slopes as often as possible, a positive for the resorts attendance and revenue. To stay in touch with racers, Ski Butternut has a special website and a dedicated Facebook page. Sawyer conducts up to 1,200 customer surveys every year to better understand who his customers are and what they need. He also compares the results with skiers who visit mountains of a similar size in other areas. Digging deeper, he analyzes data drawn from the ski shops rental business to build a detailed picture of customers demographics, abilities, and preferences. Based on this research, he knows that the typical family at Ski Butternut consists of two children under age 18 who ski or ride, and at least one parent who skis. Because they can obtain so much information from and about their customers, Sawyer and his team are able to make better decisions about the marketing mix for each segment. By better matching the media with the audience, they get a better response from advertising, e-mail messages, and other marketing communications. As one example, they found that 15 percent of the visitors to Ski Butternuts website were using a smartphone to access the site. Sawyer has now created a special version of the site specifically for mobile use and created a text-message contest to engage skiers who have smartphones.16 What role do geographic variables play in Ski Butternuts segmentation and targeting?arrow_forwardThinking tools service assembles customized personal computers from generic parts. Formed and operated by part-time Svci students paulette cruz and maureen luis, the company has had steady growth since it started. The company assembles computers mostly at night, using part time students. Paulette and Maureen purchase generic computer parts in volume at a discount from a variety of sources whenever they see a good deal. Thus, they need a good forecast of demand for their computers so that they will know how many parts to purchase and stock. They have compiled demand data for the last 12 months as reported below A. Use exponential smoothing with smoothing parameter a=0.2 to compute the demand forecast for january (period 13) B. Use exponential smoothing with smoothing parameter a=0.5 to compute the demand forecast for january (period 13). C. Paulette believes that there is an upward trend in the demand, the initial forecast is 37 and the trend over this period is 0 units. Use…arrow_forward
- Homie Appliance Company operates a branch in Manila City. The following are transactions between the home office and branch for the current year. The home office sends P200,000 cash to the branch. Shipments to branch are billed at cost of P78,750. The Home Office pays branch expense of P3,500. Home office expense of 3,375 are paid by the branch. The branch returned merchandise costing P10,000 to the home office. Home office acquires branch furniture for P20,500 cash. The said fixed asset is carried on Branch Books. The annual depreciation on the branch furniture is 5%. The branch sends a P15,000 cash remittance to home office. Q1-What is the adjusted balance of Branch Current account in the Home Office Books? Q2-What is the adjusted Home Office Current account in the Home Office Books?arrow_forwardUse the table below to answer the following question(s). Fiberia Accessories, a clothing retailer, is planning to introduce a new line of sweaters as part of the winter collection for $65 with an inventory of 1500. The main selling season is 60 days between November and December. The store then sells the remaining units in a clearance sale at 65 percent discount. Out of the 60 main retail days, Fiberia sells the sweaters at full retail price for only 45 days, while giving a discount of 25 percent for the remaining 15 days. The demand functions a, and b are given as 79.5 and 1.1 respectively. Marked Down Pricing Model for Fiberia Accessories's new sweater Data Retail Price Inventory Selling Season (days) Days at Full Retail Intermediate Markdown Clearance Markdown Demand Function A B $65 1500 60 45 25 percent |65 percent 79.5 1.1 Compute the everyday sales throughout the discount sales period.arrow_forwardElite Distributor magazine is currently working on determining the number of publications they should print for the incoming trade show. The production manager analyzed the past data and summarized the following information. The average demand for the magazine is 3264 issues with a standard deviation of 120 issues during a similar trade shows. The magazine is sold for $10 each during the trade show and printing cost is $2.64 per issue. The leftover magazines is sold to a trade association for $1 a magazine to be distributed to its members during the next annual meeting. Considering this information, how many magazines should be printed before the trade show? (round your FINAL answer to the nearest integer). Hi if you can use Excel please complete the question that way. Thank You.arrow_forward
- CANON produces printers for sale in northern Europe in its Taiwan factory. Printers sold in different countries differ in terms of the power outlets as well as the language for the manuals. Currently, CANON assembles and packs printers for sale in individual countries. The distribution of weekly demand in different countries is normally distributed, with means and standard deviations as shown in the table below: Country Mean Weekly Demand Standard Deviation Germany 3,000 2,000 Norway 4,000 2,200 Denmark 2,000 1,400 3(a). Initially, it is assumed that demand in different countries is independent. Given that the lead time from the Taiwan factory is eight (8) weeks, how much safety inventory does CANON require in northern Europe if it targets a CSL of 95 percent? HINT: For the disaggregated option, just show sample calculations for one country (e.g., Germany), then organize the results for the remaining countries in a table or amend the table…arrow_forwardComfort Plus Inc. (CPI) manufactures a standard dining chair used in restaurants. The demand forecasts for quarter 1 (January–March) and quarter 2 (April–June) are 3700 chairs and 4200 chairs, respectively. CPI has a policy of satisfying all demand in the quarter in which it occurs. The chair contains an upholstered seat that can be produced by CPI or purchased from DAP, a subcontractor. DAP currently charges $12.50 per seat, but has announced a new price of $13.75, effective April 1. CPI can produce the seat at a cost of $10.25. CPI can produce up to 3800 seats per quarter. Seats that are produced or purchased in quarter 1 and used to satisfy demand in quarter 2 cost CPI $1.50 each to hold in inventory, but maximum inventory cannot exceed 300 seats. Define the decision variables needed to model this problem. Give the objection function. Write the constraints. What is the final answer? Explain in detail.arrow_forwardUsing the information provided below, answer the following questions.INFORMATIONThe data in the table below shows the number of Next-generation Rangers exported to over 100 countries through Durban’s roll-on roll-off (RORO) vehicle terminal during 2022 and the first quarter of 2023. A demand planner wants to compare the relative performance of the weighted moving average method against the simple exponential method in forecasting the volume of export of the next-gen Ranger from the Silverton Assembly Plant.Required:5.1. Using the simple exponential smoothing method (SESM), compute the forecasts for the February 2022 to March 2023 period.Use a smoothing constant of 0.2 and assume a forecast of 7 000 units for January 2022.5.2. Compute the three-month weighted moving average (3MWMA) forecasts for the April 2022 to March 2023 period, using weights of 0.2, 0.3, and 0,5 (oldest data to newest data, respectively).5.3. Using the forecasts calculated for the April 2022 to March 2023 period,…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,Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning