Create a break-even chart in excel from a variable data range
$30-250 AUD
完了済み
投稿日: 8年以上前
$30-250 AUD
完了時にお支払い
The attached file contains:
1. A worksheet with a picture of a chart
2. A worksheet where data will be shown (currently just shows headings)
3. A worksheet where any calculations used to populate the chart would be shown and documented
The data sheet will be populated with content from another application, under the headings shown at the top of this worksheet. The number of records within the content will vary significantly, and could be greater than 10,000 records, so a range based on a fixed number of cells should be avoided.
I would like to replace the picture of the chart with an excel-based chart, generated from data in the data worksheet. The format of the chart should be the same as the current picture. Also the values calculated for total fixed cost, variable cost, break-even sales etc, should be shown in the cells next to the chart as set out in the attached.
Note that the calculation and chart is a little different from traditional break-even analysis, which tends to show units sold, rather than sales value. The source data for variable cost will be cost per $ revenue, rather than cost per unit
Experienced MBA finance and an expert in Excel, excel functions, pivot tables, graphs , charts, BI analysis.
I can create the break-even chart in excel . I already created a tool for BI analysis for raw data on Forex market. I can work on your project and can provide your the chart exactly in excel with calculations.