Fundraising Team T-shirt Sales Analysis

Activity

You were part of a fundraising team where you tried to raise money by selling t-shirts. Create a table using a spreadsheet program to record how many t-shirts each team member sold. The table can be similar to the following:

Team Member T-shirts Sold
Alice 25
Bob 18
Charlie 30
David 22
Emma 15

The team exceeded their goal by selling 10 extra t-shirts

Fundraising Analysis:

Total T-shirts Sold: 25 + 18 + 30 + 22 + 15 = 110

Average Sold: 110 / 5 = 22

Highest Seller: Charlie (30 shirts)

Percentage Contributions:

Alice: (25 shirts / 110) * 100% = 22.73%

Bob: (18 shirts / 110) * 100% = 16.36%

Charlie: (30 shirts / 110) * 100% = 27.27%

David: (22 shirts / 110) * 100% = 20.00%

Emma: (15 shirts / 110) * 100% = 13.64%

Shortfall/Excess: 110 (sold) - 100 (goal) = 10 (excess)

The team exceeded their goal by selling 10 extra t-shirts.

The Complete Question

You were part of a fundraising team aiming to raise money by selling t-shirts for a charitable cause. The table below illustrates the number of t-shirts sold by each team member during a fundraising campaign.

Using this sales data:

Calculate the total number of t-shirts sold by the team.

Determine the average number of t-shirts sold per team member.

Identify the team member who sold the highest number of t-shirts.

Calculate the percentage contribution of each team member to the total t-shirts sold.

If the team's goal was to sell 100 t-shirts, calculate the shortfall or excess in achieving this goal.

Question

Based on the fundraising team's t-shirt sales data, answer the following questions:

  1. What is the total number of t-shirts sold by the team?
  2. What is the average number of t-shirts sold per team member?
  3. Which team member sold the highest number of t-shirts?
  4. What is the percentage contribution of each team member to the total t-shirts sold?
  5. Was the team able to meet their goal of selling 100 t-shirts?

Answer

  1. The total number of t-shirts sold by the team is 110.
  2. The average number of t-shirts sold per team member is 22.
  3. Charlie sold the highest number of t-shirts with 30 shirts.
  4. Percentage contribution of each team member:
    • Alice: 22.73%
    • Bob: 16.36%
    • Charlie: 27.27%
    • David: 20.00%
    • Emma: 13.64%
  5. The team exceeded their goal by selling 10 extra t-shirts, reaching a total of 110 t-shirts sold.
← Exciting world of computer programming languages Which of the following is not true for a personal macro workbook →