Supplier database and stock/sales comparison

Assessment Task 03 BSBITU304A Produce spreadsheets (STUDENT’S NAME)

Candidate’s name

Phone no.

Assessor’s name

Phone no.

Assessment site

Assessment date/s

Time/s

The assessment task is due on the date specified by your assessor. Any variations to this arrangement must be approved in writing by your assessor.

Submit this document with any required evidence attached. See specifications below for details.

The candidate must demonstrate knowledge and skills in producing a purchase order that includes the use of formulas using an Excel template.

Combine elements of the two previous spreadsheets and a template to create a purchase order for Cindy’s CDs, using formulas and formatted to the organisational style guide.

1. Using data from Assessment Task 1 and product information and prices supplied, create a purchase order for Cindy’s CD’s using an Excel template formatted to comply with Cindy’s CDs Style Guide.

2. Insert formulas where appropriate to calculate GST, sub-totals and totals.

3. Save your work with an appropriate filename to the required destination as specified by your assessor.

4. Print the purchase order.

© 2009 IBSA MC v.2 2015 Page 1 of 1