excel Homework
Jesuis369
excelsheet.xlsxLookup
| FINAL GRADES | |||||
| Name | Score | Final Grade | Grade Distribution | ||
| Mary | 930 | ( | Points | Grade | |
| David | 450 | 0-599 | F | ||
| Tyler | 880 | 600-699 | D | ||
| Brandon | 750 | 700-799 | C | ||
| Rebecca | 320 | 800-899 | B | ||
| Mallory | 650 | 900+ | A | ||
| Carrie | 970 | ||||
| COPY COSTS | |||||
| Copies Made | Total Cost | Number of copies | Price per copy | ||
| 3 | 1 | 0.07 | |||
| 10 | 10 | 0.06 | |||
| 200 | 100 | 0.05 | |||
| 1001 | 200 | 0.04 | |||
| 500 | 0.03 | ||||
| 1000 | 0.02 | ||||
SalesMtg
| Sales Meeting in NY | ||||||||
| Item | Required/Optional | Budget | Actual | Within Budget | Component Cost | Large Meeting | Cause for Concern | No Concern |
| Food | R | $ 250 | $ 185 | |||||
| Hotel | R | $ 500 | $ 525 | |||||
| Transportation | R | $ 100 | $ 40 | |||||
| Theatre Tickets | N | $ 100 | $ 125 | |||||
| Airfare | R | $ 225 | $ 199 | |||||
| Tour Package | N | $ 50 | $ 40 | |||||
| Total | ||||||||
| At least 1 item within budget | ||||||||
| All items within budget | ||||||||
| # of Required items | ||||||||
| # of Optional items | ||||||||
| Sum of Costs for Required Items | ||||||||
| Sum of Costs for Optional Items |
FinancialOptions
| MIS, Inc. | |||||||
| OPTION | Periods per year | Annual Interest Rate | Duration in years | Periodic Payment (PMT) | Present Value (PV) | Future Value (FV) | Annual Payments |
| (1) What will my payments be? | 4 | 6.0% | 5 | $ 500,000 | $ 0 0 | $ - 0 | |
| (2) How much will my savings be worth? | 2 | 5.3% | 20 | $ (50,000) | $ 300,000 | ||
| (3) How much do I need to start? | 12 | 5.8% | 6 | $ (30,000) | $ 2,000,000 | ||
| (4) What is the interest rate? | 12 | 4 | $ (20,000) | $ 1,000,000 | $ 0 0 | $ (240,000) | |
| (5) How long will it take to pay off? | 4 | 6.5% | $ (35,000) | $ 1,000,000 | $ 0 0 | $ (140,000) |
SamsStuffQtr1
| Sam's Stuff 1st Quarter Budget | ||||
| Regular | Sale | Holiday | ||
| Sales Volume: | 2,200 | 2,500 | 3,200 | |
| Selling Price: | $ 45 | $ 39 | $ 35 | |
| Item | Costs per item | Regular Price Total | Sale Price Total | Holiday Price Total |
| Revenue | ||||
| Cost of Goods Sold: | ||||
| Materials | 25% | |||
| Labor | 6% | |||
| Overhead | 4% | |||
| Marketing | 10% | |||
| Subtotal | ||||
| Projected Earnings |
SamsStuffQtr2
| Sam's Stuff 2nd Quarter Budget | ||||
| Regular | Sale | Holiday | ||
| Sales Volume: | 1,950 | 2,250 | 2,100 | |
| Selling Price: | $ 45 | $ 39 | $ 35 | |
| Item | Costs per item | Regular Price Total | Sale Price Total | Holiday Price Total |
| Revenue | ||||
| Cost of Goods Sold: | ||||
| Materials | 25% | |||
| Labor | 6% | |||
| Overhead | 4% | |||
| Marketing | 10% | |||
| Subtotal | ||||
| Projected Earnings |
SamsStuffQtr3
| Sam's Stuff 3rd Quarter Budget | ||||
| Regular | Sale | Holiday | ||
| Sales Volume: | 2,050 | 2,100 | 2,600 | |
| Selling Price: | $ 45 | $ 39 | $ 35 | |
| Item | Costs per item | Regular Price Total | Sale Price Total | Holiday Price Total |
| Revenue | ||||
| Cost of Goods Sold: | ||||
| Materials | 25% | |||
| Labor | 6% | |||
| Overhead | 4% | |||
| Marketing | 10% | |||
| Subtotal | ||||
| Projected Earnings |
SamsStuffQtr4
| Sam's Stuff 4th Quarter Budget | ||||
| Regular | Sale | Holiday | ||
| Sales Volume: | 2,400 | 2,800 | 3,400 | |
| Selling Price: | $ 45 | $ 39 | $ 35 | |
| Item | Costs per item | Regular Price Total | Sale Price Total | Holiday Price Total |
| Revenue | ||||
| Cost of Goods Sold: | ||||
| Materials | 25% | |||
| Labor | 6% | |||
| Overhead | 4% | |||
| Marketing | 10% | |||
| Subtotal | ||||
| Projected Earnings |
BankLoans
| LoanID | First Name | Last Name | City | Loan Date | Amount | Interest Rate | Term | Type |
| 1022 | Eileen | Cooper | Santa Fe | 2/28/16 | 200000 | 0.0700000003 | 15 | Mortgage |
| 1023 | Eileen | Cooper | Santa Fe | 3/21/16 | 150000 | 0.075 | 15 | Mortgage |
| 1024 | Eileen | Cooper | Santa Fe | 3/22/16 | 100000 | 0.0700000003 | 30 | Mortgage |
| 1025 | Scott | Hunter | Taos | 3/1/16 | 25000 | 0.065 | 3 | Automobile |
| 1026 | Scott | Hunter | Taos | 4/1/16 | 10000 | 0.077 | 5 | Automobile |
| 1027 | Ellen | Harper | Albuquerque | 3/11/16 | 200000 | 0.0625 | 15 | Mortgage |
| 1028 | Ellen | Harper | Albuquerque | 3/31/16 | 15000 | 0.065 | 3 | Other |
| 1029 | Ellen | Harper | Albuquerque | 4/15/16 | 25000 | 0.0775 | 4 | Automobile |
| 1030 | Ellen | Harper | Albuquerque | 5/1/16 | 150000 | 0.0575 | 15 | Mortgage |
| 1031 | Max | Entermann | Santa Fe | 1/15/16 | 475000 | 0.0575 | 15 | Mortgage |
| 1032 | Max | Entermann | Santa Fe | 1/23/16 | 35000 | 0.0675 | 5 | Automobile |
| 1033 | Max | Entermann | Santa Fe | 1/31/16 | 12000 | 0.0825 | 10 | Other |
| 1034 | Max | Entermann | Santa Fe | 5/3/16 | 350000 | 0.08 | 30 | Mortgage |
| 1035 | Helen | Rayus | Albuquerque | 1/25/16 | 10000 | 0.055 | 3 | Automobile |
| 1036 | Helen | Rayus | Albuquerque | 3/1/16 | 20000 | 0.075 | 5 | Other |
| 1037 | Ted | Myerson | Santa Fe | 2/8/16 | 525000 | 0.065 | 30 | Mortgage |
| 1038 | Peter | Sanger | Albuquerque | 2/12/16 | 10500 | 0.06875 | 5 | Other |
| 1039 | Peter | Sanger | Albuquerque | 5/8/16 | 275000 | 0.06 | 15 | Mortgage |
| 1040 | Rose | Budnick | Taos | 2/20/16 | 250000 | 0.0575 | 30 | Mortgage |
| 1041 | Rose | Budnick | Taos | 2/21/16 | 5000 | 0.0875 | 3 | Other |
| 1042 | Rose | Budnick | Taos | 4/18/16 | 41000 | 0.075 | 4 | Automobile |
| 1043 | Austin | Powers | Albuquerque | 3/3/16 | 56000 | 0.0725 | 5 | Automobile |
| 1044 | Barbara | Ringer | Taos | 2/15/16 | 35000 | 0.06 | 5 | Other |
| 1045 | Barbara | Ringer | Taos | 3/10/16 | 129000 | 0.0575 | 15 | Mortgage |
| 1046 | Barbara | Ringer | Taos | 4/22/16 | 350000 | 0.065 | 15 | Mortgage |
