We are supposed to do this for 2 different variability assumptions:Īll components are normally distributed with a mean equal to the value given, and a std. With these defined costs, we are supposed to apply a Monte Carlo Simulation using Crystal Ball to find basically the lowest cost combination of components to meet the specifications (The output voltage needs to be within 3% of its baseline value (7.724V), 96.5% of the time). Here is the general Excel table I've made for pricing. The voltage source can have any tolerance, and its pricing is computed as: cost = $10 / tolerance^2 (e.g. The lower the tolerance, the more expensive the resistor ($200, $350, $550, and $1200 respectively). Each resistor can have one of 4 tolerances: 10%, 5%, 1%, or 0.1%. Before I ask for help, I want to provide some context and see if this is the appropriate subreddit.įor my class, we are creating a cost analysis for a mock circuit board that has 10 components: 1 voltage source and 9 resistors.
0 Comments
Leave a Reply. |