Common Business Unit: Sales and Commission
A arrangement will be adapted for the recording and adding of sales and agency for anniversary branch. Head appointment additionally requires a arrangement to analyses the sales abstracts accustomed from anniversary branch. Requirements Part 1 - Annex Arrangement A workbook arrangement will be created that will almanac and annual the sales abstracts for anniversary annex apparent in addendum 1. (The abstracts for anniversary annex charge be recorded in a abstracted workbook. ) Completed 1 . Spend some time planning and designing your template. You may ambition to Jot bottomward the plan on a allotment of paper. 0 worksheet Agency Rates. 3. Create a called ambit for the agency ante tat.
The Agency Ante abstracts is acclimated to attending up the % agency anniversary sales being will receive. This allotment will again be acclimated to annual the agency for anniversary month, based on annual sales. 4. Insert a new breadth afore the Agency Ante worksheet. Name the new breadth Sales. 0 5. On the Sales worksheet, annual the agency anniversary sales being will accept anniversary month. 6. Anniversary ages if a sales being equals or exceeds a 12% agency target, they accept an added benefit of $1 ,250. Insert a cavalcade for anniversary ages to actuate if the sales being will accept the bonus.
This can be accomplished by accumulation an IF and a VILLOUS statement. ) The agency ambition and the bulk of benefit on action will alter every quarter. Ensure that this is taken into annual back designing the spreadsheet by accession the benefit bulk and the % agency ambition in abstracted beef at the top of the worksheet data. You will charge to anticipate of application complete referencing in your blueprint as well. 7. Columns charge be advanced abundant to affectation abstracts properly. 8. Accommodate a attack absolute the book name of the workbook. 9. Today's date and a Annex name breadth charge arise on the worksheet. The annex name will be abounding in back the arrangement is used. ) 10. Annual the absolute sales for anniversary month. 1 1 . Save the workbook book as a arrangement with an adapted book name in the actual templates folder. Note that macros are adapted in the template. 12. A arbitrary of the sales for anniversary of the three months recorded charge arise on the worksheet. This arbitrary charge accommodate average, best and minimum calculations for anniversary month. All abstracts charge be angled to the abutting $100. 0 13. Format the spreadsheet so it is bright and accessible to read. Use Caliber chantry in befitting with the organization's abode style.
Format bill columns to two decimal places. 14. Check all that formulae assignment correctly. 15. Ensure that the workbook arrangement is set up to automate all calculations so the user alone needs to admission the sales abstracts for anniversary month. 16. Ensure users cannot admission abstracts in blueprint beef by attention these cells. Please use 'password' for your countersign back attention the breadth as the brand needs to be able to admission the formulae. 0 17. Develop a macro that will array all sales bodies into alphabetical order. 0 19. Assign these two macros to buttons at the top of the worksheet. Part 2 - Annex Workbooks 1.
Using the arrangement created in Part 1 to aftermath a workbook for anniversary annex application the sales abstracts in addendum 1 for all three branches. 2. Ensure all abstracts is arrested to ensure authentic input. 3. Anniversary workbook should be adored with an adapted book name in your alive folder. 0 4. Ensure the sales being abstracts is sorted into alphabetical adjustment and the arbitrary advice is printed for anniversary workbook. Scan the letters into a PDF book to submit. Part 3 - Head Appointment Arrangement Create a workbook arrangement that will affectation the absolute sales for anniversary ages from anniversary agronomical to be acclimated at Head Office. . Columns charge be advanced abundant to affectation abstracts properly. 3. Accommodate a attack absolute the date (to the right) and a footer with the book name in the lower adapted corner. 4. Use Caliber chantry in befitting with the organization's abode style. 5. Save the workbook book as a arrangement with an adapted book name in the actual templates folder. 0 6. Absolute anniversary cavalcade and row to actuate the absolute sales for anniversary ages and anniversary branch. 0 7. Create a blueprint that displays the sales for anniversary annex over the three ages period. Use an adapted blueprint blazon and add a title.
Order a unique copy of this paper