Purchase Solution

Decision Models using Excel

Not what you're looking for?

Ask Custom Question

Decision Support Systems allow us to analyze complex relationships and to examine what if situations. Excel is an excellent tool for performing this type of analysis. In this assignment you will use Excel to solve basic quantitative analysis problems based in Linear Programming, Network Analysis, and Work Assignment.

Use Microsoft Excel to analyze decision making problems from the writeup below. Complete the assignment and upload your files here. You should turn in an Excel file with each problem on a separate worksheet. Label each worksheet in the file with the problem number (i.e. 3.3.1, 3.3.2, etc.)

Attachments
Purchase this Solution
Solution Summary

Decision Models using Excel

Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

View More Free Quizzes
Related BrainMass Solutions

  • Multiple Regression Models Using Excel

    214005 Multiple regression models using excel for Beta Technologies Inc Multiple regression models using excel Managers at Beta Technologies, Inc., have collected current annual salary figures and potentially related data for a random sample of 52

  • Monte Carlo and Crystal Ball

    Excel solver is presented below: Figure: 2 Approach to Incorporate Uncertainty in Decision Models Sensitivity analysis is an approach that can be used to consider in any decision models.

  • Network Flow Models; Supply, Demand, and Transshipment Nodes; Optimization in Excel; Solver

    Network Models; Optimization Problem using Excel add-in Solver This is a problem (5-14) from the textbook by Cliff Ragsdale, "Spreadsheet Modeling and Decision Analysis".

  • Using Linear Programming

    To solve any problem using LP, we begin by defining the decision variables followed by formulating LP model using these decision model. The model is then implemented in excel and then solved using the Solver funtion.

  • Product-Mix Decision Model-Professor Tillerman's Tonic Tea

    This problem builds and solves a quantitative decision model using Excel Solver add-in "Product-Mix Decisions Model" for Professor Tillerman's Tonic Tea. Would help students to build modeling skills in Excel.

  • Financial Analysis: Recent changes in the use of IT

    This solution can automatically import data into Excel 2003 analysis models; this removes the need for data re-entry and reduces the potential for errors. Sophisticated Excel models with numerous worksheets are used by equity analysts.

  • Procter & Gamble Inventory Management System

    The original solution was created using Lotus 1-2-3, but over the years the company has developed a suite of global inventory models using Excel.

  • Capital Budgeting decisions for drug manufacturing company

    See attached file. 1) How would financial managers at a drug manufacturing company use discounted-cash-flow models in their decision-making process?

  • Forecast Analysis

    For the data in the Excel file Baseball Attendance do the following: a. Develop spreadsheet models for forecasting attendance using single moving average and single exponential smoothing. b.

View More Related Solutions