Populate a financial model using a spreadsheet

Assignment Help Strategic Management
Reference no: EM13832129

Learning objectives

This assignment addresses the following learning objectives of the course:

- solve complex organisational problems theoretically and practically and critically reflect on the effectiveness of management processes to real-world problems

- Communicate professionally and effectively in written and oral communication to various audiences.

Individual submission

Students should complete this assignment individually. You are encouraged to discuss with others to improve your understanding and clarify requirements but your assignment needs to be your own original work.

The tasks listed in the Marking Criteria relate to the following Case Study

As the Information Systems Manager you have been given the responsibility for implementing a new "smart shopping trolley" system for a grocery/supermarket chain. This smart shopping trolley technology will help customers in the store by adding up the cost of items at the same time that they are placed in their supermarket trolley. It will also help shoppers locate the items in the store, in the quantities needed, when they enter or select a particular recipe.

As you have studied Information Systems Strategy, you know that introducing a new information technology system won't be successful unless you have assessed the impact on the business strategy and the four business functions (marketing, production, finance and HR) within the firm. You also need to do a cost benefit analysis of introducing the technology across 10 stores in different regions, if the pilot study in the first store is successful. Your report includes a presentation to the CEO.

What to submit through StudyDesk:

You will submit a handout for the CEO containing the Cover letter, Spreadsheet and Reference List through StudyDesk along with a link to a URL where you recorded audio/visualpresentation.

YouTube is the preferred mode for your CEO presentation; if you do not wish for your video in YouTube or other system to be publically available then you may explore security features or options of YouTube. You are responsible for ensuring the link to your presentation will work for the Examiner marking your assignment - you should ask someone to test it for you.

It does not need to be professionally produced and you can use a mobile phone, movie camera, the video tools that are available to download to use your PC, voice capture in Powerpoint or whatever. The purpose of the presentation is to present a compelling business case to the CEO to persuade him or her to adopt the new initiative.

As a guide, written work worth 10 marks should be no more than one page of writing; your presentation should be around 10-12 slides and should be around 5-10 minutes.

Financial model of the business case

Based on your research develop a spread-sheet model of your business costs over a 6 year period; assume a discount rate of 10 per cent. Your business model should include the following analysis to ascertain the financial viability of the project:

1. Payback period
2. Net present value (NPV)
3. Internal rate of return (IRR), and
4. Profitability index

HINTS: To obtain the payback period you would first need to calculate the cumulative net cash flow. Use the NPV and IRR functions provided in Microsoft Excel. You may need to search the Internet for information if you are not familiar with how to use these functions. Provide an explanation to the CEO to help him/her interpret your results and what they mean.

Sensitivity analysis for the business case

Using the results you obtained above as the base case, conduct a sensitivity analysis to examine the impact of the critical cost and benefit variables on the viability of smart shopping trolley system project.

Provide three specific scenarios of consideration. You must clearly specify the basis of the three scenarios i.e. which critical cost variables they are examining in the sensitivity analysis.

Provide a note to explain the results to the CEO.

Letter of transmittal addressed to the CEO introducing and explaining the purpose of the presentation and handout, professional presentation

Quality of presentation

Planning, design, clarity and professionalism of presentation; you are encouraged to use graphics to illustrate points (avoid copyright material and reference all sources)

Background for smart shopping trolley system project

Description of the current state-of-the art in smart shopping trolley system technology; how it could be utilised, associated risks, experiences of other companies with similar technology; evidence of research effort

Resources required to implement smart shopping trolley system (hardware/ software/networking).

Description of the resulting or required changes to organizational business processes, and the company's relationship to suppliers and customers; and the effect of this innovation on the firm's activities - HR, sales and marketing, finance and accounting and production.

Costs and Benefits - an explanation of the main anticipated costs and benefits of the implementation and operation of the Smart shopping trolley system

Cost benefit analysis using Excel or equivalent

You will need to estimate costs and benefits and populate a financial model using a spreadsheet. You may use the functions in MS Excel

Sensitivity analysis

The calculation and interpretation of your results should be clear and convincing to the audience.

Conclusion and recommendations

The conclusion should summarise the key points of your report. The recommendations should highlight the funding sought and a specific course of action.

List of references

In-text and end-of-document references to support contentions and all information sourced for the report. This must adhere to the Harvard referencing style.

Verified Expert

Reference no: EM13832129

Questions Cloud

Why does the government grant patents to investors : Why does the government grant patents to investors? Why does the government give monopoly power to utility companies?
Define bundling-what consumer and market characteristics : Suppose a textbook publisher historically sells an econ book alone but then markets the new edition of the boo only as a bundle with an online hw supplement. Answer 2 parts: define bundling. discuss what consumer and market characteristics are needed..
Discuss how both the fiscal and monetary policies : Discuss how both the fiscal and monetary policies in the United States and in the Bible relate to the model of aggregate demand and aggregate supply and the issues involved in implementing the policies.
Use the aggregate expenditure model developed : Use the aggregate expenditure model developed in this chapter to explain the following statements: Coming amid continued turmoil in the financial and credit markets, the report sent stocks lower, with the Dow Jones Industrial Average falling 146.70 p..
Populate a financial model using a spreadsheet : Solve complex organisational problems theoretically and practically and critically reflect on the effectiveness of management processes to real-world problems - estimate costs and benefits and populate a financial model using a spreadsheet
Identify dilemmas that threaten the future integrity : Identify dilemmas that threaten the future integrity of the U.S. healthcare system. Discuss whether or not there is a need for healthcare reform
Legislations to prevent monopolization of businesses : Name at least two legislations to prevent monopolization of businesses. Do you believe these legislations have been helpful? Discuss.
The discussion of one results in considerable debate : You are in a meeting to discuss two possible acquisitions. The discussion of one results in considerable debate. One group presents credible arguments that the purchase encompasses the possibility of significantly larger profits after the acquisition..
Name the six general types of bones in the human body : 1. Name the six general types of bones in the human body and name one specific example of each type of bone. 2. For each of the following terms, do the following: (1) define the word, (2) breakdown the following words into their individual word parts..

Reviews

Write a Review

 

Strategic Management Questions & Answers

  Conduct a complete study of the external environment

Conduct a complete study of the external environment in which Fiat competes, and identify the critical strategic factors

  Improve shipment productivity

Consider Shipment productivity. Think of one way that you could improve shipment productivity and explain.

  Maximax strategy and maximin strategy

At Acme Home Products, Inc. the operations manager's staff has developed information for four manufacturing process, refereed to as T, R, Q, P. These process alternatives vary by production technology and the capacity of the machinery used.

  Provide a brief overview of the composition

Provide a brief overview of the composition of its strategic plan.

  List the methodological weaknesses of gert

1. List the methodological weaknesses of Gert Hofstede's studies of national culture

  W4 members tend to be programmers

You have been loaned to a non-profit organization, World-Wide Webmasters' Webbies (the W4). W4 members tend to be programmers with a smattering of graphic artists and performance practitioners among them.

  What are the goals and purposes of this research study

What are the goals and purposes of this research study

  Discuss the strategy and structure of international business

discuss the strategy and structure of international business

  Financial performance of the business

How does the success of serving the interests of stakeholders reinforce the financial performance of the business? How does the financial performance reinforce serving the interests of the stakeholders?

  How do customers effect a business level strategy

How do customers effect a business level strategy? If you were thinking of opening a small business what issues should you study about a community and the people in that community?

  Understand the organizations capabilities

Analysis the organization in order to understand the organization's capabilities, customers and business environment and so on.

  Q1athe critical z value is 205375if test value is gt 205375

q1a.the critical z value is 2.05375if test value is gt 2.05375 we reject null hypothesis.b. test value 47.1-45 980.5

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd