{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Unit 2 Homework Solutions

# Unit 2 Homework Solutions - Klassy Kow Sales Staff November...

This preview shows pages 1–9. Sign up to view the full content.

Klassy Kow Sales Staff November Bonus Pay Sales Representative \$ Sales Bonus This Month? \$ Bonus Anderson, Michael 55,000 No Carlson, Juan 45,000 No Dugan, Mary 75,000 Yes 1,875 Evans, William 65,000 Yes 1,625 Jenkins, Robert 52,000 No Yoto, Hashima 65,000 Yes 1,625 Adruisus, Dina 50,000 No Ara, Hassan 85,000 Yes 2,125 Solution 7.2

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Sales Representative \$ Sales Bonus This Month? \$ Bonus Anderson, Michael 55000 =IF(B4>60000,"Yes","No") =IF(C4="yes",B4*2.5%,"") Carlson, Juan 45000 =IF(B5>60000,"Yes","No") =IF(C5="yes",B5*2.5%,"") Dugan, Mary 75000 =IF(B6>60000,"Yes","No") =IF(C6="yes",B6*2.5%,"") Evans, William 65000 =IF(B7>60000,"Yes","No") =IF(C7="yes",B7*2.5%,"") Jenkins, Robert 52000 =IF(B8>60000,"Yes","No") =IF(C8="yes",B8*2.5%,"") Yoto, Hashima 65000 =IF(B9>60000,"Yes","No") =IF(C9="yes",B9*2.5%,"") Adruisus, Dina 50000 =IF(B10>60000,"Yes","No") =IF(C10="yes",B10*2.5%,"") Ara, Hassan 85000 =IF(B11>60000,"Yes","No") =IF(C11="yes",B11*2.5%,"") Solution 7.2
Klassy Kow Ice Cream, Inc. Asset Depreciation for Milk Tanks DB Method Cost \$250,000 Salvage \$10,000 Life in Years 10 1st Year \$68,750.00 2nd Year \$49,843.75 3rd Year \$36,136.72 4th Year \$26,199.12 5th Year \$18,994.36 6th Year \$13,770.91 7th Year \$9,983.91 8th Year \$7,238.34 9th Year \$5,247.79 10th Year \$3,804.65 Solution 7-19 [Student Name] Sol7-19.xls Sheet1 9/26/2005

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Klassy Kow Ice Cream, Inc. Asset Depreciation for Milk Tanks DB Method Cost 250000 Salvage 10000 Life in Years 10 1st Year =DB(B4,B5,B6,1) 2nd Year =DB(\$B\$4,\$B\$5,\$B\$6,2) 3rd Year =DB(\$B\$4,\$B\$5,\$B\$6,3) 4th Year =DB(\$B\$4,\$B\$5,\$B\$6,4) 5th Year =DB(\$B\$4,\$B\$5,\$B\$6,5) 6th Year =DB(\$B\$4,\$B\$5,\$B\$6,6) 7th Year =DB(\$B\$4,\$B\$5,\$B\$6,7) 8th Year =DB(\$B\$4,\$B\$5,\$B\$6,8) 9th Year =DB(\$B\$4,\$B\$5,\$B\$6,9) 10th Year =DB(\$B\$4,\$B\$5,\$B\$6,10) Solution 7-19 [Student Name] Sol7-19.xls Sheet1Formulas 9/26/2005
Klassy Kow Ice Cream Shops Customer Birthday List Name Shop Favorite Flavor Male/Female Chocolat Marian Most Las Vegas, Green Chocolate F Yes Tommy Dunne Lake Las Vegas Bubble Gum Goo M Other Luella Orr Carson City Chocolate F Yes Patrick Adams Reno Vanilla M Other Asata Akai Henderson Strawberry F Other Efren Aldo Las Vegas, Sunnydale Chocolate M Yes Solution 7-24 [Student Name] Sol7-24.xls CustBirthdays 9/26/2005

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Klassy Kow Ice Cream Shops Customer Birthday List Name Shop Favorite Flavor Male/Female Choc Marian Most Las Vegas, Green Chocolate F =IF(C4="chocolat Tommy Dunne Lake Las Vegas Bubble Gum Goo M =IF(C5="chocolat Luella Orr Carson City Chocolate F =IF(C6="chocolat Patrick Adams Reno Vanilla M =IF(C7="chocolat Asata Akai Henderson Strawberry F =IF(C8="chocolat Efren Aldo Las Vegas, Sunnydale Chocolate M =IF(C9="chocolat Solution 7-24 [Student Name] Sol7-24.xls CustBirthdaysFormulas 9/26/2005
Klassy Kow Salary Increase and Service Awards Based on Performance Ratings Last Name First Name Years of Service Performance Rating Eligible for Increase Eligible for Award Kraus Heinrich 5 3 FALSE TRUE Stewart Kathleen 1 3 FALSE FALSE Ladewig Glenn 2 2 FALSE FALSE McDonald Robin 3 4 TRUE TRUE Sante Juan 5 4 TRUE TRUE Sumara Keiko 1 3 FALSE FALSE Steele Marietta 7 3 FALSE TRUE Eassa Nassar 4 4 TRUE TRUE Steinbeck Sarah 4 2 FALSE FALSE Artagnan Ted 2 4 FALSE TRUE Calcivechia Maria 5 3 FALSE TRUE Alverez Toni 1 4 FALSE TRUE Nguyen Luni 1 3 FALSE FALSE Solution 7-26 [Student Name] Sol7-26.xls SalaryProjections 9/26/2005

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Klassy Kow Salary Increase and Service Award Based on Performance Ratings Last Name First Name Years of Service Performance Rating Eligible for Increase
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern