2 Sort Lists Create, edit, and format charts Utilise Financial Functions (PMT) and (FV) 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 Sales 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. 1.2 Calculate the sales obtained from each fruit. Show the formula visible in the formula bar. (2 marks) (3 marks) 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. 1.4 Calculate the total quantities of fruits sold in the period. Show the formula visible in the formula bar. (2 marks) (2 marks) 1.5 Using an Excel function, determine which fruit had the highest quantities sold. Show the formula visible in the formula bar. (2 marks) HCLT108-1-Jan-June2024-FA1-IM-V.3-08022024
2 Sort Lists Create, edit, and format charts Utilise Financial Functions (PMT) and (FV) 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 Sales 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. 1.2 Calculate the sales obtained from each fruit. Show the formula visible in the formula bar. (2 marks) (3 marks) 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. 1.4 Calculate the total quantities of fruits sold in the period. Show the formula visible in the formula bar. (2 marks) (2 marks) 1.5 Using an Excel function, determine which fruit had the highest quantities sold. Show the formula visible in the formula bar. (2 marks) HCLT108-1-Jan-June2024-FA1-IM-V.3-08022024
Principles Of Marketing
17th Edition
ISBN:9780134492513
Author:Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:Kotler, Philip, Armstrong, Gary (gary M.)
Chapter1: Marketing: Creating Customer Value And Engagement
Section: Chapter Questions
Problem 1.1DQ
Related questions
Question
![2
Sort Lists
Create, edit, and format charts
Utilise Financial Functions (PMT) and (FV)
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 Sales 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.
1.2 Calculate the sales obtained from each fruit.
Show the formula visible in the formula bar.
(2 marks)
(3 marks)
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.
1.4 Calculate the total quantities of fruits sold in the period.
Show the formula visible in the formula bar.
(2 marks)
(2 marks)
1.5 Using an Excel function, determine which fruit had the highest quantities sold.
Show the formula visible in the formula bar.
(2 marks)
HCLT108-1-Jan-June2024-FA1-IM-V.3-08022024](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fdd11b0b7-ba0e-478b-a71c-bc66d6e16d73%2Fe82ed38a-1226-47a7-96d7-8586215b1761%2F5to8pk_processed.jpeg&w=3840&q=75)
Transcribed Image Text:2
Sort Lists
Create, edit, and format charts
Utilise Financial Functions (PMT) and (FV)
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 Sales 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.
1.2 Calculate the sales obtained from each fruit.
Show the formula visible in the formula bar.
(2 marks)
(3 marks)
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.
1.4 Calculate the total quantities of fruits sold in the period.
Show the formula visible in the formula bar.
(2 marks)
(2 marks)
1.5 Using an Excel function, determine which fruit had the highest quantities sold.
Show the formula visible in the formula bar.
(2 marks)
HCLT108-1-Jan-June2024-FA1-IM-V.3-08022024
AI-Generated Solution
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
![Principles Of Marketing](https://www.bartleby.com/isbn_cover_images/9780134492513/9780134492513_smallCoverImage.gif)
Principles Of Marketing
Marketing
ISBN:
9780134492513
Author:
Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:
Pearson Higher Education,
![Marketing](https://www.bartleby.com/isbn_cover_images/9781259924040/9781259924040_smallCoverImage.gif)
Marketing
Marketing
ISBN:
9781259924040
Author:
Roger A. Kerin, Steven W. Hartley
Publisher:
McGraw-Hill Education
![Foundations of Business (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337386920/9781337386920_smallCoverImage.gif)
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
![Principles Of Marketing](https://www.bartleby.com/isbn_cover_images/9780134492513/9780134492513_smallCoverImage.gif)
Principles Of Marketing
Marketing
ISBN:
9780134492513
Author:
Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:
Pearson Higher Education,
![Marketing](https://www.bartleby.com/isbn_cover_images/9781259924040/9781259924040_smallCoverImage.gif)
Marketing
Marketing
ISBN:
9781259924040
Author:
Roger A. Kerin, Steven W. Hartley
Publisher:
McGraw-Hill Education
![Foundations of Business (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337386920/9781337386920_smallCoverImage.gif)
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
![Marketing: An Introduction (13th Edition)](https://www.bartleby.com/isbn_cover_images/9780134149530/9780134149530_smallCoverImage.gif)
Marketing: An Introduction (13th Edition)
Marketing
ISBN:
9780134149530
Author:
Gary Armstrong, Philip Kotler
Publisher:
PEARSON
![MKTG 12:STUDENT ED.-TEXT](https://www.bartleby.com/isbn_cover_images/9781337407595/9781337407595_smallCoverImage.gif)
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning