BusinessFreePrintable

Market Data Analysis Worksheet

A free, printable business worksheet ready for your classroom. Download instantly, print, and hand out to your students — no account needed.

Market Data Analysis Worksheet worksheet preview

Market Data Analysis Worksheet

Business data analysis illustration

📊 Part 1: Fresh Brew Coffee Co. Data Analysis

WALT: We Are Learning To collect and interpret market and financial data to make informed business decisions.

Success Criteria: I can identify trends in sales data, interpret survey results, and suggest business improvements based on evidence.

Sales Data Table - Fresh Brew Coffee Co. (Last 6 Months)

Month Coffee Sales ($) Food Sales ($) Total Customers Average Spend per Customer ($)
January $8,500 $3,200 650 $18.00
February $9,200 $3,800 720 $18.06
March $10,100 $4,500 850 $17.18
April $11,800 $5,200 980 $17.35
May $13,500 $6,100 1,150 $17.04
June $14,200 $6,800 1,200 $17.50

Customer Survey Results Summary (200 responses)

Most popular drink: Flat White (35%), Cappuccino (28%), Latte (22%), Other (15%)

Visit frequency: Daily (15%), Weekly (45%), Monthly (25%), Rarely (15%)

Main reason for visiting: Quality coffee (60%), Convenient location (25%), Friendly service (10%), Price (5%)

Suggested improvements: More food options (40%), Loyalty program (30%), Extended hours (20%), Lower prices (10%)

1. What is the total revenue for Fresh Brew Coffee Co. in June?

June total revenue: $ _______________

2. Which month showed the biggest increase in customer numbers compared to the previous month?
3. Based on the survey, what is the most requested improvement from customers?

Loyalty program

More food options

Extended hours

Lower prices

🔍 Part 2: Trend Analysis and Business Insights

4. Describe the overall trend in coffee sales from January to June. Use specific figures to support your answer.
5. Calculate the percentage increase in total customers from January to June. Show your working.
6. What does the survey data tell us about customer loyalty? Explain your reasoning.
7. Based on ALL the data provided, identify TWO business opportunities for Fresh Brew Coffee Co.

Opportunity 1: ________________________________________________

Opportunity 2: ________________________________________________

💡 Part 3: Business Decision Making

8. If you were the manager of Fresh Brew Coffee Co., which customer suggestion would you implement first? Justify your choice using the data.
9. What additional market research would help Fresh Brew Coffee Co. make better business decisions?

Competitor pricing analysis

Peak hour customer traffic study

Local demographic research

Seasonal demand patterns

10. Extension Challenge: Predict the likely total revenue for July if current trends continue. Explain your prediction method.

About This Worksheet

Free Download

No sign-up, no email, no paywall. Just download and print.

Print-Ready

Formatted for standard paper. Clean layout, easy to read.

AI-Generated

Created with Kuraplan's AI, designed for real classroom use.

For Teachers & Parents

Use in classrooms, for homework, tutoring, or homeschool.

Need a custom version of this worksheet?

Kuraplan's AI generates custom worksheets in seconds — differentiated for every learner, aligned to your curriculum.

Generate Custom Worksheets — Free
No credit card Curriculum-aligned Under 60 seconds