Create 4-PowerPoint slides, including detailed speaker notes, as the committee's consultation team and respond to the following:Shelley, Jonathan, and Adrian Stein, the Fundraising Chairperson, are beginning to make plans for next year's rodeo. Shelley believes by negotiating with local feed stores, inn- keepers, and other business owners, costs can be cut dramatically. Jonathan agrees. After carefully analyzing costs, Jonathan has estimated the fixed expenses can be pared to approximately $51,000. In addition, Jonathan estimates variable costs are 4% of total gross receipts. After talking with business owners who attended the rodeo, Adrian is confident the funds solicited from sponsors will increase. Adrian is comfortable in budgeting revenue from sponsors at $25,600. The local youth group is unwilling to provide concessions to the audience unless they receive all of the profits. Not having the personnel to staff the concession booth, members of the Circular Club reluctantly agree to let the youth group have 100% of the profits from the concessions. In addition, members of the rodeo committee, recognizing the net income from programs was only $100, decide not to sell rodeo programs next year.Compute the break-even point in dollars of ticket sales assuming Adrian and Jonathan are correct in their assumptions.Shelley has just learned you are calculating the break-even point in dollars of ticket sales. She is still convinced the Club can make a profit using the assumptions above (second bullet point above).Calculate the dollars of ticket sales needed to earn a target profit of $6,000.Calculate the dollars of ticket sales needed to earn a target profit of $12,000.Are the facilities at the fairgrounds adequate to handle crowds needed to generate ticket revenues calculated above (third bullet point above) to earn a $6,000 profit? Show calculations to support your answers.Show your work in Microsoft® Word or Excel®.Complete calculations/computations using Microsoft® Word or Excel®.Format the assignment consistent with APA guidelines.I only need these three bulletins done. The 4 slides will be to explain what is on excel. Must have calculation/computation using word or excel.The attachment is only the scenario and numbers needed to complete the three bulletins above.

ScenarioYou have been asked to evaluate Company A and Company B and make your recommendation for acquiring one or both companies. Based on your initial assessment, you have created balanced scorecards for both companies. You are now ready to analyze the information you have gathered so far about the two companies so that you can compare the costs, benefits, and risks associated with acquiring each company and make a well-informed decision.In this milestone, you will first analyze the current situation of TransGlobal Airlines using the given data and other sources to understand their business environment. You will also evaluate the performance of Company A and Company B using the balanced scorecards you created in Milestone One.PromptWrite a report with your performance evaluation of the three companies involved in the acquisition.Specifically, you must address the following rubric criteria:Situation Analysis of TransGlobal Airlines (parent company). Use the provided TransGlobal Company Information and Financials to highlight the company’s current business environment.Internal environment: culture, leadership, internal processes, human resources, operations, and financial performanceExternal environment: competitive, market, regulatory, customers, suppliers, and other relevant stakeholdersBalanced Scorecard Analysis of Company A. Using the balanced scorecard for Company A from Milestone One, describe your analysis of Company A’s performance. Perform a cost-benefit-risk analysis to explain whether the benefits justify the costs of acquisition.Opportunity cost: What will it cost to move forward with this opportunity?Risk: Identify and explain the magnitude (low, medium, or high) of the risks this acquisition poses to the parent company related to its market, financial, cultural, and operational environments.Balanced Scorecard Analysis of Company B. Using the balanced scorecard for Company B from Milestone One, describe your analysis of Company B’s performance. Perform a cost-benefit-risk analysis to explain whether the benefits justify the costs of acquisition.Opportunity cost: What will it cost to move forward with this opportunity?Risk: Identify and explain the magnitude (low, medium, or high) of the risks this acquisition poses to the parent company related to its market, financial, cultural, and operational environments.Guidelines for SubmissionSubmit a 6- to 8-page Word document using double spacing, 12-point Times New Roman font, and one-inch margins. If references are included, they should be cited in APA format.

If you have not done so already, please view this video from week 3 on the three waves associated with the use of IT. Then, read the article on how smart, connected products are transforming companiesFinally, read the article on how smart, connected products are transforming competition.Based upon the above video and articles, IT can be described as having three waves: automate individual functions, integrate value chains, incorporate IT into product and service offerings. Give an example of each (automate, integrate, incorporate) for specific businesses and cite your sources. Internet sources are OK if you provide the hyperlink. You can use the same business for each of the 3 categories or different businesses for different categories. Do not use the examples already posted by other students or the examples in the attached articles.