Get Data (Power X F28 Query) 7 Refresh All Data Types Sort & Filter Data Tools...

Transcribed Image Text:

Get Data (Power X F28 Query) 7 Refresh All Data Types Sort & Filter Data Tools What-If Outline Analysis Office Update To keep up-to-date with security updates, fixes, and improvements, choose Chec X fx A B C D E F 1 Table 1: Financial results for August 2019 (000) 2 4 REVENUE 5 Wedding Invitations August September October November December $ St 4,507 $ 4,765 $ 5,038 $ 5,327 $ 5,632 6 Birthday Party Invitations $ 3,841 $ 4,159 $ 4,503 $ 4,875 $ 5,278 7 Business Party Invitations $ 2,652 $ 2,750 $ 2,851 $ 2,957 $ 3,066 8 Total Sales Revenue $ 11,000 $ 11,674 $ 12,392 $ 13,158 $ 13,976 9 10 EXPENSES 11 Printing Costs 12 Salaries 13 Administration 14 Advertising 15 Legal Fees 16 Shipping 17 Total Expenses $ 4,400 $ 4,670 $ 4,957 $ 5,263 $ 5,590 $ 3,500 $ 3,500 $ 3,500 $ 3,500 $ 3,500 $ 550 $ 584 $ 620 $ 658 $ 699 $ $ sss $ 1,544 $ 1,611 $ 1,682 $ 1,755 $ 1,831 788 $ 807 $ 827 $ 848 $ 868 928 $ 988 $ 1,053 $ $ 11,710 $ 12,160 $ 12,638 $ 1,121 $ 13,145 $ 1,194 13,683 18 19 Net Income Before Taxes $ 20 Taxes (710) $ $ (487) $ (246) $ 13 $ 293 $ $ 4 $ 82 21 Net Profit (Loss) $ (710) $ (487) $ (246) $ 10 $ 211 22 23 24 Group Number 6 25 PROJECTED GROWTH PER MONTH % 26 Wedding Invitations 5.73 27 Birthday Party Invitations 8.27 28 Business Party Invitations 3.69 29 Advertising 30 Legal Fees 31 Shipping 32 December Increase Goal 4.36 SOLVER 2.46 GOAL 6.51 18.82 $ 250.35 33 BUDGET DISTRIBUTION Ready Accessibility: Investigate + GROUP ASSIGNMENTS SOLVER SALE L Get Data (Power X F28 Query) 7 Refresh All Data Types Sort & Filter Data Tools What-If Outline Analysis Office Update To keep up-to-date with security updates, fixes, and improvements, choose Chec X fx A B C D E F 1 Table 1: Financial results for August 2019 (000) 2 4 REVENUE 5 Wedding Invitations August September October November December $ St 4,507 $ 4,765 $ 5,038 $ 5,327 $ 5,632 6 Birthday Party Invitations $ 3,841 $ 4,159 $ 4,503 $ 4,875 $ 5,278 7 Business Party Invitations $ 2,652 $ 2,750 $ 2,851 $ 2,957 $ 3,066 8 Total Sales Revenue $ 11,000 $ 11,674 $ 12,392 $ 13,158 $ 13,976 9 10 EXPENSES 11 Printing Costs 12 Salaries 13 Administration 14 Advertising 15 Legal Fees 16 Shipping 17 Total Expenses $ 4,400 $ 4,670 $ 4,957 $ 5,263 $ 5,590 $ 3,500 $ 3,500 $ 3,500 $ 3,500 $ 3,500 $ 550 $ 584 $ 620 $ 658 $ 699 $ $ sss $ 1,544 $ 1,611 $ 1,682 $ 1,755 $ 1,831 788 $ 807 $ 827 $ 848 $ 868 928 $ 988 $ 1,053 $ $ 11,710 $ 12,160 $ 12,638 $ 1,121 $ 13,145 $ 1,194 13,683 18 19 Net Income Before Taxes $ 20 Taxes (710) $ $ (487) $ (246) $ 13 $ 293 $ $ 4 $ 82 21 Net Profit (Loss) $ (710) $ (487) $ (246) $ 10 $ 211 22 23 24 Group Number 6 25 PROJECTED GROWTH PER MONTH % 26 Wedding Invitations 5.73 27 Birthday Party Invitations 8.27 28 Business Party Invitations 3.69 29 Advertising 30 Legal Fees 31 Shipping 32 December Increase Goal 4.36 SOLVER 2.46 GOAL 6.51 18.82 $ 250.35 33 BUDGET DISTRIBUTION Ready Accessibility: Investigate + GROUP ASSIGNMENTS SOLVER SALE L