Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Frisbees for Lithuania You are the product manager for a Frisbee manufacturer, and you are analyzing new markets for your products. Based on your
2. Frisbees for Lithuania You are the product manager for a Frisbee manufacturer, and you are analyzing new markets for your products. Based on your market research for the Lithuania, you estimate that the market for Frisbees in that region will be 50,000 units for 2011,60,000 units for 2012, and 70,000 units for 2013 . You project that your selling price will be $5 per Frisbee for 2011-2013. The variable cost for making each Frisbee in 2011 will be $2, and that this cost will grow by 5% per year. The fixed cost for entering the market (including opening an office, hiring sales staff, paying licensing fees, etc) is estimated at $100,000 based on current currency exchange rates. Based on these estimates and projections, create a spreadsheet model to estimate costs, revenues, and profits for 2011,2012, and 2013. In building this model in Excel, please keep in mind the concepts covered in class about how to effectively design and engineer a spreadsheet model for current and future use by others. Also note that many of the model inputs are uncertain (we will revisit this model when we discuss model analysis techniques)
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