There are three written assignments in the course, in which you will use the same organization to analyze the culture and make recommendations. Therefore, it is essential you start to think now about your company selection. Consider selecting a company you work for, a company a family member or friend works for, or a civic organization. To ensure your selection sets you up for success in all three assignments, be sure to review the COURSE ASSIGNMENTS (PDF), and ensure that your selected company:is one you are familiar and can draw on internal processes the public (outsider) is unaware,has true issues that need to be resolved, andallows for realistic and enforceable solutions for the organization to be successful. When you are ready to begin this assignment, select begin at the bottom of the page and use the provided textbox to address the following:Identify the company that you want to research for the three written assignments in the course.Describe the organizational issue in your chosen company.Explain why the issue hinders organizational efficiency.I’ll input the information provided to questions 1-3 via blackboard. ASSIGNMENT PREP COMPANY SELECTION AND SOURCESDue Week 3: 60 pointsThere are three written assignments in the course, in which you will use the same organization to analyze the culture and make recommendations. Therefore, it is essential you start to think now about your company selection.Consider selecting a company you work for, a company a family member or friend works for, or a civic organization. To ensure your selection sets you up for success in all three assignments, be sure that your company:▪ isoneyouarefamiliarandcandrawoninternalprocessesthepublic (outsider) is unaware▪ has true issues that need to be resolved▪ allowsforrealisticandenforceablesolutionsfortheorganizationtobe successfulINSTRUCTIONSTo complete this assignment, use the provided textbox in which you:1) Identifythecompanythatyouwanttoresearchforthethreewritten assignments in the course.2) Describetheorganizationalissueinyourchosencompany. 3) Explainwhytheissuehindersorganizationalefficiency.

InstructionsThe Scenario:In past years, New Orleans has been hit hard by hurricanes and other bad weather. The construction industry, working with New Port Community College, has put a renewed emphasis on training the Construction Management students to build structures that meet current building codes. You have been asked to create a flyer inviting all Construction Management students to attend a conference.For this assignment, you will need the following files:New blank Publisher publicationConstruction_ManagementCM_LogoYou will save your files as:Lastname_Firstname_Construction_ManagementLastname_Firstname_Construction_ConferenceLastname_Firstname_Merged_ConferencePart 1Open the Access file Construction_Management and Save with the file name Lastname_Firstname_Construction_ManagementCreate a form named based on the Students table, save it as Lastname Firstname Student FormAdd the following student records.Use your first name and last name for the last record.First NameLast NameAddressCityStateZIPPhone NumberDegreeKarenCrosby11171 54th AveNew OrleansLA33714504-555-0092Construction ManagementRichardEagleson12501 W Isabel StNew OrleansLA33708504-555-5832Information SystemsLarryMagg15304 Cypress StNew OrleansLA33701504-555-0362Construction ManagementFirstnameLastname12513 Frierson AveNew OrleansLA33701504-555-0186Construction ManagementPart 2Create a report using the Report Wizard that includes the fields First Name, Last Name, Phone Number, and Degree.Group the data by Degree and sort the data by Last Name. Change the column widths so all data is visible.Create a Publisher template of your choice.Save the file as Lastname_Firstname_Construction_Conference and then insert the your name in the footer.In a text box, add information about the Construction Management conference to be held on campus on March 3–4.In another text box, list Louisiana cities, such as Baton Rouge, Lafayette, that have had damage due to hurricanes.Insert and format appropriate online images.Create a business set for Mrs. Finale using the following information.Individual nameTammy FinaleJob positionDirector, Construction Management ProgramOrganization nameNew Port Community CollegeAddress12745 Dartmouth Ave New Orleans, LA 70114Phone Number504-555-0030Fax504-555-0031E-mailconstruction@NewPortCC.eduTaglineBuilding a better New OrleansLogoCM_LogoBusiness Information set nameFinalePart 3Start mail merge and choose your Access file Lastname_Firstname_Construction_Management as the data source.Filter the recipients to show only the Construction Management students.Insert the student's name and mailing address.Save the publication.Complete the merge to a new publication.Save the merged publication as Lastname_Firstname_Merged_Conference and then update the footer with your name.

Answer the three (3) questions on demand forecasting and customer relationship management.Use Excel®, use multiple worksheets (tabs), with an answer to each question on a separate worksheet.