Please see below. Need help with this asap please and thank you. CEFGHKA B1 Function: SUM; Formula: Subtract, Multiply; Cell ReferencingStudent Work Area3 Using Excel to Calculate Payroll AmountsPROBLEMRequired: Provide input into cells shaded in yellow in this template.Use mathematical formulas with cell references to the Problem area45 Betsy Strand's payroll information is provided here.or work area as appropriate. Use the SUM function to add anynecessary amounts.62416.00Regular hourly wage rateHourly rate for work in excess of 40 hoursHours worked during a January pay periodFederal income tax withholding7%2424.008479Compute Betsy Strand's gross earnings and net pay for the payperiod.$95.0010FICA tax rate7.65%1112Gross earnings:Regular pay13 Betsy has no voluntary deductions.1415Overtime pay16Total gross earnings1718Gross earnings19FICA taxes withheld2021Federal income taxes withheld2223Net pay2425

Gross earnings are the earnings of the individual without considering the effect of taxes. Net Pay…

Function: SUM; Formula: Subtract, Multiply; Cell Referencing Student Work Area Using Excel to Calculate Payroll Amounts PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area Betsy Strand's payroll information is provided here. or work area as appropriate. Use the SUM function to add any 24 16.00 Regular hourly wage rate Hourly rate for work in excess of 40 hours Hours worked during a January pay period Federal income tax withholding necessary amounts. 24 24.00 47 Compute Betsy Strand's gross earnings and net pay for the pay 24 7.65% 95.00 1 FICA tax rate period. 2 Gross earnings: Regular pay 3 Betsy has no voluntary deductions. 4 _5 Overtime pay 16 17 Total gross earnings 18 Gross earnings 2$ 19 FICA taxes withheld 20 21 Federal income taxes withheld 22 23 Net pay 24

Function: SUM; Formula: Subtract, Multiply; Cell Referencing Student Work Area Using Excel to Calculate Payroll Amounts PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area Betsy Strand's payroll information is provided here. or work area as appropriate. Use the SUM function to add any 24 16.00 Regular hourly wage rate Hourly rate for work in excess of 40 hours Hours worked during a January pay period Federal income tax withholding necessary amounts. 24 24.00 47 Compute Betsy Strand's gross earnings and net pay for the pay 24 7.65% 95.00 1 FICA tax rate period. 2 Gross earnings: Regular pay 3 Betsy has no voluntary deductions. 4 _5 Overtime pay 16 17 Total gross earnings 18 Gross earnings 2$ 19 FICA taxes withheld 20 21 Federal income taxes withheld 22 23 Net pay 24

Accounting Information Systems

11th Edition

ISBN:9781337552127

Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill

Publisher:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill

Chapter6: Relational Database And Sql

Section: Chapter Questions

Problem 2P

See similar textbooks

Similar questions

Q1. Provide in full the meaning of these abbreviations and tell briefly how they interface with the GIFMIS a. Payroll & HuRMIS (PSC) b. CS-DMRS (DMD-MOF)
What SQL command(s) would you use to add the date on which an employee was hired to the EMPLOYEE table represented in Figure 6.13 (pg. 213)? Name this new attribute Employment_Date. Assume that the employees were hired on the following dates, using a year-month-day format as YYYYMMDD: Carl Elks 20000522 Janet Robins 20010103 Greg Kinman 19970825 Christy Bazie 20040801 Elaine Kopp 20060912 John Mast 19950709
Task 2- Service providers1. Based on the company scenario provided above, research the suitability of at least four payroll software products, from different providers, for processing your payroll in-house. Next research the suitability of at least four payroll service providers if you were to consider outsourcing your payroll. You are required to provide a short summary of the providers you have suggested. 2. Research and explain the different payroll lifecycle and software packages selected for two different organisations, one processing payroll for 20,000 employees and another processing payroll for 200 employees, both having a monthly pay frequency. (i) Explain your decision and an estimation of the costs relating to monetary value and time?● Include in your response to this task how you would manage the provider/customer and other stakeholder relationships necessary to influence successful payroll outcomes including delivery, customer care and enquiry handling. Identify the risks…
C4Q5 Need help Prepare journal entries for the December 31 payroll. 2. Use T-accounts to compute the following: a. The total amount of materials requisitioned into work-in-process during December b. The total amount of direct manufacturing labor recorded in work in process during December (Hint: You have to solve requirements 2b and 2c simultaneously) c. The total amount of manufacturing overhead recorded in work-in-process during December d. Ending balance in work-in-process, December 31 e. Cost of goods sold for December before adjustments for under- or overallocated manufacturing overhead 3. Prepare closing journal entries related to manufacturing overhead. Assume that all under- or overallocated manufacturing overhead is closed directly to Cost of Goods Sold.
Q2. Categorize each of the following activities into the expenditure, conversion, or revenue cycles, and identify the applicable subsystem. a. Preparing the weekly payroll for manufacturing personnel b. Releasing raw materials for use in the manufacturing cycle c. Recording the receipt of payment for goods sold d. Recording the order placed by a customer e. Ordering raw materials f. Determining the amount of raw materials to order?
Question Content Area Continuing Payroll Problem: Chapter 3 As you learned in the previous chapter, Kipley Company is a small manufacturing firm located in Pittsburgh, Pennsylvania. The company has a workforce of both hourly and salaried employees. In the last chapter, gross wages were computed for each employee. Adjacent to their name, each employee's gross wages are shown in the Payroll Register. The next task is computing the FICA withholding for each employee and the employer's liability. Requirements: Compute the OASDI for each employee. Compute the HI for each employee. On the Employer Register, compute the employer FICA liability. Payroll Register Complete the steps below: Compute the OASDI for each employee. Compute the HI for each employee. Compute the totals for each tax. Note: Round your final answers to the nearest cent. KIPLEY COMPANY, INC.Employee Payroll RegisterFor Period Ending January 8, 20-- EARNINGS DEDUCTIONS NET PAY Name Gross OASDI HI FIT…
Automated Application Controls: Input Controls. In its automated processing systemover payroll transactions, Brady Company enters the following data from its employees’attendance records (# corresponds to a numeric field; A corresponds to an alphabetic field):∙ Employee number (##-#-##, the employees’ Social Security number).∙ Entity division (AA#, an alphanumeric field containing two letters corresponding to thelocation of the employee and two numbers corresponding to that employees’ supervisor).∙ Hours worked (##.#, a weekly total of hours worked in 0.25-hour increments).After data entry, these data are processed against the information maintained in thatemployee’s master file record. The records are accessed based on employee number. If theemployee is an hourly employee, the number of hours worked is multiplied by the pay rate; ifa salaried employee, the hours worked are checked against a range of acceptable hours. Afterthe gross pay is determined, information in the master file…
Figure 2-4 in the text illustrates how a customerorder is transformed into a source document, a productdocument, and a turnaround document. Developa similar flowchart for the process of paying hourlyemployees.The Process: Supervisors collect time sheets fromemployees, review them for correctness, and submitthem to payroll where payroll checks are preparedand sent to the employees. In addition a summaryreport of total payroll charges is sent to each departmentmanager, who reviews it for correctness, signsthe report, and returns it to the payroll departmentto be files.
9 List of Statements 1. The payroll department should use personnel action forms (new employees and terminated employees) to validate employees before they are issued a check. 2. Upon completion, the daily time cards are routed to the cost accountants who use them to post the labor costs to specific WIP accounts such as direct labor, indirect labor and overhead. Which of the statement(s) above is(are) invalid? O Both statements are valid O Statement 2 O Statement 1 Both statements are invalid Answer only
Ma1. Question 11. Which of the following is not a catetory found in the Content Pane of Dynamics GP? Options: A.Cards B.Inquiry C.Print D.Reports Question 12. The typical size of a business that is most likely to use MS Dynamics GP is options: A.Fewer than 50 employees B.250-500 employees C.2500 - 5000 employees D.More than 5000 employees Question 13. Which of the following features allows you to view information about a customer and then begin entering an invoice for that customer? options: A.Lists B.Reports C.Inquiry D.SmartLists Question 14. Which of the following statements is not true regarding the Navigation Pane? options: A.You can choose not to show specific series/functions on the Navigation Pane B.You can change the order in which series/function areas appear on the Navigation Pane C.If you hide a series/function so it doesn’t appear on the Navigation Pane, it is removed from your Dynamics GP system D.It can be hidden in order to make the Content area larger…
TRUE OR FALSE 1. In ideal circumstances, each payroll check is delivered personally to the employee who signs a receipt for it. 2. The amount of income taxes withheld from employee gross pay is an expense to the employer. 3. The amount debited to the Work in Process account represents the amount of direct labor (at regular rate) charged to the different jobs in process.
(Appendix 4B) An example of a support department is a. data processing. b. personnel. c. a materials storeroom. d. payroll. e. All of these.