다차원 제품 수익성 및 비용 배분 동적 모델

Create a comprehensive Excel spreadsheet that: 1) Imports raw sales data for [companyName] segmented by [productLine], [salesChannel], and [region]; 2) Inputs both fixed and variable cost data associated with these dimensions; 3) Dynamically allocates overhead costs based on user-defined drivers such as revenue proportion or unit volume; 4) Calculates gross and net profit margins per product and channel; 5) Supports scenario analysis to project profitability changes when adjusting [priceAdjustmentPercent], [costReductionTarget], or sales mix; 6) Visualizes multidimensional profitability via pivot tables and interactive charts; 7) Allows user inputs for forecasting over the next [forecastHorizonMonths] months; 8) Incorporates sensitivity analysis to identify key cost or revenue levers impacting margins; 9) Generates a summary report highlighting best and worst performing [region]s and [productLine]s; 10) Ensures data validation and error handling to maintain model integrity.