Scribd
Upload
27 views5 pages

Formulas and Functions

1) Total sales were $1,560 across the 6 month period, with expenses of $1,020, resulting in a profit of $540. 2) Sales were highest in June at $320 and lowest in January at $120. 3) Expenses increased each month from $100 in January to $250 in June.

Uploaded by

alam khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
27 views5 pages

Formulas and Functions

1) Total sales were $1,560 across the 6 month period, with expenses of $1,020, resulting in a profit of $540. 2) Sales were highest in June at $320 and lowest in January at $120. 3) Expenses increased each month from $100 in January to $250 in June.

Uploaded by

alam khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Jan Feb Mar Apr May Jun Total Average

Sales 120 160 200 240 280 320


Expenses 100 120 150 180 200 250
Profit
Year To Date
Percentage Change

Date
Time
Employee Name Department Hire Date Years Salary New Salary 2.9%
Page, Lisa Sales 11-Nov-99 22 54,550
Taylor, Hector Sales 21-Aug-11 10 26,795
Dawson, Jonathan Administration 6-Jul-07 14 42,540
Weber, Larry ADC 31-Dec-07 13 72,830
Pratt, Erik Sales 3-Sep-06 15 60,830
Spencer, Boyd Marketing 17-Apr-07 14 66,580
Wiggins, Frank Training 10-Apr-99 22 75,150
Tanner, Timothy Sales 28-May-02 19 30,780
Chase, Troy Training 4-Jun-04 17 49,350
Wilkins, Jesse Marketing 15-Jan-12 9 79,760
White, Daniel Administration 26-Aug-00 21 74,840
Holland, Donald Training 1-Sep-11 10 29,070
Mon Tue Wed Thu Fri Total
Revenue 67 89 99 123 145

1st Quarter 4,567 89


2nd Quarter 5,634 67
3rd Quarter 6,549 23 34 45
4th Quarter 7,021

Jan Feb Mar Apr May Jun


Domestic 11 19 12 13 15 22
Europe 6 8 7 10 9 12
Asia 10 12 11 12 14 18
Latin America 4 6 5 8 6 9
Employee Name Department Hire Date Years Salary New Salary Rank 2.9%
Page, Lisa Sales 11-Jan-99 22 54,550
Taylor, Hector Sales 21-Feb-11 10 26,795
Dawson, Jonathan Administration 6-Mar-07 14 42,540
Weber, Larry ADC 31-Dec-07 13 72,830
Pratt, Erik Sales 3-Feb-06 15 60,830
Spencer, Boyd Marketing 17-Apr-07 14 66,580
Wiggins, Frank Training 10-Apr-99 22 75,150
Tanner, Timothy Sales 28-May-02 19 30,780
Chase, Troy Training 4-Jun-04 17 49,350
Wilkins, Jesse Marketing 15-Aug-12 9 79,760
White, Daniel Administration 26-Aug-00 21 74,840
Holland, Donald Training 1-Sep-11 10 29,070
Highest
Lowest
Median
2nd Largest
STD

You might also like