The following data shows sales forecast of Axis Dealer for motorbikes. Month Demand 1 650 2 700 810 4 800 5 900 6. 700 7 i. What are the 3-months moving average forecasts for months 4, 5, 6 & 7? ii. What are the 3-month Wt. Moving Average (weights: 0.2, 0.3, 0.5) for months 4, 5, 6 & 7? iii. Calculate an exponential smoothing forecast for the given data with an alpha of 0.1 for months 2, 3, 4, 5, 6 & 7. Assume a forecast of 650 for month 1. Show the formula and working method.
Q: 1 Maximize z= 3x + 7y. subject to 3x – 2y 0, y > 0.
A: Given data is Decision variables: - x and y Objective function: Max Z=3x+7y Subject to constraints: ...
Q: Please try to solve in 30 minute A queueing system has an arrival rate of 45 visitors per hour (stan...
A: Given, Service rate s = 35 visitor per hour Standard deviation Ss = 20
Q: How much time will it take to process 85 loans?
A: Processing time per request: = Processing time of the bottleneck = Processing time of Worker 2 = 9 +...
Q: (d) Fit a multiple linear regression model with an interaction term to these data. (e) Estimate o an...
A: given,
Q: Week Sales 3 WMA 4 WMA 1 40 W1 0.5 2 45 W2 0.3 3 41 W3 0.2 4...
A: Mean absolute deviation(MAD) is a forecast error calculation method through which one can get an app...
Q: Compute the multifactor productivity measure for an twelve-hour day in which the usable output was 1...
A: Multifactorial productivity consider the input values in two or more forms. It identify the producti...
Q: Given the Exponential Smoothing Method, Actual Demand alpha = .25 and Forecast Demand alpha = 0.75, ...
A: The formula for forecast using the exponential smoothening method.
Q: Max Stamp approves study abroad documents for the university. Students must wait in line with their ...
A: A queuing system refers to the system that has service facility where the customers arrive for servi...
Q: Elite Distributor magazine is currently working on determining the number of publications they shoul...
A: From the question, I would determine how many magazines are to be printed before the trade show, her...
Q: Provide various reasons as to why project costs may exceed the estimate and provide an alternative s...
A: Project costs are the sum amount of all the funds that is necessary to complete a particular project...
Q: What is efficient and effective Facility Planning - Location Strategy?.
A: Facility layout is an arrangement that include different aspects of manufacturing that helps in achi...
Q: Is globalization a cure for poverty?
A: At the start of the 21st century, the world economy was estimated to be worth $60 trillion. Over 77,...
Q: c. Using simple exponential smoothing, what would your forecast be for this month if the exponential...
A:
Q: identify the advantages of a centralised and decentralised purchasing function.
A: Centralized procurement can be stated as a single department that handles or controls and manages th...
Q: In Case A, 15 products are made by spending $1000 and in Case B, 10 products are made by spending $2...
A: Productivity is the proportion between output and inputs. It identify the unit value in output for e...
Q: Describe two techniques that can be used to improve designs and optimize the reliability of products...
A: Reliability is the ability to perform consistently and trustworthily in an organization.
Q: Mathematics Apportoinment A college offers tutoring in Math, English, Chemistry, and Biology. The ...
A: Given data is Number of hires affordable = 20 Students enrolled in maths = 330 Students enrolled in ...
Q: The company L. Houts Plastics is a large manufacturer of injection- molded plastics in North Carolin...
A: Given data is
Q: The last four weekly values of sales were 120, 90, 100, 80 and 85 units. The last four forecasts for...
A:
Q: What is Facility Planning Location Strategy?.
A: Facility planning location strategy refers to a structured planning process that involves the organi...
Q: "The most improved sales figure at Commercial Dry Cleaning in 2018 in Victoria was achieved by Richa...
A: Business analytics often called BA can be stated as the set of regulations and technologies for solv...
Q: With the aid of practical examples demonstrate how qualitative, time-series, and causal forecasts ca...
A: A Small Introduction to Forecast Demand Request anticipating is the most common way of utilizing pr...
Q: Network Diagrams Exercise 1. For each task build the relevant network diagram 2. Add the task durati...
A: Critical path analysis is done to identify the path with longest duration to complete the whole proj...
Q: The XYZ Company produces small plastic toys in its Burbuli manufacturing plant. The company is curre...
A: Information given hereTotal units attempted=6000000Goods unit manufactured=4800000Processing time=80...
Q: What is the minimum number of weeks required for completing the project? What is the latest possible...
A: D(duration)=given in the question as normal time ES (Early start)= The first activity from where the...
Q: The local driver's license center processes applications for driver's license renewals through the f...
A: Here given data:
Q: What are the five risk-control measures that should be included and briefly described?
A: Risk management is a fundamental necessity of any organization or project. While the type of risks v...
Q: briefly explain the difference between planning and scheduling
A: Thorough production planning and optimum utilization of the resources are the primary goals of plann...
Q: A process that is within specifications 99.9997% of the time is called: A 2-Sigma process A 4-Sigma ...
A: Quality is the ability to manufacture the products and services as set standards and increase custom...
Q: How might the varying forms of organizational commitment become manifest in employees’ on-the-job be...
A: Organizational commitment is described as the bond or the connection that develops between the emplo...
Q: The operations manager using a combination of methods has forecast sales of Lomi Cup Orders at the l...
A: Given data is
Q: Compute the forecast sale using α = 0.20 and α = 0.35 respectively. (Note: express all answers usin...
A: Forecasting is the process of estimation in which the future demand is determined based on previous ...
Q: Investigate the approach that Cisco Systems has used in its many successful acquisitions. What are s...
A: From the given case stuyd, it is evident that Cisco has been acquiring businesses that prove to be b...
Q: 1 Given the data below. Find the forecast value from June to December Month Actual Demand Forecast J...
A: A simple moving average forecast is an average of any subset of the values in the given data set. A ...
Q: Question 2 The ISO 9000 certification process does not include: O On-site assessments O An ongoing s...
A: ISO 9000 is described as a set of global standards on the quality management & quality assurance...
Q: Nkrumah Farms encompasses 900 acres, and is planning to grow groundnut, soybeans, corn, and wheat in...
A: Part (A): Decision Variable:Suppose-G be the no. of acres of land allocated to grow groundnutS be ...
Q: QUESTION 27 Determine the value of X in the below table. Item: A Safety Stock = 20 %3! Description: ...
A: Given data is
Q: Loans are evaluated in a process with two sequential resources. The capacities of the resources are ...
A: Given, Loans are utilized in a process with two sequential resources with, Capacity C1 =0.16 loans p...
Q: Explain the difference between Leading metric and Lagging metric and which one is used for Project O...
A: The success of an organization is measured through key performance indicators, ensuring that the obj...
Q: What is Project Closure?
A: Project closure is the last phase of the project management lifecycle. In this phase, all the activi...
Q: World Foods, Inc., imports food products such as meats, cheese, and pastries to the United States fr...
A: We first tabulate the given data in a consolidated form by combining both the tables which are easy ...
Q: The quantity to be maximized, z, is the number of viewers in thousands. Let x, be the total number o...
A: x1 = Total number of minutes allotted to the senatorx2 = Total number of minutes allotted to the con...
Q: Skousen buys tennis balls at P 25 per dozen from its wholesaler. Skousen will sell 35,000 dozens of ...
A: Average number of tennis balls indicating the economic order quantity in number of balls (not in doz...
Q: Angela manages a store that sells speakers. Each Boomer takes 38 hours to create the plastic pie hou...
A:
Q: Given the Exponential Smoothing Method, Actual Demand alpha = .25 and Forecast Demand alpha = 0.75, ...
A:
Q: What role does collaborative forecasting play in a supply chain of a build to order manufacturer suc...
A: The bullwhip effect in businesses disturb the supply chain at many production and operational level...
Q: GulfOil Company (GOC) can buy two types of crude oil: light oil at $49/barrel and heavy oil $45/barr...
A: Given data is
Q: Tasty Bread Company has monthly demand for one of its products as follows: March= 520; April=490; M...
A:
Q: The Department and Board may remove a license limitation as soon as the next license cycle begins. i...
A: A person who has had a limitation placed on a license, a certificate of registration, or the renewal...
Q: What are the essential parts of a successful HIPAA Security Compliance Program?
A: Assuring that all workers have access to the organization's formal HIPAA and confidentiality, polici...
Step by step
Solved in 2 steps with 5 images
- Under what conditions might a firm use multiple forecasting methods?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?
- 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 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. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?
- 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.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?
- 1 The demand for automobiles at Crescent Auto Dealers for the past 8 weeks is as follows. Week Auto Demand Weights1 9 0.12 11 0.33 8 0.64 125 106 137 78 12a Develop a 3-week moving average forecast for Weeks 4 through 9b Develop a 3-week weighted average forecast…Sales of quilt covers at Bud Banis' department store in Carbondale over the past year are shown below. Management prepared a forecast using a combination of exponential smoothing and its collective judgment for the 4 months (March, April, May, and June): a) Compute MAD and MAPE for management's technique.b) Do management's results outperform (i.e., have smaller MAD and MAPE than) a naive forecast?c) Which forecast do you recommend, based on lower forecast error?MSE answer for part a = 5.95 is incorrect. Please do recalculations with the correct answer. also the rest of the question was not answered so here it is: Use ? = 0.2 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two decimal places.) Use ? = 0.4 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15