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!
Design and create a workbook to keep track of the payroll for hourly employees. Each worksheet will correspond to a different week. You have six employees. List them in a column. Each employee makes a different amount per hour. List the hourly pay for each employee in a new column. Now add a column for each of the seven days of the week. In these columns enter the number of hours worked by each employee each day that week. To the right add columns that give the total number of hours worked by each employee and the gross pay for each employee. The federal government asks you to deduct 20% of gross pay for federal income taxes. Your state or province asks you to deduct 5% of gross pay for state income taxes. Add columns for these. Social security deduction is 6.2% of gross pay. The deduction for medical insurance is $20 per week. Add columns for these. Each employee’s take home pay is the gross pay minus the deductions. Add a column for take home pay. Add a row to total all of the columns. Add appropriate cells with headings for the worksheet.
Now use the worksheet you just created for one week’s payroll to create a workbook for a month (four weeks). You should have an initial worksheet that gives a title and other information. There should be one worksheet for each week. Employees may work different hours from week to week. The final worksheet should be the totals for the four weeks. There should be six worksheets in all.
The only cells in which input is allowed are the employee names, hourly pay rate, and hours worked during each of the seven days. Data entry should not be allowed in any cell containing a formula or header information. Data entry should not be allowed in the totals worksheet. Lock/unlock the appropriate cells in each of the weekly payroll worksheets and the total worksheet. Protect each of the worksheets (do not use a password).
when the capacity of the HR department was originally established, the normal usage expected for each department was 20000.
The first step to analyzing Wendy's International's involvement with Baja Fresh is to examine the financial information related to the acquisition of Baja Fresh
Miriah Inc. has 10,000 shares of 5%, $100 par value, cumulative preferred stock and 50,000 shares of $1 par value common stock outstanding at December 31, 2014. What is the annual dividend on the preferred stock?
Davies Company purchased merchandise inventory with an invoice price of $5,000 and credit terms of 2/10, n/30. What is net cost of the goods if Davies Company pays within the discount period?
Estimate the total fixed cost per month and what is the contribution margin per unit made and sold - Estimate the variable cost per unit
Explain how unrealised profits arise from transactions between companies in a group and why it is important to remove them?
In a three-variance method of factory overhead analysis, _______ variance measures the difference between the factory overhead applied and the actual hours worked multiplied by the standard rate.
what effect would this order have on the company net operation income if a special price of 349.95 is offer per brracelet for this order. should the special order be accepted at this price
The magnitude of operating leverage for Forbes Corporation is 2.3 when sales are $150,000 and net income is $19,000. If sales increase by 5%, what is net income expected to be.
The Gold Bay Hotel is in the process of developing a master budget and pro-forma financial statements for 1999. The beginning balance sheet for the fiscal year 1999 is estimated to be: During the year the hotel expects to rent 30,000 rooms. Rooms r..
Santana Rey created Business Solutions on October 1, 2011. The company has been successful and Santana plans to expand her business. She believes that an additional $86,000 is needed and is investigating these funding sources.
Describe components of internal control) List the components of internal control. Briefly describe each component. Explain the objectives of internal control) Explain why separation of duties is often described as the cornerstone of internal control ..
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