Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Mike wants to determine the impact of different advertising approaches and answer the following questions: a. How many units of Tournament disks should be

image text in transcribed
image text in transcribed
2. Mike wants to determine the impact of different advertising approaches and answer the following questions: a. How many units of Tournament disks should be sold by Word of Mouth in order for this disk type to break even? b. How many units of Supreme disks should be sold by Advertising in order for this disk type to break even? What Excel feature did you use to answer these questions? c. 3. If any of the cell values had changed by working on problem 2 and 3, revert to the original values by clicking Undo. Under the original worksheet values, what should be spent on advertising for each disk type in order to maximize the Net Income for the whole company (i.e., for Disks, Inc.)? The constraints are as follows. The total advertising budget is limited to $15000 and the company wants to spend at least $2000 towards promoting each disk type. But, the company can only make a maximum of 5000 Supreme disks to sell. Mr. Smith also wants none of the individual disk types to make a loss. 0 a. What is the amount spent on advertising for each disk type? b. What is the number of units produced to cover demand for High Flyer disks? c. What is the net income for Tournament disks? d. What is number of units sold based on advertising for Supreme disks? e. What Excel feature did you use to answer these questions? Important Final Step to Get Credit: Complete your work by the deadline and upload Word document and the Excelfile through the appropriate Canvas link. The submission is due by end of day. Friday, 11/11/2016. Remember, the files have to be named as specified in this document to get credit for this assignment. No exceptions the

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