24,000-seat arena that is home to the city’s professional basketball and ice hockey teams and that hosts a variety of concerts, trade shows, and conventions throughout the year. The hotel has experienced the following occupancy rates for the past 9 years, since the coliseum opened. Compute an exponentially smoothed forecast with an α value of .20. According to the result from Excel and/or POM-QM, the forecast for the year 5 would be (type number only, two decimals) 1 83 2 78 3 75 4 81 5 86 6 85 7 89 8 90 9 86
Q: generates Monday through Thursday sales of $150, $125, $75, and $180. What sales on Friday would…
A: Let sales on Friday be x.
Q: Brenda opened a pool and spa store in a lively shopping mall and finds business to be booming but…
A: Given data:Demand = 10 boxes per weekStore open (n) = 48 weeks/yearOrder cost = $40/orderLead time =…
Q: Construct a decision tree of the above situation clearly identifying the decision and chance nodes.…
A: A decision tree is a visual representation of the possible outcomes of a decision, with the…
Q: A renovation of the gift shop at Orlando Amway Center has six activities hours). In the following…
A: The optimistic time (a), most likely time (m), and pessimistic time (b) are given for each activity…
Q: Labor utilization of clerks: % Labor utilization of typists: % Where is the bottleneck in…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: Assuming the selling profit for the luxury, regular and exportation models is 1500, 1300 2500…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: A) Draw the network diagram. B) Determine the normal time it will take to complete this project. C)…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: An avant-garde clothing manufacturer runs a series of high-profile, risque ads on a billboard on…
A: Firstly, The given Data is Now Arrange , them From High to low:
Q: Referring to the above problem, solve it by the vogel approximation method
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: Source nodes 1 2 3 4 1000 O 1000 Sink nodes O 950 1 O 975 O 900 10 Demand 25 16 18 17 2 20 15 22 9…
A: Find the Given details below: Transportation table Source node Sink node 1 2 3 Supply 1…
Q: A plant has sufficient capacity to manufacture any combination of four different products (A, B, C,…
A: Decision variable:Suppose-xij= the units of product i to be manufactured by the plant using the…
Q: Imagine a company that has a corporate strategic goal of operating a new food delivery service line.…
A: Imagine a company that has a corporate strategic goal of operating a new food delivery service line.…
Q: Problem #1 Name: Frank Smith Date 4/6 4/7 4/8 4/9 4/10 4/11 In 8:00 8:00 7:45 7:45 8:15 10:00 Out…
A:
Q: The firm needs to satisfy all demand each day, but would like to minimize the total costs. The…
A: In the given question, there are 4 plants and 3 customers who will receive the widgets produced by…
Q: One mechanic services 7 drilling machines for a steel plate manufacturer. Machines break down on an…
A: When the source of the population is finite-number of customers or units in the queue is limited,…
Q: Chiltern Farms “[T]he beautiful valley of Vyeboom nestled between the majestic Franschhoek Mountains…
A: Green design and green operations are environment protection and sustainable method for production,…
Q: Skinner’s Fish Market buys fresh Boston bluefish daily for $4.20 per pound and sells it for $6 per…
A: Critical ratio is the rule that used to priority sequencing of waiting for processing at a work…
Q: The pucks used by the National Hockey League for ice hockey must weigh between 5.5 and 6.0 ounces.…
A: Quality control is one of the most important aspects of any company. It is necessary to make sure…
Q: 1) A construction company needs to move heavy equipment from city 1 to city 9, where the numbers on…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: a) Using a 2-year moving average, the forecast for year 6= 3750 miles (round your response to the…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. Business…
Q: MIn 150x+210y s.t. 3.8x+ 1.2y>=22.9 y>=5 y=0 Solve the linear problem graphically (X,Y)=( )…
A: MIN Zx = 150 x + 210 y subject to 3.8 x + 1.2 y ≥ 22.9 y ≥ 5…
Q: Find a company you are familiar with and explain how it uses its operations management function,…
A: Discovering and improving the processes used in the creation of services and products can assist…
Q: What are some employee benefits?
A: Employee benefits can be understood as some sort of compensations made to the employees besides his…
Q: Maximize C- SM 11N subject to 4M + 6N s 13 7M+ 4N ≤ 13 and M20, N2₂0. What is the optimal value of…
A: Linear programming is a mathematical method for determining a way to achieve the best outcome for a…
Q: Article 2: Chiltern Farms “[T]he beautiful valley of Vyeboom nestled between the majestic…
A: Supply chain management principles: There are 7 important principles of Supply chain…
Q: Which option (a, b, c, or d) shows the correct objective function and constraints for this…
A: Linear programming is a mathematical optimization technique for determining an optimal solution to a…
Q: Step 1 of 4: Determine the three-period moving average for the next time period. If necessary, round…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: Which of the following is not information needed to use the transportation model? Multiple Choice…
A: A transportation model is a type of mathematical model that is used in operations management to…
Q: Explain any three benefits of an inventory management system in relation to Costco given that they…
A: The front part of the case states that the just-in-time inventory management system that Costco uses…
Q: 1. Inventory Problem Figure 6 shows the inventory levels of dried Rainier cherries at a natural food…
A: Given data is Annual demand (D) = 800 Ordering cost (S) = $16 Carrying cost (C) = $4
Q: The NextGen distribution is working on improving inventory management by performing an ABC Analysis.…
A: Find the Given details below: Given details: Item Hits Criticality 1 A B 2 C B 3 B C 4…
Q: SOLVE THE FOLLOWING USING EXCEL 8. A manager is trying to decide whether to purchase a certain part…
A: Total cost = fixed cost + (variable cost per unit X total units)
Q: 1. Trojan Pizza shop has three workers and two stoves. Whenever the workers are idle, the shop…
A: Capacity of any process is defined by the capacity of its bottleneck workstation. Bottleneck…
Q: ose loves to eat out in area restaurants. His favorite foods are Mexican, Italian, Chinese, and…
A: Given: Cost of Mexican meal (M) = 400 Cost of Italian meal (I) = 600 Cost of Chinese meal (C)= 360…
Q: If the lead time is six days, what is the reorder point for both the no-backorder and backorder…
A: Monthly Demand = 50 Annual demand (D) = 50*12 =600 Number of business days = 300 Days in a month =…
Q: Find the least expensive route from I to L and state its cost 120 K 120 150 40 P 30 100 70 30/ N 50…
A: The shortest route method is an optimization technique of network models. Based on the input and…
Q: A project is scheduled to complete in six months duration. There are two activities in the project.…
A: Given data is
Q: The Axis car rental company allows its customers to pick up a rental car at one location and return…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: Do you need to do anything with the fact that he has only $190 in cash with him?
A:
Q: 9. The following information is given for a CPM network: Activity Predecessor Successor Normal Time…
A: A network diagram is visual representation of a project which helps to identify the project duration…
Q: A stock item has a count of 792 units, a cost of R3 and carrying charge of 20%. If the item is used…
A: Given: On- hand inventory = 792 usage per day = 36
Q: The production planner for Fine Coffees, Inc. produces two coffee blends: American (A) and British…
A: The detailed solution is given in Step 2
Q: Chiltern Farms “[T]he beautiful valley of Vyeboom nestled between the majestic Franschhoek Mountains…
A: The case is about a firm that grows and packs fruits for local and international markets. The…
Q: A wallpaper company estimates the demand for a certain pattern to be 925 rolls per year. It costs…
A: Given: Annual demand (D) = 925 Setup cost (S) = 750+150 Holding cost (H)= 4
Q: Define quality and how important it is in operation management
A: Here, As per the question, I would prepare the definition for Quality and then, I would explain how…
Q: Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal…
A: 1.28 Given: Mean weekly demand = 21 Standard deviation (s) = 5 Lead time (L) = 8 Z- score…
Q: 1.What are the decision variables 2.What is the objective functions 3. What are the constraints and…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Calculate Show critical slack float ock / path 7
A: A project might have slack time if the project manager and the team can do something else while…
Q: Construct the precedence table, and hence draw the network for the project
A: An AOA diagram is a type of organizational chart that is used to represent the hierarchical…
Q: Develop a project network for this problem. b) Determine the EST, EFT, LST, LFT, and slack for each…
A: Critical Path is a project management theory that shows the sequence of tasks in a project. The…
24,000-seat arena that is home to the city’s professional basketball and ice hockey teams and that hosts a variety of concerts, trade shows, and conventions throughout the year. The hotel has experienced the following occupancy rates for the past 9 years, since the coliseum opened. Compute an exponentially smoothed
1 83
2 78
3 75
4 81
5 86
6 85
7 89
8 90
9 86
Step by step
Solved in 3 steps with 2 images
- The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?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?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. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
- At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?
- Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
- Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 415.00, the following sales forecast has been developed: Forecasted Year Sales Sales 2005 455 415.00 2006 510 427.00 2007 516 451.90 2008 570 471.13 2009 585 500.79 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 74.04 sales (round your response to two decimal places). Forecasted sales for years 2006 through 2010 using exponential smoothing with a = 0.60 and a starting forecast of 415.00 are (round your responses to two decimal places): Year 2005 2006 2007 2008 2009 2010 Forecasted Sales 415.00 439 481.6 502.24 542.9 568.12 The MAD for a forecast developed using exponential smoothing with a = 0.60 is decimal places). sales (round your response to twoSales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 415.00, the following sales forecast has been developed: Forecasted Year Sales Sales 2005 455 415.00 2006 510 427.00 2007 516 451.90 2008 570 471.13 2009 585 500.79 The MAD for a forecast developed using exponential smoothing with a = 0.30 is sales (round your response to two decimal places).Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 415.00, the following sales forecast has been developed: Forecasted Year Sales Sales 2005 455 415.00 2006 510 427.00 2007 516 451.90 2008 570 471.13 2009 585 500.79 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 74.04 sales (round your response to two decimal places). Forecasted sales for years 2006 through 2010 using exponential smoothing with a = 0.60 and a starting forecast of 415.00 are (round your responses to two decimal places): Year 2005 2006 2007 2008 2009 2010 Forecasted Sales 415.00 439 481.6 502.24 542.9 568.12 The MAD for a forecast developed using exponential smoothing with a = 0.60 is 51.05 sales (round your response to two decimal places). Forecasted sales for years 2006 through 2010 using exponential smoothing with a =…