(There is a graph that I would need to enclose an image of) 

a. Write a function that models the difference between the female U.S. population and the male U.S. population for the years shown in the bar graph.

b. Use the function from part (a) to find how many more women than men there were in the U.S. population in 2005.

c. Does the result in part (b) overestimate or underestimate the actual difference between the female and male population in 2005 shown by the bar graph? By how much?

The link to the graph is:

http://www.mediafire.com/view/ufd2ky2f3zbi54v/image.jpeg

Write SQL DML statements that address the following requirements:

    Update the Employees table and give all employees making less than $10 per hour a 5% increase.
    List all records/fields in the EMPLOYEES table in order of the employee’s last name.
    List all records/fields in the EMPLOYEES table in order of the department name.
    List employee names, hourly pay rate and department name for employees making between (and including) $10 and $30 per hour.
    What is the total organization payroll assuming each employee works 40 hours per week?

Using the tables you created in Unit 2’s project database (excluding the Employees and Departments tables), create one or more SQL queries to demonstrate your understanding of the following concepts:

    WHERE clause using comparison operators
    ORDER BY clause
    JOINS
    Aggregation

Hint: The assignment refers to the “Department Name”. That field is stored in the Departments table. A join is needed.

Deliverable: One Word document with at least nine queries. For each query include:

    SQL in text format (not a screen shot)
    Screen shots of SQL results

NEED A WORD DOCUMENT AND THE .ACCDB FILE

MUST USE THE TEMPLATE!!!!

Suppose a chain of KFC franchises in Shanghai had budgeted sales for 2012 of RMB 7.7 million (where RMB stands for the Chinese unit of currency, officially the renminbi, also called the yuan). Cost of goods sold and other variable costs were expected to be 55% of sales.  Budgeted annual fixed costs were RMB 1.4 million. A thriving Chinese economy caused actual 2012 sales to rise to RMB 10.1 million and actual profits to increase to RMB 2,790,000. Fixed costs in 2012 were as budgeted.

The franchisee was pleased with the increase in profit.

1. Compute the sales-activity variance and the flexible-budget variance for operating income for 2012. What can the franchisee learn from these variances?

2. Suppose that in 2013 the Chinese economy weakened, and the franchise’s sales fell back to the RMB 7.7 million level. Given what happened in 2012, what do you expect to happen to profits in 2013?

1 page and 1 Excel Spreadsheet

Consider the following scenario:

Deer Valley Lodge, a ski resort in the Wasatch Mountains of Utah, has plans to eventually add five new chairlifts. Suppose that one lift costs $2 million, and preparing the slope and installing the lift costs another $1.3 million. The lift will allow 300 additional skiers on the slopes, but there are only 40 days a year when the extra capacity will be needed. (Assume that Deer Valley Lodge will sell all 300 lift tickets on those 40 days.) Running the new lift will cost $500 a day for the entire 200 days the lodge is open. Assume that the lift tickets at Deer Valley cost $55 a day. The new lift has an economic life of 20 years.

1. Assume that the before-tax required rate of return for Deer Valley is 14%. Compute the before-tax NPV of the new lift and advise the managers of Deer Valley about whether adding the lift will be a profitable investment. Show calculations to support your answer.
2. Assume that the after-tax required rate of return for Deer Valley is 8%, the income tax rate is 40%, and the MACRS recovery period is 10 years. Compute the after-tax NPV of the new lift and advise the managers of Deer Valley about whether adding the lift will be a profitable investment. Show calculations to support your answer.
3. What subjective factors would affect the investment decision?

You can view a present value table here.http://www.flexstudy.com/demo/demopdf/96019_appendix.pdf 

For assistance with your assignment, please use this table your text, Web resources, and all course materials. https://class.aiuniv.edu/LCMSFileShareCommon/e8e/c8a/5ee/0c5/461/099/5a4/e4a/e92/9ed/c0/U5IP_MACRS_Depreciation.pdf