complete the Exercises, use the spreadsheet file titled Budget Tools Chapter 02 Exercises. The exercises comes in three parts. The first part is intended to help you prepare for the second and third parts' it is a tutorial in the spreadsheet skills that are used in the second and third parts. 1. The spreadsheet opens on the " Tutorial" tab. Instructions are provided in the two highlighted green text boxes. The left text box first describes how cells F5 through F9 are summed in cell F10 and how all of these cells are formatted. It then asks you to do the same with data in cells F14 through F16. The right text box describes some advanced formatting skills and asks you to learn a very straightforward use of the "=" sign. After completing part 1, click on the "Explanation" tab, which gives step-by-step instructions for parts 2 and 3. Before completing these problems, look at the examples (using a different chart of accounts) on the blue tabs. 2. Copy the information from the "source" tab to the" Expenses" tab. When you copy the data you will learn the relationship between codes and labels. The table also contains dollar values associated with the labels. Put these data in blocks reflecting the categories shown on the "Summary" tab (look at the "Examples Summary" tab first). Format the copied information in a pleasing manner resembling the example of the first block at the top of the "Exercises" tab. Calculate subtotals for blocks, using the "subtotal" function, which should be shown at the bottom of each block as with the exaple. The "subtotal" function is explained in Appendix C, in the section on spreadsheeting for budget. 3. Carry the totals to the "summary" tab using the "=" sign as practced on the "Tutorial" tab. Format the "Summary" tab in a pleasing manner. Calculate sums as indicated by the :Total" labels on the "self-Check" column on the "Summary" tab has turned completely to"TRUE".
Category: Uncategorized
“If 200 microliters of a 2 ml extract prepared from 2 grams of wheat contains 10 micrograms of acid phosphatase, how much acid phosphatase is found in 1 gram of wheat?”
"If 200 microliters of a 2 ml extract prepared from 2 grams of wheat contains 10 micrograms of acid phosphatase, how much acid phosphatase is found in 1 gram of wheat?" I know that the answer is 50 micrograms, but I don't know how to get to that answer.
Is radiation good or bad for health? How many types…
Is radiation good or bad for health? How many types…
Is radiation good or bad for health? How many types of radiation are there? Additional Requirements Level of Detail: Only answer needed
BUS 308 Week 5 Final Paper. Get an A++.
BUS 308 Week 5 Final Paper. Get an A++.
Writing the Final Paper Assignment Instructions: A retail store has recently hired you as a consultant to advise on economic conditions. One important indicator that the retail store is concerned about is the unemployment rate. The retail store has found that an increase in the unemployment rate will cause a lack of consumer spending in their stores. Retail stores use the unemployment rate to estimate how much inventory to keep at their stores, which is important in maintaining cost effectiveness. In this consultant role you will apply calculations and research to create a predictive sales report. You will complete this project in two parts, but will submit your work as one Word document. Copy and paste your calculations from your Excel workbook into the Word document. The Final Project must be eight to ten pages in length, excluding title page and reference page(s) and must include at least three scholarly sources, in addition to the Job and Labor Statistics site. Be sure to format your work in accordance with APA guidelines outlined in the Ashford Writing Center. Part I Reference the data in this Excel workbook to complete the following quantitative components of the predictive sales report. You will complete the calculations below in your own Excel workbook and then copy and paste from your Excel workbook into the Word document. 1. Calculate the mean yearly value using the average unemployment rate by month found in the “Final Project Data Set.” 2. Using the years as your x-axis and the annual mean as your y-axis, create a scatter plot and a linear regression line. 3. Answer the following questions using your scatter plot and linear regression line: a. Compute the slope of the linear regression line. b. Identify the Y-intercept of the linear regression line. c. Identify the equation of the linear regression line in slope-intercept form. d. Calculate the unemployment rate in 2016, based on the linear regression line. e. Calculate the residuals of each year. f. Find the latest unemployment rate in your state. You will need to go to the Bureau of Labor Statistics website (www.bls.gov) and hover over “Subject Areas” in the top menu panel then select “State and Local Unemployment Rates” from the drop down menu under “Unemployment Rate”. Determine whether the rate in your state is within the range of the linear regression line or if it is an outlier. g. Interpret your results of the model and explain how a company could use the results to drive decision making. PART II Next interpret the analysis from Part I to complete the following qualitative components of the predictive sales report: 1. Introduce the project and its significance to the retail store. 2. Reference the statistical analysis that you completed in Part I and explain where the data came from, what type of analysis was done, what the findings were, and whether or not you believe the data to be accurate. 3. Explain your data-driven conclusions regarding the effects of the changing unemployment rate on the retail store. 4. Predict what could occur in the future that would change your linear regression line and therefore your prediction of sales
The Case For, or Against, New Orleans
The Case For, or Against, New Orleans
The Case For, or Against, New Orleans
Sometimes one’s choices may involve catastrophic decisions and bear great risk and yet there can be no clear answer. For example, if a person gets a divorce, shutters a plant, sells a losing investment, or closes their business, will he or she be better off? The following case incorporates nearly all of the material you have covered this far and presents an example of one such choice where nearly all of the alternatives have a significant downside risk.
Review the following information from the article “A Cost-Benefit Analysis of the New Orleans Flood Protection System” by Stéphane Hallegatte (2005):
Hallegatte, an environmentalist, assigns a probability (p) of a Katrina-like hurricane of 1/130 in his cost-benefit analysis for flood protection. However, the levees that protect New Orleans also put other regions at greater risk. You may assume the frequency of other floods is greater than Katrina-like events (Vastag & Rein, 2011).
The new levees that were built in response to Katrina cost approximately fourteen billion dollars (in 2010). This is in addition to the direct costs of Katrina (eighty-one billion dollars in 2005).
50 percent of New Orleans is at or below sea level.
A100-yearevent means that there is a 63 percent chance that such an event will occur within a 100-year period.
The following are theinterested (anchored and/or biased)constituencies:
Residents of New Orleans—both those that can move and those who cannot move
Residents of the surrounding floodplains at risk from New Orleans levees
The Mayor of New Orleans
The federal government—specifically taxpayers and the Federal Emergency Management Agency (FEMA)
Assume that the availability heuristics make people more risk averse (populations drop, at least in the short term). Consider how this would affect the local economy.
You are an analyst at FEMA and are in charge of developing a recommendation for both the state and the local governments on whether or not to redevelop New Orleans.
Write a report with your recommendation. Address the following in your report:
Part A
Analyze the economics of New Orleans in light of the above parameters and develop your own Cost-Benefit Analysis (CBA) for rebuilding.
Evaluate the value of the CBA for each constituency and integrate these estimates into a scenario model and/or decision tree. Analyze the results.
Clearly each of these constituencies may both overlap and be prey to a variety of group dynamics internally. For one of these options, discuss the decision pitfalls to which they may be susceptible and make a recommendation on how to alleviate these pressures.
Starting with your CBA, estimate the relevant expected utility for theinterested constituencies.
Note:You need not have absolute amounts but your relevant utilities should be proportional to one another.
Hint:If you assume that yourtotalCBA for New Orleans is fixed for each constituency (do not forget the overlaps), then each constituency will have a piece of the utility pie.
Part B
Make a case for or against rebuilding the city of New Orleans. This should be an executive summary; be concise and brief. Include exhibits.
Whether you are for or against, discuss how social heuristics could be used to your advantage, both ethically and unethically, in making your case. You may choose to fill the role of one of the constituents, if you prefer.
Write an 8–12-page report in Word format. Apply APA standards to citation of sources. Use proper spelling and grammar throughout, and keep the text legible and balanced with visuals.
http://www.washingtonpost.com/national/in-louisiana-a-choice-between-two-
floods/2011/05/11/AFrjFotG_story.html
Must review two articles, one is enclosed the other is hyperlinked above
Assignment 1 Grading Criteria Maximum Points
Analyze the economics of New Orleans in light of the given parameters and develop a Cost- Benefit Analysis (CBA) for rebuilding.
32
Evaluate the value of that CBA for each constituency and integrate these estimates into a scenario model and/or decision tree. Analyze the results.
68
Discuss the decision pitfalls to which constituencies may be susceptible and make a recommendation on how to alleviate those pressures.
32
Starting with the CBA, estimate the relevant expected utility for these parties.
32
Make a case for or against rebuilding the city of New Orleans. This should be an executive summary—be concise and brief. Include exhibits.
68
Discuss how social heuristics could be used to an advantage, both ethically and unethically, in making a case.
32
Estimate what percentage of the class was for, versus against, rebuilding and provide a confidence interval for the estimate.
8
Ensure academic writing, such as grammar, spelling, and attribution of sources, is appropriate.
28
Total:
Financial Planning Assignment 4
Financial Planning Assignment 4
Financial Planning Assignment 4 18.2 Eleanor needs $40,000 a year to live on in retirement net of the income she will receive. She will be retiring in 22 years and is funding for a 25-year retirement. The inflation rate is expected to be 3.5 percent a year and the after-tax return on her investments 6 percent. a. How much will the short fall amount to at the beginning of the retirement period? b. What lump sum will she need at the beginning of the retirement period? c. What is the required yearly savings? 18.3 Frank, age 28, wants to calculate his resources in real (inflation-adjusted) terms. Calculate the amount of resources made available by age 65 retirement if $18,000 a year is saved. Assume that outflows from ages 65-90 are at the rate of $27,000 a year. The projected inflation rate is 4 percent, and the anticipated investment return is 6 percent. a. How much in new savings will Frank have available at age 65 before subsequent withdrawals? b. How much will he have left at age 90? c. What is the present value of that sum at age 65? d. How much will he have to save per year exactly to meet his need? 18.4 The Smiths had $110,000 in savings at age 51. They had a desired retirement age of 65. They want to fund through age 92. Assume a 4 percent inflation rate and a 5 percent after-tax rate for investment both pre-and postretirement. They have household income of $140,000, which is increasing at the rate of inflation. Their expenditures including taxes are $125,000 a year. They estimate that in retirement they will receive $28,000 a year together in Social Security and Mr. Smith will receive a $12,000-a-year pension, both in today’s dollars. Their retirement expenditures would be $90,000 a year in today’s dollars. 1. Calculate a. The lump sum needed at retirement. b. Current assets available at retirement. c. Yearly savings needed. d. The difference between needs and resources. 2. Analysis a. Is their retirement plan achievable as is? b. If not, what are the alternatives that could help reconcile needs and resources? c. What is your recommendation?
APU POLS210 ALL WEEK FORUM EXCEPT WEEK 6
APU POLS210 ALL WEEK FORUM EXCEPT WEEK 6
WEEK 1 Week 1 forum image - we the people In the Lesson Notes for Week 1, the concept of Federalism was discussed. Over the years, have states gained more or less power relative to the federal government? Please discuss and cite examples to support your argument. Post by 11:55 pm (ET) on Friday; include citations or URLs for your work to receive full credit; and, provide substantive replies to the posts of at least 2 of your classmates by 11:55 pm (ET) on Sunday. Assignment responses should be no less than 300 words and no more than about 500 words, while student replies should be no less than 150 words and no more than about 300 words.
Assignment: Invasive Species Below are three…
Assignment: Invasive Species Below are three…
Assignment: Invasive Species Below are three websites where you will research and select an example of an invasive species. Once you have selected an invasive species, you will write an article describing the invasive species and the problems that it has caused. This article should be written as if it was going to be published in a local paper. Your article must be prepared in a Microsoft Word document, double-spaced, and in 12-point font (Times New Roman or Arial). Be sure to use proper spelling and grammar. The article must include the following: •Definition of invasive species •Description of the invasive species you selected •Description of the area in which the invasive species is found •Description of the area from which the invasive species was originally found (Where did it come from?) •Description of the problems it has caused •Two suggestions on how to solve the problems Resource sites: •Center for Invasive Species and Ecosystem Health - http://www.invasive.org/ •U.S. Fish & Wildlife Service - Invasive Species - http://www.fws.gov/invasives/index.html •National Oceanic and Atmospheric Administration – Invasive Species - http://oceanservice.noaa.gov/facts/invasive.html Additional Requirements Level of Detail: Only answer needed
Transatlantic World
What was the Transatlantic World like on the eve of the European Age of Discovery? And how did this change over the following 200 years? Explain how the process of exploration, settlement, and expansion was crucial to the development of the modern world as we know it today. You will want to touch on the conditions of life in Africa, Europe, and the Americas.
Review the following case study from your…
Review the following case study from your…
Review the following case study from your instructional materials: New York City gets 90% of its drinking water from the Catskills watershed about 60 miles away. Previously, the water quality was so high that no treatment or filtering was necessary. In recent decades, urbanization and expansion closer to the Catskills has begun to decrease water quality. Battles have ensued between the rural folk and farmers who don't want regulations put on their land use and the city that needs regulations controlling NPS pollutant sources so that water quality is maintained. Review the New York Times article A Catskills Compromise for additional information. In your discussion post, discuss the following: Is this enough to save New York's water? If not, what else do you feel should be done? Here is the website http://query.nytimes.com/gst/fullpage.html?res=950DEFDE143FF935A25753C1A9639C8B63 Additional Requirements Level of Detail: Only answer needed