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

Would you like to discuss this project or get it done? 

Reach out on WHATSapp at +1 (240) 389-5520

Or 
 Place an order on our website for quick help

Guarantees

A+ Paper
 Timely Delivery
 Zero Plagiarism
 Zero AI