My Assignment Help

BUSSB2012 Case of Sindbad Logistics for Receiving Customer Order: Research Method Assessment Answer

IN SEMESTER (INDIVIDUAL) ASSIGNMENT
Module Code: BUSS-B2012
Module Name: Research Methods, data Analytics and PP
Level: 2
Max. Marks: 100

LO Covered

  1. Design a project plan for business improvement.
  2. Execute reliable research on business processes and other phenomenon.
  3. Distinguish the different distributions in statistics.

Context of Case Study

SINDBAD Logistics is one of the reputed logistic company in Oman. When a customer submits the order list to Order Processing Department then Order Processing Department forward the order lists to material handling department. The material handling department checks the order list. If the order lists specifications are correct, then order lists will be forwarded to Purchase department and if the order lists specifications are not correct, a rejection documents will be prepared. A copy of rejection document also will be sent to material handlingdepartment and order processing department.

After receiving the order list from material handling department, the purchase department checks the availability of material for productions. If the material is available, order list will be sent to Production department for producing the items. If the materialis not available, The order list will be sent to finance department. If the finance is approved, material will be purchased and these material sent to production department for producing items. At the same time purchased materials bill document will be prepared and a copy of bill will be sent to Finance department. After receiving the order, the production department checks for the storage space availability. If the storage space is 

available, then item will be produced. If the storage space is not available, then production will be delayed and information will be sent to order processing department. After creating the additional space,item will be produced.

After producing the item, production department checks for delivery time. If the delivery time is short, item will be sent to warehousedepartment and stored in High rotation area. If the delivery time is long, then also item will be sent to warehouse department, but stored in Low rotation area. Dispatch list document will be prepared. At the same time, dispatch list also forwarded to Transportationdepartment and Order Processing Department.

On receiving the dispatch list, Transportation department checks for availability of internal transport. If internal transport is available, item will be delivered to customer. It internal transportation is not available, external transport will be hired and then item will be delivered to the customer. On delivery of items to the customer, delivery note will be prepared and copy of delivery note will also be sent to Order processing department.steps for order processing

With reference to above context

Q 1. Develop One process map and one Gantt chart for the entire processdescribed in the above mentionedcase study.                                                             

Use, only the following symbols in your process map.

Q 2. Imagine / Assume that you have visited and studiedthe market. Based on assumption, selecta company/process of your choiceand perform the following tas

  1. Write a paragraph on description about the company /process / scenario selected for thequestionnaire.
    • Alternatively you can also select one of the department and its processfrom the above mentioned case study and discuss elaborately about it.
  2. DevelopTen questions covering all the measuring areas for the selected process.(Example fueling process, shopping process, queuing process in the municipality office, ordering process in the canteen, milking cows etc.).
  • Alternatively you can also select     departments / processes in the abovementioned case studyfor designing the questionnaire.
  • The question must cover minimumone each from Nominal, Ordinal,Ratio, Interval and Dichotomous measurements.
  •  The questionnaire design must be logical, meaningful and must facilitate you to do proper data analysis.

3. Identifyand clearly mention, which types of measurements is applied to each questions.

Q 3. Develop excel tables with data (based on assumptions)for each questions. Discuss/apply/demonstrate variousStatistical Tests /Reliability Tests (minimum THREE), whichcan be applied to the questions designedin Q2(b).                             

You are required to develop a report (1200-1500 words) not exceeding 1500 words, which comprises of the answers to the above questions. The compiled report also to be includedwith introduction, conclusion and references.

Criteria

The assignment will be assessed out of 100 marks using the following criteria. The marks awarded would be then scaled to 50.

Rules & Regulations

Rules & Regulations:

All resources should be cited using CU Harvard style.

  • The final assignment must have a Title page, Table of Contents, References/ bibliography usingCU Harvard Styleand page numbers.
  • Title Page must have Assignment Name, Module name, Session, your name, ID, and the name of the faculty.

Guidelines:

  • Assignment must be computer typed.
    • Font - Times New Roman
    • Font – Style - Regular
    • Font - Size - 12
    • Heading should be with Font Size 14, Bold, Capital and Underline.
  • Explain with suitable diagrams wherever required. Diagrams must be drawn using suitable software or by pencil.
  • Each student has to do the assignment individually / Students have to do the assignment collaboratively and each student should write a brief reflection on their contribution and learnings from group work.
  • You can refer books in eLibrary or use internet resource. But you should not cut and paste materialfrom internet nor provide photocopied material from books. The assignment answersshould be in your own words after understanding the matter from the above resources.

Answer

Research Methods, Data & Analytics & PP
BUSS-B-2012

Introduction

The following pages discuss the case of an Oman-based Logistics Company called Sindbad Logistics and what process is followed from the step of receiving customer order till the delivery to customers.

Answer 1: Process MapProcess map

process for receiving customer order

Answer 2a: 

A process of ordering food from an office cafeteria is being considered. The cafeteria provides food and beverages through use of food card that can be taken by paying amount to the cashier in the cafeteria.

Once the food card has been taken, the card has unlimited validity and can be easily recharged through various methods, such as, cash to the cashier or through e-wallets or net banking. 

The cafeteria provides multiple options through various food and beverages stalls. The options include Arabian, Indian, Chinese, and Continental stalls. The customer can get the food card swiped at any of the stalls and the server will generate the waiting number for the order and provide receipt bill for the same. Once the order is ready, the waiting number will be displayed at the digital counters visible from various sitting locations. The customer can go and receive the order on showing the bill.

Once the customer is done eating, the plates will be automatically collected by the staff and washed for next use. In case of any complaints or suggestions, the customer can use the drop box available in the food court. The drop box is operated by the HR department of the company and is used for controlling vendor’s food quality, hygiene etc.

Answer 2b: 

The selected questions for measuring the above process are:

  1. Age:
  2. <25 years
  3. 25-40 years
  4. 40-60 years
  5. >60 years
  6. Gender:
  7. Male
  8. Female
  9. Annual Income:
  10. 0-50,000
  11. 50,000-70,000
  12. 70,000-100,000
  13. 100,000 and above
  14. What is the monthly frequency of using cafeteria services:
  15. 0-10 times
  16. 10-50 times
  17. 50-80 times
  18. More than 80 times
  19. What is your average monthly spending on cafeteria services:
  20. Can you rank the food in order of liking (1 being the most liked)
  21. Arabian
  22. Indian
  23. Chinese
  24. Continental
  25. On a scale of 1-5, how will you rate cafeteria’s hygiene (1 being the best and 5 being the worst):
  26. 1
  27. 2
  28. 3
  29. 4
  30. 5
  31. On a scale of 1-5, how will you rate cafeteria food and beverage selection (1 being the best and 5 being the worst):
  32. 1
  33. 2
  34. 3
  35. 4
  36. 5
  37. On a scale of 1-5, how will you rate cafeteria ambience (1 being the best and 5 being the worst):
  38. 1
  39. 2
  40. 3
  41. 4
  42. 5
  43. Any suggestions or feedback____________________________________________________

Answer 2c: 

The above questions cover different types of variables as mentioned in below table:

#QuestionVariable Type
1 Age:Ratio/Continuous
2 Gender:Nominal (Dichotomous)
3Annual   Income:Interval
4What   is the monthly frequency of using cafeteria services:Ratio
5What   is your average monthly spending on cafeteria services:Numerical
6Can   you rank the food in order of liking (1 being the most liked)Ordinal
7 On a scale of 1-5, how   will you rate cafeteria’s hygiene (1 being the best and 5 being the worst):Ordinal
8On a   scale of 1-5, how will you rate cafeteria food and beverage selection (1   being the best and 5 being the worst):Ordinal
9On a   scale of 1-5, how will you rate cafeteria ambience (1 being the best and 5   being the worst):Ordinal
10Any   suggestions or feedback____________________________________________________Qualitative

Answer 3: 

For the above questionnaire, the data has been generated using ‘RAND’ function in excel. Then, a sheet has been created ‘Frozen Data’ which has been used for analysis. The frozen data sheet is created as ‘RAND” will keep changing values every time the file is opened.

The first technique used for analysis is through graphs that reveal a lot of trend in the responses.

A stacked bar graph has been made for various ordinal variable related questions to see how respondents rank the factors, hygiene, food selection, and food quality and cafeteria ambience.Bar graph on ranking on various parameters

It can be seen that majority of people have ranked food quality as 3-5 (the lower rankings). Also, the ambience has been ranked as 4 by maximum respondents. This indicates that majority of respondents have issues with food quality as well as ambience. This can be further investigated and steps be taken to improve the same. Similarly, a lot of people have marked food selection as 4 and 5.

The cuisine preference is as follows:

cuisine preference pie-chart

Maximum respondents prefer Arabian cuisine closely followed by Chinese and Continental cuisines. 

The data analysed may indicate that food being served in cafeteria is not as per customer preference. If changed, it may lead to win-win for all as customers will get their preferred food and vendors will get higher revenue.

The second technique is testing of association between two categorical variables. The selected variables are gender and annual income and effort will be made to see if there is any relationship between the two.

Count of Annual IncomeColumn Labels



Row Labels0-50,000100,000 and above50,000-70,00070,000-100,000Grand Total
Female524415
Male243110
Grand Total767525

α = 0.05

The total sample size is 25 with two variables: gender and annual income.

The null and alternative hypothesis can be stated as:

H0: In the population, there is no association between gender and annual income.

H1: In the population, there is no association between gender and annual income.

We will use chi-squared test for association.

Expected value table is as follows:


0-50,000100,000 and   above50,000-70,00070,000-100,000
Female5 (4.2) [0.15]2 (3.60)[0.71]4 (4.20)[0.01]4 (3.00)[0.33]
Male2 (2.80)[0.23]4 (2.40)[1.07]3 (2.80)[0.01]1 (2.00)[0.5]

Chi square stat is 3.0159 and corresponding p-value is 0.389184.

At 0.05 significance level, p-value is not significant. Hence, we cannot reject the null hypothesis. We can conclude that in the population, there is no association between gender and annual income.

The third technique used is difference in means through statistical testing.

Row LabelsAverage of Monthly SpendingStdDev of Monthly SpendingCount of Monthly Spending
Female1,726.07 883.44 15.00 
Male1,345.80 878.53 10.00 
Grand Total1,573.96 883.66 25.00 
Difference380.27 4.92 

α = 0.05

The null and alternative hypothesis can be stated as:

H0: µf = µm

H1: µf ≠ µm

We will use a two-tailed test for independent samples. Hence, we will use t-test for independent means:

Pooled SD = √((nf-1)sf2+(nm-1)sm2)/ (n+ n+2) 

= √(15-1)883.442 + (10-1)878.532/(15+10+2)  

= √(10926634.93+6946275.6/27

= √661959.65

= 813.61

SE = pooled SD x √(1/nf) + (1/nm

= 813.61 x √1/15 + 1/10

= 813.61 x 0.40825

= 332.16

t-stat = (µf – µm)/SE = 380.27/332.16 = 1.1448

df = nf+ nm -2 = 15+10-2 = 23

Using T.DIST.2T (1.1448,23) = 0.264

Hence, P(t23 > 1.1448) = 0.264

At significance level of 0.05, p-value of 0.264 is greater than the significance level. Hence, we do not have significant statistical evidence to reject the null hypothesis.

Hence, we can conclude that there is no significant difference between average spending by males and females.

Customer Testimonials