Need help with the questions below. Find the attached file. Some of them are already completed in that file. Need help with the rest. Most of these are short answers and may be completed in one to two lines.

1. What is the name of your firm and why did you select it?

2. Identify 2 or 3 notable facts in the history of your firm.

3. Identify and list the ‘business segments’ in your firm. Is there at least one for each team member?

4. Who is the Chairman/CEO of your corporation? Identify some of the person’s

attributes (e.g., age, tenure, education, experience, links to other firms)

5. What are the current stock price, and most recent year end revenues, net

income and earnings per share? What is your preliminary assessment of the

firm’s financial health?

6. When is the next quarterly investor report for your company?

7. Browse through the news feeds related to your firm. What is your preliminary

assessment of the core issues facing your firm?

8. Set up a “Google Alert for your company

9. Which business segment are you focusing on?

10.What are the core activities/product lines of your business segment?

11.What percentage of the firm’s revenue is from this business segment? (show work)

12.What percentage of the firm’s earnings before taxes is from this line of

business? (show work)

13.Who is the executive in charge of this business segment? Identify some of the

person’s attributes (e.g., age, tenure, education, experience, links to other

firms)

14.What are the NAICS and SIC codes for your business segment?

15.What are the industry’s revenues, profits and percent of profits to revenues?

16.Who are the major rivals of your business segment?

17.Where does your business segment rank amongst its rivals in terms of some

performance metrics such as revenue, operating income, market share, etc?

18.What are the main economic, political and social trends facing your business

segment’s industry?

19.What is your preliminary assessment of the industry and competitive position of

your business segment?

20.What is your preliminary assessment of the issues facing your business

segment?

21.Set up a “Google Alert” for your business segment (note this is a different alert

than for your company. You should have two alerts; (1) company and (2) your

business segment)

Hello, please follow steps and do the work .

you can find data on this link : https://drive.google.com/file/d/19W_rUJP3StkNyCYgt…

• Open and save the Access database on your machine
• Create the Relationships between the tables.
• Output the names of all students taking Biology.
• Output all Student_Ids whose Advisor_ID is not 3.
• Output the names of all students whose ID is more than 3000.
• Show the number of courses in the Course table.
• Show the names of all courses in the Course table sorted by the Course name.
• Output the names of all students whose ID is in between 3700 and 4000.
• Show the names of all students whose advisor is Jones.
• Create a Student form
• Add 6 new student entries using the Student form and populate all the fields (including the State and Zip) in the form for the new students and the existing students.
• Go to the datasheet view of the Student_Course and Student_Advisor table and add 2-3 entries in both these tables for the new students (Do not add new courses or advisors, use existing ones only). Populate the scores field in the Student_Course table as well (make up some scores).
• Create two sub-forms to show the Course and Advisor information for each student on the Student form.
• Create a report to show the individual scores obtained by each student in each course they took. The student_id and name should not be repeated with the scores. Show in the report the average score for each student (use the Report layout view) at the end of each student record and the average for all students at the bottom of the report.

Queries:

Using the Access Query design option, run all the following 7 queries (questions 3 to 9):

Save the queries as Query(q.no.).

(Example: Query3 for question 3 below).

Hint:

For queries 4,5 and 8 use comparison operators (research online if necessary): <, >, =, >=, <= in the criteria

Use the Sort attribute in query design for question 7

Use the Totals feature in the Show/Hide block in the query design view for question 6.

Forms and Reports

Save the database and upload it. Make sure Access is not open when you upload it.

Task 8

Task 8 Developing, Marketing, Launching, and Managing International Production

Investigate Developing and Marketing

1. Work through the Lynda.com tutorial on International Marketing Fundamentals
   1. 1. 1. 1. 1. 1. 1. 1. 1. 1. 1. 1. Importance of International Marketing
                                    2. Strategic Considerations
                                    3. Assessing Markets Outside Home Country
                                    4. Market Development and Product Development Decisions
                                    5. Options for Global Expansion
                                    6. Resources
                                    7. Marketing Mix
                                 2. Read Chapter 14 in ebook on Marketing and Developing Products.
                                 3. What is the Marketing Communication Process and why is this critical to consider if you are going global?
                                 4. Complete the Lynda.com tutorial Top 5 Tips for Marketing Your Product Internationally

Learn about Designing Distribution Channels and Launching a Product/service

1. How did FedEx do it? WatchPlay Video
2. Or how about Starbucks? WatchPlay Video
3. Read Chapter 14 section 3 on designing distribution channels
4. Watch Lynda.com video Designing Distribution Channels
5. WatchPlay Video
6. Read Chapter 15 in ebook on Production Strategy – production and facilities planning; production concerns; shipping and inventory cost

Learn more about managing the global business. Read and analyze:

1. Managers Brief Case in Chapter 14 – Managing an International Sales Force. What are the barriers, risks, and hurdles? What is the manager’s role? What specific leadership strategies will help?
2. Managers Brief Case in Chapter 15 – What are World Class Standards? Can they be applied to all products and services on the international market? What if other countries don’t do the same? What is the leader’s role?

Locate a company that went global besides Starbucks and FedEx. Trace their development, marketing, product distribution, and management of the global enterprise. Find specific information that shows the process and strategies. Make an infographic to show the process.

The Case of the Director Who Wore Too Many Hats

Maria is one of 5 directors of Beta Investments Corporation. She is also a majority shareholder holding both common and preferred stock. Her stock with voting rights amounts to 47% of all stock issued with voting rights.

Maria buys, for $1,500, an option to purchase a tract of real estate called Blackacre, which is next to Beta’s home office, for $50,000. Maria forms a new corporation, Commercial Property, Inc., to hold the option. She then has Commercial Property buy Blackacre. As a director of Beta, Maria orders Beta to authorize its real estate agent to negotiate the purchase of the land from Commercial Property for $100,000. After a successful negotiation for the purchase of Blackacre for $100,000, Maria has Commercial Property sell it to Beta, and loan the money to Beta for the purchase price at a 5% interest rate which is 2% below the market rate. Lakesha, a minority shareholder in Beta, formally complains to Beta’s board which takes no action.

The Trial

Lakesha files a suit against Maria on Beta’s behalf seeking to cancel the sale. Maria asks the Court to dismiss the lawsuit as Lakesha has no standing to bring the lawsuit.

Arguments At Trial

Maria’s attorney argues that Blackacre is necessary for Beta as it will allow them to expand their offices and production plant thus increasing the net worth and potential profits to the shareholders. Further, the Board of Directors of Beta authorized the purchase which appeared to be in accordance with the Articles of Incorporation.

Lakesha’s attorney argues that the purchase of Blackacre should have been put to a vote of the shareholders of Beta as required by Beta’s Bylaws. Beta’s Board of Directors failed in its duty to make sure this sale was in the corporation’s best interest.

Questions to Decide

1. What kind of suit will Lakesha file and what is its basis?
2. Who are the Plaintiffs and who are the Defendants? Why?
3. What are the defenses, if any, of Beta or Maria?
4. Who will win the case and why?

Make sure that spelling and grammar is right. cite to the text at least once in the answers.

Writing 1-Letter

Submit Assignment

• Due Tuesday by 2:50pm
• Points 50
• Submitting a file upload

You have just been hired by On the Court as the community relations director. On the Court is a sports apparel company that has contracts with high school athletic departments all over the country to provide logo items and team uniforms for a variety of sports.

Over the summer, there was a series of database errors. Many orders were deleted from the system with no tracking of having ever received orders. Remaining orders were altered in the colors and sizes of the uniforms. This means that many schools never received the uniform orders, and the schools that did receive uniforms had the wrong colors and sizes that did not fit their athletes. With the fall sports season ready to start, many athletic directors have been calling your office and complaining. Others have taken to social media to complain with photos of their teams in mismatched, ill-fitting apparel.

You have been asked to draft a letter to all of On the Court’s customers explaining the situation and what the company is doing to fix it and make amends.

Your letter should be clear, concise and assist in building trust between your company and its customers. It should appear as realistic as possible, and you should use the business letter template provided. You may make up appropriate facts, names and strategies for dealing with the situation.

Business Letter Format.docx

Writing1Tips.docx

Grading Criteria

Grammar/Spelling 20

Form/Appearance 10

Appropriate Content 10

Clarity of Content 10

Rubric

Business Letter

Business Letter

Criteria	Ratings	Pts
This criterion is linked to a Learning OutcomeGrammar/Spelling		20.0 pts
This criterion is linked to a Learning OutcomeForm/Appearance		10.0 pts
This criterion is linked to a Learning OutcomeAppropriate Content		10.0 pts
This criterion is linked to a Learning OutcomeClarity		10.0 pts
Total Points: 50.0