Excel Spreadsheet Assignment Simple.
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 |