Business Report: Data Analysis and Project Planning for Syngenta

This report presents a comprehensive analysis of Syngenta's business decision-making processes, focusing on the potential launch of the Amistar fungicide in India. It begins with a detailed plan for collecting primary and secondary data, including a pest analysis of India and a market survey questionnaire. The report then delves into statistical analysis, calculating and interpreting mean, mode, median, standard deviation, range, quartiles, percentiles, and correlation coefficients to understand Syngenta's financial performance and market dynamics. Furthermore, it includes the development of graphs for data visualization and trend analysis. The report also covers project management aspects, such as the creation of a Gantt chart, network diagram, and the application of investment appraisal techniques to support decision-making. The conclusion summarizes the findings and recommendations for Syngenta's business strategy.

BDM

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Plan for the collection of primary and secondary data for a given business problem............1
Survey methodology and sampling frame..............................................................................3
Market survey questionnaire (Customers of Syngenta).......................................................3
TASK 2............................................................................................................................................5
Calculation and importance of mean, mode and median.......................................................5
Computing and analyzing the benefits of standard deviations and range in Syngenta..........7
Use of quartile, percentile and correlation coefficient to Syngenta.......................................7
TASK 3............................................................................................................................................9
Development of graphs by using spread sheets and drawing conclusion based upon it........9
Stating the trend line which can be used for projecting the growth of sales and profit.......11
Power point presentation using suitable software................................................................12
TASK 4..........................................................................................................................................12
{D1}Preparing the Gantt chart and stating the importance of using of project management12
Preparation of network diagram for the activity stating critical path...................................15
{D3}Suitable decision taken by using investment appraisal techniques.............................16
CONCLUSION..............................................................................................................................18
REFERENCES..............................................................................................................................19

INTRODUCTION
Business decision making is a cognitive process of selecting the best alternative out of
several number of alternatives available (Anderson and et.al., 2015). In other words, it can be
said that business decision making is the process of maintaining the balance between all the
activities that take place within the organization in order to achieve the desired objectives of
business. This report is based on the case scenario of Syngenta, which is one of the leading
companies and headquartered in Basel, Switzerland. Company is operating its business in over
90 countries in which more than 28000 employees are working. It aims is to bring “plant
potential to the customer’s life.”
In the following report, research has been conducted by using primary and secondary
sources of data in order to understand and analyse the market structure of Syngenta. Data
collected by using primary and secondary sources have been used to draw various conclusion
out of it. In addition to this, business presentation has been equipped by using different
techniques and software with an aim to propagate information collected in an effective manner.
At the end of this report, project plan for business activities has been interpreted in order to
ascertain the critical path.
TASK 1
Plan for the collection of primary and secondary data for a given business problem
As per the case of study of Syngenta, it has been found that company is planning to
launch Amistar which is a fungicide product. Business can launch its product in India where
large numbers of people are indulged in agricultural business (Badran, Bin-Jaza and Sharshar,
2016). Thus, in order to protect their crops, they require fungicides. Moving toward India can
lead Syngenta towards the growth and success of product. In regard to which, some of the
primary and secondary data collected are listed below.
Pest analysis of India
Pest analysis is an analysis which is done in order to examine the political, economic,
social and technological factors that are present in the environment.
Political: - Number of rules and regulations imposed by government of India put a high
pressure on the new firms to enter. Thus, in order to enter in this market, a complete
understanding of political factors is very important.

Economic: - Inflation rate, gross domestic product and foreign exchange rate have high
impact on the entry of firms. The developing country like India has a strong political economy in
place which is a good sign for the entry of new company.
Social: - Social factor of India is relatively good. These factors play a major role in
shaping the market for any type of industry.
Technological: - Reach of internet in India is very less as compared to countries like UK
and US. Thus, if Syngenta wants to start business online then it can create a problem; however, if
they start their business without using these kinds of technologies then they can easily flourish.
Primary data & Secondary data
Primary data is the data collected by the researcher for the first time by conducting
survey. In order to conduct survey in a healthy manner, questionnaire can be prepared with an
aim to analyse the view points of people and collect various information accordingly. In order to
expand its business plan, Syngenta can move with this method (Bai, Dhavale and Sarkis, 2016).
Survey will also help Syngenta to analyse the area where sales of its new products can be
increased. This can be done by considering various segments.
2

Secondary data is the data that has been collected by another researcher in the past.
Secondary data can be collected through website, books, Journals and newspapers (Champathed
and Chansa-ngavej, 2015). By using these sources, researcher can collect various data which is
highly related to the success of fungicides. Thus, by using both these methods, Syngenta will be
able to collect complete information about the future growth and success of product.
Survey methodology and sampling frame
Survey methodology
Concept of survey methodology has been used to collect various data through primary
source. In lieu of which questionnaire has been prepared by the researcher in order to anticipate
the view point of customers related to the fungicides products (Cohen and et.al., 2013). In
addition to this, Syngenta will also be able to analyze whether the launch of Amistar fungicides
in India will prove to be beneficial for company or not.
Sampling frame
A random sampling method has been taken into consideration in which 50 respondents
have been selected on the random basis (Dezső, Ross and Uribe, 2016). Along with this,
categorization has been done on random basis in order to avoid the condition of biasness.
Market survey questionnaire (Customers of Syngenta)
Name
Age
Q.1 Do you prefer to use the products manufactured by Syngenta?
 Yes
 No
Q.2 Which feature of the product attract you more?
 Quality
 Price
 Design
Q.3 Are you satisfied with the products sold out by Syngenta?
 Yes
 No
Q.4 From how long you are using Syngenta products?
3

 Less than 1 year
 1-5 years
 5 years and above
Q.5 Do you prefer to use fungicides in order to protect your crops?
 Yes
 No
Q.6 Do you think that launch of Amistar fungicides by Syngenta will be successful?
 Highly successful
 Somewhat
 No idea
Q.7 How much money do you invest on protecting crop?
 Below £10
 £10-£50
 Above £50
Q.8 According to you, Amistar will assist Syngenta in integrating Pest management system.
 Yes
 No
Q.9 At what price, Syngenta should launch its new product.
 High rate
 Affordable rate
 Low rate
Q.10 Do you prefer to use different variety of fungicides products for the protection of your
crops?
 Yes
 No
Q.11 As per your view point whether Syngenta is able to satisfy your farming needs?
 Yes
 No
Q.12 Any recommendation for company….
…........................................................................................................................................................
...................................................................................................
4

Skewness is the measure of calculating of the profitability distribution of a random
variable that is known as mean. The value of Skewness can be in both positive and negative
term, it can be undefined. Interpretation of anything by using Skewness method is very much
complicated (Li and Zhang, 2012). Positive Skewness defines that the tail is longer at the right
side and is smaller at the left hand side. If tail is longer at one size and fat at other side then in
that case, it shows Skewness is not obeying a simple rule. Similarly, negative Skewness indicates
that tail at the left side is longer and smaller at the right side. This in turn anticipates that it does
not differentiate the shapes.
Skewness= 3(Mean – Median)/ standard deviation
=3(33.07 – 30) /456.78
=9.21/456.78 = 0.020
Thus, on the basis of above calculation it can be interpreted that coefficient of Skewness
of Syngenta is 0.020
TASK 2
Calculation and importance of mean, mode and median
Statistical analysis of expense made by the company annually is as follows:
Annual Income /£m No. of Counties Mid
value
Fx Cummulative
Flow
0-10 13 5 65 13
10-20 25 15 375 38
20-30 37 25 925 75
30-40 22 35 770 97
40-50 21 45 945 118
50-60 20 55 1100 138
60-70 12 65 780 150
Total 150 4960
Mean = ∑FX/ n
=33.07
Median =L + (n/2- CF)/f*h
=30.00
5

Mode= L + h (fm-f1)/ 2*(fm-f1-f2)
=24.44
Q2=30.00
Particulars Formula Calculation
Mean Total of FX/ Total of number
of customers
= 4960/ 150
= 33.07
Median lower limit + (60- CF of
previous class
interval)/Frequency * class
interval
= 20 + (((150/2)-38)/37)*10
= 20 + (((75)-37)/37)*10
= 30
Mode L +h(fm-f1)/2*(fm-f1-f2) = 20 + (10*((37-25)/ (2*37-25-
22)))
= 24.44
Interpretation
As per the above calculation, it can be interpreted that Syngenta is required to invest
around £33.07 in order to perform all its activities and functions in an effective and efficient
manner. In addition to this, it has also been found that middle expense of about £30.00has been
invested by Syngenta on Amistar in various countries. At last, it has found that till date company
has invested £24.44 million in different countries. Therefore, by analysing the future wants, line
manager will be able to properly utilize the available financial resources in order to achieve its
targets.
Importance: - By using descriptive analysis, techniques like mean, mode and median line
manager of company will be able to take necessary decisions in order to reduce the expenses of
organization (Pozzi, Lazzarotti and Rossi, 2015).
Computing and analyzing the benefits of standard deviations and range in Syngenta
Annual
Income
No. of
Counties
Mid value X^2 F*x^2 Fx
6

/£m
0-10 13 5 25 325 65
10-20 25 15 225 5625 375
20-30 37 25 625 23125 925
30-40 22 35 1225 26950 770
40-50 21 45 2025 42525 945
50-60 20 55 3025 60500 1100
60-70 12 65 4225 50700 780
150 209750 4960
Particulars Formula Calculation
Variance s2 = ∑Fx2 – ((∑Fx) 2 /n)/ n –
1
208649.257
Standard Deviation S= √s2 456.781411
Range Highest value - lowest value 70 – 0 = 0
Standard Deviation is the tool that is used by the organization in order to examine till
what extend expenditure of company will deviate over a specific period of time. On the other
hand, range indicates the relationship between higher and lower interval value (Raju, Lonial and
Mangold, 2015). Thus, according to the above calculation it can be conclude that cost of
company will deviate till 456.78. However, range of Amistar project will be 0.
Use of quartile, percentile and correlation coefficient to Syngenta
Quartile: - Quartile is the statistical tool that is used by the organization in order to
calculate the amount of expenses made by the company during four quarter of the year
(Rodrigues and et.al., 2016). By using this tool, an enterprise will be able to develop an
evaluation for a strategies framework after the period of 3 months.
Calculation of Quartile as per the annual expenditure made by Syngenta on success of Amistar
project is as follows:-
Particulars Figure
7

Quartile 1 20.2
Quartile 2 24.44
Quartile 3 47.38
Percentiles: - It indicates the expenses that are made by company during a quarter in
form of percentage (Schwalbe, 2015).
Particulars Figure
25th Percentile 20.2
50th Percentile 24.44
75th Percentile 47.38
Correlation coefficient: - This tool help company in analyzing the relationship between
two variable. One is known as covariance and the other is known as standard deviation. These
both elements are dependent on each other (Upton and et.al., 2015). Positive correlation
coefficient anticipates that both the available variable is linked with each other in an effective
manner whereas negative correlation coefficient indicates that both are not connected properly.
This techniques is generally used by the company in order to analyses the amount of expenses
that can be incurred by the company at the time of sales and distribution.
Particular Sales Units (£’000) Profits (£’000)
Sales (Units) (£’m) 1 0.888030143
Profits (£’m) 0.888030143 1
Therefore, on the basis of the above calculation, it can be found that condition of positive
correlation coefficient arise. This in turn indicates that profit of company will move in a same
direction in which sales revenue moves.
8

TASK 3
Development of graphs by using spread sheets and drawing conclusion based upon it
Year
Sales
(£’000) Cost (£'000) Profit (£’000)
2005 270 200 70
2006 310 220 90
2007 320 220 100
2008 400 250 150
2009 380 250 130
2010 350 240 110
2011 330 220 110
2012 330 230 100
2013 340 230 110
2014 480 240 140
COLUMN GRAPH
9

BAR GRAPH
Both the graphs prepared indicates the sales and profit figures of Amistar project of
Syngenta in relation to the Japanese market. By using this method lime manager will be able to
examine the amount of sales and profit that can be generated by company after the completion of
the specific time period. In addition to this, company will also be able to calculate which action
or activities will help the company to increase its profit margin. Along with this, visual
presentation enhances more clear understanding in the mind of manager which in turn will assist
him to take correct decision. Thus, at last, it can be concluded that graphical presentation will
always help company to make a right decision.
Stating the trend line which can be used for projecting the growth of sales and profit
Trend line is the statistical and presentation tool that is used by company in order to
clearly understand the occurrence of sales and profit facet that take place within and outside the
organization (Accounting rate of return, 2016). By using the concept of trend line, company is
able to analyses the future trend and pattern of the sales made and the profit that can be generated
by the company in future. In addition to this trend line also assist the manager to develop
various strategies and policies in order to achieve the desired wants of the organization.
Year Sales (£’m) Cost (£’000) Profit (£’000)
10

2005 270 200 70
2006 310 220 90
2007 320 220 100
2008 400 250 150
2009 380 250 130
2010 350 240 110
2011 330 220 110
2012 330 230 100
2013 340 230 110
2014 480 240 140
Trend line
On the basis of above trend line, it can be examined that sales and profit margin of
Syngenta is constantly fluctuating in the Japanese market. In addition to this it is also seen that
sales and profit margin of the company is growing. This in turn shows the growth of the
company in future. Along with this it shows that gross profit and sales of the company will
increase in future time period.
But on the other hand fluctuation has been seen in income and net profit of the company.
Thus, in order to overcome this problem Syngenta should take into consideration the promotional
11

campaign methods in order to acknowledge customer more about the new product that company
is going to launch. At the same time, launch creates awareness in the mind of customers about
the benefits of the products. At last, it can be concluded that by using this trend line, company
might be able to achieve success in the Indian market while introducing Amistar fungicides.
Power point presentation using suitable software
Enclosed in ppt
TASK 4
{D1}Preparing the Gantt chart and stating the importance of using of project management
Line manager of Syngenta is making efforts to construct a new warehouse in order to
store various products. With regard to this, they have undertaken the following activities.
Activities Name of the
activities
Immediate
predecessors
Time duration Start Finish
A Lay
foundation and
building
structure
80 02/10/16 Tue 5/31/16
B Building stairs 1 30 Wed 6/1/16 Tue 7/12/16
C Building roofs 1 40 Wed 6/1/16 Tue 7/26/16
D Building
windows
1 8 Wed 6/1/16 Fri 6/10/16
E Plastering 1 70 Wed 6/1/16 Tue 9/6/16
F Carpenter
work
2,3,4,5 70 Wed 9/7/16 Tue 12/13/16
G Electrical
work
2,3,4,5 84 Wed 9/7/16 Mon 1/2/17
H Heating 2,3,4,5 70 Wed 9/7/16 Tue 12/13/16
I Plumbing 2,3,4,5 63 Wed 9/7/16 Fri 12/2/16
12

J Floor covering 6,7,8,9 28 Tue 1/3/17 Thu 2/9/17
K Decoration 6,7,8,9,10 35 Fri 2/10/17 Thu 3/30/17
Gantt chart is one of the beneficial tools that are used by company in order to find out the
start and finish time of all the activities that take place within and outside the organization. By
using this line manager of Syngenta will be able to analyse the time that will be incurred by them
while preparing a warehouse. They will easily be able to know the time that will going to take
place for the completion of the activity. Gantt chart indicates a separate bar for each and every
activity. This in turn creates deep insights in the mind of the line manager of Syngenta. A deep
knowledge about the time taken for completing the activities will help the manager to examine
the time that is going to be incurred at the time of preparing the warehouse. In addition to this
preparations of this chart will be assess the validity and reliability of the project.
Some of the benefits that can be incurred by company by using the concept of Gantt chart
are as follows:-
 Gantt chart will help the manager to easily communicate and inform its employees about
the date of start and the date of completion of activity. This in turn will prevent
confession in the mind of the workers. In addition to this company is also able to reduce
the cost of its manufacturing (Correlation coefficient, 2015).
13

 Along with this line manger will also be able to allocate the resources in a manner. This
in turn will reduce the wastage of the resources and will be able to complete the construct
of warehouse during a set time frame.
 Gantt chart also helps company to examine the extent to which the activities are
associated with the one another. This in turn will assist the organization to carry out all its
activities in an effective and efficient manner.
 In addition to this Gantt chart will also aid the line manager of Syngenta to find out the
time or activity that can be eliminated in between.
Thus, at last, it can be concluded that preparation of Gantt chart is very beneficial for the
company in order to complete is task within a set time period.
Preparation of network diagram for the activity stating critical path
Network diagram is one of the most important management tools that can be used by the
company in order to anticipate the interdependent relationship of all the activities and tasks that
are going to place within and outside the organization. Each and every box and lines made show
a relationship between each activity that company will perform. Network diagram is also known
as flow chart that provides information about the time that is taken by the firm will complete its
project.
Critical path of the construction of warehouse is as follows:-
14

Path A --1+5+7+10+11
=80+70+48+28+35
=261 days
Path B – 1+5+7+11
=80+70+48+35
=233 days
As per the above illustration, it is recommended that line manager of Syngenta should go
on with critical path B. Because while moving on path B company will be able to complete the
warehouse project within 233 days only which is less as compared to path A
{D3}Suitable decision taken by using investment appraisal techniques
Calculation of payback period
Pay back period is the method by using which company will be able to examine the time
period after which they will be able to recover the capital invested by them.
GRANGEMOUTH (IN £'000) INVERNESS (£'000)
Year Cash inflow
Cumulative cash
inflow Cash inflow
Cumulative cash
inflow
1 30 30 30 30
2 40 70 50 80
3 60 130 50 130
4 30 160 40 170
5 50 210 40 210
Payback period = A + B / C
For Grange mouth: 3 + 20 / 30
= 3+ .67
= 3.67 years
For Inverness: 3 + 20 /40
= 3 + .5
= 3.5 years
On the basis of the calculation, it can be concluded that Syngenta should move on with
the proposal that is offered by Inverness. Because it they move on with proposal offered by
15

Grange mouth than they will be able to recover their money after the completion of 3 years and 6
months. But if they go with Inverness they will be able to recover in just 3 years and 5 months.
Calculation of net present value
Net present value method is also used by the company to analyse the time period
after which they will be able to recover their money by taking into consideration
discounted rate. This is most reliable techniques as compared to other.
GRANGEMOUTH(IN £'000) INVERNESS (£'000)
Year
Net cash
inflow of ()
(1)
P.V factor
@ 10%
(3)
Discounted
cash inflow
(1*3)
Net cash
inflow of
(2)
P.V factor
@ 10%
(3)
Discounted
cash inflow
(2*3)
1 30 0.909 27.27 150 0.909 27.27
2 40 0.826 33.04 30 0.826 41.3
3 60 0.751 45.06 50 0.751 37.55
4 30 0.683 20.49 40 0.683 27.32
5 50 0.621 31.05 40 0.621 24.84
Total
discounted
cash inflow
(£'000) 156.91 158.28
Initial
investment
(£'000) 150 150
Net present
value (£'
000)
(Total
discounted
cash inflow –
initial
6.91 8.2
16

investment)
As per the above calculation, it is recommended that net present value of Inverness is
more as compared to that of Grange mouth. Thus, in respect to which Syngenta should move on
with proposal offered by Inverness because its NPV is 158.28 which is more than Grange mouth
which is only 156.91. higher NPV indicates that company will be able to earn more profit.In
addition to this it is seen that if Syngenta move on with Grange mouth than they will be earn
only £6.91 million return whereas if they move on with Inverness than they will be able to earn
£8.28 million after five years.
Calculation of Average rate of return
Grange mouth Inverness
Average accounting income 210/5 = 42 210/5 = 42
Average investment 75 75
Average rate of return (Average accounting
income/Average investment) 42/75 = .56 42/75 = .56
According to the above calculation it has been seen that Average rate of return of the proposal
offered by the both the company are equal i.e. 0.56. Thus, at last it can be concluded that
Syngenta should move on with proposal offered by Inverness in order to achieve the success.
CONCLUSION
On the basis of above report, it can be concluded that Syngenta should move to India in
order to launch its new fungicides product. Because India is a country were large number of
population is indulge in agriculture sector. In addition to it can be concluded that by preparing
various charts and trend lines, company will be able to anticipate its future sales and profit. With
regard to this, it is seen that sales and profit margin of company is constantly fluctuating. Thus,
in order to overcome this problem Syngenta should make efforts to modify its existing policy. It
is also interpreted that in order to complete the warehouse project Syngenta should choose
critical path B. Therefore, at last it is concluded that in order to earn more return on the
investment made Syngenta should move on with proposal that is offered by Inverness against the
proposal offered by Grange mouth.
17

REFERENCES
Books and Journals
Anderson, D. and et.al., 2015. An introduction to management science: quantitative approaches
to decision making. Cengage Learning.
Badran, H. M., Bin-Jaza, A. A. and Sharshar, T., 2016. Multivariate Statistical Analysis of High
Background Radiation Area on the Hadhramout Coast.Arabian Journal for Science and
Engineering. 41(1). pp.311-323.
Bai, C., Dhavale, D. and Sarkis, J., 2016. Complex investment decisions using rough set and
fuzzy c-means: An example of investment in green supply chains. European Journal of
Operational Research. 248(2). pp. 507-521.
Champathed, K. and Chansa-ngavej, C., 2015. Capital Budgeting Practice of Thai Firms.
Information Management and Business Review. 7(1). pp.59.
Cohen, J. and et.al., 2013. Applied multiple regression/correlation analysis for the behavioral
sciences. Routledge.
Dezső, C. L., Ross, D. G. and Uribe, J., 2016. Is there an implicit quota on women in top
management? A large‐sample statistical analysis. Strategic Management Journal. 37(1).
pp.98-115.
Li, Z. X. and Zhang, L. L., 2012. A Study on Multi-Project Management Based on Gantt Chart
and Network Planning Technique. In Applied Mechanics and Materials. 174. pp. 2854-
2860.
Pozzi, R., Noè, C., Lazzarotti, V. and Rossi, T., 2015. Using simulation for reliable investment
appraisal: evidence from a case study. International Journal of Operational Research.
23(1). pp. 45-62.
Raju, P. S., Lonial, S. C. and Mangold, W. G., 2015. Subjective, Objective, and Experience-
Based Knowledge: A Comparison in the Decision-Making Context. In Proceedings of the
1993 Academy of Marketing Science (AMS) Annual Conference. Springer International
Publishing.
Rodrigues, T. P. and et.al., 2016. Quality index method (QIM) and quantitative descriptive
analysis (QDA) of Nile tilapia (Oreochromisniloticus) quality indices. African Journal of
Agricultural Research. 11(3). pp.209-216.
Schwalbe, K., 2015. Information technology project management. Cengage Learning.
Upton, J. and et.al., 2015. Investment appraisal of technology innovations on dairy farm
electricity consumption. Journal of dairy science. 98(2). pp. 898-909.
Online
18

Accounting rate of return. 2016. [Online]. Available through:
<http://accountingexplained.com/managerial/capital-budgeting/arr>. [Accessed on 20th
February 2016]
Correlation coefficient. 2015. [Online]. Available through:
<http://whatis.techtarget.com/definition/correlation-coefficient>. [Accessed on 20th
February 2016].
19