The table below shows the sale of model of air conditioner( in thousands) from 2017-2021: Year Sales 2017 8 2018 15 2019 18 2020 25 2021 20 Find the equation of the trend line and use it to forecast the sales for 2022 and 2023
Q: Formulate this as an LP problem to minimize the cost of the dog food. How many pounds of beef and gr...
A: This is linear programming problem, I would formulate this problem, here, we would focus on minimizi...
Q: Why is it so critical to avoid data-entry mistakes on an e-commerce website?
A: Data entry nowadays has become a significant sep in order to streamline databases, however, errors i...
Q: Decide on Menu Hre Caterer Decide on Event Detal A 15 4. Decide on Date Send Out Invites Hold Event ...
A: ES = maximum (EF of all immediate predecessor) EF = ES + duration Minimum project duration = largest...
Q: SAQ 3: For the present, construct the appropriate network diagram representing this data. Include "S...
A: Network diagrams are of two types: AOA and AON. These diagrams are used to find the shortest or long...
Q: d) Calculate the expected value of perfect information (EVPI)- the most that should be paid CWD for ...
A:
Q: CANON produces printers for sale in northern Europe in its Taiwan factory. Printers sold in differen...
A: Given, Country Mean Weekly Demand Standard Deviation Germany 3,000 2,000 Norway ...
Q: The arrival rate of patients at a hospital counter follows Poisson distribution with a mean of 25 pe...
A: Probability of having 0 patients in the system indicating that the number of customers as 0 and the ...
Q: Decide whether the following topics or research questions is qualitative or quantitative. Explain wh...
A: Quantitative research is a type of research that makes use of the numerical data in order to conduct...
Q: I want an example of a work breakdown structure related to petroleum or drilling, if possible please...
A: The Cost Estimate Model will be developed from the WBS and give the configuration and structure to t...
Q: QUESTION 9 Using a Simplex table, in order to reach the optimal solution for a maximization problem ...
A: A Simplex tableau is utilized to accomplish row operations on the LP model as well as to inspect a s...
Q: Can you do this short answer ? A small work team consisting of Eddie, Cyndi, Gina, Jennifer, and R...
A: Ans1 Ralph and Eddie both energized the gathering by managing the negative remarks by taking care of...
Q: How can you keep track of where SKUs are at any given time? What is the difference between family gr...
A: A stock keeping unit, known as "SKU", is a scannable bar code which are seen printed on the product ...
Q: Many banks and post offices have switched from having a line at each teller or clerk to a single wai...
A: In any queueing/waiting line model, there are either one server or multiple (more than 1) servers. H...
Q: Janelle Heinke, the owners of Ha'Peppas, is consid-ering a new oven in which to bake the firm's sign...
A: Note: - Since we can answer only up to three subparts we will answer the first three subparts(a, b, ...
Q: Question 1: Мах 3X, + 4X2 s.t. X, 10 X, + X2 2 5
A:
Q: The annual demand of Bulldogs Inc. sole product totaled 450,000 units. Due to uncertainty in supply ...
A: Given- Annual Demand = 450,000 unitsMax lead time = 2 weeks and 1 day = 14 days + 1 day = 15 daysSaf...
Q: To protect themselves, restaurant owners should make their lease contingent on obtaining the necessa...
A: Obtaining licences and permissions is one of the first duties for any new business. Even an establis...
Q: iEx transports products from their three processing plants directly to three warehouses. The product...
A: Given- Cost plan-
Q: In a queueing system, customers arrive once every 6 minutes (standard deviation = 7) and services ta...
A: Given, a = 1 customer every 6 min = 1/6 s = 1 customer every 4 min = 1/4 Utilization = (1/6)/(1/4) =...
Q: Titebond blends Methanol and Toluene to produce two types of wood glues. Glue 1 must be at least 70%...
A: Here, I have considered that all glue produced could be sold, as per the question I would formulate ...
Q: Carol Cagle bas a repetitive manufacturing plantproducing trailer bitches in Arlington, Texas. The p...
A: Given data is Annual demand(D) = 31,200 units Daily demand(d) = 120 units Daily production(p) = 960 ...
Q: How do you overcome these challenges, and what lessons do you lear
A: Accurate, on-time, and on-budget project completion is essential for success. In order to achieve ex...
Q: Identify and discuss some waste in school operation like a certain university and give recommendatio...
A: The types of the wastages generated in school operations could be, 1. Food wastages 2. Plastic 3. Pa...
Q: The two main dimensions of quality are: O Ancient and modern O Aesthetic and functional O External a...
A: A quality item is an item that measures up to the assumptions of the clients. The eight components o...
Q: The XYZ Corporation has been engaged in the manufacture of electronic components for automobiles for...
A: The Human Resource manager must establish the following statements as objectives, 1. Implementatio...
Q: Give a high-level overview of project integration management.
A: Project management is the management in which different types of skills and knowledge are required t...
Q: Which of the following document best ensures that the proper quantities are reflected on supplier in...
A: Packaging slip is a document that include information like SKU numbers, weights, dimensions and numb...
Q: . CREATE THE NETWORK DIAGRAM USING AON 2. DETERMINE THE NETWORK PATHS 3. DETERMINE THE CRITICAL PA...
A: Activity-on-node is a therm related to project management. It directs to a precedence diagramming pr...
Q: Problem 2 Consider the following problem: max 2x1 + 72 + 4x3 s.t. x1 + 2x2 +x3 0. Use the dual of t...
A: given,
Q: [Ad] Suppose the cost of a full-page color ad in the U.S. national edition of The Wall Street Journa...
A: Given are the values for the cost of advertisement in different vehicle and also their audience size...
Q: Inc. expects to use 96,000 litters of paint annually costing P12 per litter. Inventory carrying cos...
A: Carrying cost is the cost incurred during the storage and managing of the inventory stock in the war...
Q: For the following problem, provide an objective in words, data definition, variable definition, and ...
A: Given data is Profit by small size soft drink = $42 Profit by medium-size soft drink = $45 Profit by...
Q: please answer quick and explain every option in details why they are wrong.
A: As per Bartleby's guidelines, I have answered the first question as multiple unrelated questions are...
Q: There are 3 servers in the checkout area. The interarrival time of customers is 2 minutes. The proce...
A: The normal circle back of giving customer service is vital to any service-situated business. Involvi...
Q: Consider the LP problem in Figure QP2.5 and refer to the Solver sensitivity report in Figure QP2.6. ...
A: Given- Sensitivity analysis report-
Q: San Angelo Manufacturing Company was concerned about a growing number of defective units being produ...
A: Trend Analysis: Trend analysis is help to identify the relationship between the give...
Q: The ELC Corporation manufactures two industrial-sized electrical devices: generators and alternators...
A: As per Bartleby's guidelines, I have Solved the first question as multiple questions are asked toget...
Q: The economic order quantity of NEKO Inc. is 1,000 unit. They sold their sole product for a selling ...
A: Cost of ordering 1000 units = 20000 Cost of ordering 1 unit, S = 20000/1000 = 20 EOQ = 10...
Q: State some of the competitive tradeoffs that may arise in a fast- food restaurant.
A: To be determined: Some of the tradeoffs that may arise in a fast-food restaurant. Introduction: Most...
Q: Widgetco manufactures widgets at two factories, one in Memphis and one in Denver. The Memphis factor...
A: The transportation problem is an exceptional sort of Linear Programming Problem (LPP) in which produ...
Q: Concerns of suppliers when moving to supplierpartnerships include:a) small lots sometimes seeming ec...
A: Suppliers need to make the largest possible margin only from what they supply and to whom they suppl...
Q: Everbright, a light bulb firm, faces both uncertain demand and supply, which can be modeled by norma...
A:
Q: The manager of a utility company in the Texas panhandle wants to develop quarterly forecasts of powe...
A: Seasonal index = season demand / average yearly demand Seasonal index when multiple periods are gi...
Q: Suds and Duds Laundry washed and pressed the following num of dress shirts per week. Week Work Crew ...
A: given,
Q: Runaway is a manufacturer of athletic shoes, bags, and sportswear in Europe. It has been maintaining...
A: A Small Introduction about Manufacturing Manufacturing is the creation or formation of a product wi...
Q: LotCode: A unique code that identifies the parking lot LotCapacity: A number with the respective par...
A:
Q: PayPal is quickly becoming one of the most popular methods of payment in E-commerce, and is availabl...
A: Paypal is a popular American company which functions all around the globe to make online payments po...
Q: The Beta II computer's electronic processing unitcontains 50 components in series. The average relia...
A: given, contains 50components reliability =99% using detail earlier provide in 17.2
Q: Discuss the three topics that should be summarized in the project management plan's work that needs ...
A: A goal, an aim, and a team make up a project management strategy. Any project needs a clear aim of w...
Q: How the concepts of quality of design and quality of compliance can be applied in the service of piz...
A: Concept Introduction Quality of Design and quality of compliance plays an important role in the serv...
The table below shows the sale of model of air conditioner( in thousands) from 2017-2021:
Year |
Sales |
2017 |
8 |
2018 |
15 |
2019 |
18 |
2020 |
25 |
2021 |
20 |
Find the equation of the trend line and use it to
Step by step
Solved in 3 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_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_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_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_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?
- Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.Management of a home appliance store wants to understand the growth pattern of the monthly sales of a new technology device over the past two years. The managers have recorded the relevant data in the file P13_05.xlsx. Have the sales of this device been growing linearly over the past 24 months? By examining the results of a linear trend line, explain why or why not.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 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.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 table below shows the sales figures for a brand of shoe over the last 12 months. Months Sales January 69 February 75 March 86 April 92 May 95 June 100 July 108 August 115 September 125 October 131 November 140 December 150 Using the following, forecast the sales for the months up to January the following year:- 1. A simple three-month moving average. 2. A three-period weighted moving average using weights of 1, 2, and 3. Assign the highest weight to the most recent data. 3. Exponential Smoothing when α= .6 and the forecast for March is 350. 4. Determine which of the three forecasting techniques is the most accurate using MAD.