Question

In: Operations Management

Q1. Jamie wants to forecast the number of students who will enroll in operations management next...

Q1. Jamie wants to forecast the number of students who will enroll in operations management next semester in order to determine how many sections to schedule. He has accumulated the following enrollment data for the past six semesters:

SEMESTER

STUDENTS ENROLLED IN OM

1

270

2

310

3

250

4

290

5

370

6

410

a (2 pts). Compute a three-semester moving average forecast for semesters 4 through 7 (Model a) (Use two decimals).

SEMESTER

Three-semester moving average forecast for semesters 4 through 7

1

-

2

-

3

-

4

5

6

7

Solutions

Expert Solution

Solution :

Please refer the image below for the answer

If you need to find Mean Absoulte deviation (MAD)

Find errors for semester 4, 5 and 6 (Since we have forecasted data and collected data only for these three semesters)

Error semester 4= 290 - 276.66 = 13.33

Error semester 5= 370 - 283.33 = 86.66

Error semester 6= 410 - 303.33 = 106.66

Note : if any error is negative, then just ignore the negative sign and take just the positive value to find the average of all errors

MAD = average of all the errors = (13.33+86.66+106.66)/3 \

MAD = 68.88

Answer : Using three-semester moving average forecast (upto two decimal places)

SEMESTER 4 276.6667
SEMESTER 5 283.3333
SEMESTER 6 303.3333
SEMESTER 7 356.6667

keosha answered 2 months ago
Next > < Previous

Related Solutions

Q1. In a class of 50 students, the number of students who offer Accounting is twice...
Q1. In a class of 50 students, the number of students who offer Accounting is twice as the number who offer Economics. 10 students offer neither of the two students and 5 student offer both subjects. i.) Illustrate the information on a Venn diagram. ii.) How many students offer Accounting? iii.) How many students offer only one subjects? Q2. In a class of 60 students, the number of students who passed Biology is 6 more than the number who passed...
Kitty Company is planning its operations for next year, and the CEO wants you to forecast...
Kitty Company is planning its operations for next year, and the CEO wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Last year's sales = S0 $200,000 Last year's accounts payable $50,000 Sales growth rate = g 40% Last year's notes payable $15,000 Last year's total assets = A0* $127,500 Last year's accruals $20,000 Last year's profit...
Kitty Company is planning its operations for next year, and the CEO wants you to forecast...
Kitty Company is planning its operations for next year, and the CEO wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Last year's sales = S0 $200,000 Last year's accounts payable $50,000 Sales growth rate = g 40% Last year's notes payable $15,000 Last year's total assets = A0* $127,500 Last year's accruals $20,000 Last year's profit...
​75% of students who enroll in summer school only take one class. We believe the proportion...
​75% of students who enroll in summer school only take one class. We believe the proportion may be different. Use alpha​ = 0.02, beta​ = 0.02 and the maximum allowable error of 0.05 to find the sample size for a hypothesis test. A. 1339 B. 1507 C. 1258 D. 1170
Garret is initiating planning for the company's operations nextyear, and he wants you to forecast...
Garret is initiating planning for the company's operations next year, and he wants you to forecast the firm's additional funds needed (AFN). The firm is operating at full capacity. Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Dollars are in millions.Last year's sales = $250Sales growth rate = 28%Last year's total assets = $450Last year's profit margin = 4%Last year's accounts payable = $30Last year's notes...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast the firm's additional funds needed (AFN). Data for use in the forecast are shown below. Based on the AFN equation, by how much would the AFN for the coming year change (indicate an increase or a decrease in AFN) if Safelight increased the dividend payout ratio from 20% to 25% and net profit margin decreased from 20% to 15%? All dollars are in millions....
Safelight is planning its operations for the coming year, and the CFO wants you to forecast...
Safelight is planning its operations for the coming year, and the CFO wants you to forecast the firm's additional funds needed (AFN). Data for use in the forecast are shown below. Based on the AFN equation, by how much would the AFN for the coming year change (indicate an increase or a decrease in AFN) if Safelight increased the dividend payout ratio from 20% to 25% and net profit margin decreased from 20% to 15%? All dollars are in millions....
3. The management of Alberta Eleven Company has received the following forecast for the next year....
3. The management of Alberta Eleven Company has received the following forecast for the next year. Sales Revenue $600,000 Fixed Costs $275,000 Variable Costs $270,000 Total Costs $545,000 Net Income $ 55,000 Capacity is a sales volume of $800,000. a) Compute the contribution margin and the contribution rate. b) Compute the break-even point (i) in dollars (ii) as a percent of capacity. c) Determine the break-even volume in dollars if fixed costs are increased by $40,000, while variable costs are...
PROBLEM 1: Felix Company wants to forecast its cash budget for the next 3 months. *...
PROBLEM 1: Felix Company wants to forecast its cash budget for the next 3 months. * Estimated sales revenues are: Month Revenue January $        200,000 February $        150,000 March $        300,000 April $        400,000 All sales are on credit and are estimated to be paid as follows: Month of Sale 60% Month after sale 40% 100% * Cost of goods sold as a percentage of sales is 75% * Payments for merchandise sold are made in the month following the...
11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next...
11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table summarizes the number of new cars sold during each of the past 12 weeks: (PLEASE ANSWER BY USING EXCEL) week number sold 1 22 2 26 3 23 4 27 5 21 6 25 7 28 8 26 9 29 10 29 11 27 12 31 (a) Provide a forecast by using a 3-week weighted moving average technique with weights...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT