1. Stationery Works has just received a shipment of goods from the warehouse.

fill in the missing numbers for items 1 to 5..

Fill in columns F - H by completing the following tasks for each item:

calculate the GST amount for each item that is liable for GST

calculate the selling price, excluding GST

calculate the selling price, including GST.

Round your answer to the nearest cent. For example, 2.494 would be expressed as $2.49.

Item No.	Description	Cost price	Mark up %	Selling price (excl. GST)	GST Amount	Selling price (incl. GST)
1	Box of envelopes	$15.20	25%
2	Box of black pens	$12.50	60%
3	Box of copy paper	$15.00	66.67%
4	Box of staples	$1.00	100%
5	Box of highlighters	$10.00	50%

2.

fill in the missing numbers for items 1 to 5.

Refer to the ATO website to verify the input data in column E for which items are liable for GST and repeat Task 2. complete column E in the table, as well as columns F to H as above.

Item No.	Description	Cost price	Mark up %	Liable for GST	Selling price (excl. GST)	GST Amount	Selling price (incl. GST)
1	Chocolate biscuits	$3.24	40%
2	White bread	$2.50	40%
3	Milk	$1.60	25%
4	Cola	$2.12	50%
5	Potato chips	$1.51	80%

3.

fill in the missing numbers for items 1 to 3 in columns C and D.

You have been provided with the income tax rates for each tax bracket in the same excel spreadsheet, columns F and G. Verify this input data and confirm it is accurate as required for workplace calculations.

Round your answer to the nearest cent. For example, 2.494 would be expressed as $2.49.

Item	Gross income $	Income tax $	Net income $
1	17,020
2	182,202
3	83,550

Taxable income	Tax payable on this income
0 - 18,200	Nil
18,201 - 45,000	19c for each $1 over $18,200
45,001 - 120,000	$5092 plus 32.5 cents for each $1 over $45,000
120,001 - 180,000	$29,467 plus 37 cents for each $1 over $120,000
180,001+	$51,667 plus 45 cents for each $1 over $180,000