Question
Breakdown on excell- Monster Inc. markets personal computer games through a variety of retail outlets. Presently, Monster is faced with a decision as to whether
Breakdown on excell-
Monster Inc. markets personal computer games through a variety of retail outlets. Presently, Monster is faced with a decision as to whether it should obtain the distribution rights to a new technology for personal computer gamers The new game consists of the Daytona 500 game CD, driver seat pad, and control unit with cable (one of each is required per computer to play the game). The retailers margin will be 30%. Other data available are as follows: Hot Stuff Daytona 500 Software License (per year).......................................$350,000 Annual interest payments................................................................................ $100,000 Annual Overhead (per year) .............................................................................. $50,000 Annual Advertising and promotion...........................................................................$60 Royalties for Daytona 500 Game (per CD)............................................................ $10 Control Unit and Cable (per unit)................................................................................ $5 Material & Labor for Seat Pad (per pad).......................... First 3 digits of your Banner ID The suggested retail price is the last three numbers in your Banner ID number. If value of last three numbers is less than 100, multiple the last three digits of your ID by 10. The Material and Labor cost are the first 3 numbers in your Banner ID (ignoring the @ symbol). For example, your Banner ID # is: @01565426, then the retail price is last 3 digits or $426 and Material cost is first 3 digits or $15. @01750043, then last 3 digits are 043, which is less than 100, so multiple by 10 to get retail price. Retail price is $430 and Material cost is first 3 digits or $17 Answer the following questions: 1) What is your Banner ID? 2) What is the price at which Monster must sell to the retailers? 3) What is VCIs unit contribution? 4) What is the break-even point in units? MUST SHOW WORK FOR CREDIT
Sun Microsystems, is a manufacturer of mid-size computers, which are primarily used by medium and small businesses. Sun Microsystemss product line currently consists of three models of mid-size computers.
The following data are available regarding the models: Model Selling Price per Unit Variable Cost per Unit Demand/Year (units)
Model SMX1 $1,800 $1,000 2,500
Monster Inc. markets personal computer games through a variety of retail outlets. Presently, Monster is faced with a decision as to whether it should obtain the distribution rights to a new technology for personal computer gamers The new game consists of the Daytona 500 game CD, driver seat pad, and control unit with cable (one of each is required per computer to play the game).
The retailers margin will be 30%. Other data available are as follows:
Hot Stuff Daytona 500 Software License (per year).......................................$350,000
Annual interest payments................................................................................ $100,000
Annual Overhead (per year) .............................................................................. $50,000
Annual Advertising and promotion...........................................................................$60
Royalties for Daytona 500 Game (per CD)............................................................ $10
Control Unit and Cable (per unit)................................................................................ $5
Material & Labor for Seat Pad (per pad).......................... First 3 digits of your Banner ID
The suggested retail price is the last three numbers in your Banner ID number. If value of last three numbers is less than 100, multiple the last three digits of your ID by 10. The Material and Labor cost are the first 3 numbers in your Banner ID (ignoring the @ symbol).
For example, your Banner ID # is:
@01565426, then the retail price is last 3 digits or $426 and Material cost is first 3 digits or $15.
@01750043, then last 3 digits are 043, which is less than 100, so multiple by 10 to get retail price. Retail price is $430 and Material cost is first 3 digits or $17
Answer the following questions:
- 1) What is your Banner ID?
- 2) What is the price at which Monster must sell to the retailers?
- 3) What is VCIs unit contribution?
- 4) What is the break-even point in units
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