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

NEED ASSIGNMENT HELP?

We guarantee plagiarism-free and AI-free writing services. Every assignment is crafted with originality, precision, and care to meet your academic needs.

Ready to get started? Place your order directly on this post!

Let us help you achieve excellence—authentic work, every time.