Question
A student in the Entrepreneurship program is looking for investors for his start-up company called Time4Treats. Time4Treats is a camera and contraption that tosses treats
A student in the Entrepreneurship program is looking for investors for his start-up company called Time4Treats. Time4Treats is a camera and contraption that tosses treats to your pet using an app on your phone. You must decide whether or not you believe this will be a good investment. Recent sales predictions for Time4Treats is as follows:
Units Sold | Probability |
2500 | .25 |
5000 | .55 |
9000 | .20 |
Fixed costs for the production is Normally Distributed with a mean of $225,000 and a standard deviation of $35,000.
Variable cost is $29 per unit and the selling price is $79.
a) Set up this simulation in Excel and calculate the net profit for each trial. Run 50 trials of the simulation. Find the average net profit for the 50 trials.
b) Given the uncertainty in the demand and the fixed costs for this investment and the inherent risk in investing in this company, based on your analysis, is this a good investment, why or why not?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started