Provide what is asked. EL CC CORPORATIONMONTHLY SALES REPORT - MARCHEmp No.NameSalarySales AmountComission Total SalaryPHP 2,500.00PHP 3,000.00PHP 2,200.00S101JuanPHP 12,000.00?S105AlexPHP 11,500.00?S112JamiePHP 12,500.0Os107AlicePHP 10,000.00?PHP 8,500.00PHP 9,000.00PHP 1,800.00PHP 1,700.00РHP 3,100.00S110RyanS103PeterTotals??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 COMMISSIONfor the first employee. The commissionrate is 2% of sales, SALES x 2% =COMMISSION. Copy the formula to theremaining employees.5. Enter the formula to find TOTALSALARY for the first employee where:SALARY + COMMISSION = TOTAL%3DSALARY. Copy the formula to theremaining employees.6. Enter the formula to find TOTALS,AVERAGE, HIGHEST, LOWEST, andCOUNT values. Copy the formula toeach column.7. Format numeric data to includecommas and two decimal places.8. Align all column title labels horizontallyand vertically at the center.

Here we will use the different functions in excel like "sum", 'average', max, min etc. to find the…

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

See similar textbooks

Similar questions

Income Statements for the Year Ended 31st Dec 2020 KM Ltd ROW Ltd £'000 £'000 Sales revenue 8,320 11,250 Cost of sales (6,020) (9,030) Gross profit 2,300 2,220 Operating expenses (1,048) (1,535) Operating profit 1,252 685 Finance charges (20) (70) Profit before tax 1,232 615 Taxation (62) (30) Profit for the year 1,170 585 SOFP (Balance Sheet) as at 31st Dec 2020 KM Ltd ROW Ltd £'000 £'000 £'000 £'000 Non-current assets 502 198 Current assets Inventory 1,290 2,437 Trade receivables     730 1,990 2,020 4,427 Total assets 2,522 4,625 Equity Share capital 1,350      800 Reserves 580 1,145        1,930     1,945…
Income Statements for the Year Ended 31st Dec 2020 KM Ltd ROW Ltd £'000 £'000 Sales revenue 8,320 11,250 Cost of sales (6,020) (9,030) Gross profit 2,300 2,220 Operating expenses (1,048) (1,535) Operating profit 1,252 685 Finance charges (20) (70) Profit before tax 1,232 615 Taxation (62) (30) Profit for the year 1,170 585 SOFP (Balance Sheet) as at 31st Dec 2020 KM Ltd ROW Ltd £'000 £'000 £'000 £'000 Non-current assets 502 198 Current assets Inventory 1,290 2,437 Trade receivables     730 1,990 2,020 4,427 Total assets 2,522 4,625 Equity Share capital 1,350      800 Reserves 580 1,145        1,930     1,945…
Income Statements for the Year Ended 31st Dec 2020 KM Ltd ROW Ltd £'000 £'000 Sales revenue 8,320 11,250 Cost of sales (6,020) (9,030) Gross profit 2,300 2,220 Operating expenses (1,048) (1,535) Operating profit 1,252 685 Finance charges (20) (70) Profit before tax 1,232 615 Taxation (62) (30) Profit for the year 1,170 585 SOFP (Balance Sheet) as at 31st Dec 2020 KM Ltd ROW Ltd £'000 £'000 £'000 £'000 Non-current assets 502 198 Current assets Inventory 1,290 2,437 Trade receivables     730 1,990 2,020 4,427 Total assets 2,522 4,625 Equity Share capital 1,350      800 Reserves 580 1,145        1,930     1,945…
Oreo reported the following for the period:Sales P1,000,000Cost of Sales P300,000Operating expenses P100,000Determine the OSD assuming that Oreo is a corporation
Use the information below provided by Angel Baby Angel Company Sales 8,250,000.00 Operating costs 4.725,000.00 Operating income 3,525,000.00 Interest expense 1,750,000.00 Earnings before taxes 1,775,000.00 Taxes (40%) 621,250.00 Net income 1,153,750.00 WACC 8%, Total invested capital 24.875,000. Calculate the EVA (2 decimal places)
Agency XYZ collected the following income during the month: Income Taxes – Individual, P500,000; Income Taxes – Corporation, P1,800,000; Permit Fee, P400,000, Processing Fee 8,000, Rent Income 15,000 and Import Duties 400,000. The salary of the employees collecting these income amounts to P48,000. How much is the Total Service and Business Income collected?
(a) You are required to calculate and state the missing figures represented by alphabet . ABC Ltd Ghs ‘000 XYZ Ltd Ghs ‘000 Turnover 8,030 7,300 Cost of sales 4,818 J Stocks 1,800 1,392 Bank 40 238 Trade creditors A 370 Accruals 100 120 Gross profit B K Gross profit Margin % C 42% Distribution costs 1,606 1,320 Admin expenses 600 480 Debtors D 800 Net current assets E L Operating profit 1,006 1,266 Interest 200 200 Net Profit F M Net Profit Margin % G N Plant and machinery 4,000 3,960 Ordinary shares of Ghs1 900 900 Retained profit 3,120 O 10% debenture 2,000 2,000 Current assets H 2,430 Current liabilities 1,100 P Equity I 3,500
Capital 1 January 2019 350 000 Drawings 20 000 Sales (70% on credit) 950 000 Gross profit 250 000 Total expenses 80 000 Bank favourable 26 000 Net profit 74 000 Trade creditors 26 000 Property, plant and equipment 350 000 Fixed deposit 20 000 Inventory 72 000 Trade Debtors 80 000 Mortgage Loan 100 000 Calculate the following ratios and explain what each ratio means in relation to the industry average given in brackets. Show your calculations as marks will be awarded for these. Round off to 2 decimal places. Q.2.1.4 Current ratio (2:1).
P&L Acc. for accountant in 31/12/2020 Expenses Revenues Salaries 30,000 Office revenues 30,000 Rent exp. 20,000 Auditing revenues 10,000 Office exp. 10,000 Other exp. 20,000 Total expenses 80,000 Net loss
Pleasantville Company had the following balance sheet on January 1. Pleasantville CompanyBalance SheetJanuary 1 1Cash$175,000.00Accounts Payable$57,000.002Inventory157,000.00Notes Payable250,000.003Property, Plant, and Equipment200,000.00Mortgage Payable150,000.004Patent25,000.00Retained Earnings100,000.005$557,000.00$557,000.00 On January 2, Carrs Company came to an agreement to purchase Pleasantville by acquiring all of its outstanding shares for $575,000 in cash. On that date in time, the fair value of their inventory was $150,000, and the fair value of the equipment was $225,000. The book value equals the fair value for all other accounts listed.Required:1. Compute the goodwill associated with the purchase of Pleasantville.2. Prepare the journal entry necessary at January 2, to record the acquisition of Pleasantville.
Brick & StoneIncome Statement for the year ended 31 December 2016 Notes $ $Sales 2,500,000Cost of Sales 1 1,100,000Gross Profit 1,400,000ExpensesSalaries & Wages 2 760,000Employer NIS Contribution 2,400Rent and Rates 3 240,000Insurance 50,000Maintenance 120,000Depreciation 4…
Read the below information and answer the following questionsINFORMATIONExtract of the Statement of Comprehensive Income for the month ended 31 May 2022Sales 100 000Cost of sales 50 000Rent income 2 500Advertising 5 000Salaries and wages 15 000Rates and taxes 900Other operating expenses 20 000 Additional information1. Sales are expected to increase by 20% each month.2. Thirty percent (30%) of the sales is for cash and the balance is on credit. Collections from credit sales are asfollows:* 30% in the month of the sale, and these customers are entitled to a discount of 5%;* 65% in the month after the sale.The balance is usually written off as bad debts.3. Inventories are kept at a constant level. The business uses a fixed mark-up of 100% on cost. All purchases arefor cash.4. In terms of the lease agreement, the rental…

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

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

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

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

SEE MORE TEXTBOOKS