User Account

All Pages

Create a spreadsheet and import the access tables

Assignment Help Management Information Sys
Reference no: EM131222195

Assignment - Decision Support System

Applicable course objective:

  • demonstrate problem-solving skills by identifying and resolving issues relating to information systems and their components, and proficiently utilise different types of information systems software (especially gaining proficiency in utilising databases, spreadsheets, and presentation applications).
  • demonstrate written communication skills by understanding basic information, communication and technology (ICT) terminology for effective communication and applying it within a business environment.

Applicable graduate qualities and skills gained from this assessment instrument:

  • Problem Solving (Skill U2)
  • Written & Oral Communication (Skill U4)

Preamble

Dr Nikola Teslawas extremely impressed with our computing firm's - Einstein Technologies- development of the Ye Olde Steampunk Emporium's Database Management System (DBMS) utilising Microsoft Access (Assignment 1). The business has contracted our firm to assist in setting up more of the business's various computer-based information systems.

The next computer-based information system that the business is interested in is a Decision Support System (DSS) utilising Microsoft Excel (any version from Excel 2007 to current). The DSS will be used to analyse sales trends for the business to determine future courses of action for the business.

Dr Nikola Tesla would like the information in the Database Management System (DBMS)imported into Microsoft Excel (any version from Excel 2007 to current) so that the information can be summarised as a report and some future analysis of sales trends performed. The suppliers used by the business, source items from either Luxembourg(LU) or Tuvalu(TV).  They allow the business to select from either of these two regions on an ad hoc basic depending on the most favourable exchange rate at the time. 

Dr Nikola Teslahas noted that a number of the business's competitors are providing a discount to customers who place large orders. The businesswould like to see what affect adopting a similar policy would have on the business. The businesshas also noted a growing number of online businesses are starting to provide free freight delivery as a way of encouraging more online business; the business would like to run a number of scenarios based on potential Mark-up and Freight options to ascertain the best combination for the business if they were to adopt this policy too.

Decision Support System Design

Mrs Ada Lovelace, your manager, has set up the following tasks for you to complete for this phase of the project:

1. Create a Spreadsheet and import the four (4) Access Tables into four (4) Worksheets.

2. Data Validation Check.

3. Create an Index Worksheet.

4. Create a Data Input Worksheet Template for later use.

5. Create a Calculations Worksheet Template for later use.

6. Create Name Ranges for the Customers, Items, and Suppliers data.

7. Create a Report Worksheet and set up the column headings.

8. Modify the Report Worksheet by Cell Referencing all the Orders Table data.

9. Modify the Report Worksheet by using VLOOKUP to get Customer, Item and Supplier data.

10. Modify the Data Input Worksheet to include extra data needed for tasks 11 to 15.

11. Modify the Report Worksheet by using a Nested IF to calculate Cost Price (AU).

12. Modify the Report Worksheet by using a Nested IF to calculate Selling Price.

13. Modify the Report Worksheet by using a Nested IF to calculate Freight Cost.

14. Modify the Report Worksheet by using a AND / IF to calculate Item Discount.

15. Modify the Report Worksheet by using simple formulas to find Purchases and Sales, and Modify the Report Worksheet by using a formula to calculate the Order Discount.

16. Modify the Data Input Worksheet to include extra data needed for tasks 18 to 22.

17. Modify the Calculations Worksheet by using simple formulas.

18. Modify the Data Input Worksheet by Cell Referencing all the Calculations data.

19. Create eight (8) Scenarios on the Data Input Worksheet.

20. Create a Scenario Summary of the eight (8) Scenarios.

21. Create an Documentation Worksheet.

22. Create an Analytical Essay to describe the findings made using the Spreadsheet.

Attachment:- DSS Assignment.rar

Attachment:- Assignment01.zip

Reference no: EM131222195

Questions Cloud

Mergers or outsourcing may have on employees : Describe 3 effects that mergers or outsourcing may have on employees. What can HR do to support employees and how can employees protect themselves.
Dunkin donuts centralized program so high : In your opinion, why was the turnover rate among management trainees in Dunkin' Donuts Centralized Program so High?
What is the largest independent police association : Which of the following is not a frequent factor in determining the extent of pursuit-related liability? Which statement about the Americans with Disabilities Act is not correct?
Legal requirements and economic conditions : What does compensation mean to an employee? Are there psychological components to compensation? Is compensation only about money?  What is the effect of satisfied employees on a company's bottom line? Use at least one citation/referenced to your r..
Create a spreadsheet and import the access tables : Create a Spreadsheet and import the four (4) Access Tables into four (4) Worksheets. Data Validation Check.  Create an Index Worksheet
Basing your knowledge on the same : Technology has greatly impacted human resources and will continue to do so as new technology is developed. Basing your knowledge on the same, highlight how the technology has managed virtual workforces in the organizations.
Discuss bounded rationality : Discuss bounded rationality. In your discussion, explain the term as well as its importance in rational managerial decision-making.
Data analysis and interpreting and presenting research : Provide feedback to your colleague below by commenting on the relationship between data collection, data analysis and interpreting and presenting research findings.
Current role of an hrm professional : Write a paper that compares what you see as the current role of an HRM professional with how the role is expected to evolve in the future. In addition, compare the varying demands made upon HRM professionals throughout time. Note: This discussion ..

Reviews

len1222195

9/27/2016 6:50:47 AM

Need it as per the guidelines, based on previous work, will share it with start working email. This assignment is quite complex, and exposes you to many different components in Microsoft Excel (any version from Excel 2007 to current), some or all of which might be very unfamiliar to you. The assignment description provides some explanation of how to use these components, but you are also expected to use available resources such as Online Help, the Beskeen et al text, the Practical Skills sections at the end of each Module in the Study Materials, the SAM online tutorial activities and the course discussion forums, as well as exploring and experimenting on your own. Demonstrate written communication skills by creating an Index Worksheet; ensuring that it contains all the recommended data for this worksheet listed in the Practical Appendixes found on the Study Schedule and Module Materials – Spreadsheet design considerations.

Write a Review

Management Information Sys Questions & Answers

  Desirable and undesirable aspects of this fragmentation

Create a presentation in PowerPoint (using both the slides and instructor's notes sections) in which you address the following questions: What are the desirable and undesirable aspects of this fragmentation

  Supply chain management identify appropriate technology

supply chain management identify appropriate technology tools for manufacturing healthcare and retailreview the

  Examine the impact to the it support personnel

Evaluate the ways that SaaS, PaaS, and IaaS are used to reduce Total Cost of Ownership (TCO) and increase Return on Investment (ROI). Create SaaS, PaaS, and IaaS architectural diagrams using Microsoft Visio or an equivalent such as Dia. Note: The..

  Describe in detail the way in which the malware was utilized

Research an article where malware was used to steal data or gain privileged remote access to a computer or network, describe in detail the way in which the malware was utilized to steal data or gain privileged remote access to a computer or networ..

  Explain organization''s people with the change strategy

Why would change leaders need to align the organization's people with the change strategy and Would it be easier to just tell workers of the change and demand compliance?

  Bead bar management information systemsdq 1in general think

bead bar management information systemsdq 1in general think of ways that information systems add value to companies

  What internet business model would be appropriate

What Internet business model would be appropriate for the company to follow in creating a Web site and why?

  Define and explain the term authority and discuss the bases

define and explain the term authority and discuss the bases of authority.how does authority differ from power?explain

  Erp systemhow do you adapt a corporate-wide system such as

erp systemhow do you adapt a corporate-wide system such as erp for your department leaders?do you feel a department is

  Population have high-speed broadband connections

Other Services Resulting From High Speed Broadband - What other services will change business models when large parts of the population have high-speed broadband connections?

  Turning data into information for decision makersexplain

turning data into information for decision makers...explain the type of data that businesses process and correlate for

  What critical tasks does it facilitate in purchasing process

Briefly describe the steps of a pure prototyping methodology as an alternative to an SDLC approach. Which disadvantages of an SDLC methodology are addressed by a prototyping approach?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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