BUS352 Operation Analytics Tutor Marked Assignment Questions | SUSS

Published: 22 Jul, 2025
Category Assignment Subject Business
University Singapore University of Social Science (SUSS) Module Title BUS352 Operation Analytics
Word Count 1000 Words

BUS352 Question 1

ConnectWave Technologies produces consumer routers. The company collects 72 months of cost and inventory data (January 2019 to December 2024) for analysis. The cost data are the monthly COGS (in $’000), and the inventory data are the on-hand inventory (in units) of raw materials, work-in-process, and finished goods at the end of a month. Data are included in Appendix 1.

(a) Perform data visualisation and descriptive analytics for the two variables according to the following requirements:

(i) Do you observe any specific abnormality and data integrity problems in the data set? If yes, how would you deal with these issues? Justify your measures.

Implement these measures in the data set and use the rectified data set in the subsequent analysis. (Word count: 100) (10 marks)

(ii) Select one (1) appropriate chart type to visualise and present data. Provide a brief justification of your choice. What observations and conclusions can you make from the data visualisation? (Word count: 200) (15 marks)

(iii) Produce descriptive statistics of the two variables. Provide a brief discussion of the key statistics. What can you observe and conclude from the descriptive statistics? Are these observations and conclusions consistent with those from (a)(ii)? (Word count: 200) (15 marks)

The operations manager of the company is interested in having a better understanding of the relationship between inventory management and production cost. The company’s inventory management uses a simple policy, i.e., at the beginning of every month, the procurement department will place an order to suppliers to replenish each Stock Keeping Unit (SKU). The order size will bring the on-hand inventory of that SKU to a level that is equal to the average quantity of the previous three months’ usage of that SKU in production. This way, the company aims to make the inventory level follow the production trend.

(b) Analyse and examine the relationship between COGS and inventory data according to the following requirements:

(i) Use one (1) appropriate chart type to examine the relationship between COGS and the inventory level for the same month. Provide a brief justification of your choice of the chart type. What can you observe and conclude from the chart? Note that you should NOT perform any statistical analysis for this question and only elaborate your observation on the chart. (Word count: 150) (15 marks)

(ii) Use one (1) appropriate statistical analysis tool to examine the relationship between the two variables. Present the steps of analysis and components of the tool (if any), as well as the numerical result. What can be concluded from the analysis? Is this conclusion consistent with the observations and conclusions in (b)(i)? Can the result of the analysis support the hypothesis that inventory level follows production trend? (Word count: 150) (25 marks)

(c) For the diagnostic analytics performed in (b)(i) and (b)(ii), can any improvement be made so that the result can be more plausible and insightful? You can comment on the design of the analysis. (Word count: 100) (10 marks)

(d) Reflecting on the inventory management concepts discussed in Seminar 2, what suggestions can you make to improve the company’s inventory management? (Word count: 100) (10 marks)

For the data analysis work, you are required to embed the related Microsoft Excel worksheets (not screenshots, but the *.xlsx file) at the end of the Word document as an appendix for verification purposes. Please test and make sure the embedded worksheet can be opened properly. A mark deduction penalty may be applied if the Excel worksheet is not included or cannot be opened properly.

If you want to know how to embed a file in WORD, please find the following link for helpful information:

Insert a Chart from an Excel Spreadsheet into Word

Need Plagiarism free Answers for your college/ university Assignments

Order Non-Plagiarized Assignment

Appendix 1. ConnectWave Technologies Cost and Inventory Data

Month COGS ($000) Inventory (units)
Jan-19 420 261
Feb-19 537 268
Mar-19 1599 225
Apr-19 918 208
May-19 1910 237
Jun-19 1083 176
Jul-19 1468 321
Aug-19 1568 145
Sep-19 2055 122
Oct-19 739 192
Nov-19 1199 455
Dec-19 968 299
Jan-20 540 140
Feb-20 836 401
Mar-20 1650 366
Apr-20 1853 185
May-20 988 158
Jun-20 -12 180
Jul-20 1656 208
Aug-20 1162 211
Sep-20 2090 194
Oct-20 1854 252
Nov-20 1098 142
Dec-20 689 349
Jan-21 664 128
Feb-21 832 149
Mar-21 909 169
Apr-21 905 173
May-21 1287 438
Jun-21 1941 255
Jul-21   157
Aug-21 1530 372
Sep-21 774 176
Oct-21 1510 159
Nov-21 539 144
Dec-21 586 275
Jan-22 708 112
Feb-22 382 148
Mar-22 695 127
Apr-22 1268 278
May-22 1544 212
Jun-22 1851 232
Jul-22 773 342
Aug-22 834 268
Sep-22 1275 286
Oct-22 1105 227
Nov-22 525 157
Dec-22 340 203
Jan-23 501 139
Feb-23 624  
Mar-23 1288 238
Apr-23 1329 267
May-23 1352 233
Jun-23 1153 310
Jul-23 1021 334
Aug-23 640 215
Sep-23 992 119
Oct-23 531 113
Nov-23 488 251
Dec-23 274 138
Jan-24 1031 285
Feb-24 1059 181
Mar-24 908 318
Apr-24 2473 269
May-24 1279 146
Jun-24 2196 203
Jul-24 2028 201
Aug-24 1813 292
Sep-24 1182 328
Oct-24 795 195
Nov-24 518 477
Dec-24 934 466

 

 

Get expert assignment help for BUS352 Operation Analytics! We specialise in offering high-quality Business Analytics assignment help, with an option for students to pay our experts to take on their assignment challenges. Need a reference? We also provide a free list of assignment examples to help you get started. With years of experience, our writers deliver 100% plagiarism-free content and offer unlimited revisions to meet your needs. Trust us to help you excel in your studies!

Workingment Unique Features

Hire Assignment Helper Today!


Latest Free Samples for University Students

RBP020L063H Leadership and Change Management Assignment Sample

Category: Assignment

Subject: Management

University: University of Roehampton

Module Title: RBP020L063H Leadership and Change Management

View Free Samples

HRMM080 Ethical and Responsible Leadership AS2 Reflective Portfolio Sample

Category: Assignment

Subject: Management

University: University of Northampton

Module Title: HRMM080 Ethical and Responsible Leadership

View Free Samples

ACAD1346 The child’s live Experience Developing Confidence Learners Assignment Sample

Category: Assignment

Subject: Education

University: University of Greenwich (UOG)

Module Title: ACAD1346 The child’s live Experience Developing Confidence Learners

View Free Samples

NUR7011 Developing Healthcare Leaders Assignment Sample | BPP

Category: Assignment

Subject: Nursing

University: BPP University

Module Title: NUR7011 Developing Healthcare Leaders

View Free Samples

Project Management, Leadership and Skills: Planning & Control Portfolio Example

Category: Assignment

Subject: Management

University: University of Salford Manchester

Module Title: Project Management, Leadership and Skills: Planning & Control

View Free Samples
Online Assignment Help in UK