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.

I attached guideline

Recruitment Ad

Recruitment Ad

Criteria	Ratings	Pts
This criterion is linked to a Learning OutcomeContent	10.0 pts Excellent Ad included the following: Job description • Location • Compensation and Benefits • Who/where to apply • EEO statement 7.0 pts Average Ad missed at least 1 of the following: Job description • Location • Compensation and Benefits • Who/where to apply • EEO statement 0.0 pts Poor Ad missed at least 2 of the following: Job description • Location • Compensation and Benefits • Who/where to apply • EEO statement	10.0 pts
This criterion is linked to a Learning OutcomeLegality/creativity	5.0 pts Excellent Ad contained: Legality • Did the ad use sexist language? • Were contents and specifications based on essential functions? Creativity • Would this ad catch your attention? • Was the correct medium used given the target market? • Was the medium used appropriately? 3.0 pts Average Missed at least one of the issues. Legality • Did the ad use sexist language? • Were contents and specifications based on essential functions? Creativity • Would this ad catch your attention? • Was the correct medium used given the target market? • Was the medium used appropriately? 0.0 pts Poor Ad did not follow legal and creative guidelines.	5.0 pts
This criterion is linked to a Learning OutcomeJob Specifications	5.0 pts Excellent Ad contained: • Realistic description working conditions (may not apply) • Minimum education, experience, and skill levels required • Special criteria (relocation, travel, etc) 3.0 pts Average Ad missed at least one of the issues. • Realistic description working conditions (may not apply) • Minimum education, experience, and skill levels required • Special criteria (relocation, travel, etc) 0.0 pts Poor Ad did not contain job specifications.	5.0 pts
This criterion is linked to a Learning OutcomeSpelling/grammar	5.0 pts Excellent No grammar or spelling errors 3.0 pts Average 1 grammar or spelling error 0.0 pts Poor More than 2 grammar or spelling errors	5.0 pts

Inventory management and aggregate planning serve an obvious need in production companies, but these concepts are also highly valuable for service businesses. Identify an existing service based business and describe the importance of inventory management or aggregate planning as it applies to that company.

– 200-300 words

– at least two references

This weeks study ————————————————-

Aggregate Planning and Master Scheduling

We will continue this week by looking at aggregate planning, which establishes general levels of employment, output, and inventories for periods of 2 to 12 months. In the spectrum of planning, it falls between the broad decisions of long-range planning and the very specific and detailed short-range planning decisions. It begins with an overall forecast for the planning horizon and ends with preparations for applying the plans to specific products and services.

The essence of aggregate planning is the aggregation of products or services into one “product” or “service.” This permits planners to consider overall levels of employment and inventories without having to become involved with specific details that are better left to short-range planning. Planners often use informal graphic and charting techniques to develop plans, although various mathematical techniques have been suggested.

Inventory Management

Inventory management is a core operations management activity. Good inventory management is often the mark of a well-run organization. Inventory levels must be planned carefully in order to balance the cost of holding inventory and the cost of providing reasonable levels of customer service. Successful inventory management requires a system to keep track of inventory transactions, accurate information about demand and lead times, realistic estimates of certain inventory-related costs, and a priority system for classifying the items in inventory and allocating control effort.

Objectives

By the end of this week, students will be able to:

• Demonstrate and discuss how inventory, level employment, chase demand, and aggregate labor planning applies to a service business.
• Define, recall, and identify terms and concepts associated with quality management, costs, quality management tools, quality teams, control charts, inventory systems, quality models, cycles, supply chain, aggregate planning, and manufacturing capacity.
• Examine and interpret key elements of scheduling and inventory management.

Operations ManagementMcGraw-Hill Education; 13thedition (February 15, 2017) by William J Stevensone-copyTextbook with Connect access code: ISBN13: 978-1259948206

Stevenson, Chapters 11 &13

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