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

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.