EL CC CORPORATION MONTHLY SALES REPORT - MARCH Emp No. S101 Sales Amount PHP 2,500.00 Comission Total Salary Salary PHP 12,000.00| PHP 11,500.00 PHP 12,500.00| PHP 10,000.00 PHP 8,500.00 PHP 9,000.00| Name ? PHP 3,000.00 PHP 2,200.00 PHP 1,800.00 PHP 1,700.00 PHP 3,100.00 Juan ? S105 Alex ? S112 S107 S110 S103 Jamie ? Alice Ryan ? Peter Totals
EL CC CORPORATION MONTHLY SALES REPORT - MARCH Emp No. S101 Sales Amount PHP 2,500.00 Comission Total Salary Salary PHP 12,000.00| PHP 11,500.00 PHP 12,500.00| PHP 10,000.00 PHP 8,500.00 PHP 9,000.00| Name ? PHP 3,000.00 PHP 2,200.00 PHP 1,800.00 PHP 1,700.00 PHP 3,100.00 Juan ? S105 Alex ? S112 S107 S110 S103 Jamie ? Alice Ryan ? Peter Totals
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Provide what is asked.
Transcribed Image Text:EL CC CORPORATION
MONTHLY SALES REPORT - MARCH
Emp No.
Name
Salary
Sales Amount
Comission Total Salary
PHP 2,500.00
PHP 3,000.00
PHP 2,200.00
S101
Juan
PHP 12,000.00
?
S105
Alex
PHP 11,500.00
?
S112
Jamie
PHP 12,500.0O
s107
Alice
PHP 10,000.00
?
PHP 8,500.00
PHP 9,000.00
PHP 1,800.00
PHP 1,700.00
РHP 3,100.00
S110
Ryan
S103
Peter
Totals
?
?
Average
?
Highest
?
?
Lowest
?
Count
?
?
1. Create a worksheet in MS Excel.
2. Follow the format shown above.
3. Set the column widths as follows:
Column A: 8, Column B: 14, Columns C
& D: 15, Columns E & F: 14.
4. Enter the formula to find COMMISSION
for the first employee. The commission
rate is 2% of sales, SALES x 2% =
COMMISSION. Copy the formula to the
remaining employees.
5. Enter the formula to find TOTAL
SALARY for the first employee where:
SALARY + COMMISSION = TOTAL
%3D
SALARY. Copy the formula to the
remaining employees.
6. Enter the formula to find TOTALS,
AVERAGE, HIGHEST, LOWEST, and
COUNT values. Copy the formula to
each column.
7. Format numeric data to include
commas and two decimal places.
8. Align all column title labels horizontally
and vertically at the center.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education