Excel Scenario Manager Tool Los Angeles CA

provided by: 
Originally published at Internet.com

As a business owner you spend a lot of your decision-making time comparing different business scenarios. It might be the cost of a new product, tweaking budget figures, or it might be comparing different leases or products you're considering purchasing.

Regardless of what you're calculating you want to compare different solutions to determine which is best for you. Excel is a handy tool for analyzing different scenarios, and its Scenario manager tool helps you manage the task of comparing options side-by-side. Create a Worksheet Model
To use the Scenario tool you first need to create a spreadsheet with formulas that make calculations that you'll use as the basis for your analysis. This type of worksheet is typically called a model, and it is here that you will enter the numbers for each of the items you are comparing.

The example we'll use is a product-pricing calculator that calculates the total unit price of items purchased taking into account bulk discounts, sales tax, and shipping and handling costs. This calculator is a useful way to calculate and compare like products that come in different quantities and come from different suppliers.

The worksheet contains cells into which you place information and cells that make calculations - each is differently colored. If you're interested in creating this worksheet yourself so you can follow along with the article, here are the cells and their contents: Cell Number Cell Contents B2 Product Pricing Calculator B4 Product B5 Supplier B6 Number in box B7 Price per box B8 Price per unit B9
Boxes for discount B10 Bulk discount B11 Savings per unit B12 Discounted unit price B13 Discounted box price B14 Boxes required B15 Number of items purchased B16 Total box price B17 Sales Tax B18 Shipping and Handling B19 Total shipping price B20 Total per unit price(inc ship&tax) C8 =C7/C6 C11 =C8*C10 C12 =C8-C11 C13 =C12*C6 C15 =C14*C6 C16 =IF(C14 C19 =(C16*(1+C17))+C18 C20 =C19/(C6*C14)