Beef Export Market Analysis

This assignment analyzes the global beef export market with a focus on key countries: China, Germany, and Japan. It examines sales trends, potential threats and opportunities, and presents visual data to illustrate market dynamics. A SWOT analysis is also included to evaluate the strengths, weaknesses, opportunities, and threats facing the beef export industry.

☐
BSBMKG511 Analyse data from
International markets
Note to Student: You are required to complete all areas of this Assessment Cover sheet where
coloured
To achieve competency in this unit you must complete the following assessment items. All tasks must be
submitted together. Tick the boxes to show that each task is attached.
 Task 1. Short Answer Questions ☐
 Task 2. Project Report ☐
Assessment cover sheet
Student’s name Click here to enter text. Student’s ID Click here to enter
text.
Qualification Qualification Code &
Title
Due date Click here to enter
text.
Date submitted Click here to enter
text.
Student’s declaration
Yes No
☐ ☐ I have read and understood the details of the assessment.
☐ ☐
I have been informed of the conditions of the assessment
and the appeals process and understand I may appeal if I
believe the assessment is not equitable, fair or just.
☐ ☐ I agree to participate in this assessment, and I am ready to
be assessed.
☐ ☐ I certify that the attached is my own work (or in
collaboration with other members of the group as required).
☐ ☐
I have acknowledged all sources where appropriate in
accordance with ILSC’s Academic Integrity Policy, and I
believe other group members have done the same.
Student’s signature Original Due Date
Submissi
on
Date(s)
1st
Submissi
on
Date:Clic
k here to
Page 1 of 24

enter text.
2nd
Submissi
on
Date:Clic
k here to
enter text.
3rd
Submissi
on
Date:Clic
k here to
enter text.
Assessment (ILSC
office use only)
Competent
Trainer’s
Fees
Result
Initial & Date
1st Submission 
Yes
 No
_____
_____
_____
_

Late
Fee =
$50

Re-
sub
Fee
2nd Submission 
Yes
 No
_____
_____
_____
_
 No
fee

Fee
waive
Page 2 of 24

d
3rd Submission 
Yes  No
_________________
 Fee paid
Page 3 of 24

Comments/Feedback from assessor to student
Click here to enter text.
Missing questions/Questions to resubmit:
Click here to enter text.
Reasonable Adjustments (if any):
Click here to enter text.
RESULT
Competent
☐ Congratulations! You have addressed the outcomes of this unit and have been deemed competent.
Not Yet Competent
☐ Please see your trainer to discuss (Trainer’s name below).
☐ You will need to address the above feedback and resubmit/provide the required answers before an
assessment decision can be made.
Assessor/Trainer Name:
Assessor Checklist Initial
Authentic: The assessor is assured that the evidence presented for assessment is
the learner’s own work. Click here to enter text.
Valid: The assessor is assured that the learner has the skills, knowledge and
attributes as described in the module or unit of competency and associated
assessment requirements.
Click here to enter text.
Current: The assessor is assured that the assessment evidence demonstrates
current competency. This requires the assessment evidence to be from the
present or the very recent past.
Click here to enter text.
Sufficient: The assessor is assured that the quality, quantity and relevance of
the assessment evidence enable a judgement to be made of a learner’s
competency.
Click here to enter text.
Assessor’s name Click here to enter text. Date Click here to
enter text.
Assessor’s signature Click here to enter text.
Page 4 of 24

Task 1 Short Answer Questions
Assessment instructions
Please read the following questions and provide a brief answer below.
You can use the workbook available in Moodle as your primary source of information when trying to
answer the questions. However, you must write your answer in your own words (otherwise, it may be
considered plagiarism).
The hardest part of it all will be to understand any new terminology or “words”. Your Trainer is here to help
you so please ask as many times as you like until you fully understand the wording.
1. Explain what Central Tendency is and give an example.
Central tendency is the centre value/average of any data. Mean, median and mode are three measures of
central tendency (Lee and Peters, 2015).
For example: Find the measures of central tendency for the following data- 1,2,3,4,5,5,6,7,8
Mean is 1+2+3+4+5+5+6+7+8/9 = 41/9 = 4.56
Median = 5
Mode = 5
2. What is Dispersion? Give an example.
Dispersion means how dispersed/varied the data is. There are various types of dispersion including Range,
Standard deviation, inter-quartile range, coefficient of variation etc.
Example : 0,1,25,50,120,210
here dispersion is huge as the set is wider.
3. Explain what Sampling is.
Sampling means to select a sample/subset of entire population which is basically the representative of the
entire population and to give inference from the entire population based on the sample.
Page 5 of 24

4. Explain what PEST analysis is giving a brief example of each area in the analysis.
PEST analysis is undertaken to scan the external environment which have an impact on the organisation.
POLITICAL FACTORS- tax policy, environmental policies, tariffs etc.
ECONOMIC FACTORS- inflation rates, interest rates, monetary and fiscal policies etc.
SOCIAL FACTORS- demographics, culture & values, buying patterns etc.
TECHNOLOGICAL FACTORS- research & development, automation etc.
Page 6 of 24

5. Give three examples of what Cultural Aspects mean when analysing international data.
When analysing international data the aspects of culture are-
religions
tradition
government.
6. Create a Quantitative question…
what is the average of the following data?
5,9,11,25,32,78,92,100
7. Create a Qualitative question…
How good is the communication skills of the people working in the XYZ Telecom company?
8. Describe what Best Practice is.
When the results which are achieved are superior to other means or alternatives, then that technique is
known as best practice.
9. Explain what Benchmarking is.
Page 7 of 24

When a specific indicators are used to measure the performance to a set standard, is known as benchmarking
(Levine, Krehbiel and Berenson, 2013).
Page 8 of 24

10. Give an example that explains what Strategic Alliance is?
ICICI BANK & Vodafone India entered into strategic alliance to launch a unique mobile money transfer
service called “m-pesa” as ICICI bank being India’s largest private bank and Vodafone being the largest
Telecom service provider (Jaggia and et.al., 2016).
Task 2 Project Report
Assessment instructions
Summary: In this task you need to conduct research regarding the export of Australian Food to various
countries. Using statistical analysis, you will need to explain the variance in data across a period of 5 years.
You will need to explain the strong growth and/or decline of various commodities over this period of time.
Step 1 - you will collect data.
Step 2 - you will create a report which provides data and an analysis of the data, and
Step 3 - you will need to deliver your interpretation of the data in a visual format, which can be
PowerPoint or similar.
Detail:
1. Select a specific commodity or product (refer to the resource materials)
2. Identify two sets of data:
a. 5 years of data for the export of that specific product to a specific country
b. 5 years of data for that specific product to other at least three (3) other countries:
3. Using measures of central tendency demonstrate forecasting:
a. For both sets of data
b. Forecasting for two years from today
c. Analysing the data, identify potential opportunities or threats to the market
4. Prepare, plot and interpret the data from the statistics for visual presentation. Select and use tools that are
appropriate, for example, Excel spreadsheet or similar.
Page 9 of 24

5. Write a report on your findings.
a. What happened to the amount of exports of that product?
b. Why do some countries want more or less of this product?
6. The report needs to contain the following:
a. All data in a table format and properly labelled
b. Line graphs to demonstrate increases, stabilization or decreases in past years
c. Line graphs to demonstrate increases, stabilization or decreases in forecasting
d. Pie graphs demonstrating the market breakdown of different countries
e. References & Appendixes
You may upload your report as a second file to Moodle – or include it at the end of this document.
Please follow your trainer’s final directions on this.
Report format guidelines (refer to template provided):
1. Use Microsoft Word/PDF or a similar program
2. Include the following:
 Title page
 Contents page
 Your report
 References
3. Follow these general report rules as well:
 Use the same font throughout the document
 Use the same font size throughout the document, except for headings which are a larger font
 Use both a Header and a Footer in your document
Please note: ILSC can use third party software to detect plagiarism.
YOU CAN PASTE ASSESSMENT TASK 2 (Report) BELOW THIS LINE OR UPLOAD A
SEPARATE FILE TO MOODLE.
Please see your trainer for final instructions on this.
Page 10 of 24

TASK 2 PROJECT REPORT
Page 11 of 24

Select a specific commodity
Meat (excl beef), f.c.f
Page 12 of 24

5 years of data for the export of Meat (excl beef)
to Algeria
Year Algeria
2006 6397.778
2007 8907.658
2008 3010.285
2009 487.04
2010 1042.065
2011 70.24
2012 467.274
2013 1036.961
2014 3083.784
2015 3368.85
2016 2412.389
Page 13 of 24

5 years of data for the export of Meat (excl beef)
to China, Germany and Japan
Year China Germany Japan
2006 50017.48 21338.33 417338.4
2007 43078.82 29590.6 333879.6
2008 70238.04 22593.78 291998.7
2008 101107.2 26831.86 322975.6
2010 95324.5 15362.97 252316.8
2009 149166.3 22473.98 264927.9
2012 191217.7 27126.08 251625.2
2010 343606 10658 247019.6
2014 562220.2 18289.48 274623
2011 440319.3 12916.91 292296.9
2016 284981.1 17674.87 344428.3
Page 14 of 24

Forecasting using measures of central tendency
measures
Algeria
Mean 2753.12
Standard Error 827.1722
Median 2412.389
Mode #N/A
Standard Deviation 2743.42
Sample Variance 7526353
Kurtosis 1.445768
Skewness 1.354519
Range 8837.418
Minimum 70.24
Maximum 8907.658
Sum 30284.32
Count 11
Forecasting for the next period:
Mean +- standard deviation
= 2,753.12 +- 2473.42
China Germany Japan
Mean 211934.2388 20441.53345 299402.7
Standard Error 52448.2231 1832.055403 15618.2
Median 149166.278 21338.331 291998.7
Mode #N/A #N/A #N/A
Standard Deviation 173951.077 6076.240367 51799.7
Sample Variance 30258977175 36920697 2.68E+09
Kurtosis -0.08996412 -0.96264637 1.403345
Skewness 0.985887007 -0.09810467 1.206098
Range 519141.417 18932.593 170318.8
Minimum 43078.822 10658.003 247019.6
Maximum 562220.239 29590.596 417338.4
Sum 2331276.627 224856.868 3293430
Count 11 11 11
Page 15 of 24

Forecasting
Formula = Mean +- standard deviation
China: 211934.23 +- 173951.07
Germany: 20441.53 +- 6076.24
Japan: 299402.7 +- 51799.7
Page 16 of 24

Forecasting by graphical presentation
Forecasting for two years
-375.7x + 5007
2017: -375.7(12) + 5007 = -498.6
2018: -375.7(13) + 5007 = 122.9
Forecasting
Country China Germany Japan
Equation 43824x - 51009 -1077x + 26906 -6687x + 33952
2017 43824(12)-51009 -1077(12) + 26,906 -6687(12)+33952
Page 17 of 24

= 474879 = 13,982 = -46292
2018 43824(13)-51009
518703
-1077(13) + 26,906
= 12,905
-6687(13)+33952
= -52,979
Page 18 of 24

Potential threats & opportunities
Opportunities
 High demand in the foreign countries like China regarding meat products
 Growth in sales & profitability
Threats:
 Decline demand in the Japan, Germany & Algeria
 Tough competition in the market
 Pricing pressure by the rivalries (Freed, Bergquist and Jones, 2014)
Page 19 of 24

Visual presentation
Page 20 of 24

Interpretations: From the graph, it can be seen that over the period, the sales of the beef shows a
declined trend in Algeria. It may be due to decreasing consumer demand towards beef product. Moerover,
excessive home country’s production may be the reason behind downward trend in the Australian export of
beef to Alegeria. However, after 2011, it show an upper trend as came to 3368.85 whilst at the end, it
dropped to 2412.39. Therefore, it showcase that in Algeria, demand of meet product is highly volatile.
Page 21 of 24

Findings and analysis: From the presented graph, it is seen that export to China shows a sudden
increase in the year 2014 as it gone up to 562220.2 and in the succeding years, it came down due to
Page 22 of 24

decreased demand in the market and higher production in the domestic nation. However, on the other side,
In Germany, it comparatively shows a stabilize trend as the presented graph depicts a stabilize export (Freed,
Bergquist and Jones, 2014). Unlike it, Japan’s exports indicates a up and down trend, in the initial years, it
reported highest export in comparison to other two nation, however, thereafter, in 2013,China’s export goes
high from the export to Japan due to sudden rise in the demand of the beef products.
Page 23 of 24

REFERENCES
Books and Journals
Freed, N., Bergquist, T. and Jones, S., 2014. Understanding business statistics. John Wiley & Sons.
Jaggia, S. and et.al., 2016. Essentials of business statistics: communicating with numbers.John Wiley &
Sons.
Lee, N. and Peters, M., 2015. Business Statistics Using EXCEL and SPSS. Sage.
Levine, D.M., Krehbiel, T.C. and Berenson, M.L., 2013. Business Statistics: International Edition. Pearson
Higher Ed.
Page 24 of 24