Data Analysis Report

This data analysis report focuses on Pecan Peanuts and the Australian Pecan Industry. It covers topics such as linear forecasting, health levels of nuts, quality assurance, costing of new machinery, hypothesis testing, customer satisfaction, and SWOT analysis. The report provides valuable insights into the industry and offers recommendations for the organization.

Data Analysis Report

Contents

INTRODUCTION
The whole study report is focused on enterprise named Pecan Peanuts that mainly
produces distinct sorts of snacking stuff manufactured from diverse nuts. This conducts out its
operations in various areas of the world and buys additives from the Australia to serve
their customers. This report takes into consideration aspects of company as well as related
factors to assess present performance in business industry. Study covers comprehensive
overview (Brar and Danyluk, 2018). Pecan industry and also the corporation, the deployment
of linear forecasting model, review of concerned health difficulties of this market and
a critical evaluation of two proposal of machinery for quality mangers. This analysis study also
analyses the estimates of new machinery's costs, evaluations of the theory, consumer experience
with both SWOT and the pros-cons analysis.
TASK 1
Overview of Australian Pecan Industry
Overview of organisation: Selected organization named Pecan Peanuts for study
purpose, is a massive entity engaged in business across different-different country-regions. Have
all merchandise which it delivers on the markets are processed through its UK-based production
facility. The best-selling and key product-items of the organization are pecans, peanuts, cashew
nuts including pistachio nuts. Corporate entity is highly focused toward attempting to address the
requirements of buyers. One of the machineries seems to be shattered much for the organization
to be apt to replace It in effort to enrich the business.
Short-overview of Australia’s Pecan Sector: Large portion Australia's pecans large
corporation is headquartered in the North New South Wales and the South East Queensland.
Here, Australia is main house with around 100 pecan farmers and more than 180,000 plant
species. Organic producers from Australian Pecan Farmers Association cultivate approximately
95% of overall nuts throughout Australia. The exports stuff from the Australia's Pecan Retail
sector between 2018 -2019 are roughly 104.5, reflecting a great increase in overall exports.
Australia exports numerous kinds of peanuts to regions of the world (All about the Australia’s
Pecan sector, 2019). Their key products comprise chestnuts, macadamias, varieties of almonds,
cashews, pistachio, pecans etc. Based on comprehensive HTW statistical analysis, there are
indeed reportedly 3000 tons of shells in the area of orchards fields wherein most pecans
1

are grown. The corporation's expansion was of great importance and aggregate demand is
projected to rise to somewhere around 9,500 tonnes in the area until 2025. The exploration of
areas that are best suited for the expansion of pecans is a vital element in the expansion of the
industry.
TASK 2
Linear forecast: Scatter diagram:
Data for export in Australia is as follows:
Scatter diagram:
Shown above diagram demonstrates that the aggregate exports figures for Australia will have
been about 25.90 in 2021 and about 28.10 in year-2022. The linear modeling theory is executed
in the spreadsheets to attempting out it. FORECAST.LINEAR is theory equation, that is
2

(Year/periods during which projections are provided, data of past years, overarching duration).
With the input of linear prediction model, enterprises can anticipate their projected sales and
anomalies. Increasing overall both the production and the profitability is valuable for production
companies. The export outputs table for the timeframe 2014-2022 is seen in the appendices
showing the expansion in demand (Cunha, Sa and Fernandes, 2018).
Year Export
2014… 11.90
2015… 11.80
2016… 15.80
2017… 15.50
2018… 20.30
2019… 19.70
2020… 25.50
2021… 25.90
2022… 28.10
With the guidance of this framework incorporated in Spreadsheets, it is being founded
that the overall export markets of peanuts will be roughly 25.90 in year 2021 and yet exports also
will be estimated 28.10 in time span 2022. This suggests that exports may expand to a noticeable
extent in the coming years.
TASK 3
Healthiness levels of Pecans, Peanuts, Cashews and Pistachio
The quality of saturated fats in differing categories of nuts, including such cashews, pistachios,
pecans, peanuts, can be seen in attached table below:
3

4

The substance of saturation fats in varied types of nuts, namely cashews, pistachios,
pecans, peanuts, might be shown in the table underneath: the graph reveals that the sum of
saturation fats in the cashews is indeed quite large compared to all other nuts, which suggests
that it may trigger several health conflicts for buyers. The higher concentration of saturated
fats accompanying cashews is already in pecan, which does have a reasonably large fraction of
saturated fats. Apart from these peanuts, like pistachio have between about 1.9 and 1.6 grammes
of saturated fats aggregately (Bolling, 2017).
As the level of overall saturated fats within cashews is very significant, it can contribute to
health dilemmas for individuals. The major health dilemma that would hinder health of people
would be overweight, which could hinder their daily lives and lead to an uptick in masses. Many
that consider fitness eat pistachio as the volume of overall saturated fats is rather low. The
saturated fats in Pistachio is really minimal relative to several other nuts, depending on the data,
and the maximum saturated fats is present in Cashews. The graph reveals that well-beings of
cashew can be weak relative to remaining nuts. While pecans, almonds, cashews, pistachio fats
Gm each pound are about 2.0, 1.9, 2.20 and 1.6 respectively.
TASK 4
Quality Assurnace
The probability rate of occurrence of company's old machine malfunction is about 0.80 percent,
and the possibilities of company's new machine malfunction are about 0.20 percent. Those same
5

results are premised on the recent analysis conducted out by the firm in attempt to ascertain the
parameters for the adjustment to the model. In comparison, the quality assurance team revealed
that functioning on one machinery would be equivalent to around 99.99 per cent.
In an exercise to calculate the quality assurance parameters, the following evaluations shall be
made in an endeavour to satisfy the study parameters:
Functional equation: probability-rate of machinery success/non-failure – probability-rate of
machine's failures.
New machine = 0.9999 less 0.20
=> 0.7999= 80%
Old equipment = 0.9999 less 0.8099
=> 0.1999 = 20%.
Contrasting study of such two machines: the accompanying figures signify that if the machinery
is updated, the likelihood of a better working standard will be about 0.79 % and, while the
machinery is not replaced, ordinary working performance of the older machine will be at 0.19
percent. The quality management unit of the organisation must buy new equipment as its
probability of a better level of production is really great. In comparison, the ratio of failure of
new machinery seems to be low compared to older ones (Dean, 2018).
TASK 5
Costing of the new machinery:
The profit balance will be gained for next 6 years (for every month) = $2,000.
Loan sum that will be lent by organization = 96000
Proportion (percentage) of interests on loan/borrowings = 9 per cent.
Annual forecast/foreseen sales = twelve months * 2000
= 24000 = 24000
Income/cashflows for the next 6 years will be as shown in:
6

Computation of the annual instalments for the loan, whether it is obtained for six years or
around 72 months, shall be carried out on the grounds of PMT equation in excel-sheet. The
calculations/computations shall be as follows:
Calculation:
It is identified that the corporation will be prepared to repay loan balance within period
of six years. It will be actively suggested that the organization can take 72 months loan as well as
construction period that would enable them to satisfy their financing conditions and enable them
to make repayments in six years. Corporation is raising capital in the remaining cycles and needs
to investment in new machine to expand its company. Investing in new machinery by borrowing
for a term of 4 years is alluring and commercially viable venture for the organization (Cheng,
2017).
TASK 6
Hypothesis testing:
In the sense of statistics, the hypothetical test is also an exercise under which the analyst
examines the samples parameter hypothesis. Using observational substantiation to verify the
effectiveness of a hypothesis. These details will emerge either from wider population or through
7

a data-producing system. There have been two alternatives accessible for the new machinery as
well as the relevant review related to below:
Requirements Machine:- A Machine:- B
Sample items 30 40
Mean value 180 grams 170 grams
Standard Deviations 40 grams 10 grams
In an effort to determine if new machinery could be employed to put same amount in
items of pecans, six-points method will be allowed to validate the theory. For this purpose, a
combination of coefficient technique will be used. The definition will be around 0.9793, which
means that the alternatives are compatible at a greater level, because the significance of the
association is very high. If this is better than about 0.70 then variables comparability will be
better and if it is lower than 0.70 then variable's reliability would be relatively lower (Morsy,
Hussein and El-Fadl, 2020).
The correlation status between two sample products comprising 30 and 40 samples is
about 0.9793, that is pretty similar to One which means that the feasibility of both samples is
very large. When person has two separate options to choose from, the study will be done among
them and relationship among themselves. With all that in mind, it could be determined
whether certain options are compatible with one another for individual. Higher mean value as
well as standard deviation type may be used by the individual where these are incompatible,
since they can show great results. Throughout the example of the Pecan Peanuts, relationship is
quite strong, which implies the longevity of the goods. Business is recommended to get through
the first alternative which is Machine A and has significantly higher mean value and S.D for
smaller sampling items (Sealey-Voyksner, Zweigenbaum and Voyksner, 2016).
TASK 7
Pros and cons analysis:
Pros Scores Cons Scores
Enhanced/increased volumes
productivity
8 Interests percent on the loan 8
Reduced timing-score of production 7 Trainings programs towards 7
8

employees/personnel
Increased/enhanced sales/revenues 8 Higher/increased overall costs of
replacements
8
Improved/strengthening
qualities/units of packing-task
7 Rivals 8
Greater profitability-index 8 Increase raw material cost 6
Producing snacking-items i.e. more
preferred in targeted-clients
8
Total scores 46 Total scores 23
Average Pros = 47 / 6 = 7.66
Average Cons = 38 / 5 = 7.4
The table described reveals that the overall pros ranking for modern equipment
acquisitions is 7.66 as well as cons are 7.4 that have been smaller than the pros. It is also advised
that the company invest on new equipment that is also beneficial for pecans peanuts. Depending
on this study, pecans would be recommended to buy new machinery that could greatly boost
overall growth, revenue, demand, production of quality goods, etc (Cetinkaya and et.al., 2020).
TASK 8
Analysis of customer satisfaction
On the context of questionnaire approach, this has been construed that most of
the individual consider pecan regardless of their health-related benefits or tastes. This is also
acknowledged that the freshness or quality of certain nuts generates a positive response from
users. In contrast, the highest number of individuals are expected to suggest pecans,
pistachios, variety cashew nuts and peanuts due to various their nutritional advantages and their
taste for recipes. There is little need for these changes, as most individuals have stated, but few
are still said to minimise the costs as well as the volume of packages so that individuals can
manage such nuts when they need them in limited amount (Dean, 2018).
TASK 9
Initial SWOT analysis:
SWOT review is a methodology of evaluation adopted by enterprises to analyse all their
core capabilities, weaknesses, prospects and challenges within sectors in order to build action
9

plan for the prospects. Pecan Peanuts is anticipated and expanded in a variety of product types,
such as Almond Treats, and Macadamia. This SWOT analysis is undertaken by the organisation
in an effort to determine the likelihood of succeeding, as stated here:
Strengths Weaknesses
• Allows to increase the total
demands of consumers and maximises
the consumer base of organisation.
• Macadamia including Almond Snacks
strive to significantly boost the net
profitability margin.
• Although the growth of the business
enterprise would have to bear very high
prices.
• By producing a fresh item, the company
would have to recruit new staff who
would be able to handle all processes in
attempt to reach better revenues. It's
supposed to be immense, though
(Atanasov and et.al., 2018).
Opportunities Threats
 Extension of product portfolio
sponsorship to reach customers who
enjoy healthier snacks.
 It delivers big progress and making it
famous among buyers.
 The intensity of competition could have
an influence on the growth of
corporations.
 As the multitude of products is widened,
the old preference of buyers would be
impacted.
CONCLUSION
It's been observed from the aforementioned analysis that chosen corporation Pecan
Peanuts is leading entity within sector and markets different varieties of nuts including such
Pecans, variety Cashews, various Peanuts and Pistachios. Entire Australia's Pecan Market has
been rising during the last couple years, response to the growth demand for pecans around the
globe. The company would procure new equipment for increased efficiency, quantity
development, etc. In comparison, production duration has also declined with the assistance of
modern machinery. Respective corporation should offer Almond Snacks in order to gain greater
market area. SWOT analyses are performed to determine the odds of progress and failures.
10

Purchasing new instead of old machinery is vital to the success of the company, but that also
serves a significant function in enhancing performance.
11

REFERENCES
Books and Journal:
Brar, P. K. and Danyluk, M. D., 2018. Nuts and grains: microbiology and preharvest
contamination risks. Preharvest Food Safety. pp.105-121.
Cunha, S. C., Sa, S. V. and Fernandes, J. O., 2018. Multiple mycotoxin analysis in nut products:
Occurrence and risk characterization. Food and Chemical Toxicology. 114. pp.260-269.
Bolling, B. W., 2017. Almond polyphenols: methods of analysis, contribution to food quality,
and health promotion. Comprehensive Reviews in Food Science and Food Safety. 16(3).
pp.346-368.
Dean, L. L., 2018. Targeted and Non‐Targeted Analyses of Secondary Metabolites in Nut and
Seed Processing. European Journal of Lipid Science and Technology. 120(11).
p.1700479.
Cheng, S., 2017. Optimization of sensor array of electronic nose for aging time detection of
pecan. Transactions of the Chinese Society of Agricultural Engineering. 33(3). pp.281-
287.
Morsy, G. M., Hussein, R. H. and El-Fadl, H. M. I. A., 2020. The chondroprotective role of
pecans (carya illinoinensis) and pistachio (pistacia vera) against experimentally induced
animal model of knee osteoarthritis. Eurasian Journal of Biosciences. 14(1). pp.1221-
1231.
Sealey-Voyksner, J., Zweigenbaum, J. and Voyksner, R., 2016. Discovery of highly conserved
unique peanut and tree nut peptides by LC–MS/MS for multi-allergen detection. Food
chemistry. 194. pp.201-211.
Dean, L. L., 2018. Targeted and Non‐Targeted Analyses of Secondary Metabolites in Nut and
Seed Processing. European Journal of Lipid Science and Technology. 120(11).
p.1700479.
Atanasov, A. G. and et.al., 2018. Pecan nuts: A review of reported bioactivities and health
effects. Trends in food science & technology, 71, pp.246-257.
Cetinkaya, P. G. and et.al., 2020. Phenotypical characterization of tree nuts and peanut allergies
in east Mediterranean children. Allergologia et immunopathologia, 48(4), pp.316-322.
Online
All about the Australia’s Pecan sector, 2019. [Online]. Available through:
< https://www.propertyobserver.com.au/finding/location/rural/105030-australian-pecan-
industry-finally-reaping-rewards.html>
12

APPENDIX
13

14

15

16

–
17