1) A psychologist is investigating the relationship between drinking coffee and sleep. She chooses 20 participants and measures how many cups of coffee they had the previous day and how many hours of sleep they got the night before. The data is presented below:

For this data you will:

• Use the SPSS program to calculate the correlation and create a scatterplot
• Provide the appropriate output
• How would you describe this relationship? (both strength and direction, and in layman’s terms)
• Are these variables truly related or could there be a third variable at play?
• Calculate the regression equation (show your work)
• How much sleep should someone get if they drink 5 cups of coffee in a day?
• Calculate the proportionate reduction in error

Sugar Land Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by a MBA student. The production line would be set up in unused space (Market Value Zero) in Sugar Land’ main plant. Total cost of the machine is $240,000. The machinery has an economic life of 4 years, and MACRS will be used for depreciation. The machine will have a salvage value of $25,000 after 4 years. MACRS calculated by 5 year period

The new line will generate Sales of 1,250 units per year for 4 years and the variable cost per unit is $100 in the first year. Each unit can be sold for $200 in the first year. The sales price and variable cost are expected to increase by 3% per year due to inflation. Further, to handle the new line, the firm’s net working capital would have to increase by $30,000 at time zero (No additional NWC is needed in years 2, 3 and the NWC will be recouped at the end of year 4). The firm’s tax rate is 40% and its weighted average cost of capital is 10%.

The text below can be copy/pasted into the submission box below. Please save your work often as you type your answers.

What are the annual depreciation expenses for years 1 through 4? (10 P0ints)

Calculate the annual sales revenues and variable costs (Don’t include depreciation in your cost estimation), for years 1 through 4. (15 points)

Estimate annual (Year 1 through 4) operating cash flows (25 Points)

Estimate the after tax salvage cash flow (5 points)

Estimate the net cash flow of this project (25 points)

Estimate the NPV, IRR, MIRR, and profitability Index of the project. (20 points)

?(c) Construct a relative frequency distribution of the data.

?

?(d) What percentage of the Saturdays had 7 or more customers waiting for a table at? 6:00 P.M.?

(e) What percentage of the Saturdays had 7 or fewer customers waiting for a table at 6:00 P.M.?

Please show your work.

Solve the following problem by Dynamic Programming:
Maximize z = (y1 + 2)^2 + y2 * y3 + (y4 - 5)^2
subject to
y1 + y2 + y3 + y4 <= 5
yi >= 0 and integer, i = 1, 2, 3, 4

Write the Molecular, Ionic, Net Ionic Equation, Spectator Ions for:

1. AgNO₃ + NaCl

2. AgNO₃ + Na₂SO₄

3. Pb(NO₃)₂ + NaCl

4. Pb(NO₃)₂ + Na₂SO₄

5. Ba(NO₃)₂ + Na₂SO₄

(a) If X is binomially distributed with 8 trials and a probability of success equal to 1/3 at each attempt, what is the probability of:

1. Exactly 4 success

2. At least 1 success

3. At most 3 successes

(b) Find the variance and standard deviation of X where: X = 2 times the score shown on a dice.

You have been asked to calculate the Return on Investment (ROI) for a project whose development will be accomplished during a single calendar year with the go-live date of Jan 1^st   The project, to develop a new Web-based ordering and fulfillment system, has already been conceptualized, and the team has provided estimates and a partial resource plan. Labor Operating expenses in years 2 through 5 are projected to be $57,000 annually. Miscellaneous expenses in years 2 through 5 are projected to be $6,500 annually. The benefit is projected to be $225,000 the first year of operation, increasing 11% each year. Hardware cost that would be installed for development is $100,000. You’ll need to complete the resource plan, the 5 year planning sheet, and calculate a 5 year ROI. Please finish filling out these tables and answer the associated questions.

Question 1 [2 points]: What is the total labor cost of development?

Question 2 [2 points]: What is the total expense of this project projected to be for the first 5 year period?

Question 3 [2 points]: What is the total benefit projected to be for the first year?

Question 4 [2 points]: What is the total benefit projected to be for the first five years?

Question 5 [2 points]: Given ROI % = ((Benefit – Cost) / Cost)*100, what is the 5 year ROI for this project?

Question 6 [2 points]: If the company could just put the money to cover the project expenses in the bank (instead of doing this project) it could make a investment gain of 7% over this same 5 year period. Should the company invest in this project, or put the money in the bank? Why?

Question 7 [4 points]: Describe in your own words BRIEFLY why APO05 and APO06 are important to project funding selection based on ROI calculation.

You have been asked to calculate the Return on Investment (ROI) for a project whose development will be accomplished during a single calendar year with the go-live date of Jan 1^st   The project, to develop a new Web-based ordering and fulfillment system, has already been conceptualized, and the team has provided estimates and a partial resource plan. Labor Operating expenses in years 2 through 5 are projected to be $57,000 annually. Miscellaneous expenses in years 2 through 5 are projected to be $6,500 annually. The benefit is projected to be $225,000 the first year of operation, increasing 11% each year. Hardware cost that would be installed for development is $100,000. You’ll need to complete the resource plan, the 5 year planning sheet, and calculate a 5 year ROI. Please finish filling out these tables and answer the associated questions.

Question 1 [2 points]: What is the total labor cost of development?

Question 2 [2 points]: What is the total expense of this project projected to be for the first 5 year period?

Question 3 [2 points]: What is the total benefit projected to be for the first year?

Question 4 [2 points]: What is the total benefit projected to be for the first five years?

Question 5 [2 points]: Given ROI % = ((Benefit – Cost) / Cost)*100, what is the 5 year ROI for this project?

Question 6 [2 points]: If the company could just put the money to cover the project expenses in the bank (instead of doing this project) it could make a investment gain of 7% over this same 5 year period. Should the company invest in this project, or put the money in the bank? Why?

Question 7 [4 points]: Describe in your own words BRIEFLY why APO05 and APO06 are important to project funding selection based on ROI calculation.

You have been asked to calculate the Return on Investment (ROI) for a project whose development will be accomplished during a single calendar year with the go-live date of Jan 1^st   The project, to develop a new Web-based ordering and fulfillment system, has already been conceptualized, and the team has provided estimates and a partial resource plan. Labor Operating expenses in years 2 through 5 are projected to be $57,000 annually. Miscellaneous expenses in years 2 through 5 are projected to be $6,500 annually. The benefit is projected to be $225,000 the first year of operation, increasing 11% each year. Hardware cost that would be installed for development is $100,000. You’ll need to complete the resource plan, the 5 year planning sheet, and calculate a 5 year ROI. Please finish filling out these tables and answer the associated questions.

                  Question 1 [2 points]: What is the total labor cost of development?

Question 2 [2 points]: What is the total expense of this project projected to be for the first 5 year period?

Question 3 [2 points]: What is the total benefit projected to be for the first year?

Question 4 [2 points]: What is the total benefit projected to be for the first five years?

Question 5 [2 points]: Given ROI % = ((Benefit – Cost) / Cost)*100, what is the 5 year ROI for this project?

Question 6 [2 points]: If the company could just put the money to cover the project expenses in the bank (instead of doing this project) it could make a investment gain of 7% over this same 5 year period. Should the company invest in this project, or put the money in the bank? Why?

Question 7 [4 points]: Describe in your own words BRIEFLY why APO05 and APO06 are important to project funding selection based on ROI calculation.

1) What is the Present Value using a discount rate of 8% given the following cash flows?

            Year 1:            40,000

            Year 2:            42,000

            Year 3:            44,000

            Year 4:            45,000

            Year 5:            37,000

            And, a sale occurs at the end of year 5 at a price of $425,000.

2) Same facts as #1. Would you pay the asking price of $502,000 ? Yes or no for NPV being positive or negative.

3) Same facts as #1.   If you pay $395,000 for the deal, what is the Internal Rate of Return?

4) If you financed the deal in #3 with a loan at 4.00% at a LTV of 70% over 20 years, what is the annual debt service (calculate the monthly payment and multiply by 12)

5) For the property in #4, what is the cash flow after debt in Yr. 2

In solving problem, please use BAII Plus calculator and show ALL steps in completing problem and ALL steps in using calculator including ALL calculator keys used in chronological order.