Reference no: EM132951137
A colleague recently approached you about investing in a start-up that has developed a doggie camera that tosses treats to your pet using a phone app. You are trying to determine whether or not you should invest in this trendy product that has recently hit the market. Recent estimates of the financial data for the doggie camera / treat tosser sales show the following information:
Units Sold Probability
3500 0.35
6000 0.45
9500 0.20
?Fixed costs for the production is Normally Distributed with a mean of $210,000 and a standard deviation of $35,000.
Variable cost is $29 per unit and the selling price is $89.
a) Set up this simulation in Excel and calculate the net profit for each trial. Run 25 trials of the simulation. Find the average net profit for the 25 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?
HINT: For each trial, you will need to simulate two random numbers -- one for units sold and one for fixed costs. You can either use the RAND() function or the Random Number Generators. Type your response to part (b) on your Excel sheet. Upload the completed Excel file here.
|
How much loan would Mr Kamlon ask
: How much loan would Mr. Kamlon ask for, if he needs P2,500 cash which will be repaid in 1 year and 3 months with 5 4/5% simple discount
|
|
Calculate the multi-factor productivity
: Calculate the multi-factor productivity for this operation in fees generated per dollar of input.
|
|
Develop an effective occupational safety
: Develop an effective Occupational Safety and Health management system and how to implement it
|
|
Discuss what Razwan should implement to protect the security
: By using a time-based model, discuss what Dr. Razwan should implement to protect the security of the information from unauthorized access
|
|
Calculate the net profit
: A colleague recently approached you about investing in a start-up that has developed a doggie camera that tosses treats to your pet using a phone app. You are t
|
|
What budget is to come to mind as the starting point
: What budget is to come to your mind as the "starting point" in preparing the master budget? What may result if this budget is inaccurate?
|
|
Establish goals for an organization
: Explain how you would, as a leader, establish goals for an organization.
|
|
Should the company make or buy the timers
: If there was no other alternative use for the facilities that is currently used to produce the timers, should the company make or buy the timers?
|
|
What amount of unrealized loss should be reported
: On January 01, 2016, Dumag Company purchased bonds with face amount of P 4,000,000 for P 4,206,000. What amount of unrealized loss should be reported
|