Month: September 2015

You have been requested to create two reports using the AdventureWorks database.

Report 1:

A report has been requested that will show a full list of products in each subcategory and category. Provide the ability to use drill down on both the category and subcategory. Also provide a count of the number of products in each subcategory. The report will be graded based on the following:

• Appropriate fields
• Report layout
• Grouping on correct fields
• Group totals

Report 2:

Produce a report that shows the total sales for each territory. Allow the user to drill down through the territory to see the total sales amounts for individual categories. The report will be graded based on the following:

• Appropriate fields
• Report layout
• Drill down
• Interpretation

Upon completing this lab, you will be able to

1. create report groups,
2. use formulas and aggregate functions to produce report totals,
3. use formulas and aggregate functions to generate group totals,
4. incorporate drill down features, and
5. specify paging information – placing page breaks, page numbers, and so forth.

What is plant? how many kinds of plant do we have? state and explain the type of plants we have?

In response to increasing criticism over its sponsorship of physician-education courses (and the suggestion of undue influence on doctors prescriptions and procedures), the drug maker Pfizer announced in July 2008 that it would no longer pay marketing communications companies to arrange continuing medical education (CME) courses, which doctors must take to maintain their licenses. Pfizer said it would support medical education only when it was put on by hospitals and professional medical associations. Zimmer Holdings, a medical device manufacturer that manufactures hip, knee, and elbow implants, suspended funding of all CME activity. The company said it will restrict the way it funds courses in the future by identifying an independent third party, such as a professional society, to organize educational programs.

 

“We understand that even the appearance of conflicts in CME is damaging, and we are determined to take actions that are in the best interests of patients and physicians,” Dr. Joseph M. Feczko, Pfizer’s chief medical officer, said in a press release.

 

Industry support for CME has quadrupled since 1988, to $1.2 billion a year, according to the Accreditation Council for Continuing Medical Education (ACCME), an organization in Chicago that approves CME providers. More than half of that is funneled to marketers, with the rest going to hospitals, medical associations, and other nonprofit entities.

 

As industry money for continuing education proliferates, so do worries that many of the courses have become at least partly aimed at promoting products. The industry and its outside marketers say they ensure that the courses remain free of commercial influence. But some medical experts argue that when employees of communications firms are beholden to pharmaceutical and device companies, they will produce CME courses that are slanted in favor of their sponsors, even if they don’t realize what they are doing. “There’s not only a perception of bias, there’s a reality,” says Dave Davis, a vice president of Association of America Medical Colleges.

 

In January 2010, Pfizer appeared to modify its 2008 position by announcing a $3 million grant to Stanford University to create continuing medical education courses that the company claims will come with “no conditions, and the company will not be involved in developing the curriculum.” However, critics have argued that the curriculum will most likely focus on at least two areas in which Pfizer has major product lines: smoking cessation and heart disease.

 

 

 

Case #1

 

#1) Where is the conflict of interest in this CME relationship?

#2) Do you think doctors are likely to be influenced by such promotional tactics? Why or why not?

#3) If the pharmaceutical company is paying for the event, shouldn’t it have the right to promote its products at the event? Why or why not?

#4) Pfizer stated in 2008 that it would only support medical education put on by hospitals and professional medical associations. How can it then justify the Stanford grant?

#5) Has Pfizer simply replaced one conflict of interest with another? Why or why not?

#6) Propose an alternative approach to ensure that CME is provided without a conflict of interest.

 

 

The Cooper Processing Company
The Cooper Processing Company (CPC) is a manufacturer/processor of food products. Located in the city of Lansing, Michigan, the company services a national market with processed and packaged meat items such as hot dogs, bologna, sausage, etc. Because the company has been experiencing increased costs in marketing and logistical activities it has hired you as an expert to analyze costs and investments and make recommendations to management. In its most recent fiscal year, the company achieved sales of $100,000,000.
The company sells its products through two separate channels of distribution and each is treated as a profit center with full financial responsibility for income statement and balance sheet. The first channel is to retail grocery stores and supermarkets. The second channel is to food service wholesalers who, in turn, sell to restaurants and other food service establishments. According to the company accounting records, the retail segment accounts for 60 percent of sales, food service for 40 percent. The cost accountant believes that both channels are profitable. He says that the company achieves an overall average gross margin of 60 percent on its sales.
The cost accountant also provides you with the following total costs for various marketing and logistics functions at CPC:
The total of all other expenses at CPC is $15,000,000.
The company’s cost accountant has always allocated all expenses and investments to the channels based on the percentage of sales volume and has used the overall company average of 60 percent gross margin to determine the profitability of each channel of distribution.
You, being much wiser than the company cost accountant, decide to do a little further analysis. The first thing you discover is that, due to differences in product mix sold in each channel, gross margins actually are different in each. You find that the gross margin in the retail channel is 70 percent, in the food service channel it is 45 percent.
Next, you find that all of the salespeople are paid a straight salary and all receive exactly the same amount of salary. However, you find that of the 50 sales people employed by CPC, 40 of them are devoted to the retail channel, 10 of them are devoted to the food service channel. Since there are no sales managers and each salesperson pays for selling expense out of their salary, this accounts for all of the personal selling expense.
You learn that all sales promotions were conducted in the retail channel.
Next, you discover that there is a great difference in the number of orders placed by customers in each channel and the deliveries to each channel. You find that the retail channel accounts for 70 percent of the orders placed and 80 percent of the delivery expense. The food service channel accounts for 30 percent of the orders placed and 20 percent of the delivery expense. Your activity-based approach suggests that this is a reasonable way to trace the costs directly to each segment.
Next you learn that packaging differs for each channel. You discover that retail accounts for 80 percent of the packaging cost, food service for 20 percent. (Don’t worry about how you discovered this.)
Next, you discover that only the retail channel requires “labeling.” The company has a machine which applies these labels. The labeling expense of $2,000,000 includes materials, labor, and depreciation of the machine. The machine has an asset value of $10,000,000.
Next, you find that the company has inventory of $10,000,000 (this has also been the average amount of inventory held by the company during the year). You learn that the inventory is specialized by channel. For the retail channel, the inventory is $4,000,000. For the food service channel the inventory is $6,000,000. Inventory carrying costs for the firm are 20 percent.
Finally, you learn that the different channels have different terms of sale. Accounts receivable for the retail channel are (and have averaged) $3,000,000. Food service accounts receivable are (and have averaged) $1,000,000. You found that the cost of financing accounts receivable is 10 percent.
As hard as you have tried, you cannot find a reasonable basis to trace any other costs or assets directly to the channel segments.
Questions
1. How “profitable” is each channel?
2. What is the ROA of each channel?
3. Any recommendations?

• 1)   Explain problems which may arise if there is not enough planning to receive refugees or asylum seekers?
• 2) ‘2) Religion has nothing to do with politics’ Do you agree? Give reasons for your answer showing that you have thought about more than one point of view

 

• 3)     3) ‘Projects which faith communities organize have no effect on local communities. They just make believers feel good’ Do you agree? Give reasons for your answer showing that you have thought about more than one point of view

8-10 Slide power point presentation with speaker notes, include the following.

– Create an example of classical conditioning to produce an assigned natural response. ( Fear, happiness, or so on )

– Identify the Unconditioned stimulus  , unconditioned response, conditional stimulus , and conditional response.

– Describe the process of learning through classical conditioning.

– Create an example of an operand conditioning situation.

– Identify which operand conditioning method you would use to either increase or decrease the specified behavior.

– Describe how positive reinforcement , negative reinforcement , and punishment can influence behavior.

Alleged computer hacker Gary McKinnon of the United Kingdom has publicly admitted to compromising computer systems belonging to NASA and the Department of Defense. Using information from your classroom, additional materials provided by your instructor, and your own independent research, discuss the impact of these widespread intrusions, and comment on McKinnon’s self-proclaimed motivations. Describe McKinnon in the context of the frameworks and theories of cyber-crime and cyber criminals discussed in the classroom. Are the efforts to extradite McKinnon to the United States simply a political stunt, or are they an important precedent in prosecuting international cyber-crimes? Finally, share what you know about computer security and best practices to make recommendations to prevent similar incidents in the future. Your submission should be a minimum of four pages in length, and it should conform to APA formatting and citation standards. A title page and reference list (APA style) are mandatory, but they will not count toward the four-page requirement.

Should La Casa de Las Botas embrace expansion? If yes, suggest an international marketing strategy for expansion. If no, what can he do to maintain its profit/growth?

There have been several classic experiments to study and describe classical conditioning; one of the more famous is the Little Albert experiment. Over the years, the experiment has lost some of its validity due to numerous interpretations by several introductory psychology textbooks. It is, therefore, beneficial to go back to the original (or primary) source and read what the authors of the experiment themselves had to say.

 

 

 

Search line: “conditioned emotional reactions” (in quotation marks). Find the article in the search results by John B. Watson and Rosalie Rayner. Watson J. B., & Rayner, R. (1920)conditioned emotional reactions.Journal of Experimental Psychology, 3(1), 1–14.
Help finding article in Library

Read the article and answer the following questions in your essay:

• Explain the initial pairing of the banging bar and the rat in terms of learning through classical conditioning. What are unconditioned stimulus (US), conditioned stimulus (CS), and conditioned response (CR)?
• How were Watson and Rayner able to condition Albert to react to different stimuli such as masks, other animals, and a fur coat? Explain the concept of generalization.
• Why didn’t the conditioning last over time? Explain the concept of extinction.
• Considering the current standards, can the same experiment be conducted (or replicated) by researchers today? Explain some of the ethical issues related to the experiment.

Discuss theoretical propositions that are influential and interesting about Personality most importantly discuss being the master of your own fate. Refer to Rotter J.B (1966). generalized expectancy for internal –vs- external control of reinforcement. – 100-150 words.