MGMT316 Decision Modelling For Managers Assignment 1: Electronic Card Transaction Data

Published: 20 Aug, 2025
Category Assignment Subject Management
University Victoria University of Wellington (VUW) Module Title MGMT316 Decision modelling for managers
Assessment Type Assignment 1

2025 Assignment 1 40% Of Course Grade, CLOs 2, 3, 4, 6

MGMT316 Electronic Card Transaction Data

A high net-worth foreign individual is contemplating introducing a new electronic payment system in the New Zealand market.

It is the first week of August 2025. The investor is trying to understand the electronic payments situation in New Zealand.  You have recently completed your BCom at Victoria University, where you studied MGMT 316. You have met the investor at a social gathering and are keen to impress with your new knowledge. The investor is also keen to size you up for possible employment. So you have been given the attached spreadsheet, sourced from Statistics New Zealand data, giving total electronic card transaction data from October 2002 to June 2025, in millions of dollars, broken down by credit and debit card sales, and by industry sector (Consumables, Durables, Hospitality, Services, Apparel, Motor Vehicles (excluding fuel) and Non-Retail transactions (excluding services).

Part A

Prepare a summary report for the investor (one page, plus graphs and tables) explaining your assessment of the reliability of the data and the patterns you see in each of the nine time series.

Part B

In your discussions with the investor, you have learned that they are interested in the total potential electronic card sales, but especially the potential for customizing the new offering for the Consumables and Hospitality sectors. The investor has suggested you prepare a forecast for the July total card, consumables and hospitality spending using a four-period moving average and exponential smoothing (with weights (α) suggested of 0.8 and 0.4). However, you suspect this might be a test and that a regression model using seasonal dummies will yield a better forecast, at least for some of the time series. Prepare another report providing the forecasts using each method for the Total, Consumables and Hospitality sectors and explain to the manager which you would recommend, based on the strengths and weaknesses of each method.

Part C 

The investor now asks you to prepare a forecast for the three series for the next two years (July 2025 to June 2027).  Would you change the method used for the forecast used in Part B above for any of the time series? If so, why? Calculate the forecasts for the extended period and report them in a further memo to the Investor. How confident are you in the accuracy of these forecasts?

Part D

Finally, the investor asks you to explain the usefulness of ARIMA forecasting for these data. You are shown the attached plots and correlograms of the Total electronic card data and Consumables data from July 2020, and the first order 12 period seasonal differences.  Provide a brief explanation of the role of stationarity in time series forecasting, the key differences between seasonal regression-based and ARIMA forecasting, and whether (in your view) the additional effort required for ARIMA forecasting of this series is likely to be justified by providing a substantially more accurate forecast than provided in Part C for this series. (Note – you are not required to calculate the ARIMA forecasts for this part– just discuss the theoretical implications and interpretations from the plots provided).

Stuck Your MGMT316 Assignment ? Deadlines Are Near?

Hire Assignment Helper Now!

MGMT316 Assessment Rubric:

Component Evaluation components  

Marks

Available

Memo presentation Introduction

Structure, style and flow

Clarity and conciseness

Spelling, punctuation, appropriate language and grammar

Figures, graphs and tables

Correct referencing

 

 

10

Part A Appropriate graphs selected and presented

Correct identification of levels, trends, seasonality, steps etc

Identification of outliers

Other factors

 

 

15

Part B Description and justification of chosen forecasting model(s)

Correct analytical procedures followed to derive the forecasts

Discussion of strengths/limitations/accuracy of forecasts

Assumptions made explicit

30
Part C Correct analytical procedures followed to derive the forecasts

Critical evaluation of method chosen.

Assessment of accuracy.

20
Part D Discussion of stationarity and application to selected series

Critical comparison of methods (theoretical elements)

Critical comparison of methods (case context)

 

 

15

Spreadsheet modelling Face validity of models

Correctness of formulae

Clear and helpful layout/naming conventions

Explanations/documentation of formulae and calculations performed for the analysis

 

 

10

Total Score 100

Buy Answer of MGMT316 Assignment & Raise Your Grades

Order Non Plagiarized Assignment

Looking for the solution of the MGMT316 Decision modelling for managers Assignment at Victoria University of Wellington? Look no further! There are specialized professionals for all categories of assignments who offer you plagiarism-free and superior content. You are assured that our Best NZ Assignment Help service will make you productive and help you achieve high grades in your academic year. A free list of assignment samples written by PhD experts is also provided here that can help you boost your study power and check the quality of the assignment. So contact us today and get your top-notch assignment!

Workingment Unique Features

Hire Assignment Helper Today!


Latest Free Samples for University Students

MED031-6 Final Project in Mass Communications Assignment 2 Example | University of Bedfordshire

Category: Assignment

Subject: Education

University: University of Bedfordshire

Module Title: MED031-6 Final Project in Mass Communications

View Free Samples

BABM2006 Work-Based Management Project Assignment 3 Example

Category: Assignment

Subject: Management

University: De Montfort University

Module Title: BABM2006 Work-Based Management Project

View Free Samples

LAA127/LAA127C Contract Law Assignment Coursework Sample 2025

Category: Coursework Example

Subject: Law

University: Swansea University

Module Title: LAA127/LAA127C Contract Law

View Free Samples

MGT4541 Strategy, Leadership and Management of Organisations Assignment 3 Example

Category: Assignment

Subject: Management

University: Middlesex University

Module Title: MGT4541 Strategy, Leadership and Management of Organisations

View Free Samples

DGM22702 Digital Consumer Journey Project Example 2025-26 | RUL

Category: Assignment

Subject: Computer Science

University: Ravensbourne University London

Module Title: DGM22702 Digital Consumer Journey

View Free Samples
Online Assignment Help in UK