Please answer questions J through M based on fig.1. Question L can be referred to from fig.2

fig.1

fig.2

j. Complete the formulas in cells provided for revenues* for 2019. 2019 revenues have increased by % over 2018 values.

k. Using the correct function or formula calculate the total revenue and gains in the cells provided. Insert the comment, Discuss with CEO and Import Team in the cell containing the words Total revenues and gains.

l. Complete the formulas in cells provided for expenses for 2019. 2019 expenses** have decreased by % over 2018 values with the exception of computer expenses*** which should be used from the Green Savings worksheet.

m. Using the correct function or formula calculate the total expenses and losses in the cells provided.

rearna brown - X File Home Incen Page Layout Formules Share Ang -A asset_mgmt000_opers 2140 - Lacel Data Beiru WEN Hels Time what you want to do Wrap lext General 12 Normal Hau Good Neutral = = = SM Merge Cente. # Conditional Format Check Cell Exploratory... Falk wil. Hulk Fummalling Tobie Algement Nu Xar Copy Format Painter Calculation Parte input Inset Delete commet Atom- - Sort & Find Clear Filur. Si Edring Clipboard Fan Cell N7 F G 1 J K L M N o H 30% 2019 A B D E 2 2 COMPARITIVE INCOME STATEMENT 3 for years ended 31 December 4 5 2018 6 Revenues and gains 7 *Sales revenue 8 *Interest revenue 9 *Investment Income 10 Other revenue 11 Total revenue and gains 12 13 Expenses and losses 14 **Cost of goods sold 460,000 15 **Selling and admin administrative 195,000 16 ***Computer (operating) 17 **Depreciation 55,000 18 **Interest expense 25,200 19 Total expenses and losses 735,200 20 Income before taxes 21 Income tax expense (30%) 22 Net Income 23 24 Employee Department Contacts Green Savings Quarterly Revenue - 2018 Statement of Income Aggregates Quarterly Revenue Chart - 2018 + 17054 Type here to search O AD 3-45 PM 5019/2000 rearna brown - X File Home Insert Page Layout Formules Share - 9 Ang A asset_mgmt000_opers 2140 - Lacel Data Beie Vir Hels Tel me what you want to do Wrap lext General 12 Num Hau Good Neutral = = = Merge Cente. $. # Conditonal Format Check Cell Exploratory... Fwd. Hulk Furmatting Table Algement NUTI Calculation Xar Copy Paste Format Pantai Clipboard H- input InsetDelete comme Clear Sort & Find Filur Ski Edring Fan Call HIS G H 1 J L A B D E F 1 Engery Cost Savings (Green Computing) The below data represents cost (expenses) and savings for Storme Imports Company (SIC) for all organizational computer use for 2018 and 2019. FRI 2 implemented a green computer initiative in January 2019. 3 Operating Cost General Green Computer Computer 4 Computer type Use (2018) Use (2019) Savings 5 Notebook Dual Core 18490 9500 $ 8,990 6 Notebook Quad Core 20500 11500 $ 9,000 7 PC Dual Core 34500 21200 $13,300 8 PC Core Duo 40000 25450 $ 14,550 9 Servers Core Duo 25000 16550 $ 8,450 10 Servers 4 Core Duo 30000 12450 $ 17,550 11 Servers Xeon Quad Core 18500 9500 $ 9,000 12 Total $ 186,990 $ 106,150 $80,840 13 14 15 16 17 Green Savings Quarterly Revenue - 2018 Sistement of Income Aggregates Quarterly Revenue Chart - 2018 Employee Department Contacts + + + 2106 Type here to search O 3:44 PM 10/12/2000