Breakeven New Product
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Breakeven New Product as PDF for free.
More details
- Words: 94
- Pages: 2
Special Products Co. Break-Even Analysis Unit Revenue Fixed Cost Marginal Cost Sales Forecast Production Quantity FixedCost MarginalCost ProductionQuantity Profit SalesForecast TotalFixedCost TotalRevenue TotalVariableCost UnitRevenue
=Name!$C$5 =Name!$C$6 =Name!$C$9 =Name!$F$7 =Name!$C$7 =Name!$F$5 =Name!$F$4 =Name!$F$6 =Name!$C$4
Data $900 $50,000 $400 300 100
Results Total Revenue $90,000 Total Fixed Cost $50,000 Total Variable Cost $40,000 Profit (Loss) $0 Break-even point
100
Special Products Co. Break-Even Analysis Unit Revenue Fixed Cost Marginal Cost Sales Forecast
$900 $50,000 $400 300
Total Revenue Total Fixed Cost Total Variable Cost Profit (Loss)
$90,000 $50,000 $40,000 $-
Production Quantity
100
Break-even point
100
=Name!$C$5 =Name!$C$6 =Name!$C$9 =Name!$F$7 =Name!$C$7 =Name!$F$5 =Name!$F$4 =Name!$F$6 =Name!$C$4
Data $900 $50,000 $400 300 100
Results Total Revenue $90,000 Total Fixed Cost $50,000 Total Variable Cost $40,000 Profit (Loss) $0 Break-even point
100
Special Products Co. Break-Even Analysis Unit Revenue Fixed Cost Marginal Cost Sales Forecast
$900 $50,000 $400 300
Total Revenue Total Fixed Cost Total Variable Cost Profit (Loss)
$90,000 $50,000 $40,000 $-
Production Quantity
100
Break-even point
100
Related Documents
Breakeven New Product
November 2019 15
New Product
June 2020 13
Breakeven Analysis
October 2019 24
Breakeven Ponderosa
November 2019 18
New Product Dev444
May 2020 21