​(Payback period calculations​) You are considering three independent​ projects: project​ A, project​ B, and project C. Given the cash flow information in the popup​ window,calculate the payback period for each. If you require a​ 3-year payback before an investment can be​ accepted, which​ project(s) would be​ accepted?

Initial Outlay   -950   -9000   -6500
Inflow year 1   700   4000   2000
Inflow year 2   200   3000   2000
Inflow year 3   100   3000   3000
Inflow year 4   300   3000   3000
Inflow year 5   500   3000   3000

Given the following price data for EA and the Market Index (DIA) from 2000 to 2015, find the returns for each price series, then calculate the beta for EA's stock. (Round to 3 decimals)

What is Data Fragmentation. Consider the following Student relation. How would you fragment Student relation horizontally based on Student’s Branch? Give a short discussion of your decision.

I need this answered not using excel

Given the following data, construct a material requirements plan which will result in 100 units of parent #1 (P1), at the beginning of week 6 and 200 units of parent #2 (P2) at the beginning of week 8:

You are considering two investment options. In option A, you have to invest $4500 now and $1000 three years from now. In option B, you have to invest $3500 now, $1000 a year from now, and $1000 three years from now. In both options, you will receive four annual payments of $2000 each (you will get the first $2000 payment a year from now). Which of these two options would you choose based on AE criterion? Assume the interest rate is 10%.

Note: find the AE for both projects. Include the annual revenues in AE calculations. Show your calculations.

1. The year is 1999 and the Ethical Pharmaceutics Company has just received FDA approval for high risk angioplasties and is bringing AngioMin to the market early January 2000 at the price of $200. The cost of manufacturing a single dose of AngioMin is $40. The key benefit of AngioMin is reduced side effects, complications, and risk of death following angioplasty. These benefits are most pronounced in the very high risk patients. Ethical Pharmaceutics Company’s marketing department decided to focus on the top 100 hospitals in the US where 80% of angioplasties are performed. In 2000 there will be 700,000 angioplasties and this number is expected to grow at 5% each year. 50% of all angioplasties are high risk and 20% of high risk angioplasties fall into the “very high risk” category. Ethical Pharmaceutics Co. is planning an aggressive marketing campaign to get on hospital formularies because (1) AngioMin’s patent protection will expire in late December 2010, after which point sales would immediately go to zero, (2) while there is no chance a better substitute will enter the market in 2000, Ethical Pharmaceutics Co. management estimates a 20% probability for each year 2001-2010, that a new significantly better than AngioMin drug will be brought to market and will replace AngioMin in any hospital that was using AngioMin at the time. Please help the Ethical Pharmaceutics Co. management determine the maximum total marketing budget for an average top hospital for educating, sponsoring travel to continuing-medical-education conferences in Hawaii, wining and dining hospital administrators, doctors, nurses, pharmacists, and their families to get AngioMin on the hospital formulary. (These practices are currently disallowed in the industry based on the voluntary pharmaceutical industry guidelines covering direct-to-physician marketing practices, but were fully acceptable and were widely used in the industry in the 1990s to early 2000s).

Please help the Ethical Pharmaceutics Co. marketing team estimate

a) CLV (customer lifetime value) of an average top hospital acquired in 2000, assuming that all high risk patients will get 1.5 doses of AngioMin during the angioplasty procedure

b) CLV of an average top hospital acquired in 2000, assuming that only very high risk patients will receive AngioMin (on average 1.5 doses will be needed per procedure)

c) To help the marketing team communicate the time value of acquiring hospitals as early as possible, calculate the net present value in 2000 of an average top hospital acquired in 2005. Assume that this hospital would administer AngioMin only to very high risk patients (on average 1.5 doses). Note that this is only possible if the new better substitute is not brought to market by 2005 and make sure that your calculations reflect this fact.

Stock Inc. has two sites in Pittsburgh that are four miles apart. Each site consists of a large factory with office space for 25 users at the front of the factory and up to 50 workstations in two work cells on each factory floor. All office users need access to an inventory database that runs on a server at the Allegheny Street location; they also need access to a billing application with data residing on a server at the Monongahela site. All factory floor users also need access to the inventory database at the Allegheny Street location. Office space is permanently configured, but the manufacturing space must be reconfigured before each new manufacturing run begins. Wiring closets are available in the office space. Nothing but a concrete floor and overhead girders stay the same in the work cell areas. The computers must share sensitive data and control access to files. Aside from the two databases, which run on the two servers, office computers must run standard word-processing and spreadsheet programs. Work cell machines are used strictly for updating inventory and quality control information for the Allegheny Street inventory database. Workstations in the manufacturing cells are switched on only when they’re in use, which might occur during different phases of a manufacturing run. Seldom is a machine in use constantly on the factory floor. Use the following write-on lines to evaluate the requirements for this network. After you finish, determine the best network topology or topology combination for the company. On a blank piece of paper, sketch the network design you think best suits ENorm, Inc.’s needs.

● Will the network be peer to peer or server-based?

● How many computers will be attached to the network?

● What topology works best for the offices, given the availability of wiring closets? What topology works best for the factory floor, given its need for constant reconfiguration?

In each of the following situations, indicate whether Walters, CPA is using unrestricted random (UR), systematic random (SR), haphazard (H), or block (B) selection.?

A. Walters created a list of all sales invoices to verify that they were supported by the appropriate shipping documents. Invoice number 15 was selected first for examination, followed by the invoices numbered 30, 45, 60, 75, 90, and so on until 40 invoices had been selected.

?B. To test the occurrence assertion regarding sales invoices, Walters randomly selected invoices from the database storage disk for examination.

?C. To ensure proper authorization of payroll functions, Walters selected all transactions during the last 5 days of each pay period to be included in the sample.

?D. Sales invoices are commonly stored in a filing cabinet during the 30-day return period before being input in the company's database. To ensure the 30-day return period was not exceeded, Walters decided to pull a few invoices from each drawer until the desired sample size was collected for examination.

?E. T&T Company's purchase orders are already pre-numbered and listed in numerical order within the company's database. As a result, Walters was able to use one of the firm's computer programs to identify random numbers and match each number with a corresponding purchase order to test the accuracy assertion.

?F. Using a random number table, Walters identified a series of 50 numbers and located the corresponding employee identification number to select time cards for examination.

?G. Walters used a computer listing of T&T's credit memos, which totaled 2,400 items, to select 4 random starting points for examination. The remaining memos were identified for testing by selecting every 24th item until the sample size reached 100 memos.

Consider the following un-normalized relational table on an online retail store orders and payments information:

An online retail store would like to create a database to keep track of its sales activities. Information recorded in the database supposed to include customer number that identifies each customer, customer’s first name, last name, unique order number of orders a customer made, the date when an order was made, unique product number of products included in orders, product description, sequence number listing the sequence when a product is included in each order as well as the quantity for each product made in each order. The retail store would also like to store the payment information such as a credit card number of credit card that was being charge to, payment date and the amount paid. The online retail store allows customer to pay using any one of the credit cards the customers own, as long as the credit card is valid.

A database designer created the following relational schema:

CUSTORDER(custNum, custFName, custLName, orderNum, orderDate, prodNum, prodDesc, itemNum, quantity, cCardNum, paymentDate, amountPaid)

Decompose the relational schema into the smallest number of relational schemas each one in forth normal form (4NF) and to explain or justify that each schema is in 4NF. To justify that the relational schemas obtained from the decomposition are in 4NF you must find all functional and multivalued dependencies valid in each relational schema, you must find the minimal keys, and then apply the definitions to support your justification. Note, that a relational schema is in 4NF when it is in BCNF and it does not have any nontrivial multivalued dependencies. It means, that first, you have to prove that a schema is in BCNF and later show that it has no nontrivial multivalued dependencies. Please keep in mind that the smallest number of 4NF relational schemas is expected