Question
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started