Assignment 1 (25%) 

Instruction Sheet

This is an individual assignment, topics covering Competency 1 – Perform a Category Sales Analysis and Present Findings on Performance.  

• You are the team leader of a department in your store and have been given the company’s sales reports from the company’s system.

o Assess the performance of store sales according to the different merchandising levels; and

o Suggest recommendations based on findings developed from performance review.

• Assignment 1 is to be assessed based on:

o Apply basic data cleansing on a given data set; o Create charts using a given data set;

o Ability to use charts to identify areas of further analysis;

o Ability to identify cause of performance with appropriate use of other types of reports; and

o Ability to make recommendations to improve future performance.

Guidelines of Report Structure and Format

• Each student must submit a type-written report, which should contain:
  o Cover Page
  o Acknowledgement
  o Table of Contents
  o Introduction
  o Body of Report
  o Conclusion / Learning points
  o Referencing
• Report length
  o Maximum of 800 words, excluding cover page, acknowledgement, table of contents and referencing.
  o Cover page
  o Title of report
  o Students’ full name
  o NRIC (last 4 characters)
  o Index number
• Paper
  o Size A4
  o White colour
• Margin
  o Centered with 1 inch left and right margins
  o Top and bottom margins may be 1 inch
• Line spacing
  o 1½-spaced (for data and information)
• Font
  o Arial, Size 12
• Page number
  o Each page of text must be numbered except for the cover page and the content page.
• Report submission
  o The report shall be submitted by the due date as determined by the Lecturer assigned.

Assignment 1 – part 1 Company introduction & Compilation of Report

Due November 7, 2025 11:59 PM

Instructions

Attached please find the template for your assignment 1. You are to complete:

1. Company Introduction
   
   • Do a brief introduction of the company including the customer profile.

2. Problem Statement
   
   • Present Situation
   • What is the problem?
   • Research objectives

3. Store Sales Report
   
   • Compile the sales report
   • Verify the period of the report
   • Show evidence of data cleansing