see requirements

Instructions

Analyze in detail why customers wont buy a good or service unless it is conveniently available when and where they want to buy it.Distribution channel decisions have a major economic impact because distribution costs, many of which do not even appear in the firms income statement, often exceed the costs of producing a good or service. Choose and airline and decide if they have strong or weak distribution channel. Defend your answer.A clear understanding of ones target market is essential for planning and implementing an effective promotional program. Explain why this statement is true.New media, including the Internet, email, and Smart cellphones, are predicted to revolutionize ad spending, because their resultslike those for direct marketing programscan often be directly measured. Using the airlines industry as your frame of reference, discuss which of the media mentioned in the preceding statement are measurable. Which metric or metrics would you suggest using to measure effectiveness, sales, inquiries, ad clicks, etc? Part 2: Channel Selection Matrix Using ExcelAs a marketing manager for a major airlines you are faced with a distribution dilemma. Your current distributors are coming up for their annual review and you must produce analytics for a meeting the rates their performance. Here is your chart: (ATTACHED)Current Performance and Criteria .mgmt449_m7_review_tables_0813.gifYour supervisor is pleased with most of the criteria that you have used on the Excel spreadsheet above but feels there is duplication between some of the criteria, i.e. consumer acceptability, dependability, cost of getting the channel up to speed, and overhead costs. You also discovered that other airlines rate their channel members' overall scores much higher and have been more profitable in the past year. Your challenge is to create new criteria to substitute for the above and assign values using scores 1 through 5, along with new weights for these new criteria. In addition, Channel B feels their performance numbers were unfairly assessed. Using the Microsoft Excel template linked below, enter an analysis of the new criteria and data with your recommendation based on quantitative channel assessment.  In a Microsoft Word document, provide your channel selection rating and overall rating. Provide sound rationale for your selections. Include a copy of your edited spreadsheet table (either copy and paste or include screen shots) in the document. You may need to save your document in landscape orientation to fit all the content onto the page. If you encounter significant difficulty in doing this, email your instructor the spreadsheet file separately.Data File attached spearatelyDownload the following file by right-clicking on the file link, selecting Save Target (or Link) As..., and saving to your computer.Channel Selection Matrix Data FilePreview the document  (Microsoft Excel file)

Answer