Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Tiny Book On Personal Finance Saving And Investing Budget Save Invest Retire

Authors: David S. Shekmer

1st Edition

179576385X, 978-1795763851

More Books

Students also viewed these Finance questions