Question 1 [28]

A month ago, your friend, Nina, opened a baby wholesale clothing shop. She has been recording sales in a notebook entitled "Daily Sales." With no detailed records, she cannot tell which types of clothing are making a profit and which are not. Nina is worried the business might be making a loss and has purchased a laptop to monitor and keep her sales records. You have decided to showcase your skills using visualisations to analyse the provided sales data.

Below is the data from the "Daily Sales" book. Each record constitutes a sales invoice.

11 baby jumpsuits sold at R90 each 202 girls dresses at R165 each 162 boys' jeans at R175 each 19 girls' jeans at R140 each 106 wrapping towels at R250 each 308 baby shoes at R80 each 160 baby monitors at R560 each 190 baby bottles at R70 each

Required:

1.1 Create a spreadsheet with the provided information. (3 marks)

1.2 Arrange the clothing types in ascending order (2 marks)

1.3 Calculate total quantities of clothing sold in the month. (2 marks)

1.4 Calculate the sales realised by Nina's shop from the provided records. (4 marks)

You realise that Nina offers no promotional discounts to customers to improve customer traffic and sales. If applied, you have decided to show her how discounts will affect her sales.

1.5 What would be the total discount if a 5 % discount is applied to each sales invoice? (4 marks)

1.6 If a 5% discount is applied on each sales invoice, what total sales would the company have realised? (4 marks)

If Nina had implemented a 5% discount policy on only sales invoices above R25 000, answer the following.

1.7 What is the discount value for sales above R25 000? (3 marks)

1.8 Determine the total sales after the 5% discount is applied? (3 marks)

1.9 Create a bar chart for the clothing quantities sold. Include quantities sold as data labels. (3 marks)