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 profit over a 3-year period. I need step by step solution please

Expert Solution

Answer

Rahul Sunny answered 2 years ago

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...

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...

Tsypkin Company's budgeted sales quantity was 80,000 units of product. The company's accountant, using regression analysis,...

Tsypkin Company's budgeted sales quantity was 80,000 units of product. The company's accountant, using regression analysis, applied the following cost formula to estimate costs at the master budget level for this year: Total cost = $500,000 + ($5.20 × units produced and sold). The product had a budgeted selling price of $15.20 each. During the year, the actual sales were 82,000 units and selling price was $15.15 per unit. The actual variable costs were $418,200 and the fixed costs were...

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...

Lies Inc. prepared the following report for the first quarter of this year: Sales (2,500 units...

Lies Inc. prepared the following report for the first quarter of this year: Sales (2,500 units @ $2,800 per unit) $7,000,000 Less: Cost of Goods sold $3,840,000 Gross Margin $3,160,000 Less: Selling Expense $1,024,000 Administrative Expense $1,000,00 $2,024,000 Income $1,136,000 Lie’s controller, Billy Baroo, studied the costs in detail, particularly focusing on cost behaviour. Her analysis revealed the following: Sixty-five percent of the cost of goods sold was variable with respect to the number of units. Of the selling expenses,...

Question