Spreadsheet simulation using Excel
Not what you're looking for?
The owner of Carlo's Computers is planning a 7-day promotion (Sunday-Saturday) to launch a new PC called "PCLink1000." *The shop owner is pricing these PC's at $675 each, and he buys them for $425 each. *He must buy in bundles of 25 sets. *At the end of the promotion, the distributor will buy any unsold PC's back for $350 each. *Demand is uncertain, but Carlo has gathered the following daily demand estimates
Computers Demanded Daily Probability
0 12%
1 22%
2 28%
3 22%
4 10%
5 6%
PROBLEM: How many TV's should Carlo buy so as to maximize profits?
We MUST use Excel's simulation/optimization capabilites. Or, we can use an add-in to Excel called Crystal Ball/OptQuest.
(see attachment).
Purchase this Solution
Solution Summary
Uses Excel for simulation.
Solution Preview
The owner of Carlo's Computers is planning a 7-day promotiuon (Sunday-Saturday) to launch a new PC called "PCLink1000." *The shop owner is pricing these PC's at $675 each, and he buys them for $425 each. *He must buy in bundles of 25 sets. *At the end of the promotion, the distributor will buy any unsold PC's back for $350 each. *Demand is uncertain, but Carlo has gathered the following daily demand estimates (see attachment).
PROBLEM: How many TV's should Carlo buy so as to maximize profits???? We MUST use Excel's simulation/optimization capabilites. Or, we can use an add-in to Excel called Crystal Ball/OptQuest.
Step 1: Create the cumulative probability table and ...
Purchase this Solution
Free BrainMass Quizzes
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.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce