
Concept explainers
Frank Flynn is the payroll manager for Powlus Supply Company. During the budgeting process, Sam Kinder, director of finance, asked Flynn to arrive at a set percentage that could be applied to each budgeted salary figure to cover the additional cost that will be incurred by Powlus Supply for each employee. After some discussion, it was determined that the best way to compute this percentage would be to base these additional costs of payroll on the average salary paid by the company.
Kinder wants this additional payroll cost percentage to cover payroll taxes (FICA, FUTA, and SUTA) and other payroll costs covered by the company (workers’ compensation expense, health insurance costs, and vacation pay).
Flynn gathers the following information in order to complete the analysis:
Compute the percentage that can be used in the budget.

Trending nowThis is a popular solution!

Chapter 6 Solutions
Payroll Accounting
- You work for a beverage company that sells coffee and tea. Your boss has asked you to help set up thecompany’s new database using Microsoft Access and then perform some queries in Access to determineinformation that your boss needs to give to the senior management. You are given a flat file(Beverage_Co_Sp25.xls) with the company’s sales information. When you open the file, you notice that it is notset up in efficient tables. You must create efficient tables in Excel before importing the data into MicrosoftAccess. Then, you need to run queries to gather the information your boss needs.Excel InstructionsYou will need to create 5 efficient tables from the one worksheet in the Excel file you have been given:Customers, Employees, Sales, Inventory, and SalesItems. You will need to determine which columns need to beincluded in each table and delete any duplicates and blank rows in the tables.Furthermore, once you have created the Sales table, make sure to change the name of the…arrow_forwardProvide correct answer general accounting questionarrow_forwardMeric Mining Inc. recently reported $16,300 of sales, $7,900 in operating costs other than depreciation, and $1,600 in depreciation. The company had no amortization charges, it had outstanding $6,550 of bonds that carry a 6.50% interest rate, and its federal-plus-state income tax rate was 40%. How much was the firm's net income after taxes? Meric uses the same depreciation expense for tax and stockholder reporting purposes.arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning

