[go: up one dir, main page]
Scribd
Upload
14 views6 pages

03 - Creating Formulas and Functions

The document contains financial data for sales, overhead, profits, and employee salary information for various departments. It includes monthly sales figures, profit margins, and employee details such as hire dates and salary adjustments. The overall sales total is 1,505 with an average profit margin of 16%.

Uploaded by

shikha.binary
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
14 views6 pages

03 - Creating Formulas and Functions

The document contains financial data for sales, overhead, profits, and employee salary information for various departments. It includes monthly sales figures, profit margins, and employee details such as hire dates and salary adjustments. The overall sales total is 1,505 with an average profit margin of 16%.

Uploaded by

shikha.binary
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
You are on page 1/ 6

Jan Feb Mar Apr May Jun Total Average

Sales 120 160 210 250 325 440 1,505 251


Overhead 100 130 160 200 260 360 1,210 202
Overhead + 2% t 2 2.6 3.2 4 5.2 7.2 24 4
Exp. 2% on Sales 2.4 3.2 4.2 5 6.5 8.8 30 5
Profits 15.6 24.2 42.6 41 53.3 64 241 40
% Profit on Sales 13% 15% 20% 16% 16% 15% 16% 16%

MOM Profit 16 40 82 123 177 241

Exp % Jan 120


2% Feb 160
Mar 210
Apr 250
May 325
Jun 440
Employee Name Department Hire Date Years Salary New Salary Rank Len
Tejash Shah Sales 11-Nov-12 12 54,550 56,459 14 11
Jayesh Khagram Sales 21-Aug-11 13 86,795 89,833 5.5 14
Sneha Lankhani Administration 6-Jul-15 9 42,540 44,029 17 14
Krunal Mehta Account 31-Dec-07 17 92,830 96,079 1.5 12
Rajesh Shah Account 1-Jan-12 13 20,000 20,700 19 11
Sweta Shah Sales 3-Sep-06 18 60,830 62,959 13 10
Yogesh Modi Marketing 17-Apr-07 17 66,580 68,910 11.5 11
Amit Sanghvi Training 10-Apr-99 25 75,150 77,780 7.5 12
Runali Patil Sales 28-May-02 22 30,780 31,857 18 12
Riya Shah Training 4-Jun-04 20 49,350 51,077 15 9
Shruti Shah Marketing 15-Jan-12 13 89,760 92,902 3.5 11
Punarvasu Thakur Administration 26-Aug-00 24 74,840 77,459 9.5 16
JayJash Shah Training 1-Sep-11 13 49,070 50,787 16 12

Count data cells 84 92,902 1 96,079 20700


Count number cells 52 2 92,902 31857
Median 62,959 3 89,833 44029
2nd Largest 92,902 4 77,780 50787
2nd Lowest 31,857 5 77,459 51077
6 68,910 56459

1/1/2010 15.00

12
Absoulate Increments
3.50% Tejash Shah - Sales - 41224
1

TeJASh Shah 11
a

Tejash Shah
TEJASH SHAH
tejash shah

65
32
2.1%
$ 1,234,567,890,122.00 BANPR1234B
12:00:00 AM
ANPR1234B

You might also like