Business Decision Making (Unit 6)

ASSESSMENT FRONT SHEET AB101B6


Programme: BTEC Higher National Diploma in Business (Marketing)

Unit Title and Number: Business Decision Making (Unit 6)

QFC Level and Credit value: 5; 15 credits

Module Tutor:

Email:

Date Set:

12



Learner’s name and statement of authenticity
Learner’s Name: ______________________________ Learner’s ID: ______ Date Handed-in: __/__/____

I certify that the work submitted for this assignment is my own. Where the work of others has been used to support my work then credit has been acknowledged.

Signature: ___________________ Date: ___/___/_____

LEARNER’S BRIEF














































































Programme: BTEC Higher National Diploma in Business (Marketing)

Unit Title and Number: Business Decision Making (Unit 6)

QFC Level and Credit value: 5; 15 credits

Module Tutor: Chris Adjei

Email: c.adjei@mrcollege.ac.uk

Date Set:

Key Dates










Distribution Date : 02/10/13

Task 1 Submission Date : 16/10/13 (for formative feedback)

Task 2 Submission Date : 30/10/13 (for formative feedback)

Task 3 Submission Date : 13/11/13 (for formative feedback)

Task 4 Submission Date : 27/11/13 (for formative feedback)



Final Submission Date (Full Assignment):16/12/13



Introduction










In business, good decision making requires the effective use of information. This unit gives learners the opportunity to examine a variety of sources and develop techniques in relation to four aspects of information: data gathering, data storage, and the tools available to create and present useful information.



ICT is used in business to carry out much of this work and an appreciation and use of appropriate

ICT software is central to completion of this unit. Specifically, learners will use spreadsheets and other software for data analysis and the preparation of information. The use of spreadsheets to manipulate numbers, and understanding how to apply the results, are seen as more important than the mathematical derivation of formulae used.



Learners will gain an appreciation of information systems currently used at all levels in an organisation as aids to decision making.



The aim of this assignment is to assess the learner’s knowledge of the all aspects of the unit

Task 1 covers AC1.1, AC1.2 and AC1.3

Task 2 covers AC2.1, AC2.2, AC2.3, AC2.4 and AC4.1

Task 3 covers AC3.1, AC3.2, AC3.3, AC3.4 and AC4.1

Task 4 covers AC4.2 and AC4.3.



GRADING DETAILS






Student need to achieve all the assessment criteria for a ‘Pass’



All Assessment Criteria = Pass

All Assessment Criteria + All Merit descriptors = Merit

All Assessment Criteria + All Merit descriptors + All Distinction descriptors = Distinction



Merit descriptors



M1: Identify and apply strategies to find appropriate solutions.

M2: Select/design and apply appropriate methods/techniques.

M3: Present and communicate appropriate findings.



Distinction descriptors



D1: Use critical reflection to evaluate own work and justify valid conclusions.

D2: Take responsibility for managing and organising activities.

D3: Demonstrate convergent/lateral/creative thinking.





Any assessment criteria that do not meet the minimum requirement for pass will be re-submitted.



P1 P2 P3 P4 P5 P6 P7 P8 P9 P10
AC1.1 AC1.2 AC1.3 AC2.1 AC2.2 AC2.3 AC2.4 AC3.1 AC3.2 AC3.3


P11 P12 P13 P14
AC3.4 AC4.1 AC4.2 AC4.3




















Grade Descriptors Indicative Characteristics Contextualised Grade Guidance
MERIT
M1
Identify and

apply strategies

to find appropriate

solutions.

effective judgements have been made
complex problems with more than one variable have been explored
an effective approach to study and research has been applied
The data collection plan (task 1, question 1) should follow a series of logical steps for the research questions on Sainsbury
M2
Select / design and

apply appropriate

methods/techniques

relevant theories and techniques have been applied
a range of methods and techniques have been applied
a range of sources of information has been used
the selection of methods and techniques/sources has been justified
the design of methods/techniques has been justified
complex information/data has been synthesised and processed
appropriate learning methods/techniques have been applied

The learner must demonstrate usage of a range of sources of information throughout the completion of the assignment by using of appropriate referencing (All tasks)

M3
Present and

communicate

appropriate findings.



the appropriate structure and approach has been used
coherent, logical development of principles/concepts for the intended audience
a range of methods of presentation have been used and technical language has been accurately used
communication has taken place in familiar and unfamiliar contexts
The communication is appropriate for familiar and unfamiliar audiences and appropriate media have been used.

Two methods of presentation of research findings are required for this assignment (Task 3).

Results should be presented using the appropriate structure/format; i.e. the layout of the PowerPoint presentation question 3 (task 3) and the production of a formal report in question 4 (task 3).



Grade Descriptors Indicative Characteristics Contextualised Grade Guidance
DISTINCTION
D1
Use critical

reflection to

evaluate own

work and justify

valid

conclusions

conclusions have been arrived at through synthesis of ideas and have been justified
the validity of results has been evaluated using defined criteria
self-criticism of approach has taken place
realistic improvements have been proposed against defined characteristics for success

The learner should identify the limitations of the research approaches use for scenario on Sainsbury’s. For limitations of the sampling method used (task 1), limitations in forecasting future performance using trend lines (task 3)

D2
Take

Responsibility

for managing

and organising

activities

autonomy/independence has been demonstrated
substantial activities, projects or investigations have been planned, managed and organised
activities have been managed
the unforeseen has been accommodated
the importance of interdependence has been recognised and achieved

Autonomy and independence must be demonstrated throughout the completion of all tasks. This will be evidenced by the level of formative feedback provided by the tutor.

Exceptional circumstances (e.g. learning difficulties such as dyslexia) will be taken into consideration

D3
Demonstrate

convergent /

lateral / creative

thinking

ideas have been generated and decisions taken
self-evaluation has taken place
convergent and lateral thinking have been applied
problems have been solved
innovation and creative thought have been applied
receptiveness to new ideas is evident
effective thinking has taken place in unfamiliar contexts

The learner should demonstrate effective thinking in solving the problem on critical path analysis (task 4, part A)











ASSESSMENT TASKS
Learners are encouraged to be familiar with the assessment criteria and contextualised grade descriptors before completing these tasks.





















Scenario (Tasks 1, 2 and 3)



Sainsbury’s was founded in 1869 by John James Sainsbury and his wife Mary Ann Sainsbury in London and has grown to become one of the UK’s largest retailers. J Sainsbury plc operates over 1,000 stores, including 440 convenience stores. It jointly owns Sainsbury’s Bank with Lloyds Banking Group and has two property joint ventures with Land Securities Group PLC and The British Land Company PLC.



Two statements on the company’s website read:



“Our five areas of focus are underpinned by our strong values and culture, as well as our commitment to operational excellence. We put the customer at the heart of everything we do, aiming to make their lives easier every day by offering great quality and service at fair prices”.


“We have delivered another strong set of results [in 2011]. Good sales growth combined with cost efficiency savings offsetting inflationary increases, helped deliver growth in both operating margin and return on capital”


As a business analyst, you want to investigate the reliability of the two statements above. For this, you develop the following research questions: What is the level of satisfaction amongst Sainsbury’s customers? What has been the relationship between operating profit and sales for Sainsbury over the last 24 years?



Task 1 [By 016/10/13 for formative feedback]
P1 create a plan for the collection of primary and secondary data for a given business problem

P2 present the survey methodology and sampling frame used

P3 design a questionnaire for a given business problem

















You are required to

Create a plan for the collection of data for your research on Sainsbury and present the survey methodology and sampling frame used. (P1, P2)
Design a questionnaire that will be administered to Sainsbury’s customers to assess their level of satisfaction. Address any data protection issues and ethical considerations for your research. (P3)


Task 2 [By 30/10/13 for formative feedback]
P4 create information for decision making by summarising data using representative values

P5 analyse the results to draw valid conclusions in a business context

P6 analyse data using measures of dispersion to inform a given business scenario

P7 explain how quartiles, percentiles and the correlation coefficient are used to draw useful conclusions in a business context

P12 use appropriate information processing tools























You have now successfully collected figures for the annual sales and operating profits of Sainsbury’s for the financial years ended 1998 to 2012. (Data available in appendix 1)



You are required to

Summarize the data using five representative values and measures of dispersion. Analyse the results to draw valid conclusions. (P4, P5, P6, P12)


Identify the 25th, 50th, 75th percentiles of the
Sales variables. Explain their use,
Operating Profit variables. Explain their use (P7, P12)


Estimate the correlation coefficient between sales and operating profit for Sainsbury’s. Comment on the possible relationship between these variables
(P7, P12)















































Task 3 [By 13/11/13 for formative feedback]
P8 produce graphs using spreadsheets and draw valid conclusions based on the information derived

P9 create trend lines in spreadsheet graphs to assist in forecasting for specified business information

P10 prepare a business presentation using suitable software and techniques to disseminate information effectively

P11 produce a formal business report

P12 use appropriate information processing tools

















In order to complete your research on Sainsbury, you decide to include statistical graphs and an estimation of next year’s operating profit and sales figures; after which you will produce a formal business report for the attention of Sainsbury’s management. You are also concerned that the management may want you to give a business research presentation instead of a formal report.

You are required to

Produce 3 types of statistical graph (including XY scatterplots and histograms*) using spreadsheets and draw valid conclusions based on the information derived (P8, P12)
Create trend lines for the sales and operating profit variables and estimate sales and operating profits figures for Sainsbury’s for the year ended 2013. Comment on the reliability factor of your forecasts (the R-squared) (P9, P12)
Prepare a business presentation for the attention of Sainsbury’s management on your findings (P10)
Produce a formal business report for the attention of Sainsbury’s management on your findings (P11)
*To create the histograms you may choose the following intervals

Sainsbury’s
Sales


Operating profit
15000 less than 17000 0 less than 200
17000 less than 19000 200 less than 400
19000 less than 21000 400 less than 600
21000 less than 23000 600 less than 800
23000 less than 25000 800 less than 1000


Task 4 [By 27/11/13 for formative feedback]
P12 use appropriate information processing tools

P13 prepare a project plan for an activity and determine the critical path

P14 use financial tools for decision making













PART A (P13)

CAMIC Associates Ltd is embacking on a project to develop a new product and has estimated the following activities and duration:



Activity Description Required Predecessor Duration

A Product design (None) 5 months

B Market research (None) 1

C Production analysis A 2

D Product model A 3

E Sales brochure A 2

F Cost analysis C 3

G Product testing D 4

H Sales training B, E 2

I Pricing H 1

J Project report F, G, I 1



Required:

Construct an activity network for this problem and determine the critical path in your network for this project



























PART B (P14, P12)



The following data relate to two investment projects, only one of which may be selected:



Project A Project B £ £ £

Initial Investment 50000 50000

Cash inflows year 1 35000 20000

2 30000 20000

3 25000 24000

4 20000 36000



At the end of year 4, project A and B will each have a resale value of £10,000.



You are required to:



Calculate the net present value of each project using Microsoft Excel if


the company’s cost of capital is 10%
the company’s cost of capital is 60%


Estimate the internal rate of return for each project by linear interpolation
Calculate the internal rate of return using Microsoft Excel
Write a brief memorandum report to the company, with recommendations on which project should be accepted if


the cost of capital is 10%
the cost of capital is 60%










































Appendix 1

Sainsbury’s Financial Performance Summary

Year Sales Revenue
(including VAT) £

Profit before tax £
2012 24511 712
2011 22,943 665
2010 21,421 610
2009 20,383 519
2008 19,287 434
2007 18518 477
2006 17317 104
2005 16364 15
2004 15517 610
2003 15147 667
2002 18198 571
2001 16940 437
2000 17414 580
1999 16378 755
1998 15496 854


































































Extension and Late Submission












If an extension is necessary for a valid reason, requests can me made using a course work extension request form available from the college. Please note that the lecturers do not have the authority to extend the coursework deadlines and therefore do not ask them to award a coursework extension.



The completed form must be accompanied by evidence such as a medical certificate in the event of you being sick.









Plagiarism and Collusion








Any act of plagiarism and collusion will be seriously dealt with according to the regulations. In this context the definition and scope of plagiarism are presented below:



‘Plagiarism occurs when a student misrepresents, as his/her own work, the work, written or otherwise, of any other person (including another student) or of any institution. Examples of forms of plagiarism include[1]:

the verbatim (word for word) copying of another’s work without appropriate and correctly presented acknowledgement;
the close paraphrasing of another’s work by simply changing a few words or altering the order of presentation, without appropriate and correctly presented acknowledgement;
unacknowledged quotation of phrases from another’s work;
The deliberate and detailed presentation of another’s concept as one’s own.’
All types of work submitted by students are covered by this definition, including, written work, diagrams, designs, engineering drawings and pictures.



‘Collusion occurs when, unless with official approval (e.g. in the case of group projects), two or more students consciously collaborate in the preparation and production of work which is ultimately submitted by each in an identical, or substantially similar, form and/or is represented by each to be the product of his or her individual efforts. Collusion also occurs where there is unauthorised co-operation between a student and another person in the preparation and production of work which is presented as the student’s own. (ibid)’























Support Material










Textbooks



Newbold P et al – Statistics for Business and Economics (Pearson Education, 2009) ISBN: 9780135072486



Day A – Mastering Financial Mathematics with Excel: A Practical Guide for Business Calculations (Financial Times/Prentice Hall, 2005) ISBN: 9780273688662



Beynon-Davies P – Business Information Systems (Palgrave Macmillan, 2009) ISBN: 9780230203686





Website:



www.bized.co.uk

Bized provides a selection of teaching and learning resources



http://www.revisionworld.co.uk/

Free GCSE, AS, A2 (A-Level) revision resources



www.ons.gov.uk

Office for National Statistics



www.statistics.gov.uk

UK National Statistics





ASSESSMENT DECISION








Programme: BTEC Higher National Diploma (HND) in Business

Unit Title and Number: Business Decision Making (Unit 6)

Module Tutor:



Learner’s Name :____________________ Learner ID:___________________



Assessment Criteria Met Evidence
Feedback

P1 create a plan for the collection of primary and secondary data for a given business problem
P2 present the survey methodology and sampling frame used
P3 design a questionnaire for a given business problem
P4 create information for decision making by summarising data using representative values
P5 analyse the results to draw valid conclusions in a business context
P6 analyse data using measures of dispersion to inform a given business scenario
P7 explain how quartiles, percentiles and the correlation coefficient are used to draw useful conclusions in a business context
P8 produce graphs using spreadsheets and draw valid conclusions based on the information derived
P9 create trend lines in spreadsheet graphs to assist in forecasting for specified business information
P10 prepare a business presentation using suitable software and techniques to disseminate information effectively
P11 produce a formal business report
P12 use appropriate information processing tools
P13 prepare a project plan for an activity and determine the critical path
P14 use financial tools for decision making




Grading Criteria (Merit -M; Distinction -D) Met Evidence Feedback

M1



Identify and apply strategies to find appropriate solutions
M2


Select/design and apply appropriate methods/techniques
M3


Present and communicate appropriate findings

D1


Use critical reflection to evaluate own work and justify valid conclusions
D2


Take responsibility for managing and organising activities
D3


Demonstrate convergent/lateral/creative thinking


Assessor’s General Comments:






Assessor’s Signature:…………………………………………………… Date: ……………………………………

Print Name:



Learner’s Comments:


Signature: Date:

Print Name:





#HND Assignment help is pioneer in the #Assignment help services and we offer coursework help with 100% unique content, quality content by adopting required theories & concepts. Our experts have PhD in various fields so that the students can get their assignment with quality work for attain A++ grades in their work. We are having 7 years of experience for offering assignment help for #marketing assignment help, management assignment help, economics assignment help, Assignment help for economics, finance assignment help, Accounting assignment help, operation assignment help and others. For assignment help you can contact us at hndassignmenthelp@gmail.com

HND Assignment help is leading and most trusted assignment help service providing range of services for the different subjects but the major area of focus for the organization is HND Assignments. HND in the higher national diploma being offered by the various universities across the world and highest number of students pursue their HND from United Kingdom. HND Assignment help is working with the students in UK since last 7 years for helping them in their HND assignments. We provide help for various HND subjects like HND in business management, HND in travel & tourism management, HND in hospitality management, HND in accounting management, HND in human resource management, HND in law and HND in health and social care etc. Our experts have long experience in writing HND Assignments and they themselves are HND holder from the top notch Universities in United Kingdom. So, we are the best place to get your HND assignments. Contact us at hndassignmenthelp@gmail.com.

HND in business management offered by the HND Assignment Help offers high quality work for the mandatory as well as optional units such as the work based experience (WBE), employability skills, business ethics, European Business, operation management in business, small business enterprise, Quality management in business, internet marketing, human resource development, managing human resource, human resource management, advertising and promotion in business, Managing communication, knowledge and information (MCKI), Managing business activities to achieve results (MBAAR), Working with and leading people (WWLP), Personal and professional development (PPD), Research project (RP), Business strategy, Business decision making, marketing principle, Organization and behavior, Managing financial resources and decisions (MFRD) and Business environment.

HND Assignment help offered for the Health and social care would include 100% unique content and high quality content based on the given specific case study for the healthcare context. Every unit of the health and social care would consider specific case scenario which would be answered keeping in mind the HND requirements. HND in health and social care help offered by HND assignment help would include help on various mandatory and optional units such as PPD in health and social care, Health & safety in HSC, Communication in HSC, Understanding specific needs in HSC, The role of public health in HSC, Empowering users in HSC and Research project in HSC etc. So contact us at www.hndassignmenthelp.com, www.hndassignmenthelp.co.uk and www.hndassignmenthelp.com.au.

List of latest assignments offered by HND Assignment Help are as under:

Unit 13 Personal and Professional development
Unit 10 strategic human resource management
ECO511 Economics for business CSU Assignment help
ITECH2106-6106 Webpage and multimedia design
Unit 1 Business environment
Assignment on operation management help
Unit 20 Sales planning and operations
Unit 18 Advertising and promotion in business
Project and people assessment 3 Harvard case study
HI5004 Marketing management
Unit 11 Strategic quality and system management assignment help
HI6025 Assignment T3 Accounting Assignment Help
Communication in health and social care organization
Economics Assignment help Online
Marketing Assignment Help
HND Assignment Help
HND hospitality management assignment help
Unit 13 Hospitality Assignment help
Assignment help for Hospitality management
Hospitality management Assignment Help
HND in business management
Unit 48 project design implementation and evaluation
Unit 46 Corporate environment and social management

Comments