Class activity Assignment Graded

Completion requirements

Opened: Tuesday, 10 February 2026, 5:29 PM

Due: Wednesday, 25 February 2026, 5:29 PM

Class Participation (CP) Assignment

Topic: Moving Average & Exponential Smoothing Forecasting

Course: Quantitative Methods

Assessment Type: Graded Class Participation

Total Marks: 5 (CP)

Instructions

• This is an individual CP assignment.
• Calculations must be shown clearly.
• Part A must be done manually.
• Part B must be done using Excel QM.
• Submit handwritten work (photo/PDF) + Excel QM output.

Question

A small UAE-based caf records the following weekly demand (cups of coffee sold):

WeekDemand11202130312541355140

Part A: Manual Calculations (3 Marks)

1. Two-Period Moving Average

• Calculate the forecast for Week 6 using a 2-period moving average.
• Show all steps clearly.

1. Exponential Smoothing

• Given:
• Initial forecast for Week 2 = 120
• Smoothing constant = 0.30
• Calculate forecasts for Week 3, Week 4, Week 5, and Week 6.
• Show all calculations step by step.

Part B: Excel QM Application (2 Marks)

Using Excel QM:

1. Enter the given demand data.
2. Generate forecasts using:

• Moving Average (n = 2)
• Exponential Smoothing ( = 0.30)

1. Attach the Excel QM output (table or screenshot).

Marking Breakdown

• Correct manual calculations & steps: 3 marks
• Correct Excel QM setup & output: 2 marks