June Commercial Salesperson Bonus Summery | |||||
Northen/Southarn | Northan | Southarn | Total | ||
Bonus | $ 6,073.00 | $ 3,287.06 | $ 9,360.06 | ||
Base Salary | $ 11,075.00 | $ 10,425.00 | $ 21,500.00 | ||
Total Compensation | $ 17,148.00 | $ 13,712.06 | $ 30,860.06 | ||
$ 34,296.00 | $ 27,424.12 | $ 61,720.12 | |||
Northan | |||||
Rosedale Landscape and Garden | |||||
SalesPerson | Sales Eligible for Bonus | Bonus Rate | Bonus | Base Salary | Total Compensation |
Reid | $ 25,630.00 | 4% | $ 1,025.20 | $ 2,275.00 | $ 3,300.20 |
Leung | $ 28,940.00 | 4% | $ 1,157.60 | $ 2,400.00 | $ 3,557.60 |
Singh | $ 41,850.00 | 5% | $ 2,092.50 | $ 3,250.00 | $ 5,342.50 |
Evans | $ 35,954.00 | 5% | $ 1,797.70 | $ 3,150.00 | $ 4,947.70 |
Total | $ 132,374.00 | $ 6,073.00 | $ 11,075.00 | $ 17,148.00 |
Southarn | |||||
Rosedale Landscape and Garden | |||||
SalesPerson | Sales Eligible for Bonus | Bonus Rate | Bonus | Base Salary | Total Compensation |
Watson | $ 22,637.00 | 2% | $ 452.74 | $ 2,350.00 | $ 2,802.74 |
Firesen | $ 20,868.00 | 2% | $ 417.36 | $ 2,325.00 | $ 2,742.36 |
Tam | $ 26,849.00 | 4% | $ 1,073.96 | $ 2,425.00 | $ 3,498.96 |
Johnston | $ 33,575.00 | 4% | $ 1,343.00 | $ 3,325.00 | $ 4,668.00 |
Total | $ 103,929.00 | $ 3,287.06 | $ 10,425.00 | $ 13,712.06 | |
Instructions 1-17 sheet 1 sheet 2 Should be done on exel file. Assignment Instructions Step Instructions...
Styles Project Description: You are an accountant for a pharmaceutical sales company. As one of your tasks, you complean annual report that documents regional sales information into one standardized worksheet. As part of this process, you group the worksheets and insert descriptive rows and columns, apply formatting, and insert hundtions. Your last step is to create a sales suminary worksheet and provide basic information for management to evaluate. Steps to Perform: Step Instructions Points Possible 1 0 Open exploring 09...
Assignment Instructions In cell B10, use the COUNTIF function to count the number of Specialty plant types in the Category column. 9 In cell H13, type Stock Level. In cell H14, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 50, the Value if true is Order. Otherwise the Value if false is OK. Fill the formula down through cell H42. 10 Apply Conditional Formatting to the Stock Level...
I have completed these but wanting to compare such as Question 14. Is the word "Total" added in the row or written as "Average" or "Total Average" Also Question 8 is not clear what fill color. Is it supposed to stay as blue and just select gradient fill? Very unclear questions. Thank you. Question: EX16_XL_VOL1_GRADER_CAP_AS – Travel Vacations 1.4 ( Excel, Chapter 4) Project Description: 1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 2 On the DC worksheet,...
EX16 XL _CH01_GRADER ML2 HW - Real Estate Sales Report 1.3 Project Description: You own a small real estate company in Indianapolis. You track the real estate properties you list for dlients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of...
EX16_XL_CH05_GRADER_CAP_AS - Travel Expenses 1.8 Project Description: <Project Description> Steps to Perform: Step Instructions Points Possible 1 Start Excel. Open the downloaded Excel file named exploring_e05_grader_a1_Expenses.xlsx. Save the workbook as exploring_e05_grader_a1_Expenses_LastFirst, replacing LastFirstwith your own name. 0 2 On the Subtotals worksheet, use the Sort dialog box to sort the data by Employee and further sort by Category, both in alphabetical order. 4 3 Use the Subtotals feature to insert subtotal rows by Employee to calculate the total expense by...
EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.6 Project Description:You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report that details all aspects of the business, including: employee tax withholding, facility management, sales data, and product inventory. To complete the task, you will duplicate existing formatting, utilize various conditional logic functions, complete an amortization table with financial functions, visualize data with PivotTables, and lastly...
please disregard the excel question А B D Question 1 -- Stacy's Travel Agency 2 3 8 Instructions 4. You are an agent at a local travel agency. Your manager has asked you to track your sales of next winter's holiday packages. For each package, customers can schoose whether or not to include a flight in the package. For each sale, an initial down payment of 20% of the total package cost is required. 6 Customers can pay the remainder...
AutoSave OFF Esu = ExcelAnalytics_CostConcepts_Template (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) "A Insert 11 = = Σν ab Wrap Text Custom 48- 0 DX Delete Paste B I U Av * Merge & Center C%) Ideas Cell Styles Conditional Format Formatting as Table Sensitivity Sort & Filter A Format Find & Select G16 fx A B с D E F G 1 2 Account 3 Equipment depreciation: Molding 4...
Southern New Hampshire University ACC 308 - Intermediate Accounting II INSTRUCTIONS FOR MILESTONE 1 (Due Module 3) IMPORTANT NOTE: Make sure to completely review the Rubric for Milestone 1 Use the data from this Milestone and begin working on your final presentation due in Final Project (Module ITEMS TO COMPLETE FOR THIS MILESTONE (Blue Tabs): GENERAL You just began a position as a financial accountant at Peyton Approved. In this role, your first task is to prepare 1 for the...
Subject: HRM Introduction and Instructions You have recently been hired as the Director of Human Resources for Wilson Brothers Canada and have HR responsibility for all of the company’s Canadian operations. Bob and John Wilson have asked you to prepare a report for their review focusing specifically on organizational behavior within the company. Review the Wilson Brothers Case Scenario in depth and address the required topic listed below in your analysis report. Marks are allocated for thoroughness of coverage of...