Business & Finance Business 508 Managerial Analytics ( Excel Spread Sheet Homework)

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