AveryCollinsKinsleyMcDonnoughRossShannon2012 Total Sales by AgentJanuary - JuneJanuaryFebruaryMarchApril$ 3,671 $ 2,973 $ 4,017 $ 5,040 $$ 1,549 $992$$2,267 $ 3,201 $2,996 $ 6,948 $ 4,205 $ 5,523 $2,003 $ 4,190 $ 3,496 $$ 4,038 $ 2,064 $ 7,015 $$ 1,172 $ 866 $2,109 $$Task 5Create Line sparklines in column Hin the Summary sheet to display six-month trends for each agent. Showthe high point in each sparkline.Task 7Create a footer with your fullname on the left side, the filename in the center, and theDate on the right side of eachsheet (Part_1 and Part_2).MayJune4,963 $ 5,4974,008 $ 3,7986,597 $ 5,1471,975 $ 2,936 $ 3,4986,832 $ 5,971 $ 5,4973,385 $ 4,078 $ 3,598TrendsBonus$BonusTask 6Insert an IF function in column I that displaysa $600 bonus if an agent's average sales aregreater than the average of all sales for thesix months. Use two nested AVERAGEfunctions in the logical_test argument of theIF function to make the comparison. Use cellreference for Bonus.600

Name: AveryCollinsKinsleyMcDonnoughRossShannon2012 Total Sales by AgentJanu
Uploaded: 2024-03-05T11:42:36.000Z
Channel: Bartleby
Description: AveryCollinsKinsleyMcDonnoughRossShannon2012 Total Sales by AgentJanuary - JuneJanuaryFebruaryMarchApril$ 3,671 $ 2,973 $ 4,017 $ 5,040 $$ 1,549 $992$$2,267 $ 3,201 $2,996 $ 6,948 $ 4,205 $ 5,523 $2,003 $ 4,190 $ 3,496 $$ 4,038 $ 2,064 $ 7,015 $$ 1,

Average function of excel is used to calculate the average of the data, whose reference cell is…

Business

Finance

Avery Collins Kinsley McDonnough Ross Shannon January February March April May June $ 3,671 $ 2,973 $ 4,017 $ 5,040 $ 4,963 $5,497 $ 3,798 $ 1,549 $ 992 $2,267 $ 3,201 $ 4,008 2,996 $ 6,948 $4,205 $ 5,523 $ 6,597 $5,147 $3,496 $ 1,975 $ 2,936 $ 3,498 $ $ 2,003 $ 4,190 $ 4,038 $ 2,064 $ 7,015 $ 6,832 $ 5,971 $ 5,497 $ 1,172 $ 866 $2,109 $ 3,385 $ 4,078 $ 3,598 Trends Bonus

Avery Collins Kinsley McDonnough Ross Shannon January February March April May June $ 3,671 $ 2,973 $ 4,017 $ 5,040 $ 4,963 $5,497 $ 3,798 $ 1,549 $ 992 $2,267 $ 3,201 $ 4,008 2,996 $ 6,948 $4,205 $ 5,523 $ 6,597 $5,147 $3,496 $ 1,975 $ 2,936 $ 3,498 $ $ 2,003 $ 4,190 $ 4,038 $ 2,064 $ 7,015 $ 6,832 $ 5,971 $ 5,497 $ 1,172 $ 866 $2,109 $ 3,385 $ 4,078 $ 3,598 Trends Bonus

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

Q36 Goods of the Invoice value R240 000 sent out to consignee at 20% profit on cost. If all goods were sold, what would be the gross amount? Select one: a. R48 000 b. R50 000 c. R40 000 d. R33 333
The following accounting records reveal: A/R, beg. P100,000 Iny, beg. P50,000 Purchases P90,000 Purchases Discount P5,000 Collections P200,000 How much is the vatable sales? a. P250,000 b. P240,000 How much is the output vat? a. P27, 600 b. P28,800 A/R, end Iny, end Sales Sales Return Cost of Sales. c. P230,000 c. P30,000 P110, 000 P60,000 P250,000 P10,000 P70,000 d. P24,000 d. P200,000
Aging of Accounts Receivable Presented below is the Accounts Receivable Subsidiary Ledger of Martian Corporation, a customer of Planetarium Company, from January 1to June 5, 2021: Martian Corporation P 20,000 Customer Credit Limit Terms 2/10, n/30 - Reference Date Particulars Doc. No. Debit Credit Balance 2021 01 Balance forwarded 07 Sales 12 Cash Jan. 9,200 INV 767 5,000 14,200 OR 1307 5,000 9,200 20 Sales INV 800 1,200 10,400 28 Sales - Cash INV 965 1,060 11,460 OR 1518 9,200 2,260 - Feb. 15 Sales INV 970 1,220 3,480 18 Sales INV 1001 1,400 4,880 22 DM for INV No. 800 05 Cash DM 217 72 4,952 OR 1689 2,332 2,620 27 Sales INV 1113 836 3,456 Freight DM 223 120 3,576 28 Cash OR 1718 1,400 2,176 3,736 2,516 Mar. 02 Sales INV 1206 1,560 15 Cash OR 1790 1,220 28 Sales INV 1491 2,594 5,110 29 Cash OR 1868 956 4,154
Operating expenses $ 50000 Sales returns and allowances 6000 Sales discounts 5000 Sales revenue 140000 Cost of goods sold 86000 The amount of net sales on the income statement would be $140000. $135000. $129000. $134000.
J Gross Sales Sales Return & Allowances Sales Discounts Cost of Merchandise Sold 33,000 O $87,000 O $46,000 100,000 Given the above values, determine Net Sales. O $67,000 10,000 O $54,000 3,000 Need help? Review these concept resources.
15. Sales revenue P480,000 Cost of goods sold Sales discounts 300,000 20,000 15,000 Sales returns and allowances Operating expenses 85,000 Interest revenue 5,000 A.What is net sales revenue? a. P400,000 b. P445,000 P415,000 d. P455,000 с. B.What is gross margin? а. Р145,000 b. P105,000 C. P140,000 d. P90,000
YE3tcuBfirwShOSzu2prZ7nd44k0L-w/formResponse?pli=1 e following to answer the five questions below: owing accounts are extracted from the worksheet of X Company on ber 31, 2020 Sales Retums and Allowances S 410,000 Sales Discount 140,000 Sales 1,500,000 Salaries Expenses - Sales 52,000 Rent Revenue 22,000 Purchases Retums and Allowances 120,000 Purchases 600,000 Loss from write down of Inventory 17,000 Inventory, January 1, 2020 460,000 Interest Expense A 55,000 Gain from Sale of Building 23,000 Freight-out 14,000 Freight-in 30,000 Depreciation Expense - Sales 22,000 Cost of Goods Sold 600,000 n the data above, the inventory account sho ed a holon
If the sales revenue 830 000 ID , - 10 sales returns 12 000 ID , sales allowance and discount 28 O00 ID * -: ,the net sales is 709 000 ID . O 790 000 ID . 970 000 ID. O
QUESTION 6 Use the information below to answer. If total sales are $18,800 what is the MD%? Style # QTY Orig Retail Sale Price 1000 120 $50.00 $29.99 1200 150 $38.00 $29.99 1300 144 $44.00 $29.99 1400 96 $54.00 $29.99
calculate the following Apple Mark -up 25% sales 50 000 Inventory 01.03.2019 13 800 Inventory 29.02.2020 7 450 Total Expenses 9 500 Calculate: Gross profit, Purchases, Cost of Sales and Net Profit
Question 18 and 19: Presented below is information related to Carnation with, Incorporated: Cost P 250,000 898,500 60,000 18,000 Retail P 390,000 1,460,000 80,000 Inventory, January 1, 2015 Purchases Purchase returns Purchase discounts Sales (net of 2% discounts) Sales returns 0- -0- -0- 80,000 1,234,800 95,550 -0- Freight-in 18. Assuming that Camation, Inc, uses the average retail inventory method, how much would be the cost of its ending inventory at December 31, 2015? 19. Assuming that Carnation, Inc. uses the FIFO retail inventory method, how much would be the cost of its ending inventory at December 31, 20157
Sales Sales Returns & Allowances Sales Discount Purchases Freight in Purchase Renurns & Allowances Purchase Discount Beginning Inventory Ending Inventory Operating expenses Other Income Otber Expenses P 780,000 15,000 19,000 420,000 12,000 8,000 2,000 50,000 80,000 120,000 16,000 3,000 How much is the cost of goods available for sale? P 4E0.000 P 472,000 P448,000 P 470,000

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