Sensitivity Analysis in Microsoft Excel

One of the finest features in Microsoft Excel is sensitivity analysis using either a table (Excel 2003) or 'What-if' in Excel 2007. Suppose you want to start a cybercafe or a restaurant in a new mall. You have done a study on the footfall and the kind of people who visit the mall. You have also found out about the business atmosphere, security and rent or the outright purchase price. You also know the rates in the market that other businesses are charging, let's say, for surfing the net per hour. You then estimate your capital costs like doing up the cybercafe and the price of the computers. You also use the Excel spreadsheet to estimate and calculate the number of people you'll need to run the show and the amount of salaries you'll have to pay. You have also estimated other variable costs like electricity and phone.

From the above data in the Excel worksheet you can calculate your total monthly or yearly costs. Now based on a certain price that you will charge the customers, number of computers and working hours you can calculate your revenue per month or per year. From the data of revenue and income you can easily calculate the profit. Till now everything was easy to implement in Excel.

Movies To Rent

Now you decide to find out how your profit can vary if you vary the charge per hour or the number of people who will visit your cybercafe or establishment. Of course, you cannot charge what you want but you can get a good estimate by observing what others are charging and what quality of service and environment they are providing.

Sensitivity Analysis in Microsoft Excel

Reviews Despicable Me (Blu-ray 3D / Blu-ray / DVD)

Products by : NBC Universal
Model :
Rating Reviews :

Usually ships in 24 hours.

Despicable Me (Blu-ray 3D / Blu-ray / DVD) Details

Despicable Me (Blu-ray 3D / Blu-ray / DVD) Description

“**** This Year’s COOLEST Animated Comedy!” – Jeff Craig, Sixty Second Preview

Get ready for a minion laughs in the funniest blockbuster hit of the year!

Vying for the title of “World’s Greatest Villain”, Gru (voiced by Steve Carell) – along with his hilarious crew of mischievous minions – plots to pull off the craziest crime of the century: steal the moon! But when Gru enlists the help of three little girls, they see something in him nobody else has ever seen: the perfect dad. From executive producer Chris Meledandri (Horton Hears a Who, Ice Age), and featuring the voices of an all-star comedic cast, including Jason Segel, Russell Brand, Miranda Cosgrove and Julie Andrews, Despicable Me is “rousingly funny, heartfelt and imaginative” (Pete Hammond, Boxoffice Magazine).

Despicable Me (Blu-ray 3D / Blu-ray / DVD) Complete

Despicable Me is a compelling animated comedy about an aging supervillain's falling popularity at the hands of a younger supervillain and three young orphan girls. Gru is a true, bad-to-the-core evildoer who's earned the title of the world's No. 1 supervillain. But when young upstart Vector steals the Pyramid of Giza, Gru's status suddenly sinks to No. 2. Gru counters his fall by speeding up his plan to shrink and steal the moon, enlisting the help of his army of minions and the elderly Dr. Nefario, but a lack of funding and the difficulties involved in stealing the needed shrink-ray gun threaten to derail everything. Adopting three young orphan girls is an unlikely, but seemingly effective means to further Gru's evil mission, but Gru quickly discovers that caring for three young girls is more work, and distraction, than he could ever have anticipated. What unfolds is an unexpected shift in attitude that will forever change the lives of Gru, Vector, and all three young girls. A visually appealing film produced by Chris Meledandri (Ice Age, Ice Age 2: The Meltdown, and Horton Hears a Who), Despicable Me is full of weirdly shaped characters and settings that are somehow a perfect fit for Sergio Pablos's story. What's especially refreshing is that in this film, 3-D effects are used skillfully and effectively: even when the effects are exploited for comic reasons, they don't become a distraction, as is all too common in many recent movies. The film is full of corny banter and silly antics that inspire plenty of spontaneous laughter, and the minions, while not the best-developed characters, sure are comical. Ultimately, there's also a wholesome message about following one's heart. Steve Carell is the perfect villain-gone-soft in his role as Gru, Jason Segal is quite funny as Vector, and Julie Andrews makes a surprising appearance as Gru's very un-motherly mom. The story isn't new, the humor is relatively juvenile and somewhat forgettable, and it's no Toy Story 3, but Despicable Me celebrates silliness in a way that's satisfying and highly entertaining. (Ages 6 and older) --Tami Horiuchi

In Stock. at Amazon Do it Now!

*** Product Information and Prices Stored : Apr 17, 2012 15:35:22

Arranging all your data properly, click on 'Data' in the ribbon in Microsoft Office 2007 or 'Data' in the menu bar in Excel 2003. In Excel 2007 select 'What-if' analysis and finally 'Data Table...'. In the popup window in the 'Row input cell' type the data that you have input horizontally next to the profit and in the 'column input cell' write down the price and vary it it by 1% 0r 2% so that that Excel can perform an analysis for, say., .5 per hour charge for a cybercafe to .5 per hour. The horizontal values can be the number of people per hour or month or year that will visit the shop and keep on varying the values by a certain estimated percentage. Click 'OK' and you can see how your profit varies with the number of customers and the price you charge. This is also known as a two variable table because you calculated the changes in your profit based on two parameters - price and number of customers.

You can also do a single variable sensitivity analysis by selecting only one parameter.

You can use the 'Data' and 'Table' feature in Excel 2003 to implement the same analysis.

The practical implementation of the above sensitivity analysis in the form of a training video can be found in the link below.

Sensitivity Analysis in Microsoft Excel