The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts for the period indicated and error calculations. 155, 145, 155, 162, 180, 165, 172, 149, 170, 172 Exponential smoothing. Use Excel Solver to determine the optimum alpha value to minimize MSE and answer: What is the Mean Absolute Percentage Error (MAPE)?
Q: B). As an inventory manager, you must decide on the order quantity for an item. Its annual demand is…
A: Given data: Quantity Price per Unit 1 - 100 $5.65 101 - 350 $4.95 351 or more $4.55 The…
Q: Define the terms supply chain and supply chain management, and discuss the benefits of supply chain…
A: Definitions Supply chain: - The process chain from sourcing raw materials from suppliers to…
Q: Inside an organization, enterprise resource planning (ERP) is related to: a. Manufacturing only.…
A: Operations management is described as a business and administrative practice that allow a business…
Q: Inventory items that belong in the A category include ________.
A: The ABC analysis is the technique of inventory management that is used to identify the value of…
Q: Explain the statement. Manufacturers locate near their resources, retailers locate near their…
A: Proximity to the market stay as an important criterion in selecting a particular location for the…
Q: Problem 3: A clothing manufacturer produces women's clothes at four locations in Hongkong. Relative…
A: Note: - Since the exact question that has to be answered is not specified we will answer the first…
Q: What is the role of quality unit in a pharmaceutical industry? Explain the quality systems? Please…
A: Quality unit:- An organisational unit that handles both Quality Assurance and Quality Control duties…
Q: Howard Weiss, Inc., is considering building a sensitive new radiation scanning device. His managers…
A: Probability = 0.40 Expected profit without suit = $40000 Expected profit with suit =$ 20000…
Q: d. Use the longest work element decision rule to balance the line and calculate the efficiency of…
A: Line balancing is the process of allocating the right tasks to the right station based on the…
Q: take a look at some of the products that are offered for sale there. What are some of the logistical…
A: In contrast to Amazon, which is largely a shop, Alibaba is a platform that connects buyers and…
Q: Howard Weiss, Inc., is considering building a sensitive new radiation scanning device. His managers…
A:
Q: The LP model and output below represent a problem whose solution will tell a specialty retailer how…
A: In the question, I have been given the LP formulation data, here, the objective function would be…
Q: market for steal. The result will be that the domestic price of steel and imports of foreign-made…
A: Ans) As the government has imposed the quota on imports of foreign made Steel. This means supply of…
Q: True or False? The average number of customers in queue plus the number of servers equals the…
A: “Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: Using the four (4) main costs of quality, re-arrange the following costs of Allison’s Company in the…
A: 1. Prevention Costs – costs from preventive actions to minimize the defects 2. Appraisal…
Q: What is a plan that can be put in order?
A: Enterprise resource planning often called ERP systems is nothing but the approach used by…
Q: Exactly how does Microsoft Office vary from ERP? How do you think it would work if implemented…
A: Microsoft Office and ERP are both computer applications that are designed to make business tasks…
Q: QUESTION 2 a. A manufacturing company Glass Items Manufacturing Limited (GIM), operating under a…
A: Given, Average weekly demand, AVG =150 units standard deviation, STD =30 units Lead time, L= 7 weeks…
Q: 2. Observe your environment for an hour. Make a list of mass communication messages you observe for…
A: Mass communication can be stated as the act of an individual, a group of individuals, and a company…
Q: At the stadium, there are seven lines for arriving customers, each staffed by a single worker. The…
A: m = number of servers or service lines
Q: In a business setting, what exactly does "control" mean?
A: Business management generally focuses on arranging or organizing the resources of an organization…
Q: please answer in 30 mins. answer only if 100% sure.
A: Given data
Q: Rick Wing has a repetitive manufacturing plant producing automobile steering wheels. Use the…
A: Number of days(N) = 305 Setup labor cost = 60 Annual holding cost(H) = 19 Production(p) = 1040…
Q: The principal goal of inventory management systems is to balance the costs of ordering, shipping,…
A: Inventory is a term that defines the raw materials, and parts that are used by a company for selling…
Q: Subject: Logistic Management Q#6) What is Porters Power Model explain with example?
A: There are two different questions, as per the guideline, the first question is taken to answer, The…
Q: mpetative advantage using Porter's Generic Strategy and Value Chain Analysis . Designate Appropriate…
A: The value chain model, developed by Harvard Business School professor Michael Porter in 1985,…
Q: how did you get the answers to the optimal production schedule.
A: Here I have provided the same answer in a different format for your better understanding. Given…
Q: 1. The levitate is a carpet making firm. They make sure all the goods are of very good quality. In…
A: Queuing theory is the analysis of the activity of people, things, or information via a line.…
Q: Recognizing today's endless globalization and internalization, companies are required to improve…
A: Processes through which the demands of the customer are met remain of critical importance to any…
Q: please answer ASAP Table 1 Activity Immediate Predecessor Time (day) ES EF LS LF A - 2…
A: A network diagram is a visual representation of a project which helps to identify the activity…
Q: 1. b. The Eastern Solutions Company Limited (ESCL) has tendered for, and won a contract to design…
A: Given- Activity description-
Q: Problem 7-13 (Algo) Owen Conner works part-time packaging software for a local distribution company…
A: The Breakeven Point is that level of sales at which there is no profit no loss. In other words it is…
Q: The element that differentiates between one-way communication and two-ways communication is? A.…
A: Communication in simple terms is the transfer of information or data between two or more people. It…
Q: Case 6: Direction for Some, Support for Others Daniel Shivitz is the manager of a small business…
A: The foundation of goal-path theory is the idea that a leader's actions have an effect on the…
Q: Use 'Transportation Problem' to solve the above problems using MS Excel Solver.
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: Explain the objectives of internship 2. Explain the objectives of internship report.
A: An internship can be stated as the time period of work experience provided by a company for some…
Q: Examine why project scope creep can yield a positive impact on a project
A: Scope creep is described as the alteration in the outcome of a project and it includes additional…
Q: Customers arrive at the company's service office at an average of one every 20 minutes. Their…
A: Given, Arrival rate,λ =60÷20 = 3 per hour Service rate, μ =60÷15 =4 per hour 1. Average time that…
Q: b. The average daily demand for watermelons from Trinbago Super Farmers Limited (TSFL) is 90 units,…
A: Given data: Average daily demand (d) = 90 units Standard deviation = 10 units Review period = 28…
Q: Describe three situations in which a purchaser might select a supplier that is having financial…
A: Supplier:- An entity that offers goods or services to another entity is known as a supplier. One…
Q: Define and explain Responsible Production and Responsible Consumption in SDG 12
A: SDG 12:- One of the 17 Sustainable Development Goals created by the United Nations in 2015 is…
Q: A supply chain strategy involves decisions on all of the following except: ( )Inventory; (…
A: SCM is a strategic approach to integrating supply and demand in the market. It involves several…
Q: Explain in depth the conflicting issue associated with the use of all revenue generation models and…
A: Ecommerce is a platform that has gained a lot of popularity in recent years. Today, it has become…
Q: Consider a firm planning to start a new venture of manufacturing area. Discuss the points for…
A: Here, as per the question, a firm is planning to start a new venture in the manufacturing area or…
Q: Nokia has recently launched a newer model in the market. Loyal customers were excited to hear about…
A: There are two different questions, as per the guideline, the first question should be attempted…
Q: Challenge Tasks and Answers After you complete the Practice tasks, you learn about new developments…
A: PERT chart, is a project management mechanism that is utilized to schedule, manage & coordinate…
Q: Analytics Solution Implementation Process Flow: Identify Risks and Contingencies Identify Business…
A: Here are the following matches provided for every part given in the question: Identify risks and…
Q: Statement of work
A: A statement of work is a document that contains fundamental information about a project such as the…
Q: A manufacturer of household kettles subjected 50 kettles to 10 000 hours of testing. Test results…
A: Given data 2 failures at 3600 hours 2 failures at 4800 hours 1 failure at 8600 hours 2 failures…
Q: a) Table 2a below illustrates the tasks to be performed for the delivery of a new software package.…
A: Note: - Since we can answer only up to three subparts we will answer the first three subparts(i,…
The number of cans of soft drinks sold in a machine each week is recorded below. Develop
155, 145, 155, 162, 180, 165, 172, 149, 170, 172
Exponential smoothing. Use Excel Solver to determine the optimum alpha value to minimize MSE and answer:
What is the Mean Absolute Percentage Error (MAPE)?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 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?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.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 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 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 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_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?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?
- A small computer chip manufacturer wants to forecast monthly ozperating costs as a function of the number of units produced during a month. The company has collected the 16 months of data in the file P13_34.xlsx. a. Determine an equation that can be used to predict monthly production costs from units produced. Are there any outliers? b. How could the regression line obtained in part a be used to determine whether the company was efficient or inefficient during any particular month?The management of a technology company is trying to determine the variable that best explains the variation of employee salaries using a sample of 52 full-time employees; see the file P13_08.xlsx. Estimate simple linear regression equations to identify which of the following has the strongest linear relationship with annual salary: the employees gender, age, number of years of relevant work experience prior to employment at the company, number of years of employment at the company, or number of years of post secondary education. Provide support for your conclusion.Under what conditions might a firm use multiple forecasting methods?