corporate profits sum The sales purchases experses profit 4% tax I profit all compares) 1000 5000 8000 68000 77500 8000 75000 90000 3000 2000 19500 1500 19500 5 Isra 3 2700 53200| 48500 | nouns 4 12000 19500 480 6. 2000 19500 7 5 right | 66000 76000 8000 2000 19500 8 10 To find the lowest profit for companies, we use the following function: =MIN(G3:G7) 1 =MIN(D3:G3) =MIN(G1:65) =MIN(F3:F7) =MAX(G1:G5) all mentioned To find the tax for the Isra company at 4%*: we use the following equation 2 To find the total profit for all companies we use *: the following function =480*4% 3 =SUM(G1:65) = 12000/100*4 SAM(G3:G7) =12000/0.04 all mentioned O =SUM(G3:G7) =480*0.04 O =SUM(E3:E7) 19500/0.04= =SUM(F3:F7) all mentioned
corporate profits sum The sales purchases experses profit 4% tax I profit all compares) 1000 5000 8000 68000 77500 8000 75000 90000 3000 2000 19500 1500 19500 5 Isra 3 2700 53200| 48500 | nouns 4 12000 19500 480 6. 2000 19500 7 5 right | 66000 76000 8000 2000 19500 8 10 To find the lowest profit for companies, we use the following function: =MIN(G3:G7) 1 =MIN(D3:G3) =MIN(G1:65) =MIN(F3:F7) =MAX(G1:G5) all mentioned To find the tax for the Isra company at 4%*: we use the following equation 2 To find the total profit for all companies we use *: the following function =480*4% 3 =SUM(G1:65) = 12000/100*4 SAM(G3:G7) =12000/0.04 all mentioned O =SUM(G3:G7) =480*0.04 O =SUM(E3:E7) 19500/0.04= =SUM(F3:F7) all mentioned
Fundamentals of Information Systems
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter7: Knowledge Management And Specialized Information Systems
Section: Chapter Questions
Problem 8SAT
Related questions
Question
I need the answer as soon as possible
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
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
Recommended textbooks for you
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning