2.99 See Answer

Question: For the coffee maker sales data in


For the coffee maker sales data in problem 33, use the Exponential Smoothing Excel template with = 0.2 to compute the exponential smoothing forecasts for February through July.


> Select three types of supply chain risks and explain in-depth how supply chain managers can help mitigate these risks. That is, develop an action plan to mitigate these risks (maximum of two typed pages).

> In Solved Problem 7.1 on Clear Water Pool Service (CWPS), CWPS replaced it fleet of pool service vans with hybrid/electric and gasoline-driven systems. This reduced the number of gallons of gasoline used to 6,000 gallons per year. How many metric tons of

> Kurelis Interior Design (see problem 67) provides home and office decorating assistance. On average, their high-end customers spend $36,000 on interior design fees plus $186,000 for furniture. In normal operation an average of 2.5 customers arrive per ho

> Trosper Tire Company has decided to hire a new mechanic to handle all tire changes for customers ordering new tires. Two mechanics are available for the job. One mechanic has limited experience and can be hired for $22 per hour. It is expected that this

> Keuka Park Savings and Loan currently has one drive-up teller window. Cars arrive at a mean rate of 10 per hour. The mean service rate is 12 cars per hour per window. To improve its customer service, Keuka Park Savings and Loan wants to investigate the e

> Kurelis Interior Design provides home and office decorating assistance. In normal operation an average of 2.5 customers arrive per hour. One design consultant is available to answer customer questions and make product recommendations. The consultant aver

> The district manager of a fast-food restaurant chain was receiving numerous complaints about customers waiting too long at the counter to place and receive their order. During the peak hour of store operation, the district manager’s audit team found that

> Big Al’s Car Wash has two wash bays. Each bay can wash 15 cars per hour. Cars arrive at the carwash at the rate of 15 cars per hour on the average, join the waiting line, and move to the next open bay when it becomes available. Use the Multiple Server Qu

> The City Beverage Drive-Thru is considering a two-server system. Cars arrive at the store at the mean rate of six per hour. The service rate for each server is 10 per hour. Use the Multiple Server Queue Excel template to answer the following questions: a

> Long lines of patients wait for CAT scanning service in a hospital. Patients arrive for scans at a rate of 1.8 per hour. The average processing time for CAT service is 27 minutes per patient. Your summer internship is in the hospital where you are assign

> Fore and Aft Marina is a new marina planned for a location on the Ohio River near Madison, Indiana. Assume that Fore and Aft decides to build one docking facility and expects a mean arrival rate of five boats per hour and a mean service rate of 10 boats

> Research the job of a global sourcing manager and describe the job duties, travel requirements, and skill set (maximum of two typed pages).

> Keuka Park Savings and Loan currently has one drive-up teller window. Cars arrive at a mean rate of 10 per hour. The mean service rate is 12 cars per hour. Use the Single Server Queue Excel template to answer the following questions: a. What is the proba

> A JetAir 304 airplane emits 22 kilograms of carbon dioxide per hour while flying. Today, the plane flew for 8.2 hours on six flights. This emission rate doesn’t include the time on the ground running its engines and other airport gate and airport emissio

> Marty’s Barber Shop has one barber. Customers arrive at a rate of 2.2 per hour, and haircuts are given at an average rate of five customers per hour. Use the Single Server Queue Excel template to answer the following questions: a. What is the probability

> Assume trucks arriving for loading/unloading at a truck dock from a single server waiting line. The mean arrival rate is four trucks per hour, and the mean service rate is five trucks per hour. Use the Single Server Queue Excel template to answer the fol

> Pete’s Market is a small local grocery store with one checkout counter. Shoppers arrive at the checkout lane at an average rate of 15 customers per hour and the average order takes three minutes to ring up and bag. If Pete does not want the average time

> A mail-order nursery specializes in European beech trees. New orders, which are processed by a single shipping clerk, have a mean arrival rate of six per day and a mean service rate of eight per day. Use the Single Server Queue Excel template to answer t

> Arrivals to a single server queue occur at an average rate of three per minute. Use the appropriate Excel function to develop the probability distribution for the number of arrivals for x 5 0 through 10.

> Trucks using a single server loading dock have a mean arrival rate of 12 per day. The loading/unloading rate is 18 per day. Use the Single Server Queue Excel template to answer the following questions: a. What is the probability that the truck dock will

> An accounts receivable manager processes 200 checks per day with an average processing time of 15 working days. Use the Excel template Little’s Law to find the average number of accounts receivable checks being processed in her office. What if through in

> An express checkout line at a grocery store takes an average of three minutes to ring-up a customer’s order. On average six customers are in the checkout line. Use the Excel template Little’s Law to find the average number of customers per hour that are

> Draw a supply chain flowchart similar to Exhibit 13.1 using the SCOR Model for a business you have worked in or have experience with. Describe how the supply chain works. If you have little or no work experience, then do the assignment for a restaurant o

> A manufacturer’s average WIP inventory for Part #2934 is 995 parts. The workstation produces parts at the rate of 225 parts per day. Use the Excel template Little’s Law to find the average time a part spends in this workstation.

> Linda Bryant recently started a small home-construction company. In an effort to foster high quality, rather than subcontracting individual work, she has formed teams of employees who are responsible for the entire job. She has contracted with a develope

> Carbon dioxide emissions associated with a one-night stay in a hotel room are calculated at 29.53 kg of CO2 per room day for an average hotel. The 200 rooms of your hotel are all occupied for 2 days during a college football game. a. How much CO2 did th

> The Hudson Jewelers case study available in MindTap integrates material found in each chapter of this book. Case Questions for Discussion: 1. What is the value of a loyal customer to Hudson Jewelers for a wealthy individual who visits Naples every Februa

> A manufacturer has committed to supply 16 units of a particular product in four months (i.e., 16 weeks) at a price of $30,000 each. The first unit took 1,000 hours to produce. Even though the second unit took only 750 hours to produce, the manufacturer i

> Yacht Superior manufactures boats for a yacht rental firm. They are in negotiation for the total price for 50 Model C314 yachts. Based on past experience, the learning rate for their employees and system is 75% and they estimate the first unit will requi

> Suppose a manufacturer of copiers has concluded that a 75 percent learning curve applies to the time a beginning service technician takes to install copy machines. Use the Learning Curve Excel template to answer the following questions: a. If the time re

> Operating at an 80 percent learning rate, the first unit took 72 hours to produce. Use the Learning Curve Excel template to determine how long the 32nd unit will take. What is the cumulative average time for the one-hundredth unit?

> A plant manufactures three products, A, B, and C. A drill press is required to perform one operation for each product. The plant operates one eight-hour shift 20 days per month. The operation times for each product follow. Determine the amount of equipme

> A hotel hosts banquet for conferences in a large ballroom with tables of eight. Servers must get the meals from the kitchen, bring them out to the tables, and then place the meals on the tables. It takes four minutes to get the meals and bring them ou

> When is simulation useful in analyzing inventory systems?

> Two experienced managers are resisting the introduction of a computerized exponential smoothing system, claiming that their judgmental forecasts are much better than any computer could do. Their past record of predictions is as follows: These data are a

> A chain of grocery stores had the following weekly demand (cases) for a particular brand of laundry soap: a. Use the Moving Average Excel template to develop three- and four-period moving average forecasts, and compute MSE for each. Which provides the be

> The president of a small manufacturing firm is concerned about the continual growth in manufacturing costs in the past several years. The data series of the cost per unit for the firm’s leading product over the past eight years are give

> The historical demand for the Panasonic Model 304 Pencil Sharpener is January, 80; February, 100; March, 60; April, 80; and May, 90 units. a. Using a four-month moving average and the Moving Average Excel template, what is the forecast for June? b. Devel

> Supreme Auto Parts produces components for motorcycle engines. It has plants in Amarillo, Texas, and Charlotte, North Carolina, and supply factories in Detroit and Atlanta. Use the following production and cost data for a major component are as follows.

> Using the factory energy cost data in Exhibit 9.11, find the best moving average and exponential smoothing models using the Moving Average and Exponential Smoothing Excel templates. Compare their forecasting ability with the regression model developed i

> The monthly sales of a new business software package at a local discount software store were as follows: a. Plot the data on a spreadsheet and provide insights about the time series. b. Use the Moving Average Excel template to find the best number of wee

> The number of component parts used in a production process each of the last 10 weeks is as follows. a. Use the Moving Average Excel template to develop moving average models with two, three, and four periods. Compare them using MSE to determine which is

> Consider the quarterly sales data for Kilbourne Health Club shown below. These data are available in a simpler format in the Excel worksheet C9 Excel P41 in MindTap. a. Use the Moving Average Excel template to develop a four-period moving average model a

> For the restaurant sales data in problem 39, use the Exponential Smoothing Excel template in MindTap to find the best exponential smoothing model by evaluating the MSE for from 0.1 to 0.9, in increments of 0.1. How does this model compare with the bes

> Why does the fixed-period model have to cover the time period of T 1 L, while the fixed-order quantity model must cover only the time period L? Why is this important?

> A restaurant wants to forecast its weekly sales. Historical data (in dollars) for fifteen weeks are shown below and can be found in the Excel worksheet C9 Excel P39 Data in MindTap. Use Excel and the Moving Average template to answer the following quest

> To plan factory staffing levels, Luke’s Surfboards, needs to forecast sales for the next two quarters. Sales of surfboards for the last five years are shown below in millions of dollars. These data are available in the worksheet C9 Exce

> For the actual sales data at Just Say Music in Problem 36, find the best single exponential smoothing model by evaluating the MSE for from 0.1 to 0.9, in increments of 0.1. How does this model compare with the best moving average model found in Problem

> Forecasts and actual sales of digital music players at Just Say Music are as follows: a. Plot the data and provide insights about the time series. b. What is the forecast for November, using a two-period moving average? c. What is the forecast for Nove

> 1. Exhibit 19.21 shows the project work activities for designing custom jewelry using computer aided design (CAD). Draw the network diagram, determine the project completion time, critical path(s), activity slack times, and create a Gantt chart for the p

> The manufacturer of gas outdoor grills provides sales data for the last three years as follows: Use the Exponential Smoothing Excel template to develop single exponential smoothing models with = 0.2, 0.4, and 0.6. Co

> Five observations from a work measurement study are shown below. Continuous timing was not used, but the times in minutes for each work element were recorded individually. Assume a total allowance of 20 percent. Use the Work Measurement Excel template t

> Nine observations from a work measurement study using continuous timing are shown below. Allowances are determined as: personal five percent; fatigue five percent; delay fiver percent. Use the Work Measurement Excel template to determine the standard

> The deli at a Metro Supermarket experiences constant and continuous demand. Staffing is a problem for store managers but several of the employees suggested they buy more deli cutting machines and weighing scales and place them side-by-side. Currently, th

> Why are quantity discounts often given by suppliers? How do these affect the customer’s inventory decisions?

> An automated car wash called Jet Express outside a large Texas city on the beltway is deciding whether to build and install one dedicated vehicle wash line or have two parallel wash lines. There are no other cash washes at this intersection and there wil

> Rework computational problem 36 (college textbook publisher) using the Break-Even template in MindTap and answer the following questions: Note that students must use Goal Seek or trial and error to find the breakeven quantities. a. What is the break-even

> Rework computational problem 34 (Worthington Machining) using the Break-Even Excel template in MindTap to answer the following questions: a. What is the break-even quantity between these two processes? b. If predicted demand for next year is 120,000 pane

> Samoset Fans, Inc. manufacturers its fan blades in-house. The owner, Betty Dice, doesn’t outsource any fan parts except fan motors—all other fans parts are made in-house. There current process and its equipment are getting old. Maintenance and repair cos

> Consider the following transportation problem data for Baker Industries (these data are available in the Excel worksheet Baker Industries on MindTap): Use the techniques explained in Supplement E: The Transportation Problem to address the following: a.

> Milford Lumber Company ships construction materials from three wood-processing plants to three retail stores. The shipping cost, monthly production capacities, and monthly demand for framing lumber are given below (these data are available in the Excel w

> Gordon Rivers, the city manager of Saratoga, Florida, pitched the proposed design schedule back at Jay Andrews. Jay Andrews is the project manager for Major Design Corporation (MDC). The city of Saratoga selected MDC for this project. As project manager,

> Cunningham Products is evaluating five possible locations to build a distribution center. Data estimated from the accounting department are provided below. The annual production is estimated to be 30,000 units. a. Use the Location Analysis Excel template

> For the David drugstore chain in Problem 39, suppose that after five years, half the customers from segment 1 are expected to move to segment 2. Where should the drugstore shift, assuming the same criteria are adopted? Use the Center of Gravity Excel t

> MegaMart, a large department store, has a very successful and profitable package wrapping department. The department uses two very complex bow-making machines that work inline to make the bows for the packages. Bow-making Machine #1 has a reliability of

> The Lemma Company manufactures and sells ten products. Managers find ways to reduce the setup and inventory-holding costs by one-half. What effect will this have on the EOQs for the ten products?

> Magnaplex, Inc. has a complex manufacturing process, with three operations that are performed in series. Because of the nature of the process, machines frequently fall out of adjustment and must be repaired. To keep the system going, two identical machin

> An electronic missile guidance system at Mguide, Inc. consists of: Components A, B, C, and D which have reliabilities of 0.98, 0.97, 0.91, and 0.95, respectively (see the following diagram). a. Use the Excel template Systems Reliability to compute the r

> Suppose that the design specifications for hydraulic cylinder are 10.00  0.10 centimeters, and that the Taguchi loss function is estimated to be L(x) = 1,400 (x – T)2. Use the Excel template Taguchi to answer the following questions: a. Determine the e

> For the situation in Problem 51, what are the economic design specifications if the cost of inspection and adjustment is $7.50?

> A quality characteristic has a design specification (in cm.) of 0.200  0.02. If the actual process value of the quality characteristic is at the boundary of the tolerance on either side, the product will require a repair of $30. Use the Excel template T

> Assume the specifications for a television remote control part (in inches) are 5.00 ± 0.10, and the Taguchi loss function is estimated to be L(x) = 5,500 (x – T)2. Determine the estimated loss per part if the quality characteristic (i.e., actual process

> Assume the specifications for a part (in inches) are 5.00 ± 0.37, and the Taguchi loss function is estimated to be L(x) = 9,300 (x – T)2. Use the Excel template Taguchi to determine the estimated loss if the quality characteristic under study takes on a

> University Medical Center needs to move from its existing facility to a new and larger facility five miles away from its current location. Due to construction delays, however, much of the new equipment ordered for installation in the new hospital was del

> The Davis national drugstore chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment along with the coordinates are as follows: Find the best location using the Center of Gravit

> Given the location information and volume of material movements from a supply point (warehouse) to several retail stores for Bourbon Hardware, find the optimal location for the supply point using the Center of Gravity Excel template.

> Does the EOQ increase or decrease if estimates of setup (order) costs include fixed, semi-variable, and pure variable costs while inventory-holding costs include only pure variable costs? Vice versa? What are the implications? Explain.

> Refer to the information provided in Question 36 to answer the following questions using the Break-Even Excel template. a. If demand is forecast to be 3,500 parts, should the firm make the part in-house or purchase it from a supplier? b. The marketing de

> Forbelt Corporation has a one-year contract to supply motors for all refrigerators produced by the Ice Age Corporation. Ice Age manufactures the refrigerators at four locations around the country: Boston, Dallas, Los Angeles, and St. Paul. Plans call for

> Arnoff Enterprises manufactures the central processing unit (CPU) for a line of personal computers. The CPUs are manufactured in Seattle, Columbus, and New York and shipped to warehouses in Pittsburgh, Mobile, Denver, Los Angeles, and Washington, DC for

> Assume the cost factors given in Problem 42 have not changed. A marketing representative of NEW-SPEC, a firm that specializes in providing manual inspection processes for other firms, approached Paris Manufacturing and offered to inspect parts for $19 ea

> A manager of Paris Manufacturing that produces computer hard drives is planning to lease a new automated inspection system. The manager believes the new system will be more accurate than the current manual inspection process. The firm has had problems wi

> Suzy’s Temporary Employee (STE) business, located in a big city, can do an on-line criminal background check in-house for $1.29 per search with a fixed cost of $29,000. A third party on-line security firm offered to do a similar security search for $8.00

> A hospital is evaluating whether to outsource or perform in-house a large set of blood and urine laboratory tests. The fixed cost of the laboratory equipment located in the hospital is $800,000 and the weighted average variable cost per test if performed

> A company is considering three vendors for purchasing a CRM system, Delphi Inc., CRM International, and Murray Analytics. The costs of the system are expected to depend on the length of time required to implement the system, which depends on such factor

> 1. Write a short paper (maximum of two pages) on how the four principles of lean operating systems are applied to diamond mining. 2. If you were to design a jewelry store based only upon the four principles of lean operating systems—elimination of waste,

> Suppose that in Problem 37, a forecasting study determines that he probabilities of demand volume are Low = 0.2, Medium = 0.2, and High = 0.6. Use the Excel template Decision Analysis to determine the expected value decision. How appropriate is it to u

> 1. Develop a staff schedule between the hours of 9 a.m. and 8 p.m. for week 8, which had 587 visits (see the worksheet Hudson Jeweler Demand Case Data in MindTap). Assume the maximum service rate is ten customers per hour per store employee. You will hav

> Edwards Machine Tools needs to purchase a new machine. The basic model is slower but costs less, while the advanced model is faster but costs more. Profitability will depend on future demand. The following table presents an estimate of profits over the n

> A firm is evaluating the alternative of manufacturing a part that is currently being outsourced from a supplier. The relevant information is provided below: For in-house manufacturing: Annual fixed cost = $80,000 Variable cost per part = $140 For purchas

> Marine International manufactures an aquarium pump and is trying to decide whether to produce the filter system in-house or sign an outsourcing contract with Bayfront Manufacturing to make the filter system. Marine’s expertise is producing the pumps the

> What might the competitive advantage be for each of the following companies? a. eBay b. Southwest Airlines c. Starbucks d. Apple e. Facebook f. Uber g. 3M h. Amazon i. Bentley automobiles j. Nordstrom

> Investigate the current technology available for laptop computers, cell phones, or tablets. Select two different models and compare their features and operational characteristics, as well as manufacturer’s support and service. Briefly explain how you mi

> Research radio frequency identification devices (RFID) and provide examples of how they are or might be used to improve productivity in operations.

> Identify and describe (maximum of one typed page) a service encounter where technology helps create and deliver the service in total or in part. What hard and soft technology most likely is involved?

> Describe at least one application of modern technology in each of these service industries: a. Financial services b. Public and government services c. Transportation services d. Educational services e. Hotel and motel services How does your example appli

> Bloomberg Businessweek published an article titled “This Economic Model Organized Asia for Decades. Now It’s Broken” (June 21, 2017; https://www.bloomberg.com/news/features/2017-06-21/this-economic-model-organized-asia-for-decades-now-it-s-broken). Res

> Community Medical Associates (CMA) is a large health care system with 2 hospitals, 25 satellite health centers, and 56 outpatient clinics. CMA had 1.5 million outpatient visits and 60,000 inpatient admissions the previous year. Just a few years ago, CMA&

> Find, describe, and draw an organization’s sup- ply chain and identify the types of inventory in it and, if possible, their purpose and how they are monitored and controlled. (The example could be a place you worked such as a call center, restaurant, fac

> Identify and describe a queueing system of interest to you. Draw a picture of the system.

2.99

See Answer