a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round Intermedlate calculations. Round your answers to 2 decimal places.) Month Forecast January February March April May June July August September October November December
Q: My App is a small but growing start-up that sees demand for several of its apps increasing quickly.…
A: Double exponential smoothing is a forecasting model which identify the forecasting with the…
Q: Actual 100 liters Demand NA SMA WMA ES Month 100 liters F |A – F | F |A -F| F |A – F| F |A – F|| 1…
A: USING MAD CALCULATION Suppose If we calculate moving average for the 3 month then calculations are…
Q: a) Is there a strong linear trend in sales over time? b) Fill in the table with what Bob and Sherry…
A: Using excel for performing regression with Sales as the dependent variable and period as independent…
Q: 4.2 2 3. 4 6. 7 8. 6. 10 11 YEAR 1 7 9. 9. 13 8. 12 13 6. 11 7 DEMAND a) Plot the above data on a…
A: A) On observing, it is concluded that it is a cyclic trend as the demand depicts an increase and…
Q: obtained
A: The answer to this question is true.
Q: 1. Solve manually. The following gives the number of pints of type A blood used at Woodlawn Hospital…
A: Given-
Q: Please show work
A:
Q: TWO LAST THIS YEARS AGO UNITS YEAR UNITS 3,495 2,696 3,475 2,375 YEAR UNITS I 4,785 3,475 4,195…
A: Decomposition is a determining procedure that isolates or deteriorates verifiable information into…
Q: The operations manager of a company extructed the following annual demand data from the research and…
A: Find the Given details below: Given Details: Quarters Demand 1 120 2 90 3 100 4 75 5…
Q: New Accounts Period New Accounts Period 200 6 232 11 214 248 12 3 211 250 13 4 228 253 14 235 10 267…
A: Given data is
Q: National Scan, Ic., sells radio frequency inventory tags. Monthly sales for a seven-month period…
A: Given data- Month Sales (000) units Feb 13 Mar 16 Apr 10 May 18 Jun 20 Jul 21 Aug…
Q: The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 6. 7 8 10…
A:
Q: The forecast for week 6 is ___ service calls (round to two decimals and show your work)
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Q: Consider the following actual (A,) and forecast (F,) demand levels for a commercial multiline…
A: The forecast for period 5 can be computed as follows:
Q: (i) MAD (ii) MAPD (iii) RSFE
A: AS PER THE GUIDELINES, WE ARE ONLY ALLOWED TO SOLVE FIRST THREE SUB-PARTS OF A QUESTION. SO, I AM…
Q: The Yummy Ice Cream Company uses the exponential smoothing method. Last week the forecast was…
A:
Q: The manager wants to forecast the month 6's sales using the following historical data: Months Month…
A: Forecasting is the process of estimating the future demand using the previous years information and…
Q: Use the least square method to make the forecasting table. Compute the MAE and MSE
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: The data below represents the quarterly changes in demand for a product over the next 3 months.…
A: Given data is
Q: What is an Advantage of the MAPE? a. It can be compared across different forecast items. b. It…
A: The mean absolute percentage blunder, otherwise called mean absolute percentage deviation, is a…
Q: You work for BMW as a planner. BMW is expecting to increase its annual sales for BMW- X5 in year…
A: BMW-X5 sales are increasing by 10% every quarter looking at as per the given data. let us clarify…
Q: Bradley’s Copiers sells and repairs photocopy machines.The manager needs weekly forecasts of service…
A: Given data, Week Actual Services level 1 29 2 27 3 41 4 18 5 33 Exponential…
Q: 20- Forecasting is very important in predicting the future sales of a company. Can you identify the…
A: Below is the solution;-
Q: Demand forecasting is the primary data for decision-making in any organization. a. What will happen…
A: Demand forecasting refers to a decision-making process that helps companies to predict future…
Q: The following table shows the actual demand observed over the last 11 years: Year Demand 1 2 7 10 3…
A: Forecast for Year 4 = (Sum of Demand of Year 3,Year 2, Year 1) / 3 Year 4 5 6 7 8…
Q: Explain the trade-off between responsiveness and stability in a forecasting system that uses…
A: Forecasting is the process of making assumptions of the future on the basis of past and present data…
Q: 5. Perform a least-squares regression analysis on Leslie's data. 6. Using the regression output,…
A: THE ANSWER IS AS BELOW:
Q: 2-The correlation between rate and base are called the dynamic forecast. Select one: O True O False
A: Correlation is described as the relationship that exists between two different variables…
Q: Monthly sales in a company for a seven-period (Jan-July) were as follows: 19, 18, 16, 14, 17, 19,…
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Q: The forecast for the month of November was higher than the actual demand and the forecast for the…
A:
Q: A) What makes a forecast optimal?
A: A) Practically all administrative choices depend on Forecasting. Each choice becomes functional…
Q: AD, M Moving Average Model (past 3 Weeks), A. B. Exponential Smoothing Model (a = 0.2) с. What is…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: 15) Which is not considered to be an OPSCM execution process by any of the most popular models?…
A: 15.A. ReturnsOperations and Supply Chain Management(OPSCM) is a very vast process. The process…
Q: Weekly demand for an item averaged 100 units over the past year. Actual demand forthe next eight…
A:
Q: Exponential Smoothing, Exponentially Smoothed MAD, and Tracking SignalThe XYZ Company was flooded by…
A: Formula:
Q: The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years…
A: BELOW IS THE SOLUTION TO THE QUESTION.
Q: Find the MAD and Tracking signal in below table. Do you think this forecast is acceptable? Why? How…
A: Given information- Period Actual demand Forecast 1 220 200 2 300 310 3 400 340 4 340 350…
Q: Suppose actual quarterly sales (in thousands) for Year 5 are 193, 163, 207, and 105 respectively.…
A:
Q: Sales Month (000 units) Feb. 19 Mar. 18 Apг. May 15 20 Jun. 18 Jul. 22 Aug. 20 a. Plot the monthly…
A: The known data is given below:
Q: 2. MULTIPRODUCT BREAK-EVEN ANALYSIS The finance manager of Jolimac Fastfood, Inc., wants to…
A: Given, Fixed cost = $2,850 chicken mojoy cheese burger french fries ice tea Canned tuna…
Q: a. What is your forecast for December of Year 4, making period 1 as the starting period for the…
A: a) Period Demand Square of X Multiplication of x and y, XY 1 4507 1 4507 2 4400 4 8800…
Q: 3. The following data show the number of issues from Initial Public Offerings (IPOS) from 1985…
A: To use exponential smoothing, we need to first define a formula and its variables. Our number of…
Q: a: By using linear regression method predict the future sales for the next 5 days (please do all…
A: There are four different questions, as per the guideline, I'm supposed to answer the first question.…
Q: Serena just visited a restaurant for dinner. During the dinner time, she overheard two customers…
A: It's a case where employees have leaked the confidential information unknowingly in the public. It's…
Q: There is an ongoing debate about the roles of quantitative and qualitative inputs in demand…
A: ANSWER: Quantitative techniques depends up on historical data where as qualitative focuses up on…
Q: 1. Using MAD as the criterion, which of the following models would you use for the given time series…
A: The term "forecasting" describes the process of speculating on what will occur in the future based…
Q: Distinguish between Historical Analogy and the Delphi Method forecasting and discuss a business…
A: Historical analogy - Forecast in light of examining the item life cycle and the requests of…
Q: Herman Hahn is attempting to set up an integrated forecasting and inventory controlsystem for his…
A: Time-series forecasting and seasonality factors in it:
Q: A company which installs swimming pools has recently merged with another regional installer. It is…
A: Forecasting in advance helps to estimate the sales that could be generated in the future period.…
Q: To better plan for future growth of the restaurant, Karen needs to develop a system that will enable…
A: Forecasting is a method that involves chronicled information as contributions to make informed…
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 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. 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?Question 6 of 10 Moving to another question will save this response. Question 6 The following transactions relate to the SHEHNILA CORP. for the month of November 2015: Product - A Product – B Production 10,000 units 8,000 units Beginning Inventory 1,000 units 900 units Ending Inventory 2,000 units 100 units Unit Cost applicable to inventories and Production Direct Material Rs. 4 per unit Rs. 3 per unit Direct Labour Rs. 10 per unit Rs. 20 per unit Factory Overhead Rs. 7 per unit Rs. 14 per unit Actual FOH was Rs. 182,400, under or over applied factory overhead is to be adjusted in Cost of Goods Sold. Calculate Conversion Cost.Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,240 February 4,340 March 4,040 April 4,440 May 5,040 June 4,740 July 5,340 August 4,940 September 5,440 October 5,740 November 6,335 December 6,030 a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 4 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round…
- Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…supply chain management Question number 3 Explain as to how the supply chain flows can influence the success of failure of a firm such as Colgate-Palmolive. Length of the answer: Between 225-250 wordsMarks distribution of the question is as follows: Originality: 2 Explanation of the supply chain flows: 6QUESTION 2 In the airline market, vacation-traveler customers have a more elastic demand than business-traveler customers, although the marginal cost of serving either type of customer is the same. If the airline companies engage in price discrimination, which customers end up paying a higher price? Vacation-traveler customers. Prices will be the same because the marginal costs are the same. There is not enough information to answer. We also need to know the average cost of serving each type of customer. Business-traveler customers. QUESTION 3 A seller engages in price discrimination by market segment. Morning customers have a price elasticity of demand E = -2, while evening customers have a price elasticity of demand E = -3. The MC of selling to both groups is the same and constant at $100. Therefore: morning customers will pay P=$400, while evening customers will pay $300. morning customers will pay P=$400, while evening…
- Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,220 February 4,320 March 4,020 April 4,420 May 5,020 June 4,720 July 5,320 August 4,920 September 5,420 October 5,720 November 6,320 December 6,020 Using linear regression analysis, what would you estimate demand to be for each month next year? (Round two decimal places) To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units…PROBLEM 8 Jim Huang and Roderick Wheeler were sales representatives in a computer store at a shopping mall in Arlington, Virginia, when they got the idea of going into business in the burgeoning and highly competitive microcomputer market. Jim went to Taiwan over the summer to visit relatives and made a contact with a new firm producing display monitors for microcomputers, which was looking for an East Coast distributor in America. Jim made a tentative deal with the firm to supply a maximum of 500 monitors per month and called Rod to see if he could find a building they could operate out of and some potential customers. Rod went to work. The first thing he did was send bids to several universities in Maryland, Virginia, and Pennsylvania for contracts as an authorized vendor for monitors at the schools. Next, he started looking for a facility to operate from. Jim and his operation would provide minor physical modifications to the monitors, including some labeling,…Question 2 Mike is a first year university student who is trying to understand his financial situation. Mike currently lives 1.5 miles away from campus. He works part time in a retail centre that pays him £800 per month. Mike saves £200 out of the part time job pay for his further education plan. a). As to the below Travel Expenses table published by the Students’ Union, 185 students were randomly selected to help understand the travel expenses and distance to campus. What’s the probability for Mike to spend over £10 on journeys to campus? Distance to Campus (miles) Amount spent, £ 0.1 to 0.25 0.26 to 1.0 Over 1.0 0 – 4.99 35 26 10 5.00 – 9.99 18 39 20 10.00+ 4 14 19 b). How much is the frequency for students living over 1 mile away from the campus? c). As to the category of Amount Spent, £, what is the modal group? d). Assuming Mike is saving the same amount per month in the next 3 years. How much does Mike get for his saving…