The purpose of this assignment is to introduce how network models can be used to solve a business problem.Using specified data files, chapter example files, and templates from the “Topic 6 Student Data, Template, and Example Files” topic material, complete Chapter 14, Problems 15, 16, 17, 20, and 88. Use Microsoft Excel’s Solver Add-In to complete these problems. For problems 17, 20, and 88, run the Solver’s Answer and Sensitivity Reports. Interpret and summarize the key results.Problem #15:In the RedBrand example, suppose the plants cannot ship to each other and the customers cannot ship to each other. Modify the model appropriately, and rerun Solver. How much does the total cost increase because of these disallowed routes?Problem #16:Modify the RedBrand example so that all flows must be from plants to warehouses and from warehouses to customers. Disallow all other arcs. How much does this restriction cost RedBrand, relative to the original optimal shipping cost?Problem #17:In the RedBrand example, the costs for shipping-from plants or warehouses to customer 2 were purposely made high so that it would be optimal to ship to customer 1 and then let customer-1 ship to customer 2. Use SolverTable appropriately to do the following. Decrease the unit shipping costs from plants and warehouses to customer 1, all by the same amount, until it is no longer optimal for customer 1 to ship to customer 2. Describe what happens to the optimal shipping plan at this point.Problem #20:Suppose in the original Grand Prix example that the routes from plant 2 to region 1 and from plant 3 to region 3 are not allowed. (Perhaps there are no railroad lines for these routes.) How would you modify the original model (Figure 14.14) to rule out these routes? How would you modify the alternative model (Figure-14.19) to do so? Discuss the pros and cons of these two approaches.Problem #88:An oil company produces oil from two wells. Well-1 can produce up to 150,000 barrels per day, and well 2 can produce up to 200,000 barrels per day. It is possible to ship oil directly from the wells to the company’s customers in Los Angeles and New York. Alternatively, the company could transport oil to the ports of Mobile and Galveston and then ship it by tanker to New York or Los Angeles, respectively. Los Angeles requires 160,000 barrels per day, and New York requires 140,000 barrels per day. The costs of shipping 1000 barrels between various locations are shown in the file P14_88.xlsx, where a blank indicates shipments that are not allowed. Determinehow to minimize the transport costs in meeting the oil demands of Los Angeles and New York.To receive full credit on the assignment, complete the following.Ensure that all Solver settings are defined through the use of the Solver dialog box.Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.Include Answer and Sensitivity Reports interpretation and summary of key results.Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.APA style is not required, but solid academic writing is expected.

CompetencyIn this project, you will demonstrate your mastery of the following competency:Apply leadership and followership in managing individuals and groupsScenarioYou work for Brooke Lillian travel agency, and you are a corporate trainer. Your boss, Brooke Blake, has asked that you develop a formal presentation that focuses on change management. During periods of transition, it is especially important to focus on leadership and followership in managing groups and individuals. This request is in anticipation of a major reorganization initiative.Company OverviewBrooke Lillian travel agency provides professional, tailored travel-planning services to its clients. Many of its clients are busy, working adults with families. The travel agents work closely with their clients, taking their interests and needs into thoughtful consideration to help them plan the perfect vacation experience.Role ChangesThe reorganization initiatives will enable the agency to grow more rapidly and to efficiently manage this growth. In the previous model, the travel agency covered a few main areas, and travel agents worked with clients who wanted to travel to specific areas. In the new model, travel agents will work on more diverse teams across a variety of geographic areas. They will cover more areas, and travel agents will be assigned based on availability, not the specific area that they cover. These changes will present the following:Long-standing teams based on specific areas will become integrated into larger, more agile teams. As part of this initiative, travel agent titles have changed. Instead of including a specialty, such as “Caribbean travel specialist,” there is now the simple title of “travel agent.” The roles of travel agents have expanded to cover all areas.Managers will oversee small teams, and many travel agents will work with new or different managers than they have worked with in the past. Many of the travel agents have experienced a role change in addition to the new structure, as some have been promoted to managers overseeing teams. Newly promoted managers have leadership development training.AudienceThe audience for your presentation will be new and existing managers. As a result of the reorganization efforts, managers will oversee teams of new people, and established teams will be shuffled. Managers should be prepared to effectively lead their new teams by applying principles of leadership and understanding their own leadership style. The team is made up of many long-tenured employees who are set in their ways and not willing to change, along with newer employees who are embracing the change and looking to improve the processes.Opportunities for ImprovementPrior to the training, management conducted an employee satisfaction survey. They want to start the new teams off on the right foot, so they compiled a list of key points and issues from the survey results. Brooke would like you to address conflict resolution and negotiation skills in your presentation.Since managers have a variety of leadership styles, some employees embrace the change, and others may struggle with the change. Some of the managers have a style that is more direct, and some employees have voiced that they feel uncomfortable with that style, while others prefer a more direct approach. Managers should use their natural style but have the flexibility to adapt to working with new employees.Some team members feel overwhelmed by the amount of work and tight deadlines, whereas others are comfortable with the workload and timeline expectations. This is creating conflict among the teams, as many people are complaining and bringing down team morale. Managers should be able to support struggling employees and help them avoid becoming overwhelmed, while also ensuring that team members who are doing well feel supported and recognized.Previously, teams approached their day-to-day work, including tracking completion and status, in their own ways. In the new paradigm, teams are having difficulty agreeing on the “right” approach, specifically for tracking and managing work. This is where you, as the leader, must pull your followers together to create the most efficient tracking system possible.DirectionsBrooke has requested that you specifically address the following in your presentation:Team Dynamics: Discuss strategies for effectively managing teams, especially as they apply to leadership strategies to support open communication and foster effective followership within teams.Discuss the impact of role changes within a team on team dynamics for informing management about what to expect in terms of followership and leadership approaches.Include management approaches for effectively leading teams during times of transition.Describe strategies to establish trust and open communication on teams for informing leadership approaches and supporting followership. Address the following in your response:What leadership approaches support teams and encourage open communication?What leadership skills encourage effective followership?Discuss conflict resolution and negotiation skills for addressing each opportunity for improvement outlined in the scenario for fostering productive team dynamics. Address the following in your response:How will the conflict resolution or negotiation skill identified address the issue?Leadership Style: Each manager you will present to will have their own unique leadership style. Brooke would like you to provide leadership skill development for the management team by discussing the importance of leadership skills and applying their leadership style.Discuss individual efficiencies in leadership and followership for informing management approaches. Address the following in your response:What is the difference between an effective leader and an ineffective leader?How does an effective leader manage individuals and encourage followership?Explain the use of self-assessment tools and strategies for determining potential on or within a team. Address the following in your response:How do self-assessment tools and strategies support employees in considering team contribution and supporting group and individual goals?Discuss the importance of understanding one’s leadership style. In the speaker notes, highlight your own style or the style of an admired leader as an example for illustrating the application of leadership styles in a workplace setting. Address the following:How does natural leadership style influence leadership and followership in managing individuals and groups?Discuss the situational leadership model as it applies to natural leadership styles. Include the following in your response:How can all leadership styles use the situational leadership model to support their natural leadership style?As an example, discuss applications to your own leadership style in speaker notes.What to SubmitEvery project has a deliverable or deliverables, which are the files that must be submitted before your project can be assessed. For this project, you must submit the following:Management Training PresentationYour management training presentation should be 10 to 12 slides, not including an introduction or references slide, and should include speaker notes on each slide. Reference List For each source that you cite, you need to include the author’s name, the publication year, the title of the source, and the location of the source in a References section at the end of your work. Cite all sources appropriately.Supporting MaterialsThe following resource(s) may help support your work on the project:Document: How to Design and Deliver an Effective Presentation- see attached down below!This resource provides tips and best practices for developing a Presentation. Specifically, review the “Designing an effective presentation” section.

Module 1 Assignment: William Olson opened Olson Construction on May 1, 2017. The following amounts summarize the transactions and financial position of Olson Construction as of May 31. During May the following transactions occurred: 1-May Olson purchased $15,000 of stock in the company. 2-May Olson purchased $4,000 of equipment for the company with cash. 7-May Olson purchased supplies for $1,000 on account. 15-May Olson replaced some windows for a client and received $8,000 cash as payment in full at the time of service. 17-May Olson billed a customer for an estimate provided. The estimate service performed cost $1,800. 20-May Olson paid $750 of his accounts payable balance as of May 20th. 24-May Olson collected a partial payment of $1,000 from the customer for the job performed and billed on May 17. 25-May Olson sold $5,000 of company stock to his brother. 28-May Olson paid wages to his workers of $2,200. 30-May Olson paid office rent of $1,500. 30-May Olson paid dividends to himself of $1,600.