Assume you are a woman working at Floridian Resorts and you have observed that you are paid $20,000 less per year than two men in your area who are doing the exact same job and all of you have the same identical degree. You actually have 5 more years work experience than the two men in your area. You have mentioned this to your male boss, but he seemed reluctant to address your concerns. After 3 months, he calls you to inform you that you are receiving a 15% raise, which is very nice ... however, you will still be earning about $5,000 less than the two men on the team. It's well known that most organizations in the area, including Floridian Resorts, are experiencing dramatic budget cuts. Although you are appreciative of the raise, you are still discouraged that you are still not paid equally. What recourse do you have?

The Neal Company wants to estimate next year's return on equity (ROE) under different financial leverage ratios. Neal's total capital is $18 million, it currently uses only common equity, it has no future plans to use preferred stock in its capital structure, and its federal-plus-state tax rate is 40%. The CFO has estimated next year's EBIT for three possible states of the world: $4.6 million with a 0.2 probability, $2.4 million with a 0.5 probability, and $0.4 million with a 0.3 probability. Calculate Neal's expected ROE, standard deviation, and coefficient of variation for each of the following debt-to-capital ratios. Do not round intermediate calculations. Round your answers to two decimal places at the end of the calculations.

How are the environment and environmental issues gendered? Provide examples of how a history of colonialism contributes to the ongoing environmental issues facing many countries today and how that contributes to environmental issues being gendered.

3. What is the weighted average cost of capital (WACC) and provide the equation when long-term debt and common equity are used to obtain capital funds? Please describe each component and how you measure each? How does a higher beta affect WACC and why? How does a drop in the bond market effect WACC and why? What is the WACC for a public utility given the following information: beta: 0.8, expected rate of return on the S&P 500: 12.4%, risk-free rate (T-bill yield): 4%, yield to maturity on long-term bonds: 7.2%, required rate of return on preferred stock: 7.5%, common equity ratio: 60%, debt ratio: 30%, preferred stock ratio: 10% and an effective corporate tax rate: 30%.

Question 1: Car Dealership Scenario. Complete parts A – D based on the database specifications listed below.

Database Specification

• Car Dealerships have a unique business id number, dealership name, city, state, and a unique website URL. The business id is a number in the range from 1000-9999.
• Salespersons have a first name, last name, age, gender, and a unique employee id number. The employee number is in the range 100-999.
• Customers have a first name, last name, city, state, gender, age, and a unique taxpayer id number. The taxpayer id number is 9 digits.
• Cars have a make, model, year, suggested price, and a unique vehicle id number. A car can have (possibly multiple) colors that should be modeled as an attribute. Note: the make of a car is the manufacturer (e.g., Ford, Honda, BMW) and the model is the name of the model (e.g. Civic, Accord, CRX).
• Salespersons work for dealerships. In order to be in the database, a salesperson must work for a dealership. However, a dealership may exist in the database without any salespersons. Dealerships have many salespersons who work for them, and a salesperson may work for many different dealerships. The database should record the start date when a salesperson began working for a dealership.
• Dealerships own cars. A dealership may own many cars, or they may be completely out of inventory and own zero cars. A car can only be owned by one dealership, and must be owned by a dealership in order to be in the database. The database should record the date that the dealership acquired the car and the price that the dealership paid for the car.
• Salespersons sell cars to customers. Even if a salesperson has not sold any cars to customers they should still be stored in the database. However, the database should only store information about customers who have purchased a car from a salesperson. Information about cars owned by dealerships should be stored in the database regardless of whether they have been sold or not. A salesperson may sell a particular car to only one customer. Similarly, a customer may purchase a particular car from only one salesperson. However, a customer may purchase more than one car from the same salesperson. When a salesperson sells a car to a customer, the sales price and date should be recorded in the database.

Parts A - D

1. Based on the database specification given above, draw an ER diagram for the database. Include entities, attributes, relationships, cardinality, and participation constraints. The ER diagram should accurately reflect the specifications.  Clearly state any assumptions.

2. Map your ER diagram to relations. Make sure to represent the relations, attributes, primary keys, and foreign keys.

3. Implement your database. Based on your ER and relation diagrams, create tables, specify primary and foreign keys, and include any other necessary integrity constraints such as checks. Turn in a list of the SQL DDL commands (e.g., create table commands) that you used to create your database.

4. Populate your database with data. You may do this either by writing SQL insert statements to load data, or by using the data entry or import features of MySQL Workbench. You need to create enough and appropriate data to illustrate that your database works for the queries below. At a minimum, load at least three records for each table. However, you may need to load more records to illustrate that particular queries work correctly.

5. Write and run SQL queries in MySQL Workbench for each of the queries listed below using your database with the data loaded. In your report, for each query, restate the query in English, then list the SQL query you wrote for it, and finally, list the output from the database in response to the query.

Queries: Write and run SQL queries for the following questions. Use the minimum number of tables required for each query.

1. List the first and last names of customers over 40 years old who purchased a Ford car.
2. List the first and last names of salespersons who have NEVER sold a Ford car.
3. List the total value (suggested price) of all cars owned by the dealership named ‘SILS Car Deals’.
4. Find the average sales price (actual sales price, not suggested price) of a 2008 Honda Civic.
5. List the dealership name and the total number of cars that each dealership owns.
6. List the average age of customers who have purchased a car from salesperson ‘Homer Simpson’.
7. List the last name, employee id number, and the overall number of cars sold by each salesperson who has sold at least one Honda Civic.
8. List the names of salespersons who have worked for all the car dealerships.

1. Please explain why money has a time value. Please interpret the present and future value of a series of future cash flows.   What is the effective rate of return? Would you prefer more frequent compounding or less and why?

Write an explanation of one of Feldman's Free Lunch cases and why it shows that the original formulation of Utilitarianism is imperfect. You will want to walk through the examples slowly in order to explain why Utilitarianism concludes what it does about the situation and why that is counterintuitive. You may use Feldman's made up numbers to illustrate the case, but you do not need to draw any graphs or tables. (~ 1 page)​

Considering platforms such as Airbnb and Uber, how will the sharing economy affect employment? And how should businesses adapt to the sharing economy?

What types of media exist and what type of information or material do they seek both pre-hazard/disaster and post-hazard/disaster? Why can be/is the media important to the emergency manager? Give examples of its importance to the emergency manager.

You are attempting to value a call option with an exercise price of $145 and one year to expiration. The underlying stock pays no dividends, its current price is $145, and you believe it has a 50% chance of increasing to $155 and a 50% chance of decreasing to $135. The risk-free rate of interest is 5%. Based upon your assumptions, calculate your estimate of the the call option's value using the two-state stock price model. Answer is not $4.76

Business Problem: A computer company produces laptop and desktop computers. The data analytics team in collaboration with the marketing team developed a predictive model that forecasts the expected demand for laptops to be at least 1,000, and for desktops to be at least 800 per day. (Assumption: production is in accordance with the demand) The production facility has a limited capacity of no more than 2,000 laptops and 1,700 desktops per day. The Sales Department indicates that contractual agreements of at most 2,000 computers per day must be satisfied. Each laptop computer generates $600 net profit and each desktop computer generates $300 net profit. The company wants to determine how many of each type should be made daily to maximize net profits.

2. Formulate a linear programming model that represents the preceding business challenge. b. Identify the decision variables. c. What is our objective function in terms of these decision variables, write down its mathematical equation) d. What are the constraints for this problem, write down their respective mathematical equations.

b) Decision Variables: X (laptop) & Y (desktop) # of units to produce for laptop & desktop a day

c) Objective function: Maximize the profit

Max profit Z = 600x + 300y

d) Constraints:

Expected demand x=>1000 and y=>800

Production capacity x<=2000, y<=1700

Contractual agreements x + y <=2000      non negative restrictions x=>0 and y=>0

NEED HELP WITH IpsolveAPI Library in R

3. Solve the problem using lpSolveAPI library in R to come up with the most optimum solution of this problem a. Write down R program to get the most optimal solution b. What is the optimal number of laptop and desktop computers to be made each day? c. What is the value of the objective function (total net profit) for the solution?

install.packages('lpSolveAPI')

library(lpSolveAPI)

lprec <- make.lp(0,2)

lp.control(lprec,sense="max")

set.objfn(lprec,c(600,300))

Plastic Products Ltd is a company that produces and markets plastic cups, teaspoons, knives and forks for the catering industry. The company was established in 1974 in response to the changes taking place in the catering industry. The growth of the fast food sector of the market was seen as an opportunity to provide disposable eating utensils which would save on human resources and allow the speedy provision of utensils for fast customer flow. In addition, Plastic Products has benefited from the growth in supermarkets and sells ‘consumer packs’ through four of the large supermarket groups. The expansion of sales and outlets has led Jim Spencer, the sales manager, to recommend to Bill Preedy, the general manager, that the present salesforce of two regional representatives be increased to four. Spencer believes that the new recruits should have experience of selling fast-moving consumer goods since essentially that is what his products are. Preedy believes that the new recruits should be familiar with plastic products since that is what they are selling. He favours recruiting from within the plastics industry, since such people are familia rwith the supply, production and properties of plastic and are likely to talk the same language as other people working at the firm.

1. What general factors should be taken into account when recruiting salespeople?

2. Do you agree with Spencer or Preedy or neither?