The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 31 34 a. Calculate the single exponential smoothing forecast for these data using an or of 30 and an initial forecast (Fg of 31. (Round your answers to 2 decimal places) Month 4 5 6 7 . 9 3 4 51 6. Calculate the exponential smoothing with trend forecast for these data using and of 0.30, a 6 of 0.30, an initial trend forecast (7 of 1, and an initial exponentially smoothed forecast (Fg of 30. (Round your answers to 2 decimal places) @ Exponential Smoothing 10 35 37 36 38 40 40 41 FIT et Calculate the mean absolute deviation (MAD) for the last nine months of forecasts (Round your answers to 2 decimal places) MAD Single exponendal smoothing foreca Exponential anothing with trend forecast e-2. Which is best? Single exponential smoothing forecast Exponential smoothing with send forecast
Q: Question 2. A machine shop is planning to move to a bigger location. The new building is 60 metres…
A:
Q: A. Is the programming phase of a project a time for the project manager to relax? Why or why not? B.…
A: The primary responsibility of a project manager is project management; programming is not one of…
Q: what are the benefits and the risk of multidomestic strategy?
A: A multidomestic strategy is business strategy that emphasizes decentralization and local…
Q: The following payoff table shows profit for a decision analysis problem with two decision…
A: Given data: Decision alternative States of nature S1 S2 S3 d1 270 120 45 d2 120 120 95…
Q: recently surveyed 585 mobile application developers and managers, and found that just 35% of mobile…
A: Project management involves breaking down complex projects into manageable tasks, setting deadlines,…
Q: is I need it! A company currently using an inspection process in its material receiving department…
A: Production is a process that turns raw materials into finished products while utilizing a variety of…
Q: Background information on Tesco in Japan and Asian markets
A: Introduction- Tesco Plc is a retail supermarket company from the united kingdom. Tesco's entrance…
Q: Touhy Surgery Center (TSC) specializes in eye and foot surgeries. Their three operating rooms…
A: note: only linear program has been asked. This linear program will provide TSC with their optimal…
Q: How important do you feel it is to include management and people issues in the operations portion of…
A: Introduction The operations section of a business plan is nothing but a detailed outline of:…
Q: Describe the phenomena known as "Bring Your Own Device" (BYOD).
A: Bring Your Own Device (BYOD) is a work environment pattern that permits employees to utilize their…
Q: As a result of your success in expanding the "Real Estate, Real Cheap" network, your boss is eager…
A: As companies expand and acquire new subsidiaries or brands, their IT infrastructure must also evolve…
Q: QUESTION 16 Refer to the project addressed in questions 21-30 of your Quiz 1 and associated worked…
A: Ans) This is PERT problem. Formula: Table Formula Calculation: Table Solution:
Q: onald Duck is trying to decide whether he should purchase a small, medium, or large new bus for the…
A: Ans) Probability of variable demands are given. Expected Annual Profit = Sum(Probability* Annual…
Q: Three methods were compared to analyze system needs: classic, contemporary, and radical. You…
A: The aforementioned query relates to operations management and the many methodologies used in system…
Q: Another way to look at the concept of inventory turnover is by measuring sales per square foot.…
A: Formulas used: Average sales per sq. foot =Average inventory at retailSquare feetAnnual sales per…
Q: a. Daily routine or schedule for the day: Let's say you want to graph your daily routine for a…
A: The given data is a time-phased schedule on an hourly basis. Hence, we will prepare a bar chart with…
Q: How important is matching process capabilities to product requirements
A: Employing statistical control techniques to manage a production process is insufficient. A…
Q: The logical approach, from beginning to end, for assembling a linear programming model begins with:…
A: Since they presuppose that the modeler is already familiar with the constraints and objective…
Q: How might a company make strategic use of countertrade schemes as a marketing weapon to generate…
A: Countertrade schemes involve exchange of goods or services between countries, where payment is made…
Q: Capacity in excess of expected demand that is intended to offset uncertainty is a: O positioning…
A: Timing bubble, option A, is not a recognized concept in operations management or capacity planning.…
Q: Testing and validation: Before any changes are implemented, they are thoroughly tested to ensure…
A: Theoretical analysis is a method of using mathematical models, simulations, and other analytical…
Q: An operator that manufactures only two commodities, shirts and coats, the production manager wants…
A: Profit case: for maximum profit number of shirts = 10 coat = 0 or shirt = 8.33 and coat = 3.33…
Q: Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS…
A: Most Recent Quarter = 0.50 Second most recent Quarter = 0.25 Third most recent Quarter = 0.25
Q: Site the difference between contract and agreement. Does contract could be an agreement? does…
A: The terms "contract" and "agreement" are often used interchangeably, but there are some key…
Q: The Friendly Greetings greeting card company outsources printing to a nearby printing shop, which…
A: Given: Ordering cost (S) = 1200 Cost (C) = 0.30 Holding cost (H) = 0.05 Annual demand (D) = 25000
Q: Descriptive and prescriptive models vary greatly
A: Prescriptive analytic models are intended to arrange data and tasks to create the guide that…
Q: Integrated Health was a large private, nonprofit health care system located in Tempe,Arizona. A year…
A: The query above concerns a case study regarding deploying an electronic drug administration record…
Q: For what possible reason would a company take the risk of BYOD?
A: There are several reasons why company might allow employees to use their devices for work, or…
Q: ore Nowadays it is very important to reduce one's carbon footprint" (how much carbon we produce in…
A: Ans) Formula for calculating monthly IRR: Formula for calculating annual effective IRR:
Q: Examine the potential benefits that data visualizations, such as KPI monitoring, might provide to…
A: The operations management environment has been dramatically influenced by technological changes,…
Q: Part A-Patches' Cat Food Patches is a cat who eats cat food for breakfast. Patches requires a…
A: Let Kitty Kibble = K Cat snack = C Minimize Z = 4K + 2 C subject to 1K + 5C >= 40…
Q: As a rule, ERP systems adhere to industry standards. Whose standards, however, should be considered…
A: The inquiry's topic is the difficulty of deploying Enterprise Resource Planning (ERP) systems in…
Q: Develop an ACTIVITY ON ARROW CPM diagram for the activities/relationships listed below. For each…
A: Find the Calculation methods below: Early Start -- For the first activity Early start is 0 then for…
Q: what do you learn from ERP, Leadership and business process.
A: Every business is implementing new technology to improve its working conditions. New technological…
Q: A manufacturer has a production facility that requires 18,515 units of component JY21 per year.…
A: Given data: Annual demand (D)= 18515 units Ordering cost (S) = $137 Annual inventory carrying rate…
Q: Consider the following all-integer linear program. Max 5, + By s.t. 6x₂ + 5x₂ ≤ 35 11x₂ + 4x₂ s 44…
A: Given LP- Max Z = 5x1+8x2Subject to-6x1+5x2≤3511x1+ 4 x2≤44x1+2x2≤12x1, x2≥0
Q: What function does architecture serve within the larger context of society? Take a project into…
A: Architecture has a far wider role in the context of society than simply developing physical…
Q: Pretend that you are the owner of a company that performs interior painting services. You are…
A: The proprietor of a company that provides interior painting services had the opportunity to create a…
Q: If a single optimal solution exists to a graphical LP problem, it will exist at a corner point. O…
A: The query above relates to linear programming (LP), a method of mathematical optimization used to…
Q: a. Daily routine or schedule for the day: Let's say you want to graph your daily routine for a…
A: The given data is a time-phased schedule on an hourly basis. Hence, we will prepare a bar chart with…
Q: Locate three websites that provide information about online safety. Use the strategy of your choice…
A: Website: Stay Safe Online - https://staysafeonline.org/ Stay Safe Online is a website dedicated to…
Q: Question 1: What steps could John take to create a cohesive team and overcome the conflicts arising…
A: A merger is a corporate strategy where two or more companies combine their businesses into a single…
Q: You have just been hired as the director of operations for Reid Chocolates, a purveyor of…
A: No. of trips:
Q: At what inventory level should he place an order
A: Annual Demand (D) = 5,000 bottles Cost = $ 3 Ordering Cost (O) = $ 10 Holding Cost (H) = 0.20 * 3 =…
Q: Due to population growth in the area, the new Liberty High School has just opened in a local school…
A: Formulas used- For calculation ofactivities expected time and variance-Expected…
Q: For a "Dual minimization problem" with optimal point equal to (x1 = 5, x2 = 1) and best Z = 56, its…
A: Given- Optimal point equal to (x1=5, x2=1)Z=56
Q: Nurse leaders and managers are responsible for the unit’s ethical and legal decisions.Consider the…
A: Short staffing is a situation where there are not enough staff members available to cover the…
Q: A company has a demand for 25,750 units annually. The holding cost is 33% of the item cost which is…
A: Given- Annual Demand (D) = 25,750 unitsOrdering cost (S) = $ 250Cost of each item (C) = $ 10Annual…
Q: The following tabulations are actual sales of units for six months and a starting forecast in…
A: Exponential smoothing is a forecasting model which considering the actual demand and forecasting…
Q: Billl's Ice Cream makes 4 different flavors of ice cream using their secret process and top secret…
A: Given data: Annual demand (D) =12000×4 =48000 kg/yearDaily production capacity (p) =300 kg/dayUnit…
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
- 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?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?
- 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.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.The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?
- Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.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?The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?
- The following table contains the demand from the last 10 months: a. Calculate the single exponential smoothing forecast for these data using an of .30 and an initial forecast (F1) of 31.b. Calculate the exponential smoothing with trend forecast for these data using an of.30, a of .30, an initial trend forecast (T1) of 1, and an initial exponentially smoothedforecast (F1) of 30.c. Calculate the mean absolute deviation (MAD) for each forecast. Which is best?The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 7 11 7 13 12 10 13 8 This exercise contains only parts b, c, and d. Part 2 b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Part 3 c) Using the 3-year weighted moving average with weights 0.10, 0.30, and 0.60, using 0.60 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to two decimal places). Part 4 d) Mean absolute deviation for the forecast developed…Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows: PREDICTED DEMAND Period Demand F1 F2 1 68 66 66 2 75 68 68 3 70 72 70 4 74 71 72 5 69 72 74 6 72 70 76 7 80 71 78 8 78 74 80 Click here for the Excel Data File Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 1 decimal place.) b. Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) c. In practice, either MAD or MSE would be employed to compute forecast errors. What factors might lead a manager to choose one rather than the other? d. Compute MAPE for each data set. Which forecast appears to be more accurate? (Round your intermediate calculations and final answers to 2 decimal places.)