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, 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. 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
| 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.
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 |
Hale Elizabeth Bot 744-6892 |
|
telnos3 |
telnos 4 |
|
Hale Elizabeth Bot 744-6892 |
Hale Elizabeth Bot 744-6892 |
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
In: Accounting
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.
State the multiple regression equation.
Interpret the meaning of the slopes, b1 and b2 , in this problem?
Explain why the regression coefficient, b0, has no practical meaning in the context of this problem.
Predict the mean fair market value for a house that has a land area of 0.25 acre and is 55 years old?
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 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.
State the multiple regression equation.
Interpret the meaning of the slopes, b1 and b2 , in this problem?
Explain why the regression coefficient, b0, has no practical meaning in the context of this problem.
Predict the mean fair market value for a house that has a land area of 0.25 acre and is 55 years old?
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 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.
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