Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello! I need the answer for this excel work: Fireball Technology CompanyFireball Technology Company is a small startup company that performs accounting, computing, and financial

Hello! I need the answer for this excel work:

Fireball Technology Company\Fireball Technology Company is a small startup company that performs accounting, computing, and financial work for nonprofit organizations. Your job was to create a spreadsheet that would keep track of salary expenditures including benefits. You need to complete the spreadsheet using lookup functions for the benefits. Fireball Technology pays a percentage of the employee\'92s salary into a pension fund and toward health insurance based upon the benefit code of the employee. The company also makes a monetary contribution for any employee using daycare based on the same benefit code. You will also need to create charts for management, and format the spreadsheet for easier understanding.}

image text in transcribed Fireball Technology Company Salary and Benefit Expenditures EmployeeBenefits Code Need Daycare Salary Pension Costs Health Insurance CostsCosts Daycare Total Employee Cost 1 2 No 39100 2 1 Yes 37150 3 3 Yes 32500 4 3 Yes 34000 5 1 No 35650 6 2 No 42500 7 3 Yes 29900 8 3 No 34000 9 3 No 30450 10 1 No 35200 11 3 Yes 33000 12 3 Yes 28600 13 2 Yes 36000 14 2 No 37300 15 3 No 34000 16 1 Yes 36500 17 3 Yes 33000 18 3 Yes 34000 19 1 No 34500 20 3 Yes 34000 21 3 Yes 30000 22 2 No 40000 23 2 No 36000 24 2 No 37000 25 1 Yes 42850 26 1 Yes 42000 27 1 No 44000 28 1 No 40660 29 2 No 44000 30 1 Yes 48500 31 1 Yes 42000 32 2 No 47500 33 2 No 47000 34 1 Yes 48500 35 2 No 52500 36 1 Yes 62520 37 1 Yes 61250 38 1 No 57000 39 2 No 58500 40 1 Yes 60050 41 2 No 72000 Summary Statistics: Number of Employees: Lowest Total Employee Cost: Average Total Employee Cost: Maximum Total Employee Cost: Median Total Employee Cost: Today's Date: Benefits Code Pension 1 0.05 2 0.075 3 0.03 Health Insurance 0.3 0.25 0.1 Daycare Contribution 5000 4000 1000 Fireball Technology Company Earnings Summary Division Computer Division Accounting Division Financial Division Quarter 1 Quarter 2 Quarter 3 Quarter 4 $42,125 $35,528 $43,187 $39,254 $33,522 $35,220 $38,454 $40,210 $21,358 $24,523 $25,383 $27,354 Trend

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Frederic S. Mishkin, Stanley G. Eakins

9th Edition

0134519264, 9780134519265

More Books

Students also viewed these Finance questions

Question

Annoyance about a statement that has been made by somebody

Answered: 1 week ago