Excel for decision support modeling

Assignment Help Database Management System

Reference no: EM13762930

Using EXCEL for Decision Support Modeling

Introduction

Willy Wonka is considering starting a production line to produce fizzy lifting drinks. As Chief Oompa Loompa (COL) you have access to a wide variety of financial data to help you determine whether bringing the new production line on will be a smart investment or not.
In this exercise you will create a decision-support model.

This assignment will be a bit more of a challenge than previous assignments, but it relies on the basics you learned in the previous lessons, especially the creation of formulas.

Organization of the DSS Model

As you learned in the previous lessons, it is always good practice to separate constant data from your calculations and inputs. In this exercise, your spreadsheet will have the following major sections: constants, inputs, summary of key results, calculations (new product line) and calculations (no new product line). The spreadsheet will also have other sections that will be described in greater detail later.

Attachment:- EXCEL_DECISION.docx

Reference no: EM13762930

Questions Cloud

A destabilizing mutation and stabilizing mutation : 1-Suggest a destabilizing mutation and stabilizing mutation to helix 201-216. Briefly explain why your proposed mutations are predicted to be destabilizing and stabilizing, respectively. Provide pictures of your two mutant proteins

Find the new portfolio beta : Assume that you manage a $10.00 million mutual fund that has a beta of 1.05 and a 9.50% required return. The risk-free rate is 2.20%. You now receive another $4.50 million, which you invest in stocks with an average beta of 0.65. What is the required..

Consumer sentiments in a positive direction : Do you know what are some active ways the government tries to turn consumer sentiments in a positive direction when the forecast on the news and in the actual economy looks bleak?

Assume no other income and taxes during retirement : Amanda is expected to receive full social security retirement benefit of $15500 annually when she turns 65. These benefits can be increased by 40% if she delays taking them till age 70. If her life expectancy is 90 years and expected rate of return i..

Excel for decision support modeling : Willy Wonka is considering starting a production line to produce fizzy lifting drinks. As Chief Oompa Loompa (COL) you have access to a wide variety of financial data to help you determine whether bringing the new production line on will be a sma..

Program takes input from a user in the form of a phrase : This program takes input from a user in the form of a phrase. It then converts the phrase to ig latin.

Define a structure type : Define a structure type to represent a single CD. The year must be stored as an integer, all other fields should be strings. Because memory space will be an issue you may not assume a length for the string fields, but must dynamically allocate app..

Leverage measure and about common stock : Which one of the following statements about common stock is true? Substituting EBITDA for EBIT when computing the times interest earned ratio will make the company appear. Which one of the following is a leverage measure?

Current labor cost per car sold : Suppose that a car dealership wishes to see if efficiency wages will help improve its salespeople's productivity. Currently, each salesperson sells an average of one car per day while being paid $20 per hour for an eight-hour day.

User Account

All Pages