Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Assignment Brief As part of the formal assessment for the programme you are required to submit a Using Information assessment. Please refer to your Student Handbook for full details of the programme...

1 answer below »
Assignment Brief As part of the formal assessment for the programme you are required to submit a Using Information assessment. Please refer to your Student Handbook for full details of the programme assessment scheme and general information on preparing and submitting assignments. Learning Outcomes: 1) Investigate data types and discuss their worth to an organisation 2) Understand the principles behind the construction of published financial statements. 3) Gain an appreciation of how data analytics can inform decision making within an organisation. 4) Use published data to inform a marketing decision 5) Calculate and comment on standard deviation 6) Explain how organisations can use data to improve quality. Maximum word count for the module: 1,000 words Please note that exceeding the word count by over 10% will result in a reduction in grade by the same percentage that the word count is exceeded. You must not include your name in your submission because Arden University operates anonymous marking, which means that markers should not be aware of the identity of the student. However, please do not forget to include your STU number. Page 3 of 6 BL0518 Assignment Task – Assessment Part 2 This assessment covers Learning Outcomes 3 and 4 and is worth 30% of the total marks for the module. This report refers to the dataset provided in the Using Information.xlsx spreadsheet. The file contains the monthly sales made by Arden Sunglasses Ltd. The company has 20 stalls in shopping centres across the UK with 100 sales staff. The file also contains the estimated monthly demand for sunglasses across all of the shopping centres giving a limit of possible sales and market share. Your task is to generate a report for the February 2018 meeting between the business analyst, chief financial officer and head of sales. In particular the following pieces of information are required: 1) Plot the monthly demand and sales figures with a description of the general trends in the data. (10 Marks) 2) Calculate the average monthly market share. (10 Marks) 3) The business analyst claims that currently promotions are started two months late. Show that the average market share would increase if the sales from each month happened two months earlier (i.e. March sales aligned to January demand, April sales aligned to February demand etc.) (15 marks) 4) The head of sales has proposed the following five new strategies with costs and expected sales increases. Evaluate the potential market shares if each of the new strategies were implemented. (15 marks) Marketing Scheme Cost Increased Sales % Customer Competition £10,000 8% Customer Promotions £20,000 10% 2 New Branches £100,000 35% Merge with Competitors £200,000 90% 10 New Branches £400,000 300% Page 4 of 6 5) Explain why the final strategy, building 10 new branches, will not result in the proposed sales increases. (10 marks) 6) Evaluate which quarter (Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec) is the most profitable where the quarterly profit margins are 50%, 30%, 25% and 40%. (20 marks) 7) The HR and sales departments have proposed to offer a bonus of £4,000 to each of the sales staff if profits increase by 8%. Check if this will result in higher profits in each quarter or if this should only be offered in a single quarter. (20 marks) Please note that exceeding the word count by over 10% will result in a reduction in grade by the same percentage that the word count is exceeded. Page 5 of 6 Student Guidelines Development of academic skills: You MUST underpin your analysis and evaluation of the key issues with appropriate and wide ranging academic research and ensure this is referenced using the AU Harvard system. The My Study Skills Area contains the following useful resources: Guide to Harvard Referencing http://moodle.bl.rdi.co.uk/guides/HarvardRef/AU_Harvard_Quick_Ref_Guide.pdf Guide to Harvard Citation http://moodle.bl.rdi.co.uk/guides/HarvardRef/AU_Guide_to_Harvard_Citation.pdf You must use the AU Harvard Referencing method in your assignment. Word Count: Students are required to indicate the exact word count on the title page of the assessment. The word count excludes the title page, executive summary, reference list and appendices. Where assessment questions have been reprinted from the assessment brief these will also be excluded from the word count. ALL other printed words ARE included in the word count. Printed words include those contained within charts and tables. See ‘Word Count Policy’ on the homepage of this module for more information. Submission Guidance: Assignments submitted late will not be accepted and will be marked as a 0% fail. Your assessment should be submitted as a single Word (MS Word) or PDF file. For more information please see the “Guide to Submitting an Assignment” document available on the module page on iLearn. You must ensure that the submitted assignment is all your own work and that all sources used are correctly attributed. Penalties apply to assignments which show evidence of academic unfair practice. (See the Student Handbook which is on the homepage of your module and also in the Induction Area). Page 6 of 6 Assessment Criteria (Learning objectives covered - all) Level 0 prepares students to function effectively at Level 4. Criteria for assessment at Level 0 reflect the preparatory nature of these modules. Students are expected to demonstrate the acquisition of generic learning skills appropriate for self-managed learning in an HE context. Students are expected to demonstrate that they have acquired the underpinning discipline-specific skills, knowledge and understanding necessary to undertake a programme of higher education Grade Mark Bands Generic Assessment Criteria First (1) 80%+ Outstanding performance which demonstrates an outstanding knowledge base, supported with wider reading and the ability to begin to analyse the subject area. The work draws widely on relevant theory and shows awareness of any relevant ethical considerations. The work shows an excellent level of competence and confidence in managing appropriate sources and materials, initiative and excellent academic writing skills and professional skills (where appropriate). The work is accurately and consistently referenced throughout. 70-79% Excellent performance which demonstrates an excellent knowledge base the ability to begin to analyse the subject. The work draws on relevant theory whilst showing some awareness of any relevant ethical considerations. The work shows a high level of competence in managing sources and materials, initiative and very good academic writing skills and professional skills (where appropriate). The work is consistently referenced throughout. Upper second (2: XXXXXXXXXX% Very good performance which demonstrates a sound understanding of the content and some ability to analyse the issues with reference to theory. The work shows a good level of competence in managing sources and materials and some initiative. Academic writing skills are good and expression remains accurate overall. Good professional skills (where appropriate). The work is referenced throughout. Lower second (2: XXXXXXXXXX% A satisfactory to good performance which shows a decent understanding of the content and makes some reference to theory. The work shows a sound level of competence in managing basic sources and materials. Academic writing skills are satisfactory and expression remains accurate overall although the piece may lack structure. Satisfactory professional skills (where appropriate). There is some attempt to reference the work. Third XXXXXXXXXX% A basic level of understanding in which there are some gaps in knowledge of the subject, its underpinning theory and ethical considerations. The work shows a basic use of sources and materials. Academic writing skills are limited and there are some errors in expression and the work may lack structure overall. There are some difficulties in developing professional skills (where appropriate). Marginal Fail 30-39% A limited level of knowledge in which there are clear omissions in understanding the subject, its underpinning theory and ethical considerations. The work shows a limited use of sources and materials. Academic writing skills are weak and there are errors in expression and the work may lack structure overall. There are difficulties in developing professional skills (where appropriate). 29% and below A poor performance in which there are substantial gaps in knowledge and understanding. The work shows little evidence in the use of appropriate sources and materials. Academic writing skills are very weak and there are numerous errors in expression. The work lack
Answered Same Day May 07, 2020

Solution

Pooja answered on May 10 2020
132 Votes
Analysis
1)
There are seasonal variations observed in the demand and sales in the past 17 years. The demand increases in the month of May-June and sales is observed to increase in the month of August-October every year.  The demand is at its low around the month of January every year. The sale is observed to be lowest in the month of March for the past 17 years
2)
     
     average
     market share
    0.48163905
The average monthly market share is calculated to be £0.48163905
3)
For co
ecting the data regarding cu
ently promotions started two months late, lag(2) is taken. The data is given below.
    Date
     lag_market_share_(2)
    
     Date
     lag_market_share_(2)
    
     Date
     lag_market_share_(2)
    
     Date
     lag_market_share_(2)
    Mar-01
    0.5124
    
    Apr-05
    0.3181
    
    Jun-09
    0.2221
    
    Aug-13
    0.3359
    Apr-01
    0.3148
    
    May-05
    0.2679
    
    Jul-09
    0.3121
    
    Sep-13
    0.4711
    May-01
    0.1848
    
    Jun-05
    0.2183
    
    Aug-09
    0.3781
    
    Oct-13
    0.5454
    Jun-01
    0.1672
    
    Jul-05
    0.2735
    
    Sep-09
    0.4337
    
    Nov-13
    0.6550
    Jul-01
    0.2254
    
    Aug-05
    0.3569
    
    Oct-09
    0.5972
    
    Dec-13
    0.7936
    Aug-01
    0.3094
    
    Sep-05
    0.3948
    
    Nov-09
    0.6513
    
    Jan-14
    0.7652
    Sep-01
    0.4703
    
    Oct-05
    0.5850
    
    Dec-09
    0.7405
    
    Feb-14
    0.6523
    Oct-01
    0.5599
    
    Nov-05
    0.6560
    
    Jan-10
    0.7748
    
    Mar-14
    0.4504
    Nov-01
    0.7076
    
    Dec-05
    0.7027
    
    Feb-10
    0.6719
    
    Apr-14
    0.3692
    Dec-01
    0.7875
    
    Jan-06
    0.9049
    
    Mar-10
    0.4863
    
    May-14
    0.2918
    Jan-02
    0.8290
    
    Feb-06
    0.6322
    
    Apr-10
    0.3756
    
    Jun-14
    0.2743
    Feb-02
    0.6969
    
    Mar-06
    0.4571
    
    May-10
    0.2575
    
    Jul-14
    0.3041
    Mar-02
    0.4260
    
    Apr-06
    0.3871
    
    Jun-10
    0.2459
    
    Aug-14
    0.3889
    Apr-02
    0.2853
    
    May-06
    0.2301
    
    Jul-10
    0.2412
    
    Sep-14
    0.4517
    May-02
    0.2862
    
    Jun-06
    0.2464
    
    Aug-10
    0.3087
    
    Oct-14
    0.5425
    Jun-02
    0.2333
    
    Jul-06
    0.2320
    
    Sep-10
    0.4327
    
    Nov-14
    0.6885
    Jul-02
    0.2579
    
    Aug-06
    0.3538
    
    Oct-10
    0.5220
    
    Dec-14
    0.8123
    Aug-02
    0.3069
    
    Sep-06
    0.4889
    
    Nov-10
    0.6884
    
    Jan-15
    0.7177
    Sep-02
    0.4376
    
    Oct-06
    0.5449
    
    Dec-10
    0.7393
    
    Feb-15
    0.7445
    Oct-02
    0.5174
    
    Nov-06
    0.6164
    
    Jan-11
    0.7432
    
    Mar-15
    0.4935
    Nov-02
    0.6477
    
    Dec-06
    0.8082
    
    Feb-11
    0.6109
    
    Apr-15
    0.3008
    Dec-02
    0.8507
    
    Jan-07
    0.8088
    
    Mar-11
    0.4239
    
    May-15
    0.2276
    Jan-03
    0.7418
    
    Feb-07
    0.5807
    
    Apr-11
    0.3586
    
    Jun-15
    0.2921
    Feb-03
    0.6313
    
    Mar-07
    0.4532
    
    May-11
    0.2339
    
    Jul-15
    0.2820
    Mar-03
    0.5050
    
    Apr-07
    0.3028
    
    Jun-11
    0.2703
    
    Aug-15
    0.3518
    Apr-03
    0.3278
    
    May-07
    0.2034
    
    Jul-11
    0.3185
    
    Sep-15
    0.4759
    May-03
    0.2405
    
    Jun-07
    0.2686
    
    Aug-11
    0.3137
    
    Oct-15
    0.5181
    Jun-03
    0.2434
    
    Jul-07
    0.3024
    
    Sep-11
    0.4397
    
    Nov-15
    0.5835
    Jul-03
    0.2824
    
    Aug-07
    0.3473
    
    Oct-11
    0.5156
    
    Dec-15
    0.6538
    Aug-03
    0.2922
    
    Sep-07
    0.4865
    
    Nov-11
    0.6207
    
    Jan-16
    0.7569
    Sep-03
    0.4310
    
    Oct-07
    0.6115
    
    Dec-11
    0.6826
    
    Feb-16
    0.6183
    Oct-03
    0.5197
    
    Nov-07
    0.6808
    
    Jan-12
    0.7258
    
    Mar-16
    0.4228
    Nov-03
    0.7373
    
    Dec-07
    0.8771
    
    Feb-12
    0.6914
    
    Apr-16
    0.3685
    Dec-03
    0.7665
    
    Jan-08
    0.7543
    
    Mar-12
    0.4331
    
    May-16
    0.2811
    Jan-04
    0.8874
    
    Feb-08
    0.6395
    
    Apr-12
    0.3883
    
    Jun-16
    0.2713
    Feb-04
    0.6821
    
    Mar-08
    0.4176
    
    May-12
    0.2649
    
    Jul-16
    0.2829
    Mar-04
    0.5837
    
    Apr-08
    0.2775
    
    Jun-12
    0.2041
    
    Aug-16
    0.3279
    Apr-04
    0.2374
    
    May-08
    0.2339
    
    Jul-12
    0.2594
    
    Sep-16
    0.4224
    May-04
    0.2015
    
    Jun-08
    0.2412
    
    Aug-12
    0.3504
    
    Oct-16
    0.5720
    Jun-04
    0.1840
    
    Jul-08
    0.2725
    
    Sep-12
    0.4017
    
    Nov-16
    0.6090
    Jul-04
    0.2713
    
    Aug-08
    0.3635
    
    Oct-12
    0.5639
    
    Dec-16
    0.7548
    Aug-04
    0.3510
    
    Sep-08
    0.4671
    
    Nov-12
    0.6442
    
    Jan-17
    0.8041
    Sep-04
    0.4457
    
    Oct-08
    0.5284
    
    Dec-12
    0.6839
    
    Feb-17
    0.7292
    Oct-04
    0.6037
    
    Nov-08
    0.6500
    
    Jan-13
    0.7583
    
    Mar-17
    0.4714
    Nov-04
    0.6138
    
    Dec-08
    0.8087
    
    Feb-13
    0.6289
    
    Apr-17
    0.3640
    Dec-04
    0.8053
    
    Jan-09
    0.8310
    
    Mar-13
    0.5186
    
    May-17
    0.3069
    Jan-05
    0.8157
    
    Feb-09
    0.7185
    
    Apr-13
    0.3302
    
    Jun-17
    0.2895
    Feb-05
    0.6428
    
    Mar-09
    0.4470
    
    May-13
    0.2612
    
    Jul-17
    0.3089
    Mar-05
    0.5469
    
    Apr-09
    0.3324
    
    Jun-13
    0.2244
    
    Aug-17
    0.3816
    
    
    
    May-09
    0.2949
    
    Jul-13
    0.3056
    
    Sep-17
    0.4498
    
    
    
    
    
    
    
    
    
    Oct-17
    0.5583
    
    
    
    
    
    
    
    
    
    Nov-17
    0.6606
    
    
    
    
    
    
    
    
    
    Dec-17
    0.7895
    
    
    
    
    
    
    
    
    
    Jan-18
    0.6662
Null hypothesis, Ho: the average market share would be equal to 0.48 if the sales from each month happened two months earlier. u = 0.48
Alternative Hypothesis, H1: the average market share would increase if the sales from each month happened two months earlier. u > 0.48
    Null Hypothesis =
    0.48
    Level of Significance
    0.05
    Population Standard Deviation
    0.195072288
    Sample Size
    203
    Sample Mean
    0.480947108
    Standard E
or of the Mean
    0.0137
    Z Test Statistic
    0.0692
    Upper Critical...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here