Question 1 [44 marks] Cape Produce is a fruit and vegetable retail shop based in the Western Cape province. With 15 branches in the region, their main branch is in the Cape Town city center. The branch has experienced a decline in demand for most of its products. The business has neglected marketing efforts in the past three years due to the COVID-19 pandemic, which impacted sales and profitability. You have been employed to lead the Sales department and implement marketing promotions. Before you strategise any marketing campaign, you must understand how the business performs. Background You have been provided with the attached Cape Produce Sale8s data in an Excel sheet. Answering these questions will provide a marketing promotion planning basis. Required: Note: add columns to the provided data table to calculate discounts and sales. Complete all calculations using formulas in Excel. Use the provided Answer Sheet. 1.1 Arrange the fruit names in descending order using the Sort & Filter function. (2 marks) 1.2 Calculate the sales obtained from each fruit. (3 marks) Show the formula visible in the formula bar. 1.3 Calculate the total sales obtained by Cape Produce from the provided data in the Rand currency. Show the formula visible in the formula bar. (2 marks) 1.4 Calculate the total quantities of fruits sold in the period. (2 marks) Show the formula visible in the formula bar. 1.5 Using an Excel function, determine which fruit had the highest quantities sold. (2 marks) Show the formula visible in the formula bar.
fruits name. Quantities. price
banana. 300. R 235
mango. 4300. R390
dates. 3200. R450
dry apricot. 1520. R 610
papaya. 3100. R230
cherry fruit. 1300. R320
cashew nuts. 3250. R370
Orange. 1800. R300
Guava. 1200. R520
Apple delicious 3200. R950
kiwi fruit. 5000. R900
plum. 1560. R 300
