Questions
Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department...

Employee ID

First Name

Last Name

email

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;...

. 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,...

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.

  • In Worker class, it includes two field, nYearWked and curSalary, and constructor(s). It defines the CalcYearWorked() function using (current year – yearStartedWked) and save it in the nYearWked variable. It also defines the CalcCurSalary() function that calculates the current year salary by using initial salary with 3% yearly increment.

Create a Manager class that is derived from Worker class.

  • In Manager class, it includes one field: yearPromo and constructor(s). Itincludes a CalcCurSalary function that calculate the current year salary by overriding the base class function using initial salary with 5% yearly increment plus 10% bonus. The manager’s salary calculates in two parts. It calculates as a worker before the year promoted and as a manager after the promotion.

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...

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...

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...

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).

  1. Assess the reasons for using lean thinking (suitable examples), what are the benefits from Suppliers to end users?
  1. Due to COVID 19 emergency do you think agile supply chain is the right concept in this kind of situation? Give reason with example.

The Answer should be within 1- 2 pages. for each question

The Answer must follow the outline points below:

  • Lean Thinking and JIT Concept
  • Agile Supply chain
  • Their Main functions
  • Reasons with suitable Examples
  • Reference

In: Operations Management

NOTE THAT ((This should be done by R studio !)) Q: Upload your data as a...

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...

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...

“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...

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:

  • 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
  1. 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 if you did not hedge, hedged using forward contracts, and hedged using option contracts?   

  1. 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