+1 862 207 3288 Scenario
You will be required to do your own research on single, including muti-national, private, as well as public companies, to understand the relationship between acquisition of data and then making of use of the data to build a framework for organisations, which helps them to take decisions effectively, as well as to understanddifferent approaches to primary and secondary research and how these can be used for correct interpretation of the data. You will focus your research on qualitative and quantitative research methodologies that can be utilized in organisations, as well as use different statistical techniques to draw out coherent analysis of the research methodologies adopted.
Business Decision Making
Assignment Task 1
Questions to be addressed in completing the Assignment Task 1:
(Figures in brackets after the question denote relation with the assessment criteria. If you achieve all the assessment criteria mentioned herein, you will have achieved a PASS grade).
[Grade Descriptors mentioned thereafter denote the evidence required in your answers to achieve MERIT and DITINCTION Grades. To achieve a MERIT, you must achieve all M1, M2, M3 grade descriptors mentioned against the respective questions and to achieve a DISTINCTION, you must achieve all D1, D2, D3 grade descriptors mentioned against the respective questions].
Be able to use a variety of sources for the collection of data, both primary and secondary
A survey is required to be performed to determine the following:
AcademicFacilities available at Westford School of Management for HND Course students, including gauging the students’ satisfaction level (the questionnaire can include quality, content, faculty, institute, facilities, administration, students engagement, satisfaction, etc.) at its Sharjah, UAE campus premises.
Questions to be addressed in completing the Assignment Task 1:
(Figures in brackets after the question denotes relation with the assessment criteria)
LO 1. Be able to use a variety of sources for the collection of data, both primary and secondary
1.1& 1.2 Create a plan for carrying out the survey of the requirement enumerated above, by presenting the survey methodology and the sampling frame you are going to use. Also bring out in your plan how are you going to collect primary and secondary data to carry out this survey? (Criteria 1.1: create a plan for the collection of primary and secondary data for a given business problem; Criteria 1.2: present the survey methodology and sampling frame used)
1.3 Design a questionnaire with at least 15 questions to carry out the survey for the requirement enumerated above.(Criteria 1.3: design a questionnaire for a given business problem)
Assignment Task 2
Questions to be addressed in completing the Assignment Task 2:
(Figures in brackets after the question denote relation with the assessment criteria. If you achieve all the assessment criteria mentioned herein, you will have achieved a PASS grade).
[Grade Descriptors mentioned thereafter denote the evidence required in your answers to achieve MERIT and DITINCTION Grades. To achieve a MERIT, you must achieve all M1, M2, M3 grade descriptors mentioned against the respective questions and to achieve a DISTINCTION, you must achieve all D1, D2, D3 grade descriptors mentioned against the respective questions].
Analysis of Data
Attempt all questions
Question 1: From the data below calculate the median, the upper quartile and the lower quartile.
7, 48, 50, 16, 44, 42, 8, 40, 44, 42, 37
Explain the significance of using medians and quartiles in business context of decision making. (Criteria 2.1)
Question 2: If the mean of numbers 28, x, 42, 78 and 104 is 62, then what is the mean of 128, 255, 511, 1023 and x?
Explain the significance of mean and mode in business context of decision making. (Criteria 2.1)
Question 3: Calculate the mean, mode, median, variance and standard deviation of the following frequency distribution: From the answers derived for all the central tendencies including deviation, give out valid conclusions of what do these figures signify in context of hours worked by employees. (Criteria 2.2)
Hours of Work No. of Employees
>0 &<=10 5
>10 &<=20 7
>20 &<=30 11
>30 &<=40 16
>40 &<=50 13
>50 &<=60 7
>60 &<=70 4
>70 &<=80 2
Question 4: Why does a standard deviation take the square root of the average of the sum of the squared differences between X and X mean instead of the average of the absolute value differences?(Criteria 2.3)
Question 5: In a company, the data below gives you the distribution of Number of Hours worked per day by company employees, with the Frequency of the number of employees working these hours per day. From the grouped data given below, find the variance and the standard deviation. From the answers derived for variance and standard deviation, analyse and state what these figures signify in terms of measures of dispersion observed in the number of hours worked by all these employees. (Criteria 2.3)
Number of Hours Frequency
3.5 – 4.5 9
4.5 – 5.5 14
5.5 – 6.5 22
6.5 – 7.5 11
7.5 – 8.5 17
Question 6: The cost of output at a factory is thought to depend on the number of manufacturing units produced. Data have been collected for the number of units produced each month in the last 6 months, and the associated costs, as follows:
Month Outputs Cost
‘000s of Units $ ‘000
Jan 3 7
Feb 4 9
Mar 2 5
Apr 5 11
May 3 8
Jun 5 12
Assess whether there is any correlation between output and cost. What conclusion can you draw in context with the business manufacturing units produced and its output costs? (Criteria 2.4)
Question 7: Respondents to a survey were asked to judge the quality of a product on a four-point rating scale (excellent, good, fair, poor). They were also asked to judge the reputation of the company that made the product on a three-point scale (good, fair, poor
The first variable is the rating for the quality the product. Responses are coded as 4=excellent, 3=good, 2=fair, and 1=poor. The second variable is the perceived reputation of the company and is coded 3=good, 2=fair, and 1=poor.
Is there a significant relationship between respondents’ perceptions of the company and their perceptions of quality of the product?What conclusion can you draw in context with the respondents’ perceptions of the company vis-à-vis their perceptions of the quality of products produced by them? (Criteria 2.4)
Variable 1 Variable 2
4 3
2 2
1 2
3 3
4 3
1 1
2 1
Question 8: From the above questions’ calculations done by you, explain how quartiles, percentiles and the correlation coefficient are used to draw useful conclusions in a business context. (Criteria 2.4)
LO 2. Understand a range of techniques to analyse data effectively for business purposes
The following criteria will be addressed while answering the questions enumerated above.
(Figures in brackets after the question denotes relation with the assessment criteria)
Use of representative values, analysis of data using given situations, dispersion techniques analysis, use of quartiles, percentiles and correlation coefficient to draw useful conclusions.
(Criteria 2.1 to 2.4:2.1 create information for decision making by summarizing data using representative values; 2.2 analyse the results to draw valid conclusions in a business context; 2.3 analyse data using measures of dispersion to inform a given business scenario; 2.4 explain how quartiles, percentiles and the correlation coefficient are used to draw useful conclusions in a business context)
Business Decision Making Assignment Tasks
Assignment title Produce Information in Appropriate Formats & Use Software Information for BDM
Purpose of this assignment:
The primary aim of this assignment is to help you to produce information in different formats of Microsoft Office, as well as use software generated information in organisations to help them to take good decisions. The business scenario is generated for good inventory control management, project management as well as use of financial tools in business context.
Scenario
You will be required to do your own research on usage of Microsoft office tools with respect to different business scenarios generated for you, as well as analyse logically how these can be utilized efficiently in businesses to help them take effective decisions. You will focus your work on making good workable reports and presentations to aid your management in giving out a clear coherent framework to them to eventually help them take business decisions. Also, different scenarios will be generated to enable you to use software generated information to help make decisions in organisations, as well as to get an insight into the mechanics of inventory management, project management and financial tools.
Assignment Task 3
Questions to be addressed in completing the Assignment Task 3:
(Figures in brackets after the question denote relation with the assessment criteria. If you achieve all the assessment criteria mentioned herein, you will have achieved a PASS grade).
[Grade Descriptors mentioned thereafter denote the evidence required in your answers to achieve MERIT and DITINCTION Grades. To achieve a MERIT, you must achieve all M1, M2, M3 grade descriptors mentioned against the respective questions and to achieve a DISTINCTION, you must achieve all D1, D2, D3 grade descriptors mentioned against the respective questions].
Use of Information for Decision Making
LO 3. Be able to produce information in appropriate formats for decision making in an organisational context
Attempt all questions
1. Consider the following time series:
Qtr Sale ($’ 000)
Qtr 1 26
Qtr 2 27
Qtr 3 30
Qtr 4 29
a) From the above data, draw a pie-chart and a bar graph. What conclusions can be drawn from each of these graphs and charts? (Criteria 3.1: produce graphs using spreadsheets and draw valid conclusions based on the information derived)
Walmart Worldwide – Japan
¥ Sales {‘000} ¥ Revenue {‘000} ¥ Cost
2009 400 200 65
2010 650 400 130
2011 1300 750 350
2012 3500 1800 800
2013 5000 2500 900
b) Prepare a line graph, histogram, xy scatter graph using the above data . What trend is being shown in the sales against revenue? What trend can be forecasted for the subsequent year? (Criteria 3.2: create trend lines in spreadsheet graphs to assist in forecasting for specified business information)
Preparation of a Formal Business Report – Electronic Auditing Procedures
The CEO of the large organization where you are a manager has heard that several of your competitors have installed electronic auditing procedures to monitor the computer use of employees. The CEO asks you, as manager of human resources, to investigate this trend. Why are other companies doing this? Should your organization do likewise? Will employees consider this an invasion of their privacy? What would be the advantages and disadvantages to instituting an employee monitoring system? Based on your discussion, what conclusions could be drawn? Make recommendations to the CEO. Use your imagination to fill in details about your organization.
a) You will have to do some research on the internet, apart from the brief posted above. (approx 1000 words) (Criteria 3.4: produce a formal business report)
b) Prepare a business presentation based on the above report, using a power point presentation to disseminate the report information effectively.(Criteria 3.3 prepare a business presentation using suitable software and techniques to disseminate information effectively)
Individual Task
This is a individual assessed task and to be submitted by each individual and should include:
1. A brief literature review pertinent to the task, which should include which references were used, including good and bad experiences faced while doing this assignment.
3. An executive summary (300 words maximum) of your assignment
4. Bring out the most important lessons learnt while executing the assignment
5. A PowerPoint presentation, as a ppt,will be made as part of the task. The ppt will also be given as a presentation to the concerned faculty.
Assignment Task 4
Questions to be addressed in completing the Assignment Task 4:
(Figures in brackets after the question denote relation with the assessment criteria. If you achieve all the assessment criteria mentioned herein, you will have achieved a PASS grade).
[Grade Descriptors mentioned thereafter denote the evidence required in your answers to achieve MERIT and DITINCTION Grades. To achieve a MERIT, you must achieve all M1, M2, M3 grade descriptors mentioned against the respective questions and to achieve a DISTINCTION, you must achieve all D1, D2, D3 grade descriptors mentioned against the respective questions].
LO 4. Be able to use software generated information to make decisions in an organisation
Assignment Task 4
Use of Software Generated Information
Instructions: Attempt all questions.
1. Distinguish between strategic, tactical and operational information.
Give two examples of strategic, tactical and operational information relevant to an organization operating in the manufacturing sector. (Criteria 4.1)
2. What do you mean by MIS? What are the four types of information suggested by Drucker? (Criteria 4.1)
3. Why hold stocks? Discuss any FOUR stock control levels. What is the use of stock control levels in inventory management? (Criteria 4.1)
4. Placing an order for an item of stock costs $ 340. The stock costs $ 60 a unit, annual storage costs are 10% of purchase price. Annual demand is 900,000 units. What is the economic order quantity (EOQ)? How does EOQ calculation help in management of inventories? (Criteria 4.1)
5. What are the project planning steps? (Criteria 4.2)
6. The following activities comprise a project to agree a price for some land to be bought for development.
Activity Preceded by Duration Days
A: get survey done – 5
B: draw up plans – 9
C: estimate cost of building work B 2
D: get tenders for site preparation A 11
E: negotiate price C,D 5
a) What are the paths during the network?
b) What is the critical path and what is the duration?
(Criteria 4.2)
7. A company is wondering whether to spend $ 36,000 on an item of equipment, in order to obtain cash profits as follows:
Year $
1 12,000
2 16,000
3 10,000
4 2,000
The company requires a return of 10% per annum.
Use the NPV method to assess whether the project is viable.
(Criteria 4.3)
8. The net present value of an investment at 25% is $ 90,000 and at 30% is 20,000. The internal rate of return of this investment is (show all calculations to the nearest whole number):
A. 17%
B. 20%
C. 22%
(Criteria 4.3)
Assessment Criteria
Criteria 4.1 use appropriate information processing tools
Criteria 4.2 prepare a project plan for an activity and determine thecritical path
Criteria 4.3 use financial tools for decision making
5
Place this order with us and get 18% discount now! to earn your discount enter this code: special18 If you need assistance chat with us now by clicking the live chat button.
