edf40wrjww2CF_PaperMaster:Desc
Met North Energy Corporation: 4 Year Net Profit Projections
The current budget figures for the four year period 1996 - 1999 show a steady
decrease in profits eventually resulting in a loss during the fourth year. The
graph shows the decrease in net profit while gross profit remains virtually
static and expenses increase. After an initial loss during the first year the
figures indicate a healthy profit at the end of the period.
The figures in this graph from the spreadsheet clearly show the long term
benefits gained by the additional $50,000 when it is added to the 1996
advertising budget. Despite a loss of $10,000 in the first year the projected
profit for the 4 year period is $160,500.
The results of the spreadsheet showing both budget options can be reduced to
just one simple graph. This supported by market research would convince
management as to which option to choose.
Met North Energy Corporation Net Profit
Projections
Year 1996 1997 1998 1999
Sales $450,000
$455,000 $455,000 $460,000 Projected Sales $450,000
$523,250 $523,250 $529,000 Cost of Goods ...