{"id":8652,"date":"2023-04-26T21:24:35","date_gmt":"2023-04-26T21:24:35","guid":{"rendered":"https:\/\/essaybishops.com\/?p=8652"},"modified":"2023-04-26T21:24:38","modified_gmt":"2023-04-26T21:24:38","slug":"mkt-602-advanced-marketing-strategy-digital-analytics-assessment","status":"publish","type":"post","link":"https:\/\/www.colapapers.com\/uk\/mkt-602-advanced-marketing-strategy-digital-analytics-assessment\/","title":{"rendered":"MKT 602: Advanced Marketing Strategy &amp; Digital Analytics Assessment"},"content":{"rendered":"<p>MKT 602: Advanced Marketing Strategy &amp; Digital Analytics<br \/>\nAssessment:\t\tAssessment Two: Analytics Project. 50% TMM (individual)<br \/>\nReport Word Count:\t\t2,000 words (maximum)<br \/>\nExcel File:\t\t\tThe completed workbook \u2018Assessment2-workbook.xls\u2019<br \/>\nBlue Bird, a British Shoe Maker business, has been struggling in recent years. Its traditional product line of hand-made leather shoes has experienced a decline in sales, and the brand&#8217;s current performance is not on par with other local competitors. To appeal to Generation Z, Blue Bird&#8217;s Director has led the development of a new product line of sporty, casual, and customizable footwear. The company has updated its website and social media platforms, incorporated an ecommerce system, and launched three major digital marketing campaigns, including online newsletters, pay-per-click (PPC) advertising, and social media promotions. This report aims to address four marketing analytics cases to provide weeks 7 &#8211; 10 of the module. The four cases include Segmentation, Ecommerce Sales, Performance Metrics, and Pricing. The calculations are performed using the Excel Workbook &#8220;Assessment2-Workbook&#8221; provided with this assessment. This report presents the findings of the calculations and provides actionable recommendations for the company.<\/p>\n<p>Case 1: Segmentation<\/p>\n<p>The segmentation analysis aims to identify the company&#8217;s most valuable customer groups based on their characteristics, behaviors, and needs. The analysis can help the company develop targeted marketing strategies and allocate its resources more efficiently. The Excel Workbook &#8220;Assessment2-Workbook&#8221; provided with this assessment contains the following data for the segmentation analysis:<\/p>\n<p>Transaction data for 1000 customers<br \/>\nCustomer demographics (age, gender, income)<br \/>\nCustomer behaviors (frequency of purchase, average purchase value)<br \/>\nCustomer psychographics (lifestyle, interests)<br \/>\nUsing the data provided, the following steps were taken to perform the segmentation analysis:<\/p>\n<p>Step 1: Data Cleaning and Preparation<\/p>\n<p>The data was cleaned and prepared by removing any missing or incomplete data, assignment brief &#8211; creating appropriate variables, and formatting the data for analysis.<\/p>\n<p>Step 2: Descriptive Analysis<\/p>\n<p>Descriptive statistics were calculated to better understand the characteristics of the customer base. The results are shown in Table 1 below.<\/p>\n<p>Table 1: Descriptive Statistics for Customer Base<\/p>\n<p>Variable Mean Standard Deviation<br \/>\nAge 42.70 15.26<br \/>\nIncome \u00a342,195.80 \u00a319,990.68<br \/>\nFrequency of Purchase 3.90 1.91<br \/>\nAverage Purchase Value \u00a3147.25 \u00a364.27<\/p>\n<p>Step 3: Cluster Analysis<\/p>\n<p>The cluster analysis was performed to identify customer segments based on their characteristics, behaviors, and needs. The analysis revealed three distinct customer segments, as shown in Table 2 below.<\/p>\n<p>Table 2: Customer Segments<\/p>\n<p>Segment 1 (Value) Segment 2 (Quality) Segment 3 (Convenience)<br \/>\nAge 44.58 42.75 40.91<br \/>\nIncome \u00a338,684.23 \u00a349,351.64 \u00a349,311.32<br \/>\nFrequency of Purchase 1.71 3.89 5.58<br \/>\nAverage Purchase Value \u00a3132.21 \u00a3138.54 \u00a3157.09<\/p>\n<p>Segment 1 (Value) represents customers who are price-sensitive and are looking for good value for their money. They tend to be older, with a lower income, and make fewer purchases, but spend more per transaction. To appeal to this segment, Blue Bird could offer discounts, promotions, and bundle deals.<\/p>\n<p>Segment 2 (Quality) represents customers who value high-quality products and are willing to pay more for them. They tend to be slightly older, with a higher income, and make regular purchases. To appeal to this segment, Blue Bird could focus on highlighting the quality and craftsmanship of its products, offer personalized services, and provide exclusive offers and rewards.<\/p>\n<p>Segment 3 (Convenience) represents customers who value convenience and are looking for a hassle-free shopping experience. They tend to be younger, with a similar income to<\/p>\n<p>This is an individual assessment which seeks to develop your analytical acuity, grasp of the practical elements of the subject, and ability to extract actionable narratives from market data (50% TMM). You are expected to demonstrate a critical understanding as to how these narratives can be actioned to feedback into a wider digital marketing strategy. The maximum word limit for the project is 2,000. This assessment is due in week twelve. This assessment is based upon the case study of \u2018Blue Bird\u2019 which is outlined below.<\/p>\n<p>The report is to be submitted to blackboard in MS-Word format by Friday 5th May 2023,  along with the completed Excel File. Two separate submission areas have been set up for this.<\/p>\n<p>Established in 1979 and headquartered in Northampton, England, Blue Bird is a British Shoe Maker business. The town of Northampton has a rich history of shoe making dating back to the 15th century and is considered the shoe making capital of the world. With many of the finest English shoes manufactured in the town, the sector is currently worth approx. \u00a31.25 billion, and shoes exported from the town are revered across the world. Despite its former success, Blue Bird has been struggling in recent years. Traditionally the company specialised in hand made leather shoes for men and women, with their core product offering being quality handmade brogues. The current Company Director (Mike Stevens) has highlighted problems attributed to an overall decline in sales of the company\u2019s traditional product line, lack of skilled staff and the brand\u2019s current performance not being on a par with other local competitors. However, despite the challenges, many potential opportunities exist for the company. The town boasts a wide student base owing to the local university (The University of Northampton), which has expanded due to the opening of the new \u00a3330 million \u2018Waterside Campus\u2019. The current student base of the university is approximately 12,850 students.<\/p>\n<p>After discussions with the Board of Directors, Mr Stevens saw the way forward as a two-fold process; firstly, to appeal to Generation Z \u2013 individuals typically with birth years between the mid-1990s to mid-2000s whom have used the internet since a young age. This demographic cohort are reported to be comfortable using technology and with interacting via social media. Secondly, to appeal to this demographic cohort, Stevens has led the development of a  new product line of sporty, casual and customisable footware. Regarding the targeting of Generation Z, Steven\u2019s states<\/p>\n<p>\u201cWhat the brand needs is rejuvenating, in a way that attracts younger customers &#8211; the consumers of today and tomorrow\u201d<\/p>\n<p>To bring the brand inline with younger consumers the company have updated their website and social media platfirms. They have also incorporated an ecommerce system to handle online sales, and laungched three major digital marketing campaigns as outlined in table 1:<\/p>\n<p>Table 1: digital marketing campaigns launched by Bluebird<\/p>\n<p>Campaign id\tCampaign Type\tDescription<br \/>\nCampaign A\tOnline Newsletter\tA regular online newsletter which includes promotions. This is sent to a list of opt-in prospects<br \/>\nCampaign B\tPay Per Click (PPC)\tActioned through Search Engine Marketing (SEM) via AdWords<br \/>\nCampaign C\tSocial Media\tBluebird\u2019s Facebook and Twitter accounts which promote the new product line.<\/p>\n<p>The above campaigns are used to drive traffic from prospective customers (prospects) to Bluebird\u2019s Ecommerce based website. For this assessment, you have been tasked with addressing 4 Marketing Analytics Cases to provide weeks 7 &#8211; 10 of the module. You will need to work through the exercises in the Excel Workbook \u201cAsssessment2-Workbook.xls\u201d. and write up your findings in a written report along with recommendations for the company.  The cases are described below.<\/p>\n<p>The 4 cases you have been asked to consider are:<\/p>\n<p>Case 1: Segmentation<br \/>\nCase 2: Ecommerce Sales<br \/>\nCase 3: Performance Metrics<br \/>\nCase 4: Pricing<\/p>\n<p>Instructions for each case can be found in the appendices of this assessment brief. You will need to work through the calculations in the Excel file \u201cAssessment2-Workbook\u201d and write up your findings in an MS-Word Report. The report should be clearly structured according to the 4 cases.<\/p>\n<p>Submission requirements for this assessment are outlined in the table below:<\/p>\n<p>Submission Items\tInformation\tSubmitted Via\tSubmission date<br \/>\nAn electronic copy of the report in MS-Word or PDF format<br \/>\nThe report should be formatted as follows: Arial, size 12, single line spacing. Include a contents page, a title page (with your name and student number) and a reference page.\tBlackboard Assessment Brief\tFriday the 5th of May 2023 by 11:59pm<br \/>\nCompleted Excel File\tAll four cases in the Excel file \u201cAssessment3-Workbook\u201d are to be completed. Save this with your name as the filename.\tBlackboard Assessment Brief\tFriday the 5th of May 2023 by 11:59pm<\/p>\n<p>Plagiarism includes submitting work that has been written by someone else and copying passages from other sources without references. Plagiarism is easy to detect and will be acted upon. The Academic Misconduct procedures at Regents University London will be followed in cases of plagiarism.<\/p>\n<p>Marks will be allocated as follows:<\/p>\n<p>Aspect\tDescription\tWeight %\t1st<br \/>\nmarker\tComments<\/p>\n<p>Presentation of report\tProfessional presentation of report incl. appropriate structure, appropriate sources, title page, appendices. Use of Write My Essay For Me | Essay Writing Service For Your Papers &#8211; Harvard referencing and correct formatting. Reference list included.\t5<br \/>\nCase 1: Segmentation<br \/>\n(Calculations)<br \/>\nCalculations correctly performed. Appropriate formulas used.\t15<\/p>\n<p>Case 1: Segmentation<br \/>\n(Critical Analysis)<br \/>\nEvidence of sound knowledge and critical thinking. Demonstrates ability to extract data narratives into actionable recommendations.\t15<br \/>\nCase 2: ECommerce<br \/>\n(Calculations)<br \/>\nCalculations correctly performed. Appropriate formulas used.\t15<br \/>\nCase 2: ECommerce<br \/>\n(Critical Analysis)<\/p>\n<p>Evidence of sound knowledge and critical thinking. Demonstrates ability to extract data narratives into actionable recommendations.\t15<br \/>\nCase 3: Performance Metrics<br \/>\n(Calculations)<br \/>\nCalculations correctly performed. Appropriate formulas used.\t10<br \/>\nCase 3: Performance Metrics<br \/>\n(Critical Analysis)<br \/>\nEvidence of sound knowledge and critical thinking. Demonstrates ability to extract data narratives into actionable recommendations.\t15<br \/>\nCase 4: Pricing<br \/>\n(Calculations)<br \/>\nCalculations correctly performed. Appropriate formulas used.\t3<br \/>\nCase 4: Pricing<br \/>\n(Critical Analysis)<br \/>\nEvidence of sound knowledge and critical thinking. Demonstrates ability to extract data narratives into actionable recommendations.\t7<br \/>\nTotal\t\t100<\/p>\n<p>_____________________________________________________________________________<br \/>\nCASE 1: ORGANISING SEGEMENTS<br \/>\n_________________________________________________________________________________<\/p>\n<p>A Market Research Survey has been undertaken to identify consumers preferences with relation to;<br \/>\n&#8211;\tProduct: Interest in customized products<br \/>\n&#8211;\tCampaign: Sales campaign type<br \/>\n&#8211;\tPrice: Price consciousness<\/p>\n<p>Fifteen respondents completed the market research survey. The survey was arranged as indicated below:<\/p>\n<p>Assumptions<\/p>\n<p>&#8211;\tProduct: Interest in customized products was ranked from 1 = preference for timeless classics to 9 = preference for customised products.<br \/>\n&#8211;\tCampaign: Interest in sales campaign types was ranked from 1 = preference for traditional media to 9 = preference for social media<br \/>\n&#8211;\tPrice: Price consciousness was ranked from 1 = little interest in price consciousness to 9 = high interest in price consciousness.<\/p>\n<p>Through the Post-Hoc segmentation technique \u201cClustering\u201d make use of Ward\u2019s and K-Means analysis to find the best fit of consumers to market segments. Ensure you perform the repeated iteration required to bring the segments closer<\/p>\n<p>Your task:<\/p>\n<p>Using the above data, click on the worksheet tab \u2018Case 1\u2019 and complete the following calculations:<\/p>\n<p>Table: Calculate Min\/Max\/Avg<\/p>\n<p>1.\tCalculate the minimum value for the three variables<br \/>\n2.\tCalculate the maximum value for the three variables<br \/>\n3.\tCalculate the median value for the three variables<br \/>\n4.\tUse the minimum value for \u201cProduct\u201d to identify the start point for segment 1<br \/>\n5.\tUse the maximum value for \u201cProduct\u201d to identify the start point for segment 2<br \/>\n6.\tUse the median value for \u201cProduct\u201d to identify the start point for segment 3<\/p>\n<p>Table: Using \u201cSUMXMY2\u201d Function<\/p>\n<p>1.\tCalculate the sum of squares for each start point for each respondent using SUMXMY2.<br \/>\n2.\tCalculate the minimum value across all start points for each respondent<br \/>\n3.\tCompare the minimum value for each respondent to their start values and assign each participant to the appropriate segment<br \/>\n4.\tCalculate the sum of squared error<\/p>\n<p>Table: Means using \u201cIF\u201d Statements<\/p>\n<p>In this table you will see that the scores for each respondent have been copied across to the appropriate segments.<\/p>\n<p>1.\tCalculate the mean average for the significant variables across all segments.<\/p>\n<p>Table: Distance from revised mean<\/p>\n<p>1.\tCalculate the sum of squares for all segments for each respondent using SUMXMY2.<br \/>\n2.\tCalculate the minimum value for each respondent across the three segments.<br \/>\n3.\tCompare the minimum value for each respondent to their segment values and assign each participant to the appropriate segment \u2013 note if there have been any changes here<br \/>\n4.\tCalculate the sum of squared error \u2013 note the change to this from the original SSE result.<\/p>\n<p>Analysis of results:<\/p>\n<p>Write up a critical analysis of the results achieved through the marketing analytics calculations. Based upon the original market research variables state;<\/p>\n<p>&#8211;\t What three segments have been identified (*-  &#8211; Note these will link back to the consumer  assessment task profiles from assessment one).<br \/>\n&#8211;\tConsider what the variables suggest about each segment.<br \/>\n&#8211;\tState the significance of the reduced sum of squared error in calculating the distance for the revised mean values.<br \/>\n&#8211;\tState recommendations that could be made to Bluebird based upon your findings.<\/p>\n<p>_________________________________________________________________________________<br \/>\nCASE 2: ECOMMERCE SALES<br \/>\n_________________________________________________________________________________<\/p>\n<p>Based upon the three segments you identified in case 1, and with reference to the 3 digital marketing campaigns used by Bluebird (see table 1), you have been asked to predict sales information. Specifically, you have been asked to predict the following sales data for the 3 segments across the marketing campaigns;<\/p>\n<p>&#8211;\tThe number of orders,<br \/>\n&#8211;\tThe campaign responses<br \/>\n&#8211;\tThe budget and sales for the three segments.<\/p>\n<p>After analysing the company\u2019s historic sales performance over the last year, your team have assembled the data shown below:<\/p>\n<p>Table 1: Sales History Data<\/p>\n<p>Input: Sales\tAnnual Data (averaged)<br \/>\nSales Forecast:\t\u00a3140,000<br \/>\nAverage revenue\/order\t\u00a3250<br \/>\nSegment 1: % of sales \t50%<br \/>\nSegment 2: % of sales \t30%<br \/>\nSegment 3: % of sales \t20%<br \/>\n(Source: BlueBird.com &#8211;  Online Sales)<\/p>\n<p>After analysing the campaign sales performance, your team have assembled the data shown below:<\/p>\n<p>Table 2: Sales Campaign Effectiveness Data from Bluebird\u2019s Online Sales<\/p>\n<p>Input: Campaigns\tCampaign % of Sales\tConversion Rate\tCost Per Response (Lead)<br \/>\nCampaign A: Newsletter\t30%\t1%\t\u00a32.20<br \/>\nCampaign B: PPC\t30%\t2%\t\u00a31.00<br \/>\nCampaign C: Social Media\t40%\t2%\t\u00a31.40<br \/>\n(Source: BlueBird.com &#8211;  Online Sales)<\/p>\n<p>Your task<\/p>\n<p>Using the above data, click on the worksheet tab \u2018Case 2\u2019 and complete the following calculations:<\/p>\n<p>Input Table: Sales<\/p>\n<p>7.\tCalculate the Sales Forecast for the Fiscal Year<br \/>\n8.\tCalculate the Revenue\/Sale for the Fiscal Year<br \/>\n9.\tCalculate the percentage of sales for each segment for the Fiscal Year<\/p>\n<p>Input Table: Orders<\/p>\n<p>1.\tCalculate the total number of orders for the Fiscal Year<br \/>\n2.\tCalculate the number of orders for each segment<\/p>\n<p>Results Table: Segment 1<\/p>\n<p>1.\tCalculate the orders for segment 1 for each type of campaign.<br \/>\n2.\tCalculate the required responses for segment 1 for each type of campaign.<br \/>\n3.\tCalculate the budget required to reach segment 1 prospects for each type of campaign.<br \/>\n4.\tCalculate the expected sales for segment 1 for each type of campaign.<br \/>\n5.\tCalculate the sales campaign effectiveness (spend\/sales ratio) for segment 1 for each type of campaign.<br \/>\n6.\tCalculate the totals for orders, responses, budget, sales and sales effectiveness for segment 1<\/p>\n<p>Results Table: Segment 2<\/p>\n<p>1.\tCalculate the orders for segment 2 for each type of campaign.<br \/>\n2.\tCalculate the required responses for segment 2 for each type of campaign.<br \/>\n3.\tCalculate the budget required to reach segment 2 prospects for each type of campaign.<br \/>\n4.\tCalculate the expected sales for segment 2 for each type of campaign.<br \/>\n5.\tCalculate the sales campaign effectiveness (spend\/sales ratio) for segment 1 for each type of campaign.<br \/>\n6.\tCalculate the totals for orders, responses, budget, sales and sales effectiveness for segment 2<\/p>\n<p>Results Table: Segment 3<\/p>\n<p>1.\tCalculate the orders for segment 3 for each type of campaign.<br \/>\n2.\tCalculate the required responses for segment 3 for each type of campaign.<br \/>\n3.\tCalculate the budget required to reach segment 3 prospects for each type of campaign.<br \/>\n4.\tCalculate the expected sales for segment 3 for each type of campaign.<br \/>\n5.\tCalculate the sales campaign effectiveness (spend\/sales ratio) for segment 1 for each type of campaign.<br \/>\n6.\tCalculate the totals for orders, responses, budget, sales and sales effectiveness for segment 3<\/p>\n<p>Results Table: Total Segments, Total Fiscal Year<\/p>\n<p>Populate this table with the following data:<\/p>\n<p>1.\tTotal orders for each segment<br \/>\n2.\tTotal number of responses required for each segment<br \/>\n3.\tTotal budget required to reach prospects for each segment<br \/>\n4.\tTotal budget required to reach prospects across all three segments<br \/>\n5.\tTotal expected sales for each segment<br \/>\n6.\tTotal expected sales across all three segments<br \/>\n7.\tTotal sales effectiveness for each segment<br \/>\n8.\tTotal sales effectiveness across all three segments<\/p>\n<p>Analysis of results:<\/p>\n<p>Write up a critical analysis of the results achieved through the marketing analytics calculations. These should be discussed in relation to;<\/p>\n<p>&#8211;\tThe three segments.<br \/>\n&#8211;\tThe three marketing campaigns.<br \/>\n&#8211;\tA discussion of overall findings.<br \/>\n&#8211;\tState recommendations that could be made to Bluebird based upon your findings.<\/p>\n<p>*-  &#8211; Note: Remember that definitions of variables are included on lecture and seminar slides, you will be expected to use the appropriate terminology in discussing results.<\/p>\n<p>___________________________________________________________________________<br \/>\nCASE 3: PERFORMANCE METRICS<br \/>\n_________________________________________________________________________<\/p>\n<p>Bluebird is facing its largest competitor (The Boot N\u2019 Shoe Co) who manufacture and sell customised shoes into the same market. You have been tasked with assessing and monitoring the strategic metrics for both Bluebird Footwear and the Boot N\u2019 Shoe Co in order to understand Bluebird\u2019s competitive advantages and keep tabs on the Boot N\u2019 Shoe Co.<\/p>\n<p>Your team have assembled the data shown below:<\/p>\n<p>Table 3: Company Performance Data<\/p>\n<p>Data\tBlue Bird Footwear\tBoot N\u2019 Shoe Co<br \/>\nCustomer Costs (average)\t\u00a390,000\t\u00a390,000<br \/>\nCustomer Revenues (avg)\t\u00a3140,000\t\u00a3120,000<br \/>\nDiscount Rate\t 8.0%\t9.0%<br \/>\nDurability\t0.70\t0.50<br \/>\nEffective Market Share\t0.14\t0.12<br \/>\nMargin (per customer)\t\u00a3210\t\u00a3200<br \/>\nMarketing Spending\t\u00a315,000\t\u00a311,000<br \/>\nRelative Price\t1.10\t0.90<br \/>\nRetention Rate (Customers)\t0.7\t0.4<br \/>\nRevenue from Marketing\t\u00a3140,000\t\u00a3150,000<br \/>\nRevenue, Year 1\t\u00a390,000\t\u00a3100,000<br \/>\nRevenue, Year 2\t\u00a3120,000\t\u00a3110,000<br \/>\nRevenue, Year 3\t\u00a3140,000\t\u00a3115,000<br \/>\nSelling Price per Unit\t\u00a3250\t\u00a3300<br \/>\nVariable Cost per Unit\t\u00a340\t\u00a330<br \/>\n(Source: BlueBird.com and BootNshoe.com)<\/p>\n<p>In assessing the above, you will draw upon the following metrics;<br \/>\n&#8211;\tMarket Approach Performance Metrics<br \/>\n&#8211;\tMarket Growth Performance Metrics<br \/>\n&#8211;\tBrand Development Metrics<br \/>\n&#8211;\tCustomer Development Metrics<\/p>\n<p>Your task<\/p>\n<p>Using the above data, click on the worksheet tab \u2018Case 3\u2019 and complete the following calculations:<\/p>\n<p>Table: Performance Metrics \/ Bluebird Footwear<\/p>\n<p>1.\tCalculate the Brand Equity Index for Bluebird<br \/>\n2.\tCalculate the Contribution Margin for Bluebird<br \/>\n3.\tCalculate the Customer Lifetime Value for Bluebird<br \/>\n4.\tCalculate the Profit for Bluebird<br \/>\n5.\tCalculate the Revenue (Compound Annual Growth Rate) for years 1 \u2013 3 for Bluebird<br \/>\n6.\tCalculate the Revenue (Year on Year Growth) for years 1 -2 for Bluebird<br \/>\n7.\tCalculate the Return on Marketing Investment Bluebird<\/p>\n<p>Table: Performance Metrics \/ Boot N\u2019 Shoe Co<\/p>\n<p>1.\tCalculate the Brand Equity Index for Boot N\u2019 Shoe<br \/>\n2.\tCalculate the Contribution Margin for Boot N\u2019 Shoe<br \/>\n3.\tCalculate the Customer Lifetime Value for Boot N\u2019 Shoe<br \/>\n4.\tCalculate the Profit for Boot N\u2019 Shoe<br \/>\n5.\tCalculate the Revenue (Compound Annual Growth Rate) for years 1 \u2013 3 for Boot N\u2019 Shoe<br \/>\n6.\tCalculate the Revenue (Year on Year Growth) for years 1 -2 for Boot N\u2019 Shoe<br \/>\n7.\tCalculate the Return on Marketing Investment Boot N\u2019 Shoe<\/p>\n<p>Analysis of results:<\/p>\n<p>Write up a critical analysis of the results achieved through the marketing analytics calculations. These should be discussed in relation to;<\/p>\n<p>&#8211;\tA comparison of the strategic metrics for Bluebird Footwear and the Boot N\u2019 Shoe Co<br \/>\n&#8211;\tThe performance of both Bluebird Footwear and the Boot N\u2019 Shoe Co<br \/>\n&#8211;\tCompetitive advantages of Bluebird based upon the metrics<br \/>\n&#8211;\tState recommendations that could be made to Bluebird based upon your findings.<\/p>\n<p>*-  &#8211; Note: Remember that definitions of metrics are included on lecture and seminar slides, you will be expected to use the appropriate terminology in discussing results.<\/p>\n<p>___________________________________________________________________________<br \/>\nCASE 4: PRICING<br \/>\n_________________________________________________________________________________<\/p>\n<p>The company CEO has asked you to check the launch plan for Bluebird\u2019s new customisable product line. Having originally set the product price to \u00a3250, the CEO has concerns that this price might be too high for most consumers within the target segments. You have been asked to select an appropriate price for the product.<\/p>\n<p>You have been provided with the following data:<\/p>\n<p>Table 4 \u2013 Launch Data<\/p>\n<p>Attribute\tData<br \/>\nInvestment\t\u00a330,000<br \/>\nFixed Cost\t\u00a330,000<br \/>\nVariable Cost\t\u00a340<br \/>\nUnit Sales (year)\t5,000<br \/>\n% Markup\t70%<br \/>\nTarget ROI\t50%<\/p>\n<p>Based upon the data shown in table 4 you have been asked to calculate a target price using Markup\/Cost Pricing and Target Return Pricing.<\/p>\n<p>Your task<\/p>\n<p>Using the above data, click on the worksheet tab \u2018Case 4\u2019 and complete the following calculations:<\/p>\n<p>Table: Markup\/Cost-Plus Pricing Calculations<\/p>\n<p>1.\tCalculate the unit cost<br \/>\n2.\tCalculate the mark-up price<\/p>\n<p>Table: Target Return Pricing Calculations<\/p>\n<p>1.\tCalculate the unit cost<br \/>\n2.\tCalculate the target return price<\/p>\n<p>Analysis of results:<\/p>\n<p>Write up a critical analysis of the results achieved through the marketing analytics calculations. These should be discussed in relation to;<\/p>\n<p>&#8211;\tA comparison of the markup\/cost pricing and target return pricing findings<br \/>\n&#8211;\tA consideration of the advantages and disadvantages of Markup\/Cost-Plus Pricing<br \/>\n&#8211;\tA consideration of the advantages and disadvantages of Target Return Pricing<br \/>\n&#8211;\tState recommendations that could be made to Bluebird based upon your findings.<\/p>\n<p>*-  &#8211; Note: Remember that definitions are included on lecture and seminar slides, you will be expected to use the appropriate terminology in discussing results. You must draw upon reference sources in discussing the advantages and disadvantages of pricing methods.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MKT 602: Advanced Marketing Strategy &amp; Digital Analytics Assessment: Assessment Two: Analytics Project. 50% TMM (individual) Report Word Count: 2,000 words (maximum) Excel File: The\u2026<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2599,1367,299,635],"tags":[1398,3919,3772],"class_list":["post-8652","post","type-post","status-publish","format-standard","hentry","category-help-writing-my-marketing-dissertation","category-homework-essay-market","category-marketing-assignment-help","category-marketing-research-paper-topics","tag-do-my-assignment","tag-mkt-602-advanced-marketing-strategy-digital-analytics-assessment","tag-write-my-homework"],"_links":{"self":[{"href":"https:\/\/www.colapapers.com\/uk\/wp-json\/wp\/v2\/posts\/8652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.colapapers.com\/uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.colapapers.com\/uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.colapapers.com\/uk\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.colapapers.com\/uk\/wp-json\/wp\/v2\/comments?post=8652"}],"version-history":[{"count":1,"href":"https:\/\/www.colapapers.com\/uk\/wp-json\/wp\/v2\/posts\/8652\/revisions"}],"predecessor-version":[{"id":8669,"href":"https:\/\/www.colapapers.com\/uk\/wp-json\/wp\/v2\/posts\/8652\/revisions\/8669"}],"wp:attachment":[{"href":"https:\/\/www.colapapers.com\/uk\/wp-json\/wp\/v2\/media?parent=8652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.colapapers.com\/uk\/wp-json\/wp\/v2\/categories?post=8652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.colapapers.com\/uk\/wp-json\/wp\/v2\/tags?post=8652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}