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 visualizations to analyze 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 realized by Nina's shop from the provided records. (4 marks)
You realize 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 realized? (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)