INF10009 Introduction to Business Information Systems
Individual Assessment 1 (Individual Report)
The two primary aims of this assessment is • To analyse the operational information of BookLoversParadise and provide an assessment on how well the business is doing. • To assess the competitive landscape of BookLoversParadise as well as how technology has affected them over time.
Each student is required to use MS Excel to perform an analysis of the state of BookLoversParadise’ business. You are then expected to write a report that refers to specific analytical charts which you have created in MS Excel to assess BookLoversParadise’ business. Describing the data content of each chart is insufficient, you need to analyse the information that the chart provides.
Note that BookLoversParadise is a fictitious company.
Each student is expected to undertake research of the book industry and use the information gathered to analyse the competitive landscape of BookLoversParadise using Porter’s Five Forces Model. The application of technology in BookLoversParadise and the book industry also need to be examined.
You are expected to apply the concepts (not just define the theory) to BookLoversParadise. If necessary, you can make assumptions to support your argument. These assumptions must be stated clearly. Clear application of theory will demonstrate your understanding of these concepts. Students need to write simply. The sentences need to flow and be easily understood by the reader. Use of complex jargon and difficult words should be the exception rather than the norm. Your ability to communicate well and concisely will be assessed.
BookLoversParadise is a bookstore chain in Australia. It has 4 shops in Australia in Melbourne, Sydney, Brisbane and Adelaide. It sells non-educational books. BookLoversParadise has been in business since 2007. It has noted a considerable decline in its sales across all stores since 2013. Due to that, a website was launched in 2018 to promote their operations in an effort to reach more customers via the internet. Their website provides a comprehensive catalogue of their products, and customers can call or visit relevant store to put in their orders, which can be picked up or delivered. BookLoversParadise suspects that they need to revamp their book collection in order to generate higher interest.
A part of the management team has strongly advocated to drop the sales of all product categories except for the top 2 categories. Senior management is leaning towards closing all stores except one. You have been given some basic data on the total sales revenues of BookLoversParadise over the last 2 years. Your objective is to analyse the data and provide your assessment.
You are expected to complete and submit (a) MS Excel Analysis Document (b) Business Analysis Report
i. Use MS Excel to populate the following sales data into 1st worksheet called “Sales Analysis (Student Name)”
Ensure that the coloured cells are filled in with the right data. You MUST use a relevant predefined function to do this. Use the relevant function add up the vertical totals and to count the number of product categories. Please ensure that the formatting of cells and numbers is done per the table shown above. You need to calculate the annual sales growth (or decline) for the cells above. For example, the sales growth (or decline) is calculated by taking the difference between the sales for 2019 and 2018. The sales growth (or decline) percentage is calculated by dividing sales growth (or decline) over the sale in 2018. A positive figure represents growth and a negative figure represents decline. The Gross profit for 2018 is 10% of the Sales for 2018 for all products. The Gross profit for 2019 is 30% of Sales for 2019 for first 4 categories and for the rest it is 5% of 2019 Sales. The reason for this is the suppliers for the respective products have changed their unit costs for the books. The status column should be derived from the middle table using the VLOOKUP function. Use Sales growth or sales growth percentage as the lookup value.
The Number of categories should be calculated using relevant function to show how many product categories are sold. Total Declined Sales 2019 and Total Increased Sales 2019 should respectively be an addition of the 2019 sales for when the 2019 product sales show a decline or growth. Net sales Growth is the addition of total declined sales and total increased sales. Please ensure that the formatting of cells and numbers is done per the table shown above, in terms of grid lines, colours and decimal places
ii. Create a 2nd worksheet, which should be named “Sales Chart (Student Name)”. Create the following 2 charts with appropriate chart title, axis labels, legends and colours.
a. A Clustered Bar chart showing Annual Sales 2018-2019 for each product category. The vertical axis should be labelled as Category while the horizontal axis should be AUD$. The Legend should be on the right.
Chart title should be “BookLoversParadise Sales 2018-2019 (Student Name)”
b. Create clustered column chart which shows the annual gross profit of 2018- 2019. The AUD$ value should be the vertical axis label and the horizontal axis should be the product categories. The legend which should be on top of the chart The title of the chart to be “BookLoversParadise Gross Profit 2018-2019 (Student Name)
Students are expected to • use absolute addressing, SUM function, SUMIF, COUNTA and VLOOKUP function, where appropriate. Students are expected to research SUMIF function in more detail, as this assessment requires students to specify all 3 elements in SUMIF. • to create the charts as described in the assessment (Student Name) is expected to be replaced by the student’s name. For example, if the student’s name is Scarlet Johansen, then it should be (Scarlet Johansen) in the MS Excel worksheet names and titles, as demonstrated in one of the charts above.
B. Business Review Report
The report will have the sections as per the table below. The assessment requires you to apply the concepts you have learnt from INF10009 in the analysis and argument about BookLoversParadise. Therefore, pure definitions from the recommended textbook or lecture material should not be used. Explain the concepts in your own words (paraphrase) and at the same time making reference to the material which you referred to. Quotations will only be given minimal marks. Students are also expected to paraphrase the background of BookLoversParadise.
Title Page Table of Contents
1. Introduction Brief background of BookLoversParadise and purpose of report.
2. Business Performance Review Using the charts from MS Excel, present your analysis on how the business is performing. Do research on Amazon Australia Best sellers to help in your analysis. (Tip: You should not only describe the chart but to analyse it. Your explanation of why this has happened, and what the business should do) Provide your recommendation on whether BookLoversParadise should close all stores except one. (Hint: Importance of information)
3. Competitive and Technological Analysis Based on the background information provided in the assessment, and the current book retail industry that you gather from research, examine the following concepts in relation to BookLoversParadise, and their importance in gaining competitive advantage • Using Porters 5 forces model, provide an analysis of the competitive intelligence of BookLoversParadise with focus on Competitive Rivalry and Threat of new entrant and threat of substitute. • Discuss on the state of the book industry and explain how sustaining and disruptive technology can help decrease buyer power in book industry • Discuss and contrast Borders bookstore chain (A real organisation) and lessons that can be learnt by BookLoversParadise
4. Conclusion Summary of BookLoversParadise business (from section 2 and 3)
5. Appendix Reference Lists
Students are expected to insert the figures/charts in MS Excel and use it to support your analysis of BookLoversParadise business performance. At least 3 references must be provided to support section 3 of the report. Assessment marks will also be allocated to correct referencing (Harvard System). There is a guide freely available at: http://www.swinburne.edu.au/lib/researchhelp/harvard_system.htm. Students should refrain from quoting and should paraphrase (rewrite in your own words) what you have found from the research.
WHAT ARE THE LINKAGES BETWEEN INCOME INEQUALITY AND POOR HEALTH?
Presently, the primary sources of inequalities among people are unequal access to health-related services. Health does not refer to the absence of infirmity or the diseases, but it is a state of complete mental, physical as well as social wellbeing. Lack of education, sufficient income, food, and gender disparities along with other economic, social as well as cultural variations might cause health to suffer. Income inequality and poor health have become dependent on each other. The main reason behind it is accessing healthcare services are becoming more expensive along with the improvement of healthcare services which are creating difficulties for the lower class people in obtaining the healthcare facilities who have lesser capacity to earn. The original aim of this essay is identifying the link between income inequality and poor health.
According to the epidemiology research, higher level of inequality always creates a negative impact on the health because inequality reduces the social cohesion which increases stresses, fear as well as insecurities among every people (Pickett & Wilkinson, 2015). Health experts and economists have demonstrated the fact that people who live in poor society mainly lives a decidedly shorter lives, whereas, people who live in the nation with a lower level of inequalities lives more extended periods of times.
Figure 1: World inequality and infant mortality
(Source: Elgar et al. 2016)
The study has also made it more apparent that there is a good link among the inequalities and mental health. It is seen that a nation with a higher degree of differences among rich and poor increases the cases of schizophrenia (Batterham et al. 2016). Generally, a 0.2 point increase in the Gini coefficient of a country creates eight additional incidents of the schizophrenia per every 100000 people (Marmot, 2015). The main reason behind it is a higher level of inequalities in society reduces social cohesion and develops the chances of chronic stress.
Figure 2: Inequality versus world mental health
(Source: Batterham et al. 2016)
Arcaya, Arcaya & Subramanian (2015) stated that the extreme level of inequality always affects the perception of people regarding well-being. In a country where the top 1% holds most of the national income, people are tending to have a lower sense of prosperity. As argued by Elgar et al. (2017), the social determinant of the health varies among the developing and developed nations. It has been observed that a girl born in the present time is expected to live more than 80 years if she is born in the developed countries, but there are chances that she could live 45 years if she is born in the less developed countries (Krueger, 2018). Presently, the lack of education and poverty are the two primary drivers of early mortality and poor health. Poor housing conditions, as well as poor nutrition, create a higher level of impacts on the development of mental health, anxiety, stress and ambitions for life. The incidence of cervical cancers and childhood cancers are highest in north Argentina where the most miserable people live. According to Elgar et al. (2015), countries with the extreme level of inequalities have very lower rates of the trusts, social mobility as well as educational performance and higher rates of infant mortality, imprisonment, teenage births etcetera. The main reason behind it is unequal countries always discourage the lower income group to gain a better education which reduces their knowledge about different health well-being factors.
As stated by Krueger (2018), asymmetric wealth distribution is not a new fact because humans have lived in this lopsided societies for long years. As argued by Bartley (2016), inequality isn't bad for the economic health of a country, but it creates an adverse impact on the overall health of humanity. The growing level of evidence has established the fact that a higher level of inequality increases the number of crime, creates worse public health conditions and generates more social illness which affects every level of society. According to Mullahy, Robert & Wolfe (2018), poverty goes hand in hand with the inequalities. Along with the more significant inequalities in income, social status and education, the health inequalities are also increases.
The rich people mainly live a different life from the rest of people who are not rich, and they live in a different neighbourhood and send their children to different schools from where they can get good educations (Adler, Glymour & Fielding, 2016). When rich people pay directly for every essential service for them, then they become less tending to pay tax for other people on the societies which erode the public services. This whole argument is against the facilities for poor people who are different than the rich because poor people get poor services (Schultz & Mullings, 2006). Health-related services mainly follow a social gradient.
Along with the development of wealth, the costs of the health-related services also increases which creates difficulties for the poor in getting those services. As argued by Douglas (2016), earning money 1 million to 2 million would not change the economic status of a person because earning this extra 1 million money will not make people go beyond the 1% wealthiest people, but it will increase the national income which will increase the cost of services. Therefore, a small amount of extra income can increase the costs of health-related services which creates difficulties for the poor in accessing these services
Ineffective education is also one of the factors which can lead to poor health because ineffective education is directly linked with inequality. (2019) stated that dDuring the transition phase of youth that means when youth goes to the secondary school from elementary school then if any youth do not get the chances to access the further education then they face difficulties in enhancing their technical knowledge to get a good job which in turns creates income and social inequalities (Bauer & Landholt, 2018). As the youth do not understand the access to proper higher education in their life, then they face difficulties in getting adequate knowledge about the proper nutrition along with other health-related information. This situation increases the possibilities of poor health for the lower socioeconomic group.
Presently, every women and girl belonging from the developing nations are participating in the school system more than earlier times. However, in some developing countries, inequalities mainly affect rural, poor as well as indigenous women (Ames, 2012). Due to the poor economic conditions, some women face difficulties in accessing proper education which creates problems for them in getting appropriate knowledge to secure better health (Ames, 2012). As those women do not know about various diseases, the importance of nutrition in life and disparate treatment available to treat different conditions so that those women faces difficulties in securing good health.
According to Papan & Clow (2015), nearly three-quarters of the chronic disease-related deaths have occurred in the low and medium income countries. This is because people belong to those countries mainly consumes low costs, less nutritious and high-fat foods which increases the chances of obesity in this country. Obesity is primarily associated with a range of health morbidities or conditions which include asthma, osteoarthritis, type 2 diabetes, types of cancers, chronic back pain, and strokes etcetera (Papan & Clow, 2015). Schuring et al. (2019) stated that women who have a higher degree of food insecurities are also suffered due to obesity. As per a study, it has been observed that women of various developed nations such as Australia, USA, and the UK are 20% to 40% more obese than other people who have food securities which clearly show that there are intrahousehold inequalities (Papan & Clow, 2015). The higher rates of food insecurities are mainly observed among the lone parents with a child or children. Therefore, it can be said that women and men have income inequalities which sometimes creates food insecurities among women and increases the possibilities of poor health conditions.
Epidemiological studies have made it clearer that income inequalities within a given population have some negative impact on health. Income refers to the stream of revenues from salaries, wages or interests achieved from savings, profits gained from selling something etcetera. Income inequality refers to the extent to which incomes can be distributed unevenly among a particular population (Schultz & Mullings, 2006). Income is strongly influential on the longevity of life and health through the behavioural, clinical as well as environmental mechanisms. Economic inequality has an enormous influence on the expectancy of life. In the year of 1970s, a 60-year-old man with good income was expected to live 1 to 2 years longer than a man who has a lower level of income. In the present century, a 60-year-old man is expected to live 5.8 years longer than because of the advancements of medical science. As stated by Ponsford et al. (2018), presently, medical science has been advanced due to innovation that has also increased the costs of accessing medical treatments. As an example, it can be mentioned that low-income Americans are facing higher rates of physical difficulties such as strokes, diabetes, heart diseases along with other chronic conditions. The increasing costs of the medical treatments create problems for the poor people in accessing the medical facilities for them which lead to poor health for them.
Income inequality causes social and health-related problems due to the status of anxiety. As stated by Compton & Shim (2015), income inequality is harmful to people because it places people in a hierarchy which increases the status related competition which ultimately resulted in the poor health conditions as well as adverse health-related outcomes. Bécares (2015) argued that Anxiety about income inequality is the mechanisms by which social problems can be increased. In those consequences, the sources of stresses are lack of friends, deficient social status along with the stresses in early life. Therefore, income inequality creates chronic stresses, depressions and lower self-esteem which ultimately build some mental health issues.
Moreover, the consequences of the income inequality also produce a lower life expectancy, the increasing rate of a teenage birth, violence in the society and higher rate of murder (Smith, Bambra & Hill, 2016). The theory of status anxiety suggested the fact that people compare them with other people which increase anxiety among them about their position. This anxiety often leads to different unwanted consequences. Income inequality creates unequal access to education which affects people from an early age. As stated by Paredes (2016) children belonging from the poorer backgrounds are less likely to access the home learning environment. The main reason behind it is children who are residing from lower economic background generally have parents who are not much educated. This situation destroys the chances of the home learning environment (Schultz & Mullings, 2006). Lower access to education reduces the opportunities to get a good job in the future which increases the chances of poor health in their future.
Culture has an important role in income inequality. Japan and Sweden are the outliers in case of equality so that they have a lesser number of social problems. Income equality is the consensus of the collectivism. As stated by Mehdipanah et al. (2015), the countries that follow the collectivist cultures are more likely to have lower income inequality. Therefore, in those countries, almost every people can afford a better healthcare facility to secure good mental and physical health for them. Wang, Li & Chen (2015) argued that income inequality and access to health-related services are also dependent on the rate of education in a particular country. If the rate of education is high in a country, then there are vast possibilities that the employability is high in the country which increases the possibility to access the healthcare services with efficiencies.
Various mechanisms are there through which income influences heath that are mainly divided into clinical, behavioural as well as environmental factors. Compared to people with higher income, people with low income mostly face the most significant level of barrier in accessing medical care (Rao & Sweetman, 2014). This is because people with lower income mainly meets issues in obtaining health insurance and receiving new technologies as well as drugs while accessing various primary and speciality care. The main reason behind it is people with lower income mainly doing jobs in those organisation that do not offer then any medical insurance along with other health-related benefits (Truesdale & Jencks, 2016). In Australia, there are only 47% people who have the coverage of private hospital, and there are only 56% people who have general treatment coverage in the year of 2016 (Mithen et al. 2015). In the USA, there are less than a third people belonging from the low-income group who gets the health insurance from their employers compared to the 60% people residing from the high-income group of people.
People with low income also have higher rates of the behavioural risk factors such as smoking, utilisation of various substances, and obesity along with the low level of physical activities. These behavioural risk factors profoundly influenced the community as well as home environments in which they live (Rao & Sweetman, 2014). As an example, it can be said that if tobacco manufacturing company observes that people with lower income are consuming tobacco in the greatest extents, then they will targets these lower-income people with the help of different marketing strategy (Wilkinson & Pickett, 2017). This fact will increase the consumption of tobacco. Along with that, people with lower income have limited access to the pharmacotherapy as well as cessation counselling services which may create chronic stress among the people with lower income.
Poor health habits are prevalent in the lower economic environments because of the lack of funds for accessing better nutrition, education as well as medical attention. For example, most of the high sodium and high-fat foods which leads to heart diseases are tending to be the most inexpensive foods found in stores (Wilkinson & Pickett, 2017). The lower income group of people are managing to buy cheap food because they cannot earn more so that there are higher levels of possibilities that those lower income groups of people buy the unhealthy foods which can create a devastating impact on the health. Due to the poor nutrition, the lower socioeconomic class not only suffers due to the heart diseases but they also suffer from chronic lung diseases, back pain, obesity, cancers, gastrointestinal disorders, low life expectancy and many more.
The above description can conclude the fact that inequality has a higher level of negative impact on the health of the lower social, economic group of people. This is because; inequality always creates social anxiety among people as they always compare their condition with other people who are their relatives or friends. This comparison produces a negative impact on the mental health of people. Along with the improvement of the economic condition of the top 1% rich people, the national income of a country also increases which increases the costs of various products and services along with the healthcare services. This situation creates difficulties for the lower economic group of people to access healthcare services as their earning is not good.
For reducing the chances of poor health outcome in a country, it is always necessary for government in taking a good step. The government of both the developed and developing countries must make good action in offering free essential healthcare services to every people so that it can help the low-income people in accessing basic good health. Moreover, the government must take steps to equalise the economic condition of people living in a society so that it can reduce the chances of social anxiety. A better taxation system and a good policy need to be developed to equality the economy. Moreover, constant campaigning needs to be arranged by the government of a country so that they can offer different knowledge about proper nutrition, multiple diseases, causes of diseases and different consequences of the diseases.