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

Fundamentals of Financial Management (MindTap Course List)

15th Edition

ISBN:9781337395250

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter4: Analysis Of Financial Statements

Section: Chapter Questions

Problem 24P: Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of...

See similar textbooks

Similar questions

PROBLEM 2Determine the missing elements of the Income Statement. Replace the letters with your answers.The partial income statements of five different companies are as follows: 12345 Net SalesAD250,000290,000400,000 Merchandise Inventory, 1/1/2020B50,00070,000J120,000 Net Cost of Purchases80,000EG160,000390,000 Goods Available for Sale110,000160,000HKM Merchandise Inventory, 1/1/202040,000F30,00070,000N Cost of Goods SoldC140,000230,000L380,000 Gross Profit50,00040,000I160,000O
Sales $ 150,000 $ 550,000 $ 38,700 $ 255,700 Sales discounts 5,000 17,500 600 4,800 Sales returns and allowances 20,000 6,000 5,100 900 Cost of goods sold 79,750 329,589 24,453 126,500 Compute net sales, gross profit, and the gross margin ratio for each of the four separate companies. (Round your gross margin ratio to 1 decimal place; i.e.; 0.2367 should be entered as 23.7%.) Company columns from above. A. Carrier B. Lennox C. Trane D. York Net sales Gross profits Gross margin ratio
38 BB Corp.’s accounts receivable subsidiary ledger shows the following information: Customer Account BalanceDecember 31, 2022 Sales Invoices Date Amount Pray Inc. P 35,180 12/6/2022 P 14,000 11/29/2022 21,180 Patience Co. 20,920 9/27/2022 12,000 8/20/2022 8,920 Love Corp. 30,600 12/8/2022 20,000 10/25/2022 10,600 Happy Co. 45,140 11/17/2022 23,140 10/9/2022 22,000 Kindness Corp. 31,600 12/12/2022 19,200 12/2/2022 12,400 Gentleness Inc. 17,400 9/12/2022 17,400 The estimated bad debts rates below are based on BB’s receivable collection experience. Age of Accounts Rate 0 -30 days 1.00% 31- 60 days 1.50% 61-90 days 3.00% 91 - 120 days 10.00% over 120 days 50.00% The allowance for bad debts had beginning balance of P6,500. Statement 1: The net realizable value of the accounts receivable at December 31, 2022 is P165,170. Statement 2:…
17.The following data pertain to a particular item sold by Pomegranate Company.8/1 – Beg. invy: 2,000 @ P50=100,0008/8 – Purchases: 9,000 @ P52=468,0008/10 – Sales: 1,500 @ P105=157,5008/14 – Purchases: 3,000 @ P55=165,0008/20 – Sales: 8,000 @ P110=880,0008/29 – Purchases: 1,500 @t P59=88,500Using the weighted average method, how much is the gross profit during the month of August? a. 503,500 b. 534,000 c. 553,000 d. 318,000
Beginning inventory 32 000 Cost of goods sold 404 000 Ending inventory 45 000 Net icome 28 000 Net sales 750 000 Operating expenses 220 000 Sales revenue 765 000 Compute each of the follwoing ratios Gross profit rate Inventory turnover Days in inventory Profit ma
ANSWER ASAP THANKS! Company's cost of sales is 125% of gross profit. If Sales amounts to 400,000, and Net Income is 40%. Compute for: Cost of Sales, Gross Profit, and Operating Expense.
lf the cost of purchases 130 000 lD., sales revenue 200 000 lD.,beginning inventory 20 000 lD.,sales discount 25 000 lD.,sales returns 50 000 lD.,ending inventory 25 000 lD . , the cost of goods sold are :- * 220 000 lD. 195 000 lD . 125 000 lD . 70 000 lD .
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.
Calculate the following Apple Mark - up 25% Sales 50 000 Inventory 01.02.2020 13 800 inventory 29.02.2020 7 450 Total expenses 9 500 Calculate : Gross Profit, Purchases, Cost of sales, Net Profit
35.The following data were available for ABC Corp at Dec 31, 20X2:Net purchases P345,000Inventory, Dec 31 P11,000Gross Sales, 446,250Sales returns, P10,000Gross profit is 25% of costHow much was the beginning inventory during the year? 23,000 15,000 7,000 1,000
The following relates to a single sale of goods made by Spurs in 2023: Selling price P500,000Freight costs 5,000Terms 3/15, n/30Shipping Date December 28, 2023Date goods received by the customer January 3, 2024Date payment is received by Spurs January 5, 2024 Question:9. If the term is FOB destination, how much sales should be recorded by Spurs for the year ended December 31, 2023? a. P0b. P490,000c. P495,000d. P500,000
cushman company had 834,000 in sales sales discount of 12510 sales returns and allowness of 18765 cost of goods sold of 396150 and 286895 in operating expenses net income equals what 802725 150955 406575 119680 182230