Questions
Using the attached template, you are to compute the gross pay, federal withholding, Social Security withholding,...

Using the attached template, you are to compute the gross pay, federal withholding, Social Security withholding, Medicare withholding and the net payment for this company. Assume there is no state income tax. Overtime is paid at a rate of 1.5 times the normal wage rate.

NOTE: PLEASE DONT FORGET THE PIVOT TABLE!

In addition, compute the total gross pay, federal withholding, Social Security withholding, Medicare withholding and net payment for all the employees. Further, create a pivot table indicating the total gross pay, Social Security withholding, Medicare withholding and net pay for wage employees and for salary employees. Please note you should use auto fill to complete this assignment in an efficient manner. Use the following Excel template:

Tax Rates
6,20% 1,45%
Employee Numbers Pay Rate Regular Hours Worked Overtime Hours Worked Gross Pay Federal W/H Rate Federal W/H SS W/H Medicare W/H Net Pay Type
1 $44,00 40 6 0,25 Wage
2 $56,00 40 0,28 Wage
3 $35,00 40 9 0,15 Wage
4 $3 200,00 1 0,25 Salary
5 $23,00 40 2 0,25 Wage
6 $19,00 1 0,15 Wage
7 $33,00 40 9 0,28 Wage
8 $3 100,00 1 0,28 Salary
9 $2 400,00 1 0,28 Salary
10 $32,00 40 6 0,25 Wage
11 $23,00 40 0,28 Wage
12 $37,00 40 9 0,15 Wage
13 $2 450,00 1 0,25 Salary
14 $41,00 40 2 0,25 Wage
15 $23,00 1 0,15 Wage
16 $36,00 40 9 0,28 Wage
17 $4 100,00 1 0,28 Salary
18 $2 100,00 1 0,28 Salary
19 $40,00 40 6 0,25 Wage
20 $27,00 40 0,28 Wage
21 $31,00 40 9 0,15 Wage
22 $2 200,00 1 0,25 Salary
23 $26,00 40 2 0,25 Wage
24 $18,00 1 0,15 Wage
25 $31,00 40 9 0,28 Wage
26 $2 900,00 1 0,28 Salary
27 $2 850,00 1 0,28 Salary
28 $30,00 40 6 0,25 Wage
29 $41,00 40 0,28 Wage
30 $36,00 40 9 0,15 Wage
31 $2 560,00 1 0,25 Salary
32 $22,00 40 2 0,25 Wage
33 $42,00 1 0,15 Wage
34 $31,00 40 9 0,28 Wage
35 $1 800,00 1 0,28 Salary
36 $1 900,00 1 0,28 Salary
37 $35,00 40 6 0,25 Wage
38 $53,00 40 0,28 Wage
39 $32,00 40 9 0,15 Wage
40 $3 600,00 1 0,25 Salary
41 $25,00 40 2 0,25 Wage
42 $19,00 1 0,15 Wage
43 $29,00 40 9 0,28 Wage
44 $5 000,00 1 0,28 Salary
45 $1 900,00 1 0,28 Salary
46 $22,00 40 6 0,25 Wage
47 $31,00 40 0,28 Wage
48 $52,00 40 9 0,15 Wage
49 $1 900,00 1 0,25 Salary
50 $22,00 40 2 0,25 Wage
51 $18,00 1 0,15 Wage
52 $28,00 40 9 0,28 Wage
53 $3 300,00 1 0,28 Salary
54 $2 100,00 1 0,28 Salary
55 $37,00 40 6 0,25 Wage
56 $52,00 40 0,28 Wage
57 $19,00 40 9 0,15 Wage
58 $4 200,00 1 0,25 Salary
59 $15,00 40 2 0,25 Wage
60 $21,00 1 0,15 Wage
61 $35,00 40 9 0,28 Wage
62 $3 500,00 1 0,28 Salary
63 $2 200,00 1 0,28 Salary
64 $38,00 40 6 0,25 Wage
65 $51,00 40 0,28 Wage
66 $41,00 40 9 0,15 Wage
67 $1 875,00 1 0,25 Salary
68 $27,00 40 2 0,25 Wage
69 $33,00 1 0,15 Wage
70 $27,00 40 9 0,28 Wage
71 $3 700,00 1 0,28 Salary
72 $2 600,00 1 0,28 Sala

In: Accounting

Consider an industry in which all firms have constant marginal costs of 50, MC = 50,...

Consider an industry in which all firms have constant marginal costs of 50,
MC = 50, and market demand is Qd = 385 - 0.5P
(a) If there are two firms operating as Cournot duopolists, find the equilibrium price
and total quantity
(b) If there are two firms operating as Stackelberg duopolists, find the equilibrium price,
how much the leader firm produces and how much the follower firm produced?

In: Economics

Assume Haiti and Antigua are the only two countries that produce and consume fish and sugar....

Assume Haiti and Antigua are the only two countries that produce and consume fish and sugar. In a single year, Haiti can catch 50 tons of fish or produce 500 bags of sugar. In the same growing season, Antigua can catch 50 tons of fish or produce 750 bags of sugar. When the two countries begin trading fish for sugar, we expect the price of fish in Haiti:

In: Economics

A theater seating chart is implemented as a table of ticket prices, like this C1 C2...

A theater seating chart is implemented as a table of ticket prices, like this
C1 C2 C3 C4 C5 C6 C7 C8 C9 C10
R1 10 10 10 10 10 10 10 10 10 10
R2 10 10 10 10 10 10 10 10 10 10
R3 10 10 10 10 10 10 10 10 10 10
R4 10 10 20 20 20 20 20 20 10 10
R5 10 10 20 20 20 20 20 20 10 10
R6 10 10 20 20 20 20 20 20 10 10
R7 20 20 30 30 30 30 30 30 20 20
R8 20 30 30 40 50 50 40 30 30 20
R9 30 40 50 50 50 50 50 50 40 30
R10 20 40 50 50 50 50 50 50 40 20

A theater seating chart is implemented as a table of ticket prices, like this above Write a program that asks users to pick either a seat or a price. When choosing seat, indicate the row and column for the location; when choosing the price, like computer find the first available price; mark the sold seats by changing the price to 0. When a user specifies a seat, make sure it is available. Use loop to determine whether continue to order or not. In each time, the seating chart should be displayed for user. When user stops ordering, your program should output the number of tickets ordered, and amount ordered.

PS- the program is being written in python language and our insturctor has told us to us elif

In: Computer Science

please fill in the blanks using c program or lunix with the answers being highlighted 1....

please fill in the blanks using c program or lunix with the answers being highlighted

1.

You will now need four files. These are telnos, telnos2, telnos3, telnos4. These files are all short files that contain names, departments, and telephone numbers. This is what they look like.

telnos

telnos2

Hale Elizabeth Bot   744-6892
Harris Thomas Stat 744-7623
Davis Paulette Phys 744-9579
Cross Joseph   MS    744-0320
Holland Tod    A&S   744-8368

Hale Elizabeth Bot   744-6892
Harris Thomas Stat 744-7623
Davis Paulette Phys 744-9579
Holland Tod    A&S   744-8368

telnos3

telnos 4

Hale Elizabeth Bot   744-6892
Harris Thomas Stat 744-7623
Smith John     Comsc 744-4444
Davis Paulette Phys 744-9579
Cross Joseph   MS    744-0320
Holland Tod    A&S   744-8368

Hale Elizabeth Bot   744-6892
Smith John     Comsc 744-4444
Davis Paulette Phys 744-9579
Cross Joseph   MS    744-0320
Holland Tod    A&S   744-8368

To make it easier to copy you can use the * (wildcard) to copy these files. Type in the command:

                cp /tmp/csc3321/telnos* .  

Remember the . (period) means current directory and will copy all of the telnos files at one time and assign them the names that they have in the instructor's file

In order to see how diff works, type in:

                diff telnos telnos2

What was the result?
________________________________________________________________________________________________________________________________________________________________________________________________________________________

The difference between these two files (telnos and telnos2) is that the 4th line in telnos is missing from telnos2. The first line that diff displays (4d3) indicates that you need to delete the 4th line from file telnos to make the two files match. The 4 is the line number and the (d) is delete. The line number to the left of each of the a,c, or d instructions always pertains to file1. Numbers to the right of the instructions apply to file2. The diff command assumes that you are going to change file1 to file2. The next line that diff displays starts with a less than (<) symbol indicating that this line of text is from file1. Next type in:

                diff telnos telnos3

What was the result?__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

In this case, the second line has the (>) greater than sign which means that the extra line is in file2. The a means you must append a line to the file telnos after line 2 to make it match telnos3. Append means to add on to the end. Next is an example of the change feature. Type in the following command:

                diff telnos telnos4

What was the result? __________________________________________________________

What lines do you need to change in order to make the two files alike? ________________________________________________________________________________________________________________________________________________

Notice that the three hyphens indicate the end of the text in the first file that needs to be changed and the start of the second file that needs to be changed. Next, copy telnos to telnos5. What command did you use to do this? ________________________________________________________________________


Next, type in:

                diff telnos5 telnos2

What was the answer that you received? _________________________________________________________________________________________________________________________________________________________________________________________________________________

Use the vi editor to change telnos5 to match the file telnos2. Then check to see if they are now alike.

What command did you use? _________________________________________________________

What was the result? __________________________________________________

What is the output of the diff command when the files match?
_______________________________________________________________________________

When the two files are alike, there is no response. Unfortunately, Unix is not always user-friendly.

Uniq Command

The uniq command displays a file, removing all but one copy of successive repeated lines. If the file has been sorted, uniq ensures that no two lines that it displays are the same. Sort telnos and telnos3 and then send them to a new file called tel2. Type in the following:

                sort telnos telnos3 > tel2

Next look at the file, tel2. What does it contain?___________________________________________________________________________________________________________________________________________________________________________________________________

Next issue the command:

                uniq tel2

What was the result?__________________________________________________________________________________________________________________________________________________________________________________________________________________

The uniq command has three options. These are:

-c   Causes uniq to precede each line with the number of occurrences of the line in the input file

-d   Displays only lines that are repeated

-u   Displays only lines that are not repeated

Issue the command:

                uniq -u tel2

What was the result?__________________________________________________________________________________________________________________________________________________________________________________________________________________

Next, issue the command:

                uniq -d tel2

What was the result?__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

In: Computer Science

Which set requires one additional final step to determine the median? A: 5, 6, 10, 9,...

Which set requires one additional final step to determine the median?
A: 5, 6, 10, 9, 7, 8, 4
B: 6, 5, 8, 8,9,11

In: Accounting

You are studying the market value of home in Houston. You collect data from the recent...

You are studying the market value of home in Houston. You collect data from the recent sale of 30 single family homes. The data is organized and stored in an Excel file. The dataset includes the fair market value (in $thousands), land area of the property in acres, and age, in years of the 30 homes. Develop a multilinear regression model to predict the fair market value based on land area of the property (in acres) and age, in years.

The name of the Excel data file is HoustonHomes.xlsx. Import the data into SPSS and complete the assignment using SPSS.


  1. State the multiple regression equation.


  1. Interpret the meaning of the slopes, b1 and b2 , in this problem?

  1. Explain why the regression coefficient, b0, has no practical meaning in the context of this problem.

  1. Predict the mean fair market value for a house that has a land area of 0.25 acre and is 55 years old?

  1. Construct a 95% prediction interval estimate for the fair market value for an individual house that has a land area of 0.25 acre and is 55 years old.

Address Fair Market Value ($000) Property Size (acres) Age House Size (square feet) Rooms Baths Garage
9 Sycamore Road 522.9 0.2297 56 2448 7 3.5 2
21 Jefferson St 425.0 0.2192 61 1942 7 2.5 1
38 Hitching Post Lane 539.2 0.1630 39 2073 5 3 2
4 Poppy Lane 628.2 0.4608 28 2707 8 2.5 1
5 Daniel Drive 490.4 0.2549 56 2042 7 1.5 1
15 Francis Terrace 487.7 0.2290 98 2089 7 2 0
23 Guilfoy Street 370.3 0.1808 58 1433 7 2 0
17 Carlyle Drive 777.9 0.5015 17 2991 9 2.5 1
8 Craft Avenue 347.1 0.2229 62 1008 5 1 0
22 Beechwood Ct. 756.8 0.1300 25 3202 8 2.5 2
14 Fox Street 389.0 0.1763 64 2230 8 2 0
1 Raynham Road 889.0 1.3100 62 1848 7 2 1
2 Jerome Drive 452.2 0.2520 56 2100 6 2 0
7 Valentine Street 412.4 0.1148 22 1846 5 3 1
38 Jefferson Street 338.3 0.1693 74 1331 5 1 1
15 Inwood Road 334.3 0.1714 62 1344 8 1 0
29 Meadowfield Lane 437.4 0.3849 54 1822 6 2 1
13 Westland Drive 644.0 0.6545 56 2479 6 2.5 2
79 Valentine Street 387.8 0.1722 62 1605 6 3 0
13 Fairmont Place 399.8 0.1435 88 2080 11 2 0
1 Prestwick Terrace 356.4 0.2755 81 2410 6 1 1
11 Clement Street 346.9 0.1148 107 1753 8 2 0
7 Woodland Road 541.8 0.3636 55 1884 7 2 2
36 Elm Avenue 388.0 0.1474 51 2050 10 2 2
17 Duke Place 564.0 0.2281 50 2978 6 2.5 2
12 Prospect Avenue 454.4 0.4626 92 2132 7 1 0
1 Buckeye Road 417.3 0.1889 64 1551 6 2 0
30 Ann Street 318.8 0.1228 54 1129 5 1 0
26 Broadfield Place 519.8 0.1492 44 1674 7 2 1
16 Jackson Street 310.2 0.0852 104 1184 5 1 0


In: Statistics and Probability

You are studying the market value of home in Houston. You collect data from the recent...

You are studying the market value of home in Houston. You collect data from the recent sale of 30 single family homes. The data is organized and stored in an Excel file. The dataset includes the fair market value (in $thousands), land area of the property in acres, and age, in years of the 30 homes. Develop a multilinear regression model to predict the fair market value based on land area of the property (in acres) and age, in years.

The name of the Excel data file is HoustonHomes.xlsx. Import the data into SPSS and complete the assignment using SPSS.

  1. State the multiple regression equation.

  1. Interpret the meaning of the slopes, b1 and b2 , in this problem?

  1. Explain why the regression coefficient, b0, has no practical meaning in the context of this problem.

  1. Predict the mean fair market value for a house that has a land area of 0.25 acre and is 55 years old?

  1. Construct a 95% prediction interval estimate for the fair market value for an individual house that has a land area of 0.25 acre and is 55 years old.

Address Fair Market Value ($000) Property Size (acres) Age House Size (square feet) Rooms Baths Garage
9 Sycamore Road 522.9 0.2297 56 2448 7 3.5 2
21 Jefferson St 425.0 0.2192 61 1942 7 2.5 1
38 Hitching Post Lane 539.2 0.1630 39 2073 5 3 2
4 Poppy Lane 628.2 0.4608 28 2707 8 2.5 1
5 Daniel Drive 490.4 0.2549 56 2042 7 1.5 1
15 Francis Terrace 487.7 0.2290 98 2089 7 2 0
23 Guilfoy Street 370.3 0.1808 58 1433 7 2 0
17 Carlyle Drive 777.9 0.5015 17 2991 9 2.5 1
8 Craft Avenue 347.1 0.2229 62 1008 5 1 0
22 Beechwood Ct. 756.8 0.1300 25 3202 8 2.5 2
14 Fox Street 389.0 0.1763 64 2230 8 2 0
1 Raynham Road 889.0 1.3100 62 1848 7 2 1
2 Jerome Drive 452.2 0.2520 56 2100 6 2 0
7 Valentine Street 412.4 0.1148 22 1846 5 3 1
38 Jefferson Street 338.3 0.1693 74 1331 5 1 1
15 Inwood Road 334.3 0.1714 62 1344 8 1 0
29 Meadowfield Lane 437.4 0.3849 54 1822 6 2 1
13 Westland Drive 644.0 0.6545 56 2479 6 2.5 2
79 Valentine Street 387.8 0.1722 62 1605 6 3 0
13 Fairmont Place 399.8 0.1435 88 2080 11 2 0
1 Prestwick Terrace 356.4 0.2755 81 2410 6 1 1
11 Clement Street 346.9 0.1148 107 1753 8 2 0
7 Woodland Road 541.8 0.3636 55 1884 7 2 2
36 Elm Avenue 388.0 0.1474 51 2050 10 2 2
17 Duke Place 564.0 0.2281 50 2978 6 2.5 2
12 Prospect Avenue 454.4 0.4626 92 2132 7 1 0
1 Buckeye Road 417.3 0.1889 64 1551 6 2 0
30 Ann Street 318.8 0.1228 54 1129 5 1 0
26 Broadfield Place 519.8 0.1492 44 1674 7 2 1
16 Jackson Street 310.2 0.0852 104 1184 5 1 0

In: Math

An airline analyzed whether telephone callers to their reservations office would remain on hold longer if...

An airline analyzed whether telephone callers to their reservations office would remain on hold longer if they heard (a) an advertisement from the airline or (b) classical music. For 10 callers randomly assigned to these two conditions, the table shows the data.

Recorded Message  

Holding Time Observations

Advertisement

1, 2, 5, 8, 11

Classical Music   

7, 8, 9, 13, 15

Question 5:

Choose the correct alternate hypothesis for this test.

a. Ha: The distributions for classical music and advertisements are shifted from each other.

b. Ha: The distribution for classical music is shifted to the left of the distribution for advertisements.

c. Ha: The distribution for classical music is shifted to the right of the distribution for advertisements.

d. Ha: The distributions for classical music and advertisements are the same.

Question 6:

Provide the correct test statistic. Round answer to two decimal places.

Question 7:

Choose the correct p-value.

a. <0.0001

b. 0.0475

c. 0.0029

d. 0.0225

Question 8:

What conclusions can be drawn from this hypothesis test? α = 0.05

a. Fail to reject Ho. Conclude that there is insufficient evidence to claim that the two distributions are not identical.

b. Reject Ho. Conclude that there is sufficient evidence to claim that the distributions are shifted from each other.

c. Reject Ho. Conclude that there is sufficient evidence to claim that the distributions are not identical, and that people wait longer on the phone while listening to airline advertisements rather than classical music.

d. Reject Ho. Conclude that there is sufficient evidence to claim that the distributions are not identical, and that people wait longer on the phone while listening to classical music rather than airline advertisements.

In: Math

1) Melissa works as a biller for a small medical company and has just received her paycheck.

 

1) Melissa works as a biller for a small medical company and has just received her paycheck.

Her gross earnings were: 4300, with $900 deducted for Federal & State taxes, $175 deducted for medical insurance premiums, and $50 for disability insurance.

What is Melissa’s disposable income? ______________________

What is Melissa’s discretionary Income? ______________________

2) Using the information in questions 2, if Melissa also paid $1000 in rent, $100 for electric & gas, $50 in groceries, $150 for two pairs of shoes, and $50 on a video game as a gift for her boyfriend’s birthday, and left the rest in her savings account.

What is Melissa’s discretionary income? ________________________

How much does Melissa have left in discretionary income after paying her expenses? __________________

3) The amount of money loaned (whether it be the bank lending you money for a mortgage or you buying a bond) is called: ______________________

4) Bank of NY is short 20 million to meet its reserve requirement. To cover, Bank of NY borrows the money from Chase bank at what type of interest rate? ____________________________________

5) When a consumer gets a loan from a bank, the benchmark interest rate charged to them is called the ___________________________ rate.

6) Mohammed and Vanessa are both taking out student loans to complete their Ph. D in Business. They both go to TD Bank to apply for a loan. Mohammed has a credit rating of 800, while Vanessa has a credit rating of 650. Who would get the lower interest rate? _________________ Why? _____________________________________________________________________________________

7) Madalena borrows $300,000 from TD Bank at an annual interest rate of 8%. What is the amount of interest she will pay per year??

8) Jose has a 25,000 loan with a 5% annual interest rate, with a payment due April 1 st. What is the interest amount due on the loan?

In: Finance