difference in years calculation

difference in years calculation

In column F, calculate the difference in years using the same function as you used to calculate ages. Make sure the difference appears as a positive number by using the ABS function. In column G, use an IF function to display the word “years” if the celebrity is not the same age as you. This cell serves as a label to the difference value from column F.........Enter appropriate math, statistical, and lookup functions to answer the questions in the Interesting Facts range. Apply appropriate formats throughout the worksheet.

Celebrity Birthdays and Ages Compared to You									
									
									
Input Area				Interesting Facts:					
Today's Date				Youngest celeb's bday and name:					
Student Name				Oldest celeb's bday and name:					
				How many celebs are older than you?					
				How many celebs are the same age?					
				How many celebs are younger than you?					
				What is the average female celeb's age?					
				What is the average male celeb's age?					
									
Celebrity	Gender	Birth Date	Age	You are	Difference	Years	Rank		
Aiken, Clay	M	30/11/1978							
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									
									

Responsibility Centers and Master Budget ACC281: Accounting Concepts for Health Care Professionals (HCH1438A) DQ 1

Responsibility Centers and Master Budget ACC281: Accounting Concepts for Health Care Professionals (HCH1438A) DQ 1

Responsibility Centers and Master Budget ACC281

From your text and at least one scholarly source, research information on responsibility centers. Explain how responsibility centers are used for the budgeting process. You must respond to at least two of your other classmates’ posts to receive full credit.  

HRM 326 Final Exam

HRM 326 Final Exam

HRM 326 Final Exam

1). Business strategy influences how the company uses all of the following capitals EXCEPT:

2). to use _________ to gain a competitive advantage requires linking the company’s human resources practices (such as training and development) to the business strategy.

3). this provides employees with immediate access to information, advice, and guidance.

4). Centralized training means that training and development programs, resources, and professionals are primarily housed in one location and decisions about training investment, programs, and delivery methods are made from inter-related departments.

5). Research suggests that the company satisfaction with the outsourcing of training and development depends on company-supplier trust and the specificity of the contract.

6). an organizational analysis involves determining the appropriateness of training, based on all the following parameters, EXCEPT:

7). A mid-level manager questioning aspects such as who should be trained is involved with which variable of needs assessment?

8). the following are all advantages associated with online technology (software) method of needs assessment EXCEPT:

9). With respect to person analysis, a major pressure point for training is poor or substandard rewards system:

10).Trainees need to understand what specifically they are expected to learn in the training program.

11). Regardless of the training methods, all of the following are some of the conditions which must be present for learning to occur, EXCEPT:

12). this includes specialized knowledge that employees need in their jobs.

13). this relates to the learner’s decision regarding what information to attend, how to remember and how to solve programs

14). Pedagogy gives the instructor major responsibility for making decisions about learning content, method, and evaluation

15). Seating arrangement at the training site should be based on an understanding of the desired type of trainee interaction and trainee-trainer interaction.

16). ______ refers to the collection of information – including what, when, how, and from whom – that will be used to determine the effectiveness of the training program.

17). What provides a way to understand the investments that training produces and provides information needed to improve training?

18). _______ can be used as a “dress rehearsal” to show the program to managers, trainees, and customers.

19). Identify the third level outcome amongst the following Kirkpatrick’s four-level framework for categorizing training outcomes.

20). Skill-based outcomes include acquisition or learning of skills and use of skills on the jobs.

21). All of the following are the most frequently used training techniques EXCEPT:

22). the following are all advantages of using videos as a component of training EXCEPT:

23). in case studies, trainees are required to analyze and critique the actions taken, indicating the appropriate actions and suggesting what might have been done differently

24). Meaningfulness of business games are enhanced if they are imaginative

25). Vicarious reinforcement occurs when a trainee sees a model being reinforced for using certain behaviors.

26). this typically involves videoconferencing and/or computers for the delivery of instructions from a trainer to trainees who are different locations.

27). which one of the following is NOT an advantage of e-learning?

28). Online learning allows more employees to gain access to these types of programs in a quicker time period than if face-to-face instruction is used.

29). simply providing learning control ensures that trainees will use all the features provided by online learning.

30). which of the following is evidence supporting the assertion that companies are investing in more training?

31). Learning is defined as

32). According to the text, _____ provides the opportunity for learning and _____ is a result of the learning.

33). to understand a manager's development needs, you must first understand _____.

34). which of the following is not an advantage to using externally based training programs for mangers?

35). which of the following statements about corporate universities is not true?

Case: Property Purchase Strategy.

Case: Property Purchase Strategy.

Case: Property Purchase Strategy.
Case Problem 1 PROPERTY PURCHASE STRATEGY
Glenn Foreman, president of Ocean view Development Corporation, is considering submitting a bid to purchase property that will be sold by sealed bid at a county tax foreclosure:

Glenn's initial judgment is to submit a bid of $5 million. Based on his experience, Glenn estimates that a bid of $5 million will have a 0.2 probability of being the highest bid and securing the property for Oceanview. The current date is June 1. Sealed bids for the property must be submitted by August 15. The winning bid will be announced on September 1.

If Oceanview submits the highest bid and obtains the property, the firm plans to build and sell a complex of luxury condominiums. However, a complicating factor is that the property is currently zoned for single-family residences only. Glenn believes that a referendum could be placed on the voting ballot in time for the November election. Passage of the referendum would change the zoning of the property and permit construction of the condominiums.

The sealed-bid procedure requires the bid to be submitted with a certified check for 10% of the amount bid. If the bid is rejected, the deposit is refunded. If the bid is accepted, the deposit is the down payment for the property. However, if the bid is accepted and the bidder does not follow through with the purchase and meet the remainder of the financial obligation within six months, the deposit will be forfeited. In this case, the county will offer the property to the next highest bidder.

To determine whether Oceanview should submit the $5 million bid, Glenn conducted some preliminary analysis. This preliminary work provided an assessment of 0.3 for the probability that the referendum for a zoning change will be approved and resulted in the following estimates of the costs and revenues that will be incurred if the condominiums are built.






REVENUE AND COST EXTIMATES
REVENUE FROM CONDOMINIUM SALES $ 15 MILLION
COST
PROPERTY $ 5 MILLION.
CONSTRUCTION EXPENSES $ 8 MILLION.

If Oceanview obtains the property and the zoning change is rejected in November, Glenn believes that the best option would be for the firm not to complete the purchase of the property. In this case, Ocean view would forfeit the 10% deposit that accompanied the bid.

Because the likelihood that the zoning referendum will be approved is such an important factor in the decision process, Glenn has suggested that the firm hire a market research service to conduct a survey of voters. The survey would provide a better estimate of the likelihood that the referendum for a zoning change would be approved. The market research firm that Oceanview Development has worked with in the past has agreed to do the study for $15,000.The results of the study will be available August 1, so that Oceanview will have this information before the August 15 bid deadline. The results of the survey will be either a prediction that the zoning change will be approved or a prediction that the zoning change will be rejected. After considering the record of the market research service in previous studies conducted for Oceanview, Glenn has developed the following probability estimates concerning the accuracy of the market research information.

P(A |s1) = 0.9

P(A |s2) = 0.2

p(N | s1) = 0.1

P(N |s2) = 0.8

where

A = prediction of zoning change approval
N = prediction that zoning change will not be approved
s1 = the zoning change is approved by the voters
s2 = the zoning change is rejected by the voters


Managerial Report
Perform an analysis of the problem facing the Oceanview Development Corporation, and prepare a report that summarizes your findings and recommendations. Include the following items in your report:

1. A decision tree that shows the logical sequence of the decision problem

2. A recommendation regarding what Oceanview should do if the market research information is not available

3 A decision strategy that Oceanview should follow if the market research is conducted

4. A recommendation as to whether Oceanview should employ the market research firm, along with the value of the information provided by the market research firm
Include the details of your analysis as an appendix to your report.

And also a spreadsheet report of this case

The Case of the Web Surfers

The Case of the Web Surfers

The Problem: The Case of the Web Surfers

You have been hearing rumors that people are using company time to “surf” the ‘net and to conduct personal business on the company Internet system. You have heard in the news and from your HR people that problems can occur if people are either accessing pornography or other work inappropriate sites. Also, e-mails are going out to unintended recipients – salacious jokes or other comments that many would find offensive and are clearly inappropriate in the work place. The current policy is to treat the computer like a telephone, which is to say there is an assumed “expectation of privacy” where what one does on the computer is confidential. The question is whether that should in fact be the policy or whether, in light of these recent events, there should be a more restrictive policy in your department.

Be Intelligent: Identify the Issue and the Values in Tension 1. Issue

In one sentence, identify the issue for this problem.

Values in Tension

In three or four bullet points, identify the values in tension 

flat organizational structure

flat organizational structure

1. What do you believe one are influences among managers who operate using a flat organizational structure may exert on an organization, as opposed to the impact of managers with specialized skills in a hierarchical structure. Provide support for your rationale.
2. Put yourself in a managers position that's responsible for implementing an extensive technology change within an organization. How do you think most employees are will react to this change. What is one (1) way in which you would decrease the impact of this reaction to the change management process. Provide support for your suggestion.

3. Reommend one (1) HR Management strategy that both addresses the needs of a multi-generational workforce and supports an organization’s recruitment and maintenance of quality employees. Provide support for your recommendation.

4. Attempt to come up with (1) significant challenge that may be management related management related to diversity, and suggest one (1) strategy that management may use either to minimize or overcome this challenge. Provide one (1) example to illustrate the challenge.

situations in which having competitors can help you

situations in which having competitors can help you

In most cases, competitors are viewed as being undesirable, that is, having fewer competitors is better than having many. Can you think of situations in which having competitors can help you?

Microsoft is planning to introduce a new PC operating system to replace Windows 7. What kind of research would it need to do in order to have confidence that the new software would sell well? 

Final Research Paper

Final Research Paper

Review the Final Research Paper instructions located within the Final Research Paper link in your online course or under the “Components of Course Evaluation” section of this guide. The Final Research Paper is due in Week Five. To help with the preparation of the paper, complete the following and submit it to your instructor for feedback.
a.	Topic: Refer to the Final Research Paper guidelines for your topic selection. Confirm your topic, and identify how this selection relates to your academic and professional pursuits. Review the feedback from your topic choice presented in the Week One discussion. How did your argument stand up to the examination of your peers?
b.	Thesis: Write a direct and concise thesis statement, which will become the point or perspective you will argue or prove in the Final Research Paper. Refer to the Ashford Online Writing Center for information on how to develop a solid thesis statement.
c.	Annotated Bibliography: To help prepare for your final paper, you will be writing an annotated bibliography to indicate the quality of the sources you have read. Please make sure to cite each source using APA style. After each citation, write a brief paragraph (around 150 words) summarizing the source and examining how it will support you in defending your argument. For more information and example of an annotated bibliography, please refer to section 7.7 in the Ashford Writing Center within the Learning Resources tab on the left navigation toolbar in your online course.. Keep in mind the Academic Research standards for all Ashford University Papers.
Academic Research Standards

Academic research and papers must meet certain standards of quality recognized by the academic community. What constitutes quality, academic research?
a.	Primary sources, which are documents from the time period being discussed
b.	Secondary sources supported by research in primary sources 
c.	Credible sources (experts in the area of study) 
d.	Relevant research (materials are pertinent to the area of study) 
e.	In graduate work, the use of peer-reviewed journal articles (journal articles reviewed by recognized experts in the relevant field of study) is required.
f.	Educational and Government websites may be appropriate in some cases, but should be evaluated carefully.
The paper must be five to seven pages in length (excluding the title pages) and formatted according to APA style. You must use at least five scholarly sources, three of which can be found in the Ashford Online Library, to support your points. Of the five sources, two will be your primary sources, and one will meet the multimedia requirement. For information regarding APA, including samples and tutorials, visit the Ashford Writing Center within the Learning Resources tab on the left navigation toolbar in your online course.

Suppose that the table below shows an economy’s relationship between real output and the inputs needed to produce that output:

Suppose that the table below shows an economy’s relationship between real output and the inputs needed to produce that output:

Suppose that the table below shows an economy’s relationship between real output and the inputs needed to produce that output:

Input
Quantity
Real
GDP
300.00	$400
225.00	300
150.00	200

a. What is the level of productivity in this economy?

Instructions: Round your answer to two decimal places.



b. What is the per-unit cost of production if the price of each input unit is $5?

Instructions: Round your answer to two decimal places.

$ 

c. Assume that the input price increases from $5 to $6 with no accompanying change in productivity.

What is the new per-unit cost of production?

Instructions: Round your answer to two decimal places.

$ 

In what direction would the $1 increase in input price push the economy’s aggregate supply curve?

The aggregate supply curve would shift to the .

What effect would this shift of aggregate supply have on the price level and the level of real output? 

d. Suppose that the increase in input price does not occur but, instead, that productivity increases by 25% percent. What would be the new per-unit cost of production?

Instructions: Round your answer to three decimal places. 

$ 

What effect would this change in per-unit production cost have on the economy’s aggregate supply curve?

The aggregate supply curve will shift to the .

What effect would this shift of aggregate supply have on the price level and the level of real output?