Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SOLVE BY EXCEL PLZ Tomas Jone is the investment manager at the High Moon Feet which is a famous company specialist in sport shoes and

SOLVE BY EXCEL PLZ

image text in transcribed

Tomas Jone is the investment manager at the High Moon Feet which is a famous company specialist in sport shoes and other sport equipment's in Western Asia. Jone needs your help to support his decision regarding the company investments. The strategic assumptions regarding the company project necessitate the development of two planning models. The first one is a tentative plan for years (2016-2020) which will be used to estimate the price and the fixed cost. The second plan (years from 2021 to 2025) will be the actual model which will help the manager to take a decision. 1- The following are some assumptions provided by the manager to help you in developing the tentative model: a. At price $30, demand was 1600 units. With each $1 increase in the price, 8 units will be decreased from the company demand. b. The following UNIT 500 800 1000 1200 2000 COST 7000 32500 36700 41000 43280 c. The unit selling price is $70 and is expected to grow at 12% per year d. Fixed cost is $2300 and is expected to be grow at 15% per year

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Finance questions