05 Feb Excel Homework Assignment 1 – Business Analytics Basics
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
