What-if+and+Goal+Seeking

Introduction
[|This short tutorial] will show you how goal seek can be used.

[|Watch this video] to find out how Goal Seek can be used

Task
Yellow Peril Corporation design and develop games for smart phones. The company employ a programmer and a graphic artist. They are planning a new game called "The Haunted Abyss". They have summarised some of the financial information below:

Programmer: £80 per day Graphic artist: £50 per day Office rent: £20 per day
 * Salaries**

Development: 35 days Sale price: 59p
 * Haunted Abyss**

January: 1500 February: 2200 March: 3500
 * Projected Haunted Abyss Sales**

Yellow Peril predict they will make a loss on Haunted Abyss for January to March. How much of a loss will they make?

What-if Analysis
>
 * 1) Use what-if analysis to show the difference in profit/loss if the project takes 30 days instead of 35
 * 1) Use what-if analysis to show the difference in profit/loss if both staff take a pay cut of £25 per day

Goal Seeking
>
 * 1) Use the goal-seeking tool to determine how many sales would Yellow Peril need to make in March in order to break even (assuming sales of 1500 in Jan and 2200 in Feb).
 * 1) Use the goal-seeking tool to determine what price they need to sell Haunted Abyss for in order to break even (assuming the first 3 months sales are 1500, 2200 and 3500).