OMGT2229: Strategic Supply Chain Assignment, RMIT, Singapore: Demand forecasting for 5 kg bag ice and inventory management of 20-roll pack of toilet paper at Caltex
| University | RMIT University (RMIT) |
Task 1: Demand forecasting for 5 kg bag ice and inventory management of 20-roll pack of toilet paper at Caltex
Description:
Demand for ice (in 5 kg bag) at Caltex – a petrol station in Melbourne – for the last five years are as follows:

Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
Task Questions to be done in Excel:
a) Estimate the demands for Quarters I, II, III, and IV in Year 6 using a 3-quarter
moving average method.
b) Estimate the demand for Quarters I, II, III, and IV in Year 6 using the static
method.
c) Evaluate the MAD, MAPE and TS (i.e., the KPIs) in each case and compare
them in the format as shown below.

d) Based on the findings from (b), which of the two methods do you prefer? Why?
(Note: You can give your answer in the table of Question (c).)
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
For Thesis Writing Service in Singapore and online assignment help, Singaporean students can rely on our expertise. Whether tackling the OMGT2229 Strategic Supply Chain Assignment at RMIT in Singapore or any other coursework, our service offers convenient assistance.
- NUR09717 Promoting Excellence in Older People’s Care Assignment Essay | Edinburgh Napier University
- 7WBS2008 Strategic Marketing Planning and Entrepreneurship Assignment CW1 | PSB Academy
- SM9689 Responsible Strategy Individual Assignment Report and Presentation September 2025
- BM9615 Project Management Assessment Individual Report | Northumbria University
- Introduction to Data Communications Assignment Case Study Individual Report | Singapore Management University
- Arts Marketing and Audience Development Assessment 2 Case Study | SMU Singapore
- NUR09718 Advancing Practice through Research Assignment | Edinburgh Napier University (ENU)
- MKTG1001 Foundations of Marketing Assignment 2 Individual Report | The University of Newcastle (UoN)
- S2010C Health and Wellness Graded Assignment AY2025 Term 4 – Republic Polytechnic (RP)
- RBP040L051 Postgraduate Dissertation Assessment brief – University of Roehampton Business School
