Gleem Sales Corporation uses the perpetual inventory system. On January 1, 2019, Gleem had: 2,600 units of product B with a unit cost of $40 per unit. A summary of purchases and sales during 2019 follows :

Required
a. Assume that Gleem uses the first-in, first-out method. Compute the cost of goods sold for 2019 and the ending inventory balance at December 31, 2019, for product B.

B. Assume that Gleem uses the last-in, first-out method. Compute the cost of goods sold for 2019 and the ending inventory balance at December 31, 2019, for product B.

C. Assume that Gleem uses the weighted-average cost method. Compute the cost of goods sold for 2019 and the ending inventory balance at December 31, 2019, for product B.

The town hall of a city wants to open some recreational centers. It has been analyzed 3 options. The opening cost and the capacity of each center are listed below.

The selected recreational centers must be hosting the students from 5 schools. In the table below is summarized the number of students at each school.

Each school must be assigned to only one recreational center. And the capacity of each center must be respected. What are the recreational centers that must be open in order to minimize the opening cost?

Illustrate the greedy procedure with the following data:

For the following commands you must be logged in as user “system”. You will need to do some research on the commands CREATE USER; GRANT CREATE SESSION; GRANT CREATE…..; GRANT ALTER …., GRANT SELECT….; REVOKE ……; and EXECUTE …..

5. Create two database users:  The first is a concatenation of your first and last name (e.g. johndoe).  The second is a concatenation of your instructors first and last name (e.g. sallysmith)

6. Assign the two users privileges to connect to the database.

7. Assign the user with your first and last name the privilege to select data from the employees table.

8. Assign the user with your instructors first and last name all privileges to the Departments table.

9. Assign the user with your first and last name the privilege to execute any procedure.

10. Take away the instructors privilege to execute any SQL commands on the Departments table

Regression and Correlation Analysis

Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and X3) in the data file. Select and use one independent variable throughout this analysis. Use Excel to perform the regression and correlation analysis to answer the following.

Generate a scatterplot for the specified dependent variable (Y) and the selected independent variable (X), including the graph of the "best fit" line. Interpret.

Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable.

Determine the coefficient of correlation. Interpret.

Determine the coefficient of determination. Interpret.

Test the utility of this regression model, represented by a hypothesis test of b=0 using α=0.10. Interpret results, including the p-value.

Based on the findings in steps 1-5, analyze the ability of the independent variable to predict the dependent variable?

Compute the confidence interval for b, using a 95% confidence level. Interpret this interval.

Compute the 99% confidence interval for the dependent variable, for a selected value of the independent variable. Each student can choose a value to use for the independent variable (use same value in the next step). Interpret this interval.

Using the same chosen value for part (8), estimate the 99% prediction interval for the dependent variable. Interpret this interval.

What can be said about the value of the dependent variable for values of the independent variable that are outside the range of the sample values? Explain.

Summarize your results from Steps 1–10 in a 3-page report. The report should explain and interpret the results in ways that are understandable to someone who does not know statistics.

Submission: The summary report and all of the work done in 1–10 (Excel output and interpretations) as an appendix

Format for report:

Summary Report

Steps 1-10 addressed with appropriate output, graphs and interpretations. Be sure to number each step 1-10.

Please solve the following game:

Assume that a total $100 grant will be shared by the three researchers, X, Y, and Z. Each person is rational and selfish. There are six proposals with different shares of (X, Y, Z) for choices as the following.

Proposal I: (X, Y, Z) = (50, 40, 10)

Proposal II: (X, Y, Z) = (60, 10, 30)

Proposal III: (X, Y, Z) = (40, 20, 40)

Proposal IV: (X, Y, Z) = (20, 30, 50)

Proposal V: (X, Y, Z) = (30, 50, 20)

Proposal VI: (X, Y, Z) = (20, 50, 30)

The rule of choosing the final proposal is simple. First, Z is the person to determine who (either X or Y) is the proposal raiser. Then the proposal raiser chooses a particular proposal. Finally, the last person has the right to pass it or reject it. If the last person’s payoff is the smallest among the three, then the proposal will be rejected and no one will get anything. The decision making process can be done by only one time. Which proposal will be the final outcome? Explain the decision briefly.

Please solve the following game:

Assume that a total $100 grant will be shared by the three researchers, X, Y, and Z. Each person is rational and selfish. There are six proposals with different shares of (X, Y, Z) for choices as the following.

Proposal I: (X, Y, Z) = (50, 40, 10)

Proposal II: (X, Y, Z) = (60, 10, 30)

Proposal III: (X, Y, Z) = (40, 20, 40)

Proposal IV: (X, Y, Z) = (20, 30, 50)

Proposal V: (X, Y, Z) = (30, 50, 20)

Proposal VI: (X, Y, Z) = (20, 50, 30)

The rule of choosing the final proposal is simple. First, Z is the person to determine who (either X or Y) is the proposal raiser. Then the proposal raiser chooses a particular proposal. Finally, the last person has the right to pass it or reject it. If the last person’s payoff is the smallest among the three, then the proposal will be rejected and no one will get anything. The decision making process can be done by only one time. Which proposal will be the final outcome? Explain the decision briefly.   

The tables below present expected free cash flow related data for XYZ for Year 1 and selected balance sheet data as of Year 0.  XYZ has reached the steady state growth phase and XYZ’s WACC is 8%.

Year 0 Data                                                               

Year 1 Data

You expect that XYZ would grow at 2.0% per year in perpetuity. What is XYZ’s intrinsic value per share.

Using the miles driven data, test the following claims:

1. 50% of drivers travel less than 40 miles per day.
2. One-third of drivers never travel more than 50 miles per day.
3. 50% of drivers travel less than 350 miles per week.    
4. One-third of drivers never travel more than 400 miles per week.  

A company plans to purchase a new machine. There are two choices. The following are the cash flows from two machines:  

     Machine A:    The machine’s initial purchase price is $99,718, and it has a singlemaintenance fee of $6,000 at the end of year 4. The machine would last for 7 years. Assume that the discount rate is 8% for this machine.

     Machine B:    The machine’s initial purchase price is $10,000, and it has annualmaintenance cost of $10,000 at the end of each year for 5 years. The machine would last for 5 years. Assume that the discount rate is 10% for this machine.

    As a financial analyst assistant, you have been asked to compute Equivalent Annual Annuity (EAA), also called Equivalent Annual Cost (EAC). How much are the EAA of these two machines?