Scribd Logo
Upload

Welcome to Scribd!

  • 61 views

    Pivot Table - Lab Instructions

    Uploaded by

    Hà Lê
    This document discusses two exercises for improving decision making. The first involves using an Excel pivot table to analyze sales data to answer questions about average purchases, payment methods, purchase times, and relationships between regions, products, and prices. The second involves using an online retirement planning tool from CNN Money or MSN Money to determine how much a 50-year-old needs to save over 16 years to generate $60,000 annual retirement income including Social Security. The exercises build skills in pivot tables and online decision support systems for financial planning.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Pivot Table - Lab Instructions

    Uploaded by

    Hà Lê
    61 views2 pages
    This document discusses two exercises for improving decision making. The first involves using an Excel pivot table to analyze sales data to answer questions about average purchases, payment methods, purchase times, and relationships between regions, products, and prices. The second involves using an online retirement planning tool from CNN Money or MSN Money to determine how much a 50-year-old needs to save over 16 years to generate $60,000 annual retirement income including Social Security. The exercises build skills in pivot tables and online decision support systems for financial planning.

    Original Title

    Pivot table_Lab Instructions

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses two exercises for improving decision making. The first involves using an Excel pivot table to analyze sales data to answer questions about average purchases, payment methods, purchase times, and relationships between regions, products, and prices. The second involves using an online retirement planning tool from CNN Money or MSN Money to determine how much a 50-year-old needs to save over 16 years to generate $60,000 annual retirement income including Social Security. The exercises build skills in pivot tables and online decision support systems for financial planning.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    61 views2 pages

    Pivot Table - Lab Instructions

    Uploaded by

    Hà Lê
    This document discusses two exercises for improving decision making. The first involves using an Excel pivot table to analyze sales data to answer questions about average purchases, payment methods, purchase times, and relationships between regions, products, and prices. The second involves using an online retirement planning tool from CNN Money or MSN Money to determine how much a 50-year-old needs to save over 16 years to generate $60,000 annual retirement income including Social Security. The exercises build skills in pivot tables and online decision support systems for financial planning.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    Enhancing decision making

    MIS excel pivot table: Using the provided Excel file


    Improving Decision Making: Using Pivot Tables to Analyze Sales Data

    Software skills: Pivot tables

    Business skills: Analyzing sales data

    Use Excel’s PivotTable to help you answer the following questions:

    •Where are the average purchases higher? The answer might tell managers where to focus marketing and sales
    resources, or pitch different messages to different regions.

    •What form of payment is the most common? The answer might be used to emphasize in advertising the most
    preferred means of payment.

    •Are there any times of day when purchases are most common? Do people buy products while at work (likely
    during the day) or at home (likely in the evening)?

    •What’s the relationship between regions, type of product purchased, and average sales price?
    Exercise 12.2: Web based scenario
    Improving Decision Making: Using a Web-Based DSS for Retirement Planning

    Software skills: Internet-based software

    Business skills: Financial planning

    This project will help develop your skills in using Web-based DSS for financial planning.

    The Web sites for CNN Money and MSN Money Magazine feature Web-based DSS for financial planning and
    decision making. Select either site to plan for retirement. Use your chosen site to determine how much you need
    to save to have enough income for your retirement. Assume that you are 50 years old and plan to retire in 16
    years. You have one dependant and $100,000 in savings. Your current annual income is $85,000. Your goal is to
    be able to generate an annual retirement income of $60,000, including Social Security benefit payments. To
    calculate your estimated Social Security benefit, search for and use the Quick Calculator at the Social Security
    Administration Web site.

    Q1: Use the Web site you have selected to determine how much money you need to save to help you achieve your
    retirement goal.

    Q2: Critique the site—its ease of use, its clarity, the value of any conclusions reached, and the extent to which the
    site helps investors understand their financial needs and the financial markets.

    You might also like