January February March April May June February March April May June ACTUAL FORECAST 85 100 96 a. Calculate forecasts for the remaining five months using simple exponential smoothing with a = 0.4. MAD 103 82 66 90 Forecasts 91 93 97 91 81 b. Calculate the MAD for all the forecasts, including January's. (Round your answer to 1 decimal place.)
Q: 1. How do you integrate online and social media touchpoints, customer information, and insights…
A: the steps to integrate online and social media touchpoints, customer information, and insights…
Q: 1. Estimate the daily trip production for a new zone to be developed by selecting the best multiple…
A: Go to Data > Data Analysis > Regression. The regression result: Daily trip production =…
Q: Inna is an hourly worker whose employer uses the hundredth-hour method. During a one-week period,…
A:
Q: Part 2 Given the following information for a company that wants to use Backorders: Regular Prod.…
A: Find the Given details below: Given details: Period 1 Period 2 Demand 2350 1250…
Q: 7. Component Manufacturing. Vollmer Manufacturing makes three components for sale to refrigeration…
A: Decision Variables: Suppose-A be the units of component 1 manufacturedB be the units of component…
Q: ABC company creates specialty shipping bags that they sell to pharmaceutical companies across the…
A: Given that the 10 bundles of material can produce 12000 bags.
Q: From your understanding, do MRP and Kanban work together or against each other? explain
A: Materials requirement planning can be defined as a computerized planning system that addresses the…
Q: A good or service purchased and brought in from another country. Question 11 options:…
A: Any item or service that is acquired outside of the country of origin is considered an import.…
Q: Describe a normal probability distribution that can be used to approximate the demand distribution.…
A: Expected selling price = $24 Cost = $16 Salvage value = $5
Q: Using the precedence network diagram below, create the corresponding Activity list: Start A B с E D…
A: Network diagram is a diagram that shows the visual picture of the project activities and its…
Q: How many shipping bags does ABC produce in a standard month (20 working days)? Each workday (8…
A: Productivity measures the number of outputs produced per unit of inputs used.
Q: Projects are different from operations, state any five (5) project attributes. There are four…
A: There is a wide range of project sizes, and it is essential to distinguish between regular business…
Q: Compare and contrast the distributive bargaining and integrative negotiation situation. Identify the…
A: A competitive negotiating tactic known as distributive bargaining, commonly known as declaring value…
Q: Uzbekistan sells 150,000 MWh per year of electrical power to Afghanistan at $80 per MWh, has fixed…
A: At Break-Even Point-Total Revenue = Total CostSuppose the price charged from other customer is $A…
Q: Klein Chemicals, Inc., produces a special oil-based material that is currently in short supply. Four…
A: Given data is
Q: Suppose the LCL for a control chart is 2, the UCL is 10, and the CL is 6. Which of the following…
A: Given LCL = 2 UCL = 10
Q: Least squares Regression Analysis The controller for TG Enterprises is trying to determine whether…
A: a) Let, y^ = Total cost x =Machine hours (independent variable) b0 =y intercept…
Q: study a company to understand thedetails about the culture and structure of the organization.
A: The internal communications of personnel as well as how an organization functions are both impacted…
Q: A just-in-time (JIT) inventory system appears to be an importantsuccess factor for retailers like…
A: 'JIT' is an inventory-management arrangement which intends to aid firms have just sufficient…
Q: Indicate how services differ from goods. (Note that for this question, the words generally and often…
A: All economies depend on the production and exchange of goods and services. To satisfy their…
Q: 9.15 If the annual cost of goods sold is $30,000,000 and the average inventory is $5,000,000: a.…
A: Given data: Annual cost of goods sold = $30,000,000 Average inventory = $5,000,000
Q: You have just started to work in the purchasing office of a major pharmaceutical firm. The…
A: For organizations, buyers, including purchasing agents, purchase goods and services. Buyers and…
Q: project risk management, and what are the necessary measures, and what are they
A: Managing a project is similar to solving a Rubik's cube in that you must maintain numerous aspects…
Q: Non-binding constraints have values that have not met their extreme value. O True O False
A: Non Binding Constraints: A constraint in linear programming is considered to be binding, if any…
Q: Discuss the importance of the expected benefits and risks in a Project Proposal,
A: A project proposal is a document used to brief a company's board or management team on the plan's…
Q: $7.17 Sroufe Manufacturing intends to increase capacity by overcoming a bottleneck operation by…
A: Given data is Fixed cost for proposal A = $50000 Fixed cost for proposal B = $70000 Variable cost…
Q: GameStop has maintained 75% service level for inventory of PlayStation 5. Mean demand during lead…
A: Initial Service level = 75% Mean demand during lead time = dL = 166 Std. deviation during lead time…
Q: et, timeline, and goal objectives, according to a recent IBM survey of 585 managers and developers…
A: More and more mobile applications are becoming huge successes, as we can see. More businesses that…
Q: An Soda company sells about 400 gallons of its highly demanded beverage each week. The estimated…
A: EOQ = 2DSHHolding cost = Q*H2Setup cost = D*SQTotal cost = holding cost + setup costReorder level =…
Q: Discuss the strengths and weaknesses of each of the forecasting models Naïve approach, Simple…
A: Sales, inventory levels, customer habits, and other variables may all be anticipated with the use of…
Q: When implementing a hazard control program, emphasis should be placed on what? A) the counter…
A: A hazard control program includes all measures required to safeguard employees from exposure to a…
Q: A negative value for slack indicates: the problem is feasible O the problem is infeasible there may…
A: Linear programming is a mathematical model for finding the maximum or minimum of a linear function…
Q: 13.13 The TransCanada Lumber Company and Mill processes 10,000 logs annually, operating 250 days per…
A: Optimal order quantity helps the company to minimize logistic, overhead and stockouts costs. It is…
Q: Synovec Company is growing quickly. Dividends are expected to grow at a rate of 22 percent for the…
A: Dividend: Current dividend paid = 2.35 Dividend Increase = 22% So, Year 1, Dividend = 2.35*1.22…
Q: The Montemar Company is considering contracting with a market research firm to do a survey to…
A: Find the given details below: Given details: Market Conditions Product Favorable (0.2)…
Q: Techno Corporation is currently manufacturing an item at variable costs of $5 per unit. Annual fixed…
A: The company have two kinds of costs which are fixed cost and variable cost. The fixed cost is spent…
Q: Briefly argue the need and relevance of a project quality plan, then state and justify at least…
A: Seeing to it that a project is completed on time and within its allotted budget is not quality. It's…
Q: What should be the pessimism value the company should consider if it is indifferent between pricing…
A: Maximin decision analysis is a type of decision-making that is based on the principle of maximizing…
Q: What is the impact on availability as the mean time between failures (MTTR) approaches zero? Is it…
A: Mean time between failures (MTBF) is the expected time of the arrival of a failure. If,' Failure…
Q: Our company has recently received a few customer complaints that its candles are not lasting the…
A:
Q: Design an assembly line to manufacture cupcakes from scratch. - Assume the bakery operates for 1…
A: The bakery operates for 1 eight-hour shift per day, so there are 8×60=480 minutes available for…
Q: Resistors for electronic circuits are manufactured on a high-speed automated machine. The machine is…
A: Formulae used: Number of samples (N) = 15 Size of samples (n) = 4 Range (R) = Difference between…
Q: Why do you need a good WBS to use project management software? What other types of software can you…
A: A Good WBS could help us with many opportunities, and it would come with detailing all the major…
Q: How can the most responsible financial choices be made using linear programming?
A: Linear programming is a problem solving approach developed in helping the management for making…
Q: A local bagel shop produces two products: bagels (B) and croissants (C). Each bagel requires 6…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Assuming the selling profits for products A, B and C are 2, 3 and 4€ per unit. Determine how many…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: 10.5 An SKU has an annual demand of 10,000 units, each costing $20, ordering costs are $80 per…
A: The economic order quantity is indeed the optimal order number for a business to reduce total costs…
Q: What are Scheduling Models for Projects and how are they defined
A: Project scheduling is a process which helps to identify the big picture of the project by breaking…
Q: The following activities are part of a project to be scheduled using CPM: ACTIVITY IMMEDIATE…
A: Forward Pass:Early Start (ES) = Max EF value from immediate Predecessor(s)Early Finish (EF) = ES +…
Q: 2) A service garage operates 300 days and uses 120 boxes of cleaning cloths a year. The boxes cost…
A: Given data: Annual Demand (D)= 120 boxes per year Ordering cost (Co)= RM3 Holding cost Ch 10% =…
Step by step
Solved in 2 steps with 5 images
- 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?The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?
- 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 file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. 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?Under what conditions might a firm use multiple forecasting methods?
- 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 file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?The file P13_25.xlsx contains the quarterly numbers of applications for home mortgage loans at a branch office of Northern Central Bank. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b? Is it guaranteed to produce better forecasts for the future?
- The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Create a chart of the series with the forecasts superimposed from this optimal smoothing constant. Does it make much of an improvement over the model in part b? d. Write a short report to summarize your results. Considering the chart in part c, would you say the forecasts are good?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_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? b. Repeat part a with a span of 10. c. Which of these two spans appears to be more appropriate? Justify your choice.