Excel Assignment Winter 2011-Antoine Tardif

Excel Assignment Winter 2011-Antoine Tardif - Assignment 1...

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

View Full Document Right Arrow Icon
Assignment # 1 - Excel - Winter 2011 Change the values in the tables below, per instructions. Note: Often in team work, one of the two students will do most of the work. Don't find yourself short changed for your midterm. Furthermore, plagiarism, i.e. the copying of this assignment will not be tolerated and is strictly enforced. The tables below are used in Step 1 Green Copy Centre Sales Order No Puchase Date Cust ID Salesman # Task ID Quantity Payment date 889 2/Sep/10 200 300 COL75 251 2/Sep/10 2604 890 5/Sep/10 250 101 LAM10 100 5/Nov/10 19801 891 18/Sep/10 225 300 FOL25 1500 19/Nov/10 14617 892 26/Sep/10 175 101 LAM10 249 22/Dec/10 8509 893 29/Sep/10 175 125 COL75 2539 28/Dec/10 9181 894 1/Sep/10 300 300 FOL35 4000 19/Sep/10 13935 895 1/Oct/10 225 125 COL75 875 17/Oct/10 8578 896 12/Oct/10 250 101 COL75 1250 13/Nov/10 19070 897 14/Oct/10 300 125 FOL25 500 2/Jan/11 9238 898 15/Oct/10 225 300 LAM10 99 15/Oct/10 14818 899 23/Oct/10 175 125 PHO85 50 19/Nov/10 15286 900 2/Dec/10 175 101 FOL25 49 1/Apr/11 7271 901 17/Dec/10 225 245 FOL35 999 4/Mar/11 2729 Cust ID Cust Name Prov Salesman # 101 125 245 300 175 Mike Cameron NB Name Your Own Name Partner (if one) Agnes Alverez David Richter 200 Robert Lasalle QC 5.00% 3.27% 5.00% 8.00% 225 Your name QC 8.50% 4.13% 7.50% 12.00% 250 Aaron Cinco ON 300 Thanura Leung NS Task ID Task Description Province Sales tax COL75 Collating $0.280 $0.273 $0.259 $0.239 NS 12.45% FOL25 Folding $0.248 $0.227 $0.213 $0.199 NB 12.35% FOL35 Folding $0.443 $0.424 $0.411 $0.407 ON 11.95% LAM10 Laminating $18.500 $17.890 $16.350 $14.259 QC 12.11% PHO85 Photo prints $0.185 $0.169 $0.147 $0.123 This assignment is to be uploaded as an Excel file to webct by the posted deadline. It can be done on your own or as a team of 2 students (for the latter, the 2 need not be in the same section). Note: When you first start, use the File Save As to name your workbook: Excel Assignment with Your own name. Note: You can work with any version of Excel. Random number for instructor Commission % if Sales >500 and <1,000 Commission % if Sales >=1,000 Change Cust ID 225 to your own name (first, last). For a team use 1 name. As well, in the table above, change your own name and possibly the Partner name for Salesman # 101 & 125 respectively. Unit cost Quantity<5 0 units Unit cost Quantity >= 50 and <250 Unit cost Quantity >= 250 and <1,000 Unit cost Quantity >= 1,000 units
Image of page 1

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

View Full Document Right Arrow Icon
Monday Antoine Tardif 260440232 Green Copy Centre Sales Complete all other columns with formulas (expressions). Order No 889 890 891 892 893 894 895 896 897 898 899 900 901 From pick list select your class. Enter your full name (last + first names) & your partner's name, if you have one. Enter your student number(s) to the right.
Image of page 2
Data for Step 2, 3 and 4. Note: This table is to be used as the starting point for Step 2 (i.e. do all your work here). Date Month Genus Species Sex City Profit Supplier 45 17-Dec-10 Dec Conure Maroon-Bellied U Dollard 285 474 189 Independant 320 2 2-Oct-10 Oct Conure Maroon-Bellied U Dollard 220 294 74 Royal Bird Co 345 15 27-Oct-10 Oct Conure Green-cheek U Dorval 200 406 206 Pet Bird Co 518 8 11-Sep-10 Sep Lovebird Peach-Face U Montreal 100 257 157 Royal Bird Co 552 36 24-Oct-10 Oct Parrot African Grey U Verdun 750 942 192 Pet Bird Co 775 10 9-Oct-10 Oct Conure Jendaya F Montreal 400 454 54 Independant 1,097 32 20-Dec-10 Dec Lovebird Pied U Montreal 40 194 154 Independant 1,861 17 10-Sep-10 Sep Amazon Double Yellow M Dollard 750 819 69 Pet Bird Co 1,931 43 6-Nov-10 Nov Lovebird Peach-Face U Dollard 55 121 66 Pet Bird Co 2,185 3 11-Nov-10 Nov Conure Maroon-Bellied F Dollard
Image of page 3

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

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