Set up Figures 9-5 and 9-6 in spreadsheets in an Excel workbook. The spreadsheet for Figure 9-5
Question:
Set up Figures 9-5 and 9-6 in spreadsheets in an Excel workbook. The spreadsheet for Figure 9-5 should allow the user to recalculate the social security, Medicare, FUTA, and SUTA costs by changing the social security rate and limit, Medicare rate, FUTA rate and limit, SUTA rate and limit, the wages for salaried employees, and the hours [worked] per week and wage rate for hourly employees. Use the concepts presented in Sidebar 9-1 to set up this spreadsheet.
FIGURE 9-5 Employee Costs
FIGURE 9-6 General Overhead Budget
When a change is made to the spreadsheet for Figure 9-5, the employee wages and salaries, the employee taxes, and insurance should automatically change in the spreadsheet for Figure 9-6.
Social Security Rate: 6.20% Social Security Limit:97500 Medicare Rate FUTA Rato: FUTA Limit SUTA Rate: SUTA Limit 1.45% 0.80% 7.000 2.00% 22,000 Jan. Fob March April May Jno Oct. Nov. Dec,Total Wages Social Socurity 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000 6,045 145 145 145 145 145 145 145 145 145 145 145 145 1.740 620 620 620 620 620 620 620 620 620 FUTA SUTA 200 200 Projoct Managor/Estimator Wages Social Security 5,000 5,000 5,000 5.000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 60,000 310 310 310 310 310 310 310 310 310 310 310 310 3,720 FUTA SUTA 100 100 100 100 Office Salaries 15.000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 ,000 15,000 15,000 15,000 180,000 Secretary/Receptionist Hours Per Woek Wage Rate Wages Social Socurity 42 42 2,236 2,236 2,236 2236 2236 2,236 2,236 2,236 2,236 2,236 2.236 2236 26,832 139 139130 139 139 139 139 139 139 139 1.664 FUTA SUTA 5 Hours Per Weok Wage Rate Wagos Social Security 45 45 3,705 3,705 3,705 3,705 3,705 3,705 3.705 3,705 3,705 3,705 3,705 3,705 44,460 230 230 230 230 230 230 230 230 230 230 230 230 2757 54 54 FUTA 74 74 74 74 74 69___ Hours Per Week Wage Rate Wages Social Security 42 42 1,677 1,677 1,677 1.677 1,677 1,677 1,677 1,677 1,677 1,677 1677 1677 20.124 104 104 104 104 04 04 041040404 104 1,248 24 24 24 FUTA SUTA 34 7,618 7,618 7.618 7618 7,618 7,618 7,618 7,618 7,618 7,618 7,618 7,618 91,416 22,618 22,618 22,618 22618 22.618 22,618 22,618 22,618 22,618 22,618 22618 22618 271,416 34 Hourly Wages Total Wages Taxes Social Security 1,402 1,402 1,402 1,402 ,402 1,402 1,402 1,402 1,402 1,247 782 782 15,433 328 328 328 3,936 328 328 328 329 328 328 328 FUTA SUTA TOTAL 452 452 292 252 192 14878 2,340 2,256 2.054 1,998 1,925 1,878 1,809 1,809 180 1.646 1.144 1,144 21,811 General Overhead 3,910 3,420 4,600 4,920 5,160 68,400 1 Car and Truck Expenses Computer and Office Furniture Employee Wages and Salaries 22,618 22,618 22,618 22,618 22,618 22,618 22,618 22,618 22,618 22,618 22,618 22,618 271,416 2,340 2,256 2,054 1,998 1,925 1,878 3 3 2 4 Dues and Memberships Legal and Professional Services 1,000_ 1,000 43,972 41,949 42,742 46,946 39,238 39,066 65,321 36,686 35,851 38,459 37,537 55,897 523,663
Step by Step Answer:
Social Security Rate 620 Social Security Limit 97500 Medicare Rate 145 FUTA Rate 080 FUTA Limit 7000 SUTA Rate 200 SUTA Limit 22000 Item Jan Feb March April May June July Aug Sept Oct Nov Dec Total Ow...View the full answer
Construction accounting and financial management
ISBN: 978-0135017111
2nd Edition
Authors: Steven j. Peterson
Students also viewed these Finance questions
-
The self-reported number of hours worked per week by 204 top executives is given below. (a) Estimate the mean, standard deviation, and coefficient of variation, using an Excel work- sheet to organize...
-
a. A change is made that should improve student satisfaction with the parking situation at a local high school. Before the change, 37% of students approve of the parking thats provided. The null...
-
a. A change is made that should improve student satisfaction with the parking situation at your school. Before the change, 37% of students approve of the parking thats provided. The null hypothesis H...
-
Find the volumes of the solids in Problems 4952 correct to the nearest unit. 4 cm -6 cm 8 cm
-
An electron with total energy E = 5.1 eV approaches a barrier of height Ub = 6.8 eV and thickness L = 750 pm. What percentage change in the transmission coefficient T occurs for a 1.0% change in (a)...
-
A gas obeys the ideal gas law at (a) Low pressure and high temperature (b) Low pressure and low temperature (c) Low temperature and high pressure (d) High temperature and high pressure.
-
Examine the BNF definition of the syntax of a programming language such as C++, BASIC, or Java.What differences are immediately obvious compared with the BNF for a human language grammar? Are there...
-
At the beginning of 2014, Metal Manufacturing purchased a new computerized drill press for $75,000. It is expected to have a five-year life and a $15,000 salvage value . Required a. Compute the...
-
Merbau Furniture is a main manufacturer of custom-made office furniture in Ipoh, Perak. The company applies job order costing system, where each client's order is treated as separate job. The company...
-
The bent rod ABDE is supported by ball-and-socket joints at A and E and by the cable DF. If a 600-N load is applied at C as shown, determine the tension in the cable. 70 mun 90 mm 600 N 110 tmm 100...
-
Determine the projected costs for utilities in year 5. The inflation rate has been determined to be 0.222 and the initial cost is $57.39.
-
A construction company has total revenues of $650,000, total construction costs of $509,000, and general overhead costs of $65,000 for the year. Determine the companys total profit for the year and...
-
Whether they were misled intentionally or innocently will not affect the nature of the injury suffered by the victims of false statements. However, it makes a significant difference to the remedies...
-
Consider the following apportionment problem: Use the apportionment plan requested in Problems 51-55 assuming that there must be 16 representatives. Jefferson's plan North: 18,200 South: 12,900 East:...
-
Consider the following apportionment problem for College Town: Suppose each council member is to represent approximately 2,500 citizens. Use the apportionment plan requested in Problems 41-45...
-
Consider an election with three candidates with the following results: a. Is there a majority winner? If not, who is the plurality winner? b. Who wins using the pairwise comparison method? c. Is the...
-
A group of fun-loving people have decided to play a practical joke on one of their friends, but they can't decide which friend, Alice (A), Betty (B), or Connie (C). Their preferences are: Use this...
-
The township of Bella Rosa is divided into two districts, uptown (pop. 16,980) and downtown (pop. 3,350) and is governed by 100 council members. Use this information in Problems 48-53. Suppose the...
-
All 20 RBPS elements are equally important and cannot be prioritized. Based on your personal and/or company experiences, what are two elements you have found to be inadequately addressed? State the...
-
What are the two components of a company's income tax provision? What does each component represent about a company's income tax provision?
-
Cal Corey and his wife are living in Las Vegas, Nevada, and own an apartment house from which they receive $20,000 a year in net rental income. Cal's wife also owns an apartment house, which she...
-
What is the present value of perpetuity of $100 per year if the appropriate discount rate is 7 percent? If interest rates in general were to double and the appropriate discount rate rose to 14...
-
Assume that you inherited some money. A friend of yours is working as an unpaid intern at a local brokerage firm, and her boss is selling some securities that call for four payments, $50 at the end...
-
Assume that your aunt sold her house on December 31 and that she took a mortgage in the amount of $10,000 as part of the payment. The mortgage has a quoted (or nominal) interest rate of 10 percent,...
-
Determine "Tyson Food "Company's firmographics, activities, and objectives. Then relate these differences to differences in the organizational cultures of the organizations. or provide detail of any...
-
Wimble Ltd had $400 million of debt outstanding at an interest rate of 9% and $600 million of equity (market value) outstanding. Wimble is subject to a 30% corporate tax rate. What is the amount of...
-
explain and comments thies pints Has existed for a long time One of the original fast-food establishments High standing Commonly recognized for its root beer. With high-quality cuisine Markets to...
Study smarter with the SolutionInn App