{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

View Full Document Right Arrow Icon
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
Image of page 1

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

View Full Document Right Arrow Icon
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
Image of page 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
Image of page 3

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

View Full Document Right Arrow Icon
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
Image of page 4
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
Image of page 5

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

View Full Document Right Arrow Icon
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
Image of page 6
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
Image of page 7

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern