Excel Homework Assignment 1 – Business Analytics Basics (50 Points)
Course: Business Analytics / Project Management Analytics
Submission Format: Excel File Upload
Assignment Overview
This assignment is designed to help you practice basic Excel skills and introductory business analytics modeling. You will build a simple spreadsheet, apply formulas, and use Excel to support a basic business decision.
Student Task (Excel Assignment)
Create one Excel worksheet named: Sales_Model
Enter the following data:
| Product | Unit Price ($) | Units Sold | Cost per Unit ($) |
| A | 25 | 100 | 10 |
| B | 40 | 80 | 18 |
| C | 60 | 50 | 25 |
Requirements (ONLY 3 TASKS)
1) Create formulas to calculate:
– Revenue = Unit Price × Units Sold
– Total Cost = Cost per Unit × Units Sold
– Profit = Revenue − Total Cost
2) Use Excel functions to calculate at the bottom of the table:
– Total Revenue (SUM)
– Total Profit (SUM)
3) Decision Question (written in Excel or a separate cell):
– Which product is the most profitable and why?
Submission Instructions
Submit one Excel file containing:
– Completed calculations
– Formulas (not hard-coded numbers)
– Decision answer
Grading Rubric (50 Points)
| Category | Points |
| Correct formulas | 20 |
| Correct calculations | 15 |
| Decision answer | 10 |
| Formatting & clarity | 5 |
Struggling with where to start this assignment? Follow this guide to tackle your assignment easily!
Step-by-Step Guide to Completing This Excel Assignment
Step 1: Set Up Your Excel Worksheet
-
Open Excel and create a new workbook.
-
Rename the worksheet tab to Sales_Model.
-
Enter the column headers exactly as shown in the assignment.
-
Input the product data carefully—accuracy here affects all calculations.
Tutor tip: Clean, well-labeled tables make your work easier to grade and easier to understand.
Step 2: Create the Required Formulas
Add three new columns:
-
Revenue
-
Total Cost
-
Profit
For the first product row, enter formulas using cell references (not numbers):
-
Revenue = Unit Price × Units Sold
-
Total Cost = Cost per Unit × Units Sold
-
Profit = Revenue − Total Cost
Once the formulas work correctly:
-
Use fill down to apply them to Products B and C.
Important: Hard-coding numbers instead of formulas will result in lost points.
Step 3: Calculate Totals Using Excel Functions
Below the table:
-
Use the SUM() function to calculate:
-
Total Revenue
-
Total Profit
-
Example:
This shows that you understand basic Excel functions, a key learning objective of this assignment.
Step 4: Answer the Decision Question
In a separate cell or text box, clearly answer:
-
Which product is the most profitable?
-
Why? (Reference your calculated profit values.)
Tutor expectation: A strong answer connects numbers to business reasoning, not just “Product X has the highest profit.”
Step 5: Check Formatting & Clarity
Before submitting:
-
Ensure dollar values are formatted as Currency ($).
-
Make sure column headers are bold.
-
Double-check that formulas—not typed results—are used.
These small details help you earn the full formatting & clarity points.
Helpful Excel Learning Resources
You may use the following links to support your work:
-
Microsoft Excel Basics (Official):
https://support.microsoft.com/excel -
Excel Formulas & Functions Guide:
https://www.excel-easy.com/formulas.html -
Beginner Excel Tutorials (Step-by-Step):
https://www.gcfglobal.org/excel/ -
Understanding Profit, Cost & Revenue Concepts:
https://www.investopedia.com
The post Excel Homework Assignment 1: Business Analytics Basics with Profit Analysis appeared first on Skilled Papers.