For a new product, sales volume in the first year is estimated to be 50,000 units...

For a new product, sales volume in the first year is estimated to be 50,000 units and is projected to grow at a rate of 7% per year. The selling price is $100 and will increase by $10 each year. Per-unit variable costs are $22 and annual fixed costs are $1,000,000. Per-unit costs are expected to increase 4% per year. Fixed costs are expected to increase 10% per year.

Develop a spreadsheet model to predict the net present value of profit over a three-year period, assuming a 4% discount rate.

Please include Excel worksheet with all the details.

Expert Solution

orchestra answered 1 year ago

For a new product, sales volume in the first year is estimated to be 80,000 units...

For a new product, sales volume in the first year is estimated to be 80,000 units and is projected to grow at a rate of 4% per year. The selling price is $12 and will increase by $0.50 each year. Per-unit variable costs are $3, and annual fixed costs are $400,000. Per-unit costs are expected to increase 5% per year. Fixed costs are expected to increase 8% per year. Develop a spreadsheet model to calculate the net present value of...

1. For a new product, sales volume in the first year is estimated to be 50,000 units and is projected to grow at a rate of 7% per year.

1. For a new product, sales volume in the first year is estimated to be 50,000 units and is projected to grow at a rate of 7% per year. The selling price is $100 and will increase by $10 each year. Per-unit variable costs are $22 and annual fixed costs are $1,000,000. Per-unit costs are expected to increase 4% per year. Fixed costs are expected to increase 10% per year. Develop a spreadsheet model to predict the net present...

The Marketing Department has estimated sales as follows for the remainder of the year (in units):...

The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 34,000 October 24,000 August 78,000 November 10,500 September 47,000 December 11,000 The selling price of the beach umbrellas is $11 per unit. All sales are on account. Based on past experience, sales are collected in the following pattern: 30% in the month of sale 65% in the month following sale 5% uncollectible Sales for June totaled $297,000. The company maintains finished goods inventories...

5. Skelton Corporation had planned to produce 50,000 units of product during the first quarter of...

5. Skelton Corporation had planned to produce 50,000 units of product during the first quarter of the current year. The company prepared the following budget on May 1: Budgeted (50,000 units) Variable costs: Direct materials used $ 36,000 Direct labor 45,000 Variable overhead 22,500 Fixed costs: Manufacturing overhead 58,500 Total manufacturing costs $ 162,000 - During the first quarter, Skelton produced 60,000 units and incurred total manufacturing costs of $184,000. For the 2 questions, below, asked, show your calculations to...

Question 1: Cost allocation Product A Product B Total sales volume (units) 270 150 420 Revenue...

Question 1: Cost allocation Product A Product B Total sales volume (units) 270 150 420 Revenue $6,000 $36,000 $42,000 Variable costs: direct materials $1,200 $2,400 $3,600 direct labor $2,400 $6,000 $8,400 Contribution margin $2,400 $27,600 $30,000 Fixed costs $25,200 Profit $4,800 a) Allocate the fixed costs between products A and B. Use direct labor dollars as the cost driver. allocation rate=$ per DL$ allocated costs for A=$ allocated costs for B=$ b) Compute the profit margins for products A and B:...

Question 1: Cost allocation Product A Product B Total sales volume (units) 180 100 280 Revenue...

Question 1: Cost allocation Product A Product B Total sales volume (units) 180 100 280 Revenue $3,000 $18,000 $21,000 Variable costs: direct materials $600 $1,200 $1,800 direct labor $1,200 $3,000 $4,200 Contribution margin $1,200 $13,800 $15,000 Fixed costs $12,600 Profit $2,400 a) Allocate the fixed costs between products A and B. Use direct labor dollars as the cost driver. allocation rate=$ per DL$ allocated costs for A=$ allocated costs for B=$ b) Compute the profit margins for products A and B:...

A proposed new investment has projected sales of 15,000 units in year 1 and 20,000 units...

A proposed new investment has projected sales of 15,000 units in year 1 and 20,000 units in year 2. The sales price for both years will be $10 per unit. The project will terminate after the second year. Variable costs are expected to be 50% of sales. Fixed costs will be $25,000 per year. The investment will cost $20,000 and will be depreciated straight line to $0 over the 2 year period. The tax rate is 34% for both years...

CD ONLY Cd with instructional materials Estimated demand 27,000 units 27,000 units Estimated Sales Price $23.00...

CD ONLY Cd with instructional materials Estimated demand 27,000 units 27,000 units Estimated Sales Price $23.00 $38.00 Estimated Cost per unit Direct materials $2.75 3.25 Direct Labor 4.00 7.00 Variable Manufacturing Overhead 4.00 7.25 Fixed moh 3.50 3.50 UNIT Manufacturing cost 14.25 21.00 Additonal devolopment cost 105,000 Based on the given data, compute the increase or decrease in profit that would result if instructional materials were added to the CDs. 2. Should MSI add the instructional materials or sell the...

LearnCo Sales Budget For the Year Ending December 31, 20Y2 Product Unit Sales Volume Unit Selling...

LearnCo Sales Budget For the Year Ending December 31, 20Y2 Product Unit Sales Volume Unit Selling Price Total Sales Basic Abacus 36000 $7 $252,000 Deluxe Abacus 36000 13 468,000 Totals 72,000 - $720,000 LearnCo Production Budget For the Year Ending December 31, 20Y2 Units Basic Units Deluxe Expected units to be sold (from Sales Budget) 36000 36000 Desired ending inventory, December 31, 20Y2 1,000 3,000 Total units available 37000 39000 Estimated beginning inventory, January 1, 20Y2 (1,050) (2,100) Total units...

Revenues generated by a new fad product are forecast as follows year Revenues 1 $50,000 2...

Revenues generated by a new fad product are forecast as follows year Revenues 1 $50,000 2 40,000 3 20,000 4 10,000 Expenses are expected to be 50% of revenues, and working capital required in each year is expected to be 20% of revenues in the following year. The product requires an immediate investment of $40,000 in plant and equipment. Required: a. What is the initial investment in the product? Remember working capital. b. If the plant and equipment are depreciated...

Question