Description:

This assessment task has four tasks. Trainers/assessors may vary the data for the task for different students. Tasks may be scheduled according to classroom learning sessions and organised over a number of sessions to coincide with the relevant lessons and activities.

1.Complete the following tasks using the given data set.

Assets

$

Cash200 000

Accounts receivable400 000

Inventory1 200 000

Plant600 000

Total assets2 400 000

Liabilities

$

Accounts payable800 000

Long-term debt400 000

Capital1 200 000

2 400 000

Profit and loss

Sales1 600 000

Cost of goods sold1 000 000

Operating expenses200 000

Interest100 000

Taxes100 000

Net profit200 000

Find the following:

(a) Current ratio

(b) Quick asset ratios

(c) Inventory turnover

(d) Collection period

(e) Fixed asset turnover

(f) Times interest covered

(g) Net profit margin

(h) Return on total assets

(i) Return on capital.

2.The following data represents sales for 2005 to 2015:

Year Sales

200810 000

200911 000

201012 000

201112 500

201216 000

201318 000

201425 000

201540 000

201641 000

201743 000

201850 000

Based on the data,

(a) Plot the data on a graph.

(b) Draw the secular trend line of best fit using semi-average method.

(c) With the data from 2009 to 2018 predict sales for 2019 with least square method of forecasting

3.You are given the following data:

21121131210

11321411102

Required:

(a) Draw a histogram.

(b) Draw a frequency table.

(c) Draw a frequency polygon.

4. Calculate the correlation coefficient between advertising (x) and sales (y).

Year

2009

2010

2011

2012

2013

2014

$'000 Advertising

10

11

12

13

14

15

$'000 Sales

200

220

230

250

260

300

( b ) Describe the relationship between advertising and sales.

( c ) Find the equation of the regression line.

( d ) Plot the data for the annual sales versus advertising on a scattergram using the paper below. Start the x axis from 100 and the y axis from 8.

( e )Use the regression equation to draw the line of regression on your scatter diagram.

( f )If advertising is $16,000 in 2015 calculate the expected sales.

5. Why is accurate data so important for business survival? What are some of the graphical data techniques that are used to illustrate statistics results?