|
Employee ID |
First Name |
Last Name |
|
Title |
Address |
Extension |
Department |
Department ID |
Hiring Date |
Department Phone # |
|
0001 |
John |
Smith |
jsmith |
Accountant |
1300 West st |
5775 |
Accounting |
2100 |
8/1998 |
407-366-5700 |
|
0002 |
Brian |
Miller |
badams |
Admin Assistant |
1552 Palm dr |
5367 |
Human resource |
2300 |
4/1995 |
407-366-5300 |
|
0003 |
James |
Miller |
miller |
Inventory Manager |
2713 Buck rd |
5432 |
Production |
2520 |
8/1998 |
407-366-5400 |
|
0004 |
John |
Jackson |
jackson_sam |
Sales Person |
433 tree dr |
5568 |
Sales |
2102 |
6/1997 |
407-366-5500 |
|
0005 |
Robert |
Davis |
Davis |
Manager |
713 corner st |
5642 |
Production |
2520 |
1/2001 |
407-366-5400 |
|
0006 |
Paul |
Thompson |
thompsonp |
Market Analyst |
205 Bridge dr |
5744 |
Marketing |
2101 |
5/2003 |
407-366-5600 |
|
0007 |
Sandy |
Davis |
SDavis |
Manager |
713 Corner st |
5702 |
Accounting |
2100 |
11/1999 |
407-366-5700 |
1. List the major entities identified in the table above
2. After examining the table carefully identify candidate keys. Remember from the lecture that a candidate key field has to be unique, but should not hold private information that might compromise person's identity. For example SSN is unique and can be used to determine student information, so it is a candidate key, but using SSN might compromise student security for that it will not be used as primary key. The combination of first name and last name is not unique and cannot be used as a candidate key. Once the candidate keys been identified, some will be as primary keys and will be used to normalize the table. To connect the tables, the primary key of one table can be used as a foreign key in the other.
In: Computer Science
. The meat packing company gives you the following assumptions: Price of beef=$2; price of pork=$2.50; disposable income=$1,000,000; and population=225. Given this information, use model 1 to complete the following: a. Estimate of beef demand and a 95% confidence interval around this estimate. b. Estimate total revenue c. Estimate the following elasticities: Price elasticity, Cross elasticity (that is, elasticity with respect to Pork price), income elasticity, and population elasticity. d. Should the meat packing company increase or decrease the price of beef? Why or why not?
| Year | Q (millions of lbs) | P Beef Per Lb ($) | P Pork Per lb ($) | Disp Inc (millions $) | Pop (millions) |
| 1975 | 19295 | 1.9 | 1.864 | 517250 | 182.76 |
| 1976 | 17535 | 2.312 | 1.944 | 566500 | 185.88 |
| 1977 | 19520 | 2.208 | 1.972 | 708250 | 189.12 |
| 1978 | 25622.5 | 1.68 | 2.072 | 631500 | 192.12 |
| 1979 | 26530 | 1.68 | 2.128 | 643500 | 195.6 |
| 1980 | 27745 | 1.64 | 1.776 | 688250 | 199.08 |
| 1981 | 29805 | 1.568 | 1.732 | 733000 | 202.68 |
| 1982 | 28950 | 1.648 | 1.916 | 771250 | 206.28 |
| 1983 | 26932.5 | 1.868 | 2.092 | 796250 | 209.88 |
| 1984 | 27592.5 | 1.892 | 1.792 | 843250 | 213.36 |
| 1985 | 30162.5 | 1.804 | 1.884 | 875000 | 216.84 |
| 1986 | 31530 | 1.708 | 1.916 | 911000 | 220.44 |
| 1987 | 31397.5 | 1.856 | 1.9 | 963250 | 223.8 |
| 1988 | 34122.5 | 1.668 | 1.772 | 1011500 | 227.04 |
| 1989 | 39107.5 | 1.592 | 1.772 | 1095250 | 230.28 |
| 1990 | 39987.5 | 1.732 | 2.128 | 1183000 | 233.16 |
| 1991 | 41775 | 1.768 | 2.276 | 1279750 | 235.92 |
| 1992 | 43130 | 1.804 | 2.06 | 1365750 | 238.44 |
| 1993 | 45675 | 1.892 | 2.036 | 1477500 | 240.84 |
| 1994 | 47185 | 1.968 | 2.3 | 1586000 | 243.24 |
| 1995 | 48722.5 | 1.96 | 2.276 | 1729250 | 245.88 |
| 1996 | 49242.5 | 2.188 | 1.992 | 1866000 | 248.4 |
| 1997 | 51277.5 | 2.304 | 2.58 | 2006250 | 250.56 |
In: Economics
C# (Thank you in advance)
Create an Employee class with five fields: first name, last name, workID, yearStartedWked, and initSalary. It includes constructor(s) and properties to initialize values for all fields.
Create an interface, SalaryCalculate, class that includes two functions: first,CalcYearWorked() function, it takes one parameter (currentyear) and calculates the number of year the worker has been working. The second function, CalcCurSalary() function that calculates the current year salary.
Create a Worker classes that is derived from Employee and SalaryCalculate class.
Create a Manager class that is derived from Worker class.
Write an application that reads the workers and managers information from files (“worker.txt” and “manager.txt”) and then creates the dynamic arrays of objects. Prompt the user for current year and display the workers’ and managers’ current information in separate groups: first and last name, ID, the year he/she has been working, and current salary.
**Following is the content of the text files**
________________
manager.txt :
3 Sam Reza M000411 1995 51000 2005 Jose Perez M000412 1998 55000 2002 Rachel Pena M000413 2000 48000 2010
_______________
worker.txt :
5 Hector Alcoser A001231 1999 24000 Anna Alaniz A001232 2001 34000 Lydia Bean A001233 2002 30000 Jorge Botello A001234 2005 40000 Pablo Gonzalez A001235 2007 35000
In: Computer Science
With the code that is being tested is:
import java.util.Random;
public class GVdate
{
private int month;
private int day;
private int year;
private final int MONTH = 1;
private final int DAY = 9;
private static Random rand = new Random();
/**
* Constructor for objects of class GVDate
*/
public GVdate()
{
this.month = rand.nextInt ( MONTH) + 1;
this.day = rand.nextInt ( DAY );
}
public int getMonth()
{return this.month;
}
public int getDay()
{return this.day;
}
public int getYear()
{return this.year;
}
public String toString()
{String monthString = "0" + this.month;
int monthLength = monthString.length();
String dayString = "0" + this.day;
int dayLength = dayString.length();
return (
"\t" +
monthString.substring( monthLength-2 ) + ":" +
dayString.substring( dayLength-2 ) + " " +
this.year
);
}
public boolean isMyBirthday()
{return month == 8 && day == 31 && year ==
2001;
}
public void setMonth( int m )
{
month=m;
}
public void setDay( int d )
{
day=d;
}
public void setYear( int y)
{
year=y;
}
public void setDate (int m, int d, int y)
{ year = y;
month = m;
day = d;
}
}
How do I fix the errors so that it runs?
int errors = 0;
System.out.println ("Testing begings");
//********** phase 1 testing ************
// testing the default constructor
GVdate today = new GVdate();
if (today.getMonth() != 10){
System.out.println("month should be 10");
errors++;
}
if (today.getDay() != 12){
System.out.println("day should be 12");
errors++;
}
// TO DO: test the year
// testing constructor 2
GVdate theDay = new GVdate(1, 10, 1995);
// TO DO: complete the checks for month, day and year
// testing setter methods
//testing setMonth
theDay.setMonth(8);
// TO DO: complete the code to check for month
// TO DO: finish testing setDay and setYear
// TO DO: test the toString method
System.out.println("Errors: " + errors);
System.out.println ("Testing ends");
}
}
In: Computer Science
The internal characteristics of the organization make up
critical sources for success (Barney,
1991). Increasing attention has been paid to identifying what
characteristics are vital to
organizational success and how they exert their influence on
organizational outcomes. Internal
organizational context focuses on broad and relatively stable
categories of organizational
characteristics such as structure, culture, and power and political
characteristics (Pettigrew,
1979). They constitute an environment where organizational
activities take place. There has been
a large volume of studies that examine how the fit between
organizational context and
organizational strategy explains variances in organizational
performance (Daft, 1995 and
Robbins, 1990). What is lacking in existing literature, though, is
an understanding of the
intervening mechanism that explains the paths of the influence from
organizational context and
strategy to organizational effectiveness.
Knowledge management plays a potentially mediating role in
connecting organizational context
and strategy with organizational effectiveness. Successful
knowledge management is believed to
have the potential of enhancing an organization's
competitive advantage, customer focus,
employee relations and development, innovation, and lower costs
(Skyrme and Arnindon, 1997).
In turn, knowledge management is context-specific, because context
determines who participate
and how they participate in the knowledge management process
(Nonaka et al., 2000).
Knowledge management could serve as one of the intervening
mechanisms through which
organizational context influences organizational effectiveness.
However, the mediating role of
knowledge management has not been adequately investigated.
Exploration of its potential role as
a mediating factor would provide better understanding of how to
leverage it to achieve desirable
organizational goals. This study sets out to do that.
The purpose of this study is to examine the possible mediating
effect of knowledge management
on the relationship between organizational culture, structure,
strategy and organizational
effectiveness. This study attempts to detect and explain one of the
mechanisms through which
organizational contextual and strategic factors are mobilized to
achieve higher levels of
organizational effectiveness.
What do you think is the significance of the above research? Clearly justify your answer.
In: Operations Management
Critical Thinking
The global marketplace has witnessed an increased pressure from customers and competitors in manufacturing as well as service sector (Basu, 2001; George, 2002). Due to the rapidly changing global marketplace only those companies will be able to survive that will deliver products of good quality at cheaper rate and to achieve their goal companies try to improve performance by focusing on cost cutting, increasing productivity levels, quality and guaranteeing deliveries in order to satisfy customers (Raouf, 1994).
Increased global competition leads the industry to increasing efficiency by means of economies of scale and internal specialization so as to meet market conditions in terms of flexibility, delivery performance and quality (Yamashina, 1995). The changes in the present competitive business environment are characterized by profound competition on the supply side and keen indecisive in customer requirements on the demand side. These changes have left their distinctive marks on the different aspect of the manufacturing organizations (Gomes et al., 2006). With this increasing global economy, cost effective manufacturing has become a requirement to remain competitive.
To meet all the challenges organizations try to introduce different manufacturing and supply techniques. Management of organizations devotes its efforts to reduce the manufacturing costs and to improve the quality of product. To achieve this goal, different manufacturing and supply techniques have been employed. The last quarter of the 20th century witnessed the adoption of world-class, lean and integrated manufacturing strategies that have drastically changed the way manufacturing firm’s leads to improvement of manufacturing performance (Fullerton and McWatters, 2002).
The Answer should be within 1- 2 pages. for each question
The Answer must follow the outline points below:
In: Operations Management
NOTE THAT
((This should be done by R studio !))
Q: Upload your data as a CSV in R studio, then do
any
cleaning or convert needed for example convert the date in your
table
from character to date and NA identifiers . After
do all these, run a summary statistics
|
Year |
REX |
OilP |
Food exports (% of merchandise exports) |
Ores and metals exports (% of merchandise exports) |
|
1980 |
239.5433424 |
35.52 |
0.09638294 |
0.060083757 |
|
1981 |
240.3102173 |
34 |
0.094079554 |
0.024360528 |
|
1982 |
245.3895131 |
32.38 |
0.128489839 |
0.025668368 |
|
1983 |
242.8677506 |
29.04 |
.. |
.. |
|
1984 |
238.0284197 |
28.2 |
.. |
.. |
|
1985 |
221.878717 |
27.01 |
0.259787311 |
0.116943755 |
|
1986 |
169.6457184 |
13.53 |
.. |
.. |
|
1987 |
144.1934823 |
17.73 |
.. |
.. |
|
1988 |
134.5212315 |
14.24 |
1.371078529 |
0.732151804 |
|
1989 |
136.0536024 |
17.31 |
1.374888969 |
0.834330299 |
|
1990 |
125.5311345 |
22.26 |
0.713126234 |
0.491007478 |
|
1991 |
125.8812467 |
18.62 |
0.526384845 |
0.242750346 |
|
1992 |
118.7733668 |
18.44 |
1.074388363 |
0.548851562 |
|
1993 |
122.2521688 |
16.33 |
0.982275388 |
0.429968062 |
|
1994 |
117.8952881 |
15.53 |
0.673955645 |
0.346686956 |
|
1995 |
114.1213899 |
16.86 |
0.810242733 |
0.567217625 |
|
1996 |
116.3114665 |
20.29 |
0.632336949 |
0.304958406 |
|
1997 |
121.4661302 |
18.86 |
.. |
.. |
|
1998 |
127.1948915 |
12.28 |
1.114818605 |
0.507089276 |
|
1999 |
121.9490893 |
17.44 |
0.930990348 |
0.262574488 |
|
2000 |
123.200674 |
27.6 |
0.538501429 |
0.147164016 |
|
2001 |
125.2424379 |
23.12 |
0.558465111 |
0.201693533 |
|
2002 |
121.5455166 |
24.36 |
0.628539417 |
0.223275991 |
|
2003 |
111.1523893 |
28.1 |
0.835851768 |
0.182707717 |
|
2004 |
103.4682918 |
36.05 |
0.7405123 |
0.172800798 |
|
2005 |
100.5070052 |
50.59 |
0.620831971 |
0.137293785 |
|
2006 |
98.93290899 |
61 |
0.64203501 |
0.219532433 |
|
2007 |
95.96813741 |
69.04 |
0.838923226 |
0.283587719 |
|
2008 |
93.62494305 |
94.1 |
0.744029125 |
0.221986187 |
|
2009 |
100.1652448 |
60.86 |
1.407633083 |
0.232499732 |
|
2010 |
100 |
77.38 |
1.155876888 |
0.154654215 |
|
2011 |
96.57013945 |
107.46 |
0.898301922 |
0.122271232 |
|
2012 |
99.61967144 |
109.45 |
0.860627792 |
0.138455596 |
|
2013 |
102.3680362 |
105.87 |
0.878931429 |
0.403127249 |
|
2014 |
105.3894897 |
96.29 |
1.006265279 |
0.769034983 |
|
2015 |
118.5851177 |
49.49 |
1.798068624 |
1.307540253 |
R ONLY !!
In: Computer Science
Suppose that you are part of the Management team at Porsche. Suppose that it is the end of December 2019 and a novel coronavirus that causes a respiratory illness was identified in Wuhan City, Hubei Province, China. The illness was reported to the World Health Organization and there is heightened uncertainty around the Globe. You (as part of the management team) are reviewing Porsche’s hedging strategy for the cash flows it expects to obtain from vehicle sales in North America during the calendar year 2020. Assume that Porsche’s management entertains three scenarios:
Scenario 1 (Expected): The expected volume of North American sales in 2020 is 35,000 vehicles.
Scenario 2 (Pandemic): The low-sales scenario is 50% lower than the expected sales volume.
Scenario 3 (High Growth): The high-sales scenario is 20% higher than the expected sales volume.
Assume, in each scenario, that the average sales price per vehicle is $85,000 and that all sales are realised at the end of December 2020. All variable costs incurred by producing an additional vehicle to be sold in North America in 2020 are billed in euros (€) and amount to €55,000 per vehicle. Shipping an additional vehicle to be sold in North America in 2020 are billed in € and amount to €3,000 per vehicle.
The current spot exchange rate is (bid-ask) $1.11/€ - $1.12/€ and forward bid-ask is $1.18/€ - $1.185/€. The option premium is €0.025, and option strike price is €0.922. Your finance team made the following forecasts about the exchange rates at the end of December 2020:
• bid-ask will be $1.45/€ - $1.465/€ if the investors (and speculators) consider the euro (€) a safe haven currency during the pandemic.
• bid-ask will be $0.88/€-$0.90/€ if the investors (and speculators) consider the U.S. dollar ($) a safe haven currency during the pandemic
5. Assume that the Scenario 2 (Pandemic) took place in 2020 and the U.S. dollar became a safe haven currency during the pandemic. What are your cash flows (profits) if you did not hedge, hedged using forward contracts, and hedged using option contracts?
6. Based on the calculations in Part B, do you believe that it is a good policy to hedge Porsche’s currency exposure? Why?
In: Finance
“Lactose repressor protein (LacI) utilizes an allosteric mechanism to regulate transcription in E. coli, and the transition between inducer- and operator-bound states has been simulated by targeted molecular dynamics (TMD). The side chains of amino acids 149 and 193 interact and were predicted by TMD simulation to play a critical role in the early stages of the LacI conformational change. D149 contacts IPTG directly, and variations at this site provide the opportunity to dissect its role in inducer binding and signal transduction. Single mutants at D149 or S193 exhibit minimal change in operator binding, and alterations in inducer binding parallel changes in operator release, indicating normal allosteric response. The observation that the double mutant D149A/S193A exhibits wild-type properties excludes the requirement for inter-residue hydrogen bond formation in the allosteric response. The double mutant D149C/S193C purified from cell extracts shows decreased sensitivity to inducer binding, while retaining wild-type binding affinities and kinetic constants for both operator and inducer. By manipulating cysteine oxidation, we show that the more reduced state of D149C/ S193C responds to inducer more similarly to wild-type protein, whereas the more oxidized state displays diminished inducer sensitivity. These features of D149C/S193C indicate that the novel disulfide bond formed in this mutant impedes the allosteric transition, consistent with the role of this
region predicted by TMD simulation. Together, these results establish the requirement for flexibility of spatial relationship between D149 and S193 rather than a specific D149-S193 interaction in the LacI allosteric response to inducer.” Biochemistry 48:4988.
(4 points) What is allosteric regulation?
(4 points) How does the lactose repressor protein (LacI) use an allosteric mechanism to regulate transcription?
(6 points) How do the side chains of amino acids 149 and 193, of the lactose repressor protein, play a role in the LacI conformational change.
(6 points) What would you predict would happen if either amino acid 149 or 193 were mutated?
In: Biology
Suppose that you are part of the Management team at Porsche. Suppose that it is the end of December 2019 and a novel coronavirus that causes a respiratory illness was identified in Wuhan City, Hubei Province, China. The illness was reported to the World Health Organization and there is heightened uncertainty around the Globe.
You (as part of the management team) are reviewing Porsche’s hedging strategy for the cash flows it expects to obtain from vehicle sales in North America during the calendar year 2020. Assume that Porsche’s management entertains three scenarios:
Scenario 1 (Expected): The expected volume of North American sales in 2020 is 35,000 vehicles.
Scenario 2 (Pandemic): The low-sales scenario is 50% lower than the expected sales volume.
Scenario 3 (High Growth): The high-sales scenario is 20% higher than the expected sales volume.
Assume, in each scenario, that the average sales price per vehicle is $85,000 and that all sales are realised at the end of December 2020. All variable costs incurred by producing an additional vehicle to be sold in North America in 2020 are billed in euros (€) and amount to €55,000 per vehicle. Shipping an additional vehicle to be sold in North America in 2020 are billed in € and amount to €3,000 per vehicle.
The current spot exchange rate is (bid-ask) $1.11/€ - $1.12/€ and forward bid-ask is $1.18/€ - $1.185/€. The option premium is 2.5% of US$ strike price, and option strike price is $1.085/€. Your finance team made the following forecasts about the exchange rates at the end of December 2020:
In: Finance