1 A Backhoe Acquired On January 5 At Acost Of 84 000 Has An Estimated Useful Life Of 3529288

/in /by

1. A backhoe acquired on January 5 at a cost of $84,000 has an estimated useful life of 12 years. Assuming that it will have no residual value, determine the depreciation for each of the first two years (a) by the straight-line method and (b) by the declining-balance method, using twice the straight-line rate. Round to the nearest dollar

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

1 4 Points Professor Crewel Would Like To See The Distribution Of Questions Difficul 2379462

/in /by

1. (4 points) Professor Crewel would like to see the distribution of questions difficulty among the various topics.
For each question list the topic title, the question id, the questions status, and the question difficulty. Sort the results for question difficulty. Within question difficulty sort the questions by topic title. Use a join. Do not use the INNER JOIN keywords.

SELECT A. Title, B. QuestionId, B. Status, B. Difficulty from Topics A., Question B WHERE

A. Topicid =B. Topicid ORDER BY B. Difficulty, A. Title how do u show The result of the SELECT statement

Document Preview:

CITD 120 — SQL Concepts Homework Assignment 4 40 points NOTE: The Course Quizzes database you are using for this assignment is a test database and contains much less data than would be in the production database used to run the company. It has been made smaller to make it easier for you to check that your SELECT statement retrieves the correct data. However, retrieving the correct data from the testing database is not a guarantee that the SELECT statement is correct. You must write your commands as if they were run against the larger database which has different data than the testing database you are using. The ER Diagram for the Course Quizzes database is shown below. For EACH TASK for this assignment submit the following: a. The SELECT statement you used. b. The result of the SELECT statement. TASKS: (4 points) Professor Crewel would like to see the distribution of questions difficulty among the various topics.For each question list the topic title, the question id, the questions status, and the question difficulty. Sort the results for question difficulty. Within question difficulty sort the questions by topic title. Use a join. Do not use the INNER JOIN keywords. SELECT A. Title, B. QuestionId, B. Status, B. Difficulty from Topics A., Question B WHERE A. Topicid =B. Topicid ORDER BY B. Difficulty, A. Title 2.(4 points) Professor Crewel would like to know the text of the questions she has used on quiz 2.List the question text for the questions for quiz 2. Do not use a join. Use the IN operator. SELECT Text FROM Questions WHERE QuestionId in (SELECT QuesionId from QuizQuestionns WHERE QuizNum = 2) 3.(4 points) Professor Crewel would like to know which questions she has used on quiz 2.List the question text for the questions for quiz 2. Do not use a join. Use the EXISTS operator. SELECT Text FROM QuestionQ WHERE EXISTS ( SELECT* FROM QuizQuestionsQQ …

Attachments:

CITD120Assign….docxCourseQuiz1–….zip

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

1 40 Points You Are Evaluating Two Potential Public Projects To Implement In Your Lo 2420955

/in /by

1. (40 points) You are evaluating two potential public projects to implement in your local jurisdiction. Both projects have a 10 year time horizon. For Project Alpha, the cost at the end of the first year is $1,000,000 and $100,000 each year thereafter. There are no benefits in the first two years but are constant at $300,000 per year thereafter. For Project Beta, the cost at the end of the first year is $1,000,000 and $90,000 each year thereafter. Benefits are constant at $200,000 per year for all years.

Use Excel to answer the following questions in 2-5 sentences each. You have to provide your answers here even if you are attaching a separate Excel file.

1) What is the NPV for Project Alpha? In your answer explain what NPV is, why it’s useful as well as its shortcomings.

2) Does Project Alpha pass the economic efficiency test based on your answer in part 1)? Why? Explain?

3) What is the BCR for Pro Project Alpha? In your answer explain what BCR is, why it’s useful as well as its shortcomings.

4) Does Project Alpha pass the economic efficiency test based on your answer in part 3)? Why? Explain?

5) What is the IRR for Project Alpha? In your answer explain what IRR is, why it’s useful as well as its shortcomings.

6) Does Project Alpha pass the economic efficiency test based on your answer in part 5)? Why? Explain?

7) Are your conclusions about economic efficiency consistent in parts 2), 4), and 6)? Why or why not? Did you expect this?

8) What is the NPV for Project Beta?

9) Does Project Beta pass the economic efficiency test based on your answer in part 8)? Why? Explain?

10)What is the BCR for Project Beta?

11) Does Project Beta pass the economic efficiency test based on your answer in part 10)? Why? Explain?

12)What is the IRR for Project Beta?

13)Does Project Beta pass the economic efficiency test based on your answer in part 12)? Why? Explain?

14)Are your conclusions about economic efficiency consistent in parts 9), 11), and 13)? Why or why not?

15)Which project would you recommend? Why?

16)What if I told you that Project Alpha is a football stadium and Project Beta is a hospital and your jurisdiction currently does not have either? Would your answer change? Why or why not?

17)Instead of implementing either project, if you invested your $1,000,000 today at a 5% interest rate which compounds quarterly, how much money would you have in 10 years?

2. (28 points) It’s that time of the year and you have to calculate your federal taxes. (Lucky for you, there are no state or local income taxes where you live.) You have gathered these data about your finances:

i. Wage income = $45,000

ii. Corporate bond interest income = $800

iii. US Treasury bond interest income = $1000

iv. Tax-exempt Interest income from the bond issued by the State of Georgia = $600

v. Total itemized deductions = $12,000

Use the personal exemptions, standard deductions and rate schedule in this link:https://taxfoundation.org/2017-tax-brackets/

First, suppose you are single:

1) What is your marginal tax rate?

2) What is your tax liability?

3) What is your effective tax rate?

4) How would a $1,000 tax credit change your tax liability and effective tax rate?

Now, suppose you are married and your spouse has no wage or interest income and your joint itemized deductions are still $12,000:

5) What is your joint marginal tax rate?

6) What is your joint tax liability?

7) What is your joint effective tax rate?

8) How would a $1,000 tax credit change your tax liability and effective tax rate?

Now, suppose you are married and your spouse has the exact same income profile as you and your joint itemized deductions are still $12,000:

9) What is your joint marginal tax rate?

10)What is your joint tax liability?

11) What is your joint effective tax rate?

12)How would a $1,000 tax credit change your tax liability and effective tax rate?

13)Do you think this is fair? Does this make you want to get married or stay single?

14)Is this tax system progressive, regressive, or proportional? Why?

3. (14 points) A small town has a property tax base with an appraised value of $400,000 of taxable real property, $80,000 of taxable personal property, and $50,000 of non-taxable property. The assessment ratio is 40% for this local government. The homestead exemption is relatively small but reduces the assessed value by $50,000. The town estimates that the budgetary needs at $120,000.

1) What statutory tax rate would allow the town to meet its budgetary obligations?

2) Given the statutory tax rate you found in part 1), what is the effective property tax rate for this town?

3) You are contemplating about moving to this town. The property you are interested in buying has a market value of $150,000. How much would you pay in property taxes to this school district?

4) How would your answer in part 3) change if you discovered that you could get a $5,000 exemption against the assessed value of your new home?

5) Would your property tax bill affect your decision to move to this town? Why or why not? What other information might be helpful in making your decision?

6) Suppose that the property tax rate you found in part 1) increases by 3%. What is the new rate and your new tax bill?

7) Suppose that the property tax rate you found in part 1) increases by $1 per $100 of assessed value. What is the new rate and your new tax bill?

4. (12 points) Suppose you are in the 25% federal income tax bracket and want to invest $100,000 in an interest-earning asset.

1) Which asset would you invest in and why:

i. AAA rated (highest rating) municipal bond with a 4% yield or

ii. AAA rated (highest rating) corporate bond with a 5.4% yield

iii. U.S. treasuries with a 5.5% yield? Explain.

2) Suppose you get a large pay raise and your marginal income tax rate is now 39.6%. How would your answer change in part 1)?

3) What do you conclude about the value of tax-exemption for different income groups?

4) Do you think this type of tax preference is fair?

5) Would you answer change if the corporate bond rating declined to below investment grade? Why?

6) Would your answer change if the municipal bond rating declined to below investment grade? Why?

5. (6 points) Explain the role of financial statement analysis, Balance Sheet and Income Statement, and financial ratios in evaluating financial health of a jurisdiction or an organization in 1-2 paragraphs.

Attachments:

Problem-Set-4….docx

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

1 A Group Of Researchers Conducted An Experiment To Determine Which Vaccine Is More 2858724

/in /by

1.A group of researchers conducted an experiment to determine which vaccine is more effective for preventing getting the flu. They tested two different types of vaccines: a shot and a nasal spray. To test the effectiveness, 1000 participants were randomly selected with 500 people getting the shot and 500 the nasal spray. Of the 500 people were treated with the shot, 80 developed the flu and 420 did not. Of the people who were treated with the nasal spray, 120 people developed the flu and 380 did not. The level of significance was set at .05. The proportion of people who were treated with the shot who developed the flu = .16, and the proportion of the people who were treated with the nasal spray was .24. The calculated p value = .0008.

We have to research Is there any significant difference between two typres of vaccine i.e, a shot and nasal spray used for preventing nasal spray?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

1 A Gearbox Is Modeled As Which Comprises Two Identical Gears Of Moments Of Inertia 2647670

/in /by

1. A gearbox is modeled as which comprises two identical gears of moments of inertia J1 and N1 teeth, meshing with two identical pinions of moments of inertia J2 and N2 teeth. All three shafts have stiffness k. For the relations given below:

find the natural frequencies and natural modes of the system. Sketch the latter.

2. Derive a procedure to obtain the zero-state response of a two-dof semidefinite system that does not preserve the generalized—translational or angular— momentum. To this end, use as an example the belt-pulley system.

 

 

 

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

1 According To Service Quality Model Willingness Of Employees To Solve Problems Of C 2847171

/in /by

1.According to service quality model, willingness of employees to solve problems of customers is classified as A. responsiveness B.assurance C.empathy D.reliability 2. Considering categories of services mix, air travel with eatable is classified as A. tangible goods with accompanying services B.pure tangible goods C.pure services D.major service with minor goods 3. Legal staff, computer operators and accountants are examples of services of A. government sector B.private non-profit sector C.manufacturing sector D.business sector 4. Hospitals, loan agencies, postal services and schools are examples of services of A.government sector B.private non-profit sector C.manufacturing sector D.business sector 5. Act of specific performance offered by one party to another and tangible in nature is classified as A.service B.product C.co-branding D.None of the above

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

1 A Group Of Researchers Conducted An Experiment To Determine Which Vaccine Is More 2858721

/in /by

1.A group of researchers conducted an experiment to determine which vaccine is more effective for preventing getting the flu. They tested two different types of vaccines: a shot and a nasal spray. To test the effectiveness, 1000 participants were randomly selected with 500 people getting the shot and 500 the nasal spray. Of the 500 people were treated with the shot, 80 developed the flu and 420 did not. Of the people who were treated with the nasal spray, 120 people developed the flu and 380 did not. The level of significance was set at .05. The proportion of people who were treated with the shot who developed the flu = .16, and the proportion of the people who were treated with the nasal spray was .24. The calculated p value = .0008.

We have to research Is there any significant difference between two typres of vaccine i.e, a shot and nasal spray used for preventing nasal spray?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

1 According To The Ef Is The Human Population Living At Beyond Or Below The Earth S 2766987

/in /by

1. According to the EF, is the human population living at, beyond or below the Earth’s natural biocapacity? For how long has this been the case? Is this sustainable? (4 marks) 2. According to the EF, is the Chinese population living at, beyond or below China’s natural biocapacity? For how long has this been the case? Is this sustainable? (4 marks) 3. If you assume that EF grows at a constant yearly rate, what is the approximate slope of the EF relationship with time for China? And what is its units? Give the equation of, and sketch this line, with EF on the vertical axis and year on the horizontal axis. (EF for 2012 is 3.4 and for 1961 was approximately 1). (4 marks) 4. If you assume that biocapacity grows at a constant yearly rate, what is the approximate slope of the biocapacity relationship with time for China? And what is its units? Give the equation of, and sketch this line, with biocapacity on the vertical axis and year on the horizontal axis. (biocapacity for 2012 is 0.9 and for 1961 was approximately 1). (4 marks) 5. If this trend continues, what will EF and biocapacity be in 2050? (Hint: use your equation from questions 3 and 4.) What will biocapacity minus EF be in 2050? Will there be a deficit or reserve? (4 marks) 6. Use the data presented in Figure 1 to suggest a policy to make land use sustainable. (4 marks)
The model describes the evolution of a population over time ??. ??(??) = ??0?? (??-??)?? (1) where ??0 is the population at time ?? = 0. 1. If the initial population is ??0 = 2000, the annual birth rate ?? = 0.03 (3% exponential birth rate) and annual death rate ?? = 0.02 (2% exponential death rate), what is the population after 1 year? Explain this result. (4 marks) 2. Find an expression for the growth rate (population change) of the population in terms of time and the parameters. Hint: differentiating with respect to time gives a rate of change. (4 marks) 3. If ??
The model in equation (1) in Part A describes a population untouched by humans: there is no harvesting. We can model what happens if we harvest ?? individuals from the population each period. The unlimited population growth with harvesting model is given by ??(??) = ???? (??-??)?? + ??-???? (??-??)?? (??-??) (2) where ?? is the birth rate, ?? is the death rate, and ?? is the number of individuals taken from the population in each period. 1. Confirm that the rate of population change is ????(??) ???? = (?? – ??)??(??) – ??. (3) (5 marks) 2. Give the meaning of the expression in equation (3). (4 marks) 3. Let ??0 = ??(0) = 2000, ?? = 0.05 and ?? = 0.02. At what rate can the population be harvested sustainably? Hint: The sustainable harvest, ??, will be the value that causes no change in the overall population, i.e. ????(??) ???? = 0. (4 marks) 4. Suppose an ecosystem is being sustainably harvested at exactly its replacement rate, and the population is constant. Now suppose the population experiences a brief disease epidemic, which causes 4% of individuals to perish. What will happen to the population if harvesting continues at the same rate? (4 marks) 5. Suppose a population of fish that follows this model is being harvested sustainably, as before. What will happen in the long run if, one day, a fisherman decides to throw one of the fish back? (4 marks) 6. This type of model is often said to have a “knife-edge” equilibrium. Explain what this means. (4 marks) 7. Governments often levy fishing quotas in areas where populations are at risk. Does this model shed any light on the effectiveness (or otherwise) of these policies? (Hint: what if someone cheats?) (4 marks)
A model linking these ideas was first proposed by a French mathematician Pierre Verhulst in 1838. The Verhulst model can be written as: ??(??) = ??0?? ???? 1+ ??0(?? ????-1) ?? (4) where ??0 is the initial population level. For simplicity, we’ll write the net reproduction rate simply as ??, rather than in terms of births and deaths. 1. What is the growth rate if the initial population is zero? (4 marks) 2. When the population is initially at its carrying capacity, i.e. ??0 = ??, what is the population at time ??? How does the population level change when the growth rate r increases? (4 marks) 3. Differentiate (4) to show that the rate of population growth at time t is ????(??) ???? = ????(??) (1 – ??(??) ?? ) (5) Remember to use the quotient rule to differentiate (4). You will find it easier if you carefully look for the terms that you expect to see in the final expression, and factor those out. (5 marks) 4. Does the population grow faster when it is above the environment’s carrying capacity (N>K), or below it (??

Attachments:

V2.pdf

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

1 A For The Circuit Shown In Figure 1 Sketch The Voltage Waveform Across The Seconda 2866555

/in /by

1. (a) For the circuit shown in FIGURE 1 sketch the voltage waveform across the secondary winding of the transformer. On the same diagram sketch the load voltage waveform. The sketches should take into account diode voltage drops. Indicate the following on the sketches: (i) when diodes are conducting and in what order (ii) when the capacitor is charging and discharging (b) With the aid of the above voltage waveform sketches, briefly explain the operation of the circuit. Document Preview:

(a) For the circuit shown in FIGURE 1 sketch the voltage waveform across the secondary winding of the transformer. On the same diagram sketch the load voltage waveform. The sketches should take into account diode voltage drops. Indicate the following on the sketches: when diodes are conducting and in what order when the capacitor is charging and discharging With the aid of the above voltage waveform sketches, briefly explain the operation of the circuit. T1 vSECONDARYDD1ESUPPLY2 D3D4 C1vCRL 10 : 1 FIG. 1 Teesside University Open Learning© Teesside University 2011 Created with an evaluation copy of Aspose.Words. To discover the full versions of our APIs please visit: https://products.aspose.com/words/ The source voltage for the power supply circuit shown in FIGURE 1 is mains, i.e. 230 V rms at a frequency of 50 Hz. Calculate the following for a load resistance of 25 ? and a smoothing capacitance of 1000 µF: rms and peak voltage across the secondary winding of the transformer the peak voltage across the capacitor the peak-to-peak and rms ripple voltages the load d.c. voltage and current. Model the power supply circuit using PSPICE and use the simulation to plot the load and ripple voltages, the current in the capacitor and a diode. Compare the waveforms with the values calculated above and attempt to account for any discrepancies. Briefly explain the function and operation of TR1, TR2, R1 and R1 in the circuit shown in FIGURE 2. R2 TR1 Created with an evaluation copy of Aspose.Words. To discover the full versions of our APIs please visit: https://products.aspose.com/words/ R1 TR2 Voltage regulator InOut Common Created with an evaluation copy of Aspose.Words. To discover the full versions of our APIs please visit: https://products.aspose.com/words/ VINRLOAD FIG. 2 Teesside University Open Learning© Teesside University 2011 Created with an evaluation copy…

Attachments:

em201852abd95….doc

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW

1 A What Is The Relationship If Any Between The Amount Shown In The Adjusted Trial B 1416007

/in /by

1.

a)

What is the relationship, if any,between the amount shown in the adjusted trial balance column for an account and that account and that account’s ledgerbalance?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
ORDER NOW