QUESTION 1The enrollment of the new students at ABC University has increased steadily over the past fewyears. The university would like to plan the workforce for academicians for year six to year eight.The reyulalury buuy, Malaysian Acuredilaliun Ayency (MQA) has set the standard of the ratiobetween academicians and student to be 1:50. The data below show the number of studentsenrolled for the past five years.YearDemand450050005200123456005800The university's administration considers using simple regression analysis to forecast the numberof students enrolled in the next three years.a) Use simple linear regression to forecast the annual number of students enroll for the next threeyears.b) Determine the correlation coefficient for the data and interpret its meaning.c) Determine the coefficient of determination for the data and interprot its moaning.d) Determine the number of academicians that can fulfill the MQA standard for year six.

Note: - Since we can answer only up to three subparts we will answer the first three subparts(a, b,…

Answered: QUESTION 1 The enrollment of the new…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Problems: 1. A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecasted to be 90 percent of capacity; actual usage was 87.6 percent of сарacity. A smoothing constant of .1 is used. a. Prepare a forecast for September. b. Assuming actual September usage of 92 percent, prepare a forecast for October usage. 2. An electrical contractor's records during the last five weeks indicate the number of job requests: Week: 3 4 30 32 28 Requests: 32 31 Predict the number of requests for week 6 using each of these methods: a. Naive. b. A four-period moving average.
Q1 LAB2 subject : production and operation management please answer ASAP
Compute for MAD, MSE and MAPE using Moving Average Model (past 3 Weeks), В. А. Exponential Smoothing Model (a = 0.2) С. What is your sales forecast for Period 8 using A and B? Period Actual Sales Forecast Error Error Error |Error %| 1 39 44 3 40 4 45 5 38 6. 43 7. 39 MAD MSE МАРЕ Compute for MAD, MSE, and MAPE using the Moving Average Model (past 3 weeks). Use two decimal places and do not put unit of measurement (UoM). (for example 35.00 or 35.40) MAD is Blank 1. MSE is Blank 2. MAPE is Blank 3%. Blank 1 Add your answer Blank 2 Add your answer Blank 3 Add your answer Compute for MAD, MSE, and MAPE using the Exponential Smoothening Model (a=0.2). Use two decimal places and do not put unit of measurement (UoM). (for example 35.00 or 35.40) MAD is Blank 1. MSE is Blank 2. MAPE is Blank 3%. Blank 1 Add your answer Blank 2 Add your answer Blank 3 Add your answer What is your sales forecast for period 8 using Moving Average Model and Exponential Smoothing Model? Use two decimal places and…
subject: Quantitative Analysis For Business Please answer both. 22. Dawn owns a dog day care company that offers kenneling services for dogs that weigh less than 30 pounds. Dawn has decided to expand the building that houses the kennels by 1,000 square feet. A friend suggested that Dawn consider three expansion options: 1) only board dogs under 30 pounds; 2) only board dogs larger than 30 pounds; or 3) split the new space, allocating 50% to dogs under 30 pounds and 50% to dogs over 30 pounds. Expansion Options Strong Economy Weak Economy Likelihood 40% Likelihood 60% Only dogs under 30 pounds $19,000 increase in revenue $18,000 increase in revenue Only large dogs $22,000 increase in revenue $15,000 increase in revenue Split the space between small and large dogs $20,000 increase in revenue $16,000 increase in revenue Based on the table shown above, which option has the highest expected value? Splitting the space between small and large…
Question 1. The dean of a school of business is forecasting total student enrollment for this year (2019)'s summer session classes based on the following historical data: YEAR TOTAL ENROLLMENT y 2,000 2,200 2,800 3,000 2015 2016 2017 2018
Problem: The data is regarding the ratings of service crews of a famous coffee shop who have been judge by the HR based on 32 variables. 1 Distant 17 Perseverant 2 Talkative 18 Friendly 3 Careless 19 Worrying 4 Hardworking 20 Responsible 5 Anxious 21 Contradictory 6 Agreeable 22 Sociable 7 Tense 23 Lazy 8 Kind 24 Cooperative 9 Opposing 25 Quiet 10 Relaxed 26 Organized 11 Disorganized 27 Critical 12 Outgoing 28 Lax 13 Approving 29 Laidback 14 Shy 30 Withdrawn 15 Disciplined 31 Give up easily 16 Harsh 32 Easy going Since correlations between many variables are high, it was felt that the HR might be confusing some of the variables, or that some variables might be redundant. Thus, a factor analysis was conducted to determine the fewer underlying factors. Tasks: Perform factor analysis and develop a tool to evaluate the…
QUESTION 1 The table below shows the sales figures for a brand of shoe over the last 12 months. Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate using MAD
1. The FedEx Company supports its global network, the company has 51 customer service call centers, whose service goal is to answer 90% of calls within 20 seconds. With million daily calls, FedEx makes extensive use of forecasting models for the number of calls, average handling time, and staffing decisions and to ensure the highest customer satisfaction. Question: Being an Operational Manager, guide with reasons for the company to use appropriate forecasting models.
Question Completion Status: Year 1 2 seconds. Tucson Macninary, Inc. manufacturers numerically controlled macnines (NCMS), which sell for an average price of $0.5 million each. Sales for these NCMS for the past two years were as follows: P Quarter 1 Quarter 2 Quarter 3 Quarter 4 12 18 26 16 16 24 28 18 What season factor would be associated with the fourth quarter? Show the formula you used and how you derived the answer. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph Arial A Moving to another question will save this response. 10pt hyji 27 描く A Bb toggle_stat... A N IQ5 0 WORDS POWERED BY TINY Question 8 of 19 > >> 1:34 PM 9/30/2022
QUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate usingMAD. b. The following table shows the number of televisions sold over the last ten years at alocal electronic store.YEAR TV SALES1 1502 3003 4804 6005 6306 6407 7008 8259 90010 980i. Using trend projection, develop a formula to predict sales for years 11 and 12. Youhave to show all working. You will need to develop a table to calculate the slope andthe intercept.…
Q/Choose a suitable question for each of the following answers. 1-Harry works for an international company in Dallas. * Where Harry is working and in which place? For what company Harry does work and where? For what and where does Harry work ? Does Harry work in an international company in Dallas?
QUESTION # 7 A small restaurant offers tacos to their patrons. One of their specialties is the Mega Taco Supreme. A weekly forecast of the demand of this special taco is to be made in order for the manager to order taco shells in time. Recently the demand has been as follows: Week Tacos Week Таcos April 6 April 13 Аpril 20 April 27 May 4 Мay 11 56 60 65 56 55 50 a. Forecast the demand for the taco for April 27 to May 18 by using the simple moving average method with n-3. Then repeat the forecast by using the weighted moving average method with n=3 and weights of 0.5, 0.3, and 0.2 with 0.5 applied to the most recent demand. b. Calculate the MAD for each method and compare.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS