Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Consider the following scenario: As supervisor for a retail company, you supervise six people in your location. You are responsible for their payroll and commissions each week. This task would normally take a couple of hours on paper, but you now have the expertise needed to automate the process by using formulas and functions in an Excel spreadsheet. Use the data provided to create a worksheet described below: You must create a workbook with separate sheets for each week that would allow sales managers to compare sales figures and commissions from one week to the next. Each worksheet should calculate the payroll amount for each of your six employees. If sales are below $1,000, then the commission paid is 5% of the sales. If sales are between $1,000 and $3,999.99, the commission paid is 10% of the sales. If sales are $4,000 or higher, the sales person receives a 12.5% commission rate. Sales people will be paid either their commission or hourly pay earned amount-whichever is higher. Hourly employees receive 150% of their hourly rate for any hours worked over 40 hours per week (time and a half for overtime worked). Each worksheet should contain the following headings: Employee Sales Hours Worked Hourly Pay Commission Earned Hourly Pay Earned Payroll Amount To complete this workbook, you must write specific formulas and functions. The Commission Earned, Hourly Pay Earned (for the two hourly employees), and Payroll Amount columns require you to use IF functions. Remember, the payroll amount for salespeople will be either the commission earned or hourly pay earned-whichever is greater. Do not calculate commission earned for hourly employees or overtime for sales employees (this is anyone who has a sales figure in the Sales column). Remember to format your worksheets, rename and change color on the tabs, and submit your workbook to your instructor using the following naming convention: LastnameFirstnameIP5.xls.
change in economic structurewith regards to the changes within the economic structure how do politics and government
public budgeting what are the major subjects of issue assessments?what are the major subjects of issue assessments?the
Explain what is Corporate Social Responsibility and how does CSR relate to an organization's mission statement and to its strategy?
important information about transformational and transactional leadershipshow the relationship between transformational
Who is IBM's external auditor? In addition to auditing IBM's financial statements, what else dies this firm audit? What body's standards does the firm follow in conducting its audit?
Differentiate among business operation, operation management and product management ?
Assume that you are on the staff of a PRC legislator. Outline the arguments that you would use to support a law that required all government agencies to use only open-source software on their Web servers.
organizational sales teams1.why is it important for the sales team to remember the overall goals of the organization?it
Explain what primary research is and what it entails. Also discuss how one might plan to do primary research in terms of data collection.
how should a company assess readiness for learning? include characteristics of both the employee and the work
Explain The appraisal is most accurate on the day of the closing and Using traditional appraisal techniques, appraised value is a reconciliation of three preliminary estimates of value
Explain Sandy believes her employer has breached the employment agreement and she should be paid for the two weeks between jobs. Is she right
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd