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

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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 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 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 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...
View Full Document

This note was uploaded on 10/30/2010 for the course FINANCE Excel taught by Professor Vahn during the Spring '10 term at City College of San Francisco.

Page1 / 121

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

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online