You are a data analyst with strong backgrounds in database design and management. In fact, you have learned from education, mentors, and experience the art of collecting data and transforming data into business intelligence and your experience in database design and management complements your abilities to analyze data. Your hypothetical employer, Park University, is in the process planning a new employee payroll database and has asked you for assistance. The database will be standalone but will need to have ability to communicate with other ODBC and SQL Server databases. The overall purpose of the database will be to input employee data for 100-150 employees. The database will need to input time and process data needed to document payroll and to create payroll checks. Park University at this point needs to understand and review options so that cost to develop and maintain this payroll database are kept at a minimum but without compromising security. Park University has requested information and has asked you to address the following questions: Would a full-scale Database Management System (DBMS) or Relational Database Management Systems (RDBMS) be required in this case? Discuss and defend your answer in scholarly detail!! Could Microsoft Access be a good option in this case? Discuss and defend your answer in scholarly detail!! Could even Microsoft Excel be used in this case maybe as a secondary database support application for further data analysis and statistical models? Discuss and defend your answer in scholarly detail!! What Systems Development Life Cycle methodology would you suggest in this case for the overall planning, design, implementation, and maintenance of this database? Discuss and defend your answer in scholarly detail!! What else might you need to cover to help Park University determine what type of database to consider for the new payroll database? Include any other important conclusions or content you see fit to support this assignment.
In: Computer Science
As the world’s biggest maker of mobile phones, Nokia, the Finnish company, is a “powerhouse in Europe, Asia, and Latin America, with market shares regularly topping 30 percent”. However, in the United States, Nokia phones have lost popularity over the last few years. In March 2002, Nokia led the American market with 35 percent market share. By June of 2009, its share was only 7 percent. What happened and more importantly, what is Nokia doing about it?
As mobile phone usage skyrocketed, Nokia was the most popular choice. It was the “cool” phone—the one that everyone, from business executive to high school student to stay-at-home-mom wanted. In 2005, Nokia had just launched the N series, an innovative new line with a Web browser, video, music, and pictures in a single phone. That device moved Nokia a generation ahead in the race to build the first real smart phone. The “forecast for Nokia was as sunny and clear as an endless Finnish summer day.” Then came Apple and its iPhone with its clever touch screen and sophisticated software and services. With rave reviews and a reputation for being cool, customers flocked to buy one. However, Nokia executives dismissed the iPhone, saying they were “unimpressed by its engineering.”
Now, three years after Apple introduced the iPhone in 2007, Nokia still has no alternative. It did not anticipate changes in American consumer tastes, like flip phones or touch screens. Another major strategic blunder 246 PART THREE | PLANNING was that its models were based on a European communications standard called GSM when roughly half the United States market used the CDMA (code division multiple access) format. One former Nokia executive said, “Nokia, at the height of its success, decided not to adapt its phones for the U.S. market. That was a mistake and they’re still trying to recover from this.” An executive at a North American network operator said, “The attitude at Nokia was basically: Here is a phone. Do you want it? Nokia wouldn’t play by the rules here, and they have paid a price.” That arrogant attitude and the global economic slowdown have continued to hurt the company’s sales and earnings.
Meanwhile, Nokia set up liaison offices in Atlanta, Dallas, Seattle, and Parsippany, New Jersey, cities where the top American operators have big business units. And it has recently revamped its U.S. operations to collaborate more closely with those major operators. For example, AT&T has begun billing its customers who use Nokia services, keeping those customers from receiving a second bill from Nokia. Best Buy began carrying a Nokia netbook, which is a model for its new collaborative strategy. Nokia also forged a deal with Qualcomm, the largest maker of mobile phone chips for CDMA devices in the United States. It also struck a deal with Microsoft to design Windows Office Mobile software applications for phones that use Nokia’s Symbian operating system. Despite these efforts, however, some industry executives remain unimpressed. One analyst said, “They claim they get it and understand the U.S. market. But the execution still is not there.” Mark Louison, president of Nokia’s North American unit, who has a seat on Nokia’s global management board, said, “In the past, we had a one-size-fits-all mentality that worked well on a global basis but did not help us in this market. That has changed now.” The company recognized that its former strategy had not worked in North America and began trying to lay the groundwork for long-term success. Louison says, “Everything you see us doing is to build the broad set of capabilities to take us broader and deeper into the U.S. market.”
In: Operations Management
The average “moviegoer” sees 8.5 movies a year. A moviegoer is defined as a person who sees at least one movie in a theater in a 12-month period. A random sample of 40 moviegoers from a large university revealed that the average number of movies seen per person was 9.6. The population standard deviation is 3.2 movies. At the 0.05 level of significance, can it be concluded that this represents a difference from the national average?
STEP 1. State the null and alternate hypothesis
The hypotheses are (Enter an UPPER CASE Letter Only.)
STEP 2. State the critical value(s). Enter the appropriate letter.
z =
STEP 3. Calculate the test value
z =
STEP 4. Make the decision by rejecting or not rejecting the null hypothesis. Since the test value falls in the non-rejection region, we do not reject the null hypothesis.
Conclusion 1. Reject the null hypothesis. At the α = 0.05 significance level there is enough evidence to conclude that the average number of movies seen by people each year is not different from 8.5.
Conclusion 2. Reject the null hypothesis. At the α = 0.05 significance level there is enough evidence to conclude that the average number of movies seen by people each year is different from 8.5.
Conclusion 3. Do not reject the null hypothesis. At the α = 0.05 significance level there is enough evidence to conclude that the average number of movies seen by people each year is different from 8.5.
Conclusion 4. Do not reject the null hypothesis. At the α = 0.05 significance level there is enough evidence to conclude that the average number of movies seen by people each year is 8.5.
(Enter a number only from the list 1, 2, 3, or 4)
In: Statistics and Probability
A famous analyst once said it is not important what financial statement shows us- it’s what they hide that counts. What does the analyst mean by this statement? How would a company hide information inside financial statements? What is a pro forma financial statement and how is this used in the financial markets?
In: Accounting
An open-end mutual fund invests in a mixed of major stocks in the US market. Each share of the mutual fund contains the following assets:
| Stock | shares | price |
| A | 1 | 15.00 |
| B | 1 | 17.00 |
| C | 1 | 43.00 |
| D | 1 | 35.00 |
| E | 1 | 28.00 |
The front-end load is $5 and the back-end load is $4.
a) The Net Asset Value per share =
b) To buy one share of the mutual fund, the cost is =
c) For a person who sells one share of the mutual fund today, the net proceeds (net revenue) =
In: Finance
Find an article about the current proposals and actions being taken by the Trump administration. Summarize the who stands to gain and to lose.
Review both sides of the argument presented in the chapter, Pro-trade "Free Trade" and Anti-trade "Protectionist".
Where do you stand on the issue?
Site an article about the current direction the US Government seems to moving in. Recent decisions that have been made and actions that have been taken as well as proposals being discussed. What do you think this will mean for America's economy moving forward?
In: Economics
Robert Barro critiqued the Obama Administration for crafting policy based on the assumption that the fiscal multiplier is about 1.5. Barro supposed that “A much more plausible starting point is a multiplier of zero.”5 How do these two different assumptions change the cost-benefit analysis of fiscal stimulus programs? Under what conditions will the Obama Administration be correct in their assumption? Under what conditions will Barro be correct? Who do you think is more correct as it pertains to the US economy today? Why? (Helpful Advice: think outside of the basic models. Craft an economic story.)
In: Economics
1. what are the consequences of the united states having a two party system rather than a multi party system? what aspects of the U.S political system explain why the US has two party system?
2. Who determines ballotg acces in the American states? why this a relavent concern and what are the consequances?
3. on the heals of the 2016 presidential election, we are seeing much discussion of the role internet and socail media in voter education. what are the consequances of free online speech and how might the internet comprmise democratic processes and accountability?
In: Psychology
In: Operations Management
A small but growing manufacturer of business class network routers. They produce two main types of routers, Model A and the more expensive variant, Model B. The company has a capacity of producing 500 Model A routers per month and currently produces 300 routers of that type every month. The routers are sold to small computer stores. The company’s expenses are $30,000.
What are the contribution margin and the contribution rate [round to a full number]?
What is the break-even point in units? At their current level of production, how many units above or below the break-even point is company working at?
How much profit per month would be earned at the current level of production?
At the current level of production what percent of capacity is utilized?
What is the BE volume as a percent of current production [use the rounded number of BE units]?
What is the BE volume as a percent of capacity [use the rounded number of BE units]?
Company has decided to increase its production from the current 300 routers per month to 425 routers per month, while at the same time lowering its selling price to $85. How would this change the company’s profit?
A chain store wants to purchase additional routers from company on a regular basis. To meet the new demand, company expanded their facility by renting additional space. This increased their total fixed cost by 30% and doubled their capacity to 1200 units. company wants to break-even at 25% of this new capacity. What is the lowest price they can charge per router and still break-even?
This is the complete information and there is no other values provided so, please do not say need more information. Please explain in details. Thank You.
In: Accounting