Act_4_4

Research combined with educational event at TCS Management Group New York-based TCS Management Group markets TeleCenter System, software used to forecast staffing needs for reservation centers, order centers, or customer service centers. Using TeleCenter System allows companies to have the correct number of people on duty at any given hour of the day or night, thereby optimizing the delivery of good service while holding costs as low as possible. TCS has an impressive list of customers, including American Express, British Airways, Sears, Amtrak, and Citicorp. TCS was planning a special two-day educational event, Customer-Forum, for its 300-plus customers, but was unsure how many TeleCenter System users would attend. Scheduled at the Opryland Hotel, the forum would offer speakers, workshops, and presentations. While TCS would underwrite the costs associated with planning the meeting and preparing the presentations, customers would be responsible for paying a fee to attend, as well as…

Required: Using 2-months moving average forecast sales from 5 to 11 months Using 4-months weighted moving average forecast sales from 4 to 12 months, use 3,2,1 weights with the heaviest weight applied to the most recent months. Forecast sales for January-2018 under above two method Forecast sales for January-2018 under exponential smoothing approach

A weighted moving average using wl = 0.60; w2 = 0.30 and w3 = 0.10 Calculate MAD, MSE for each method and suggest the most appropriate method. C.

A marketing analyst wants to examine the relationship between sales (in $1,000s) and advertising (in $100s) for firms in the food and beverage Industry and collects monthly data for 25 firms. He estimates the model Sales-o Advertising. The following ANOVA table shows a portion of the regression results. Regression Residual df 1 23 55 78.53 504.02 MS 78.53 21.91 T 3.58

Smith Corporation is using employee data on the length of the employee's commute to the office to forecast the impact on employee retention that a potential return to in person work at the corporate headquarters vs continuting to permit employees to work remotely.   Which type of data analytics was being used by Smith Corporation?   Question 7 options:   a)  Descriptive   b)  Diagnostic   c)  Predictive   d)  Prescriptive

A restaurant manager tracks complaints from the diner satisfaction cards that are turned in at each table. The data collected from the past​ week's diners appear in the following table.   Complaint Frequency Food taste 27 Food temperature 9 Order mistake 5 Slow service 19 ​Table/utensils dirty 47 Too expensive 9   Using a classic Pareto​ analysis, what top categories comprise​ 80% of the total​ complaints? Part 2   A. Food​ taste, Food​ temperature, Order​ mistake, Slow​ service, Too expensive   B. ​Table/utensils dirty, Food​ taste, Slow service   C. ​Table/utensils dirty   D. Food​ taste, Food​ temperature, Order​ mistake, Slow​ service, Table/utensils dirty

q10-  What is the best description of Granger-causality? Select one: a.   the ability of lags of one variable to contribute to the forecast of another variable   b. the ability of a variable to predict its own future c. the ability of the one variable to explain it own past d. None of the above Clear my choice

45 A forecasting method has produced the following over the past five months. What is the mean absolute deviation?   Actual Forecast Error |Error| 10 11 -1 1 8 10 -2 2 10 8  2 2 6 6  0 0 9 8  1 1   Select one: a. -0.2 b. 1.2 c. 8.6 d. -1.0 e. 0.0

The classified department of a monthly magazine has used a combination of quantitative and qualitative methods to forecast sales of advertising space. Results over a 20-month period are as follows: Month Error Month Error 1 —8 11 1 2 —2 12 6 3 4 13   4 7 14 4 5 9 15 1 6 5 16 —2 7 0 17 —4 8 —3 18 —8 9 -9 19 —5 10 —4 20 —1 a. Compute a tracking signal for months 11 through 20. Compute

2. The demand for hand sanitizers is off the charts due to this corona virus outbreak. People are in desperate need of hand sanitizers. Therefore, FMCGS like Unilever Bangladesh Limited is producing this life essential product in a bulk amount to help the citizens across Bangladesh to maintain the hygiene standards. Sales figures and profits for the stores are given in the following table: Unit Sales Profit (Taka) X Y 12 1000 13 1550 14 1600 15 1800 17 1900 18 2200 21 2700 25 3500

Compute the following using customer satisfaction data from the table below.2.1 Mean Squared Error (MSE)2.2 Mean Absolute Deviation (MAD) 2.3 Mean Absolute Percentage error (MAPE)

Use of Statistical Analysis Tools? explain

QUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales: Year Quarter Sales (millions of dollars) 1 1 9.2 1 2 5.4 1 3 4.3 1 4 14.1 2 1 10.3 2 2 6.4 2 3 5.4 2 4 16.0 Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.

Can you please give step by step how to do regression including the Text and charts in Excel  for the 2 problems attahced

5. The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the tractors increases with their age. The following data were collected. Age (years) 4.5 4.5 4.5 4.0 4.0 4.0 5.0 5.0 5.5 Yearly Maintenance Cost ($) 619 1,049 1,033 495 723 681 890 1,522 987 Age (years) Yearly Maintenance Cost ($) 5.0 0.5 0.5 6.0 6.0 1.0 1.0 1.0 1,194 163 182 764 1,373 978 466 549 a. Use linear regression model to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor (use Excel) b. If a section has a three-year old tractor, what is the forecast for the annual maintenance cost?

Question 3 An organization uses a business intelligence system to predict products that tend to be purchased together. This is an example of. O A) Regression Analysis B) Cluster Analysis C) REM Analysis D) Market Basket Analysis

Question 4.1  A-C

Question 21 The quality of the journal that published an article is linked to the quality of a research article, O True O False

Give typed full explanation

Describe the process of minimization with simplex method?

Subject: Qualitative research method Q#1: Identify the sampling techniques, sampling frame, and sample size in the following scenarios. a) Consider a scenario where an organization is looking to survey the performance of Internet connectivity across Pakistan. They can divide the entire country’s population into cities and select further towns with the availability of the internet. b) The working approach of top managers in an organization is quite different from that of middle managers. If there are 60% top managers and 40% middle managers in this organization, and if a total of 30 people is to be interviewed to find the answer to the research question, then 18 top managers and 12 middle managers will be chosen for the collection of data through an interview, because these numbers represent 60% and 40% of the sample size.

Apple Corporation is planning to produce their new product called the next generation low cost iPhone the said product will compete the product lines of Samsung, the management is hoping that it will further increase their revenue starting 2nd Quarter of 2018. Below is the historical data of actual sales and forecast of iPhone last 2017: Forecast Sales in Million Actual sales in Million Month Units Units Jan 51 55.3 Feb 52 54.1 Mar 53 62.3 Apr 55 61.1 May 57 58.6 June 60 59.2 July 62 67.3 Aug 65 70.2 Sep 68 75.1 Oct 69 79.2 Nov 70 80.1 Dec 75 81.2 Solve the following questions: According to operations manager the bottleneck process is tester with weekly capacity of 120,500 units and it has machine inventory of 85 testers, how many additional testers are needed to support the startup of the new product? Per feedback from accounting department the fixed cost for investing the new product is 4,500,000andvariablecostof0.75 per unit and selling price of $5 per unit, how much quantity is…

Fill in the blanks indicated by letters A through J in the image provided below.

Divvy Bikes 2021 summer ridership has increased 30% from the ridership levels in 2020.  Divvy's management attributes this to 2020 having fewer work places and recreation venues were open than in 2021.   This is an example of which type of data analytics?   Question 6 options:   a)  Descriptive   b)  Diagnostic   c)  Predictive   d)  Prescriptive

Period Actual Forecast Error Abs Error 1 35 40 -5 5 2 38 37 1 1 3 45 41 4 4 4 39 43 -4 4 5 44 42 2 2 6 49 45 4 4 7 46 48 -2 2 8 46 48 -2 2 9 52 47 5 5 10 57 52 5 5           Sum 451 443 8 34 Average 45.1 44.3 0.8 3.4   Calculate the Tracking Signal to two decimal places.

q 1  An analyst must decide between two different forecasting techniques for weekly sales of roller blades. Based on the following data, answer the below questions.   time Units sold 1 147 2 148 3 151 4 145 5 155 6 152 7 155 8 157 9 160 10 165 What's the MAD if the exponential smoothing technique with alpha 0.4 is used?