Aplicatia9 Excel - Instrumente Excel de Sintetizare a Datelor
20141211110651252tutorial Analiza Scenariilor in Excel
10
Monthly Income Statement document.xls Paula Ecklund SC ALFA SRL Scenario Manager Contul de profit si pierdere Scenarii Indicatori Valori UM Variabile Pret/cost redus Pret/cost competitiv Pret/cost ridicat Venit Vânzări (nr. bucaţi) 800 buc. Units_Sold 800 1200 1500 Preţ pe bucata 150 u.m. Price_per_Unit 150 200 250 Venit total 120,000 u.m. Total_Revenue Cheltuieli variabile Producţie (nr. bucaţi) 800 buc. Units_Produced Costuri materiale pe buc 40 u.m./bucMaterial_Cost_per_Unit 40 50 60 Costuri materiale totale 32,000 u.m. Total_Material_Cost Costuri manopera pe buca 15 u.m./bucManufacturing_Cost_per_Unit Costuri manopera totale 12,000 u.m. Manufacturing_Expenses Cheltuieli variabile tot 44,000 u.m. Total_Variable_Expense Cheltuieli fixe Leasing 5,000 u.m. Leasing Cheltuieli cu salariile 45,000 u.m. Salary_and_benefits Cheltuieli cu publicitat 5,000 u.m. Advertisement Cheltuieli administrativ 2,500 u.m. Administrative Cheltuieli fixe totale 57,500 u.m. Total_Fixed_Expense Total Cheltuieli totale 101,500 u.m. Total_Expenses Profit brut 18,500 u.m. Operating_Income
-
Upload
rita-harper -
Category
Documents
-
view
219 -
download
5
description
analiza
Transcript of 20141211110651252tutorial Analiza Scenariilor in Excel
Scenario ManagerSC ALFA SRLScenario ManagerContul de profit si pierdereScenariiIndicatoriValoriUMVariabilePret/cost redusPret/cost competitivPret/cost ridicatVenitVnzri (nr. bucai)800buc.Units_Sold80012001500Pre pe bucata150u.m.Price_per_Unit150200250Venit total120,000u.m.Total_RevenueCheltuieli variabileProducie (nr. bucai)800buc.Units_ProducedCosturi materiale pe bucata40u.m./buc.Material_Cost_per_Unit405060Costuri materiale totale32,000u.m.Total_Material_CostCosturi manopera pe bucata15u.m./buc.Manufacturing_Cost_per_UnitCosturi manopera totale12,000u.m.Manufacturing_ExpensesCheltuieli variabile totale44,000u.m.Total_Variable_ExpenseCheltuieli fixeLeasing5,000u.m.LeasingCheltuieli cu salariile45,000u.m.Salary_and_benefitsCheltuieli cu publicitatea5,000u.m.AdvertisementCheltuieli administrative2,500u.m.AdministrativeCheltuieli fixe totale57,500u.m.Total_Fixed_ExpenseTotalCheltuieli totale101,500u.m.Total_ExpensesProfit brut18,500u.m.Operating_Income
&LMonthly Income Statement&C&F&RPaula Ecklund
Scenario SummaryScenario SummaryCurrent Values:Pret/cost redusPret/cost competitivPret/cost ridicatCreated by NB on 06.11.2012
Modified by useer on 06.11.2012Created by NB on 06.11.2012Created by NB on 06.11.2012Changing Cells:Units_Sold1,2008001,2001,500Price_per_Unit200150200250Material_Cost_per_Unit50405060Result Cells:Total_Expenses135,500101,500135,500170,000Operating_Income104,50018,500104,500205,000Notes: Current Values column represents values of changing cells attime Scenario Summary Report was created. Changing cells for eachscenario are highlighted in gray.
Scenario PivotTable$C$5:$C$6;$C$10 by(All)Result Cells$C$5:$C$6;Material_Cost_per_UnitTotal_ExpensesOperating_IncomePret/cost competitiv135500104500Pret/cost redus10150018500Pret/cost ridicat170000205000
Goal SeekRambursarea unui imprumut: Goal SeekImprumut$100,000.00Numar luni180Rata de dobanda5.00%Plata lunara$790.79
Data TableSC ALFA SRLData TableContul de profit si pierdereIndicatoriValoriUMVariabileData Table cu doua intrariVenitUnits Sold240000.0135500.0104500.0Vnzri (nr. bucai)1,200buc.Units_Sold800160,000109,50050,500Pre pe bucata200u.m.Price_per_Unit900180,000116,00064,000Venit total240,000u.m.Total_Revenue1,000200,000122,50077,500Cheltuieli variabile1,100220,000129,00091,000Producie (nr. bucai)1,200buc.Units_Produced1,200240,000135,500104,500Costuri materiale pe bucata50u.m./buc.Material_Cost_per_Unit1,300260,000142,000118,000Costuri materiale totale60,000u.m.Total_Material_Cost1,400280,000148,500131,500Costuri manopera pe bucata15u.m./buc.Manufacturing_Cost_per_Unit1,500300,000155,000145,000Costuri manopera totale18,000u.m.Manufacturing_ExpensesCheltuieli variabile totale78,000u.m.Total_Variable_ExpenseData Table cu doua intrariCheltuieli fixe104500.0125150175200225250Leasing5,000u.m.Leasing800-9,50010,50030,50050,50070,50090,500Cheltuieli cu salariile45,000u.m.Salary_and_benefits900-3,50019,00041,50064,00086,500109,000Cheltuieli cu publicitatea5,000u.m.Advertisement10002,50027,50052,50077,500102,500127,500Cheltuieli administrative2,500u.m.Administrative11008,50036,00063,50091,000118,500146,000Cheltuieli fixe totale57,500u.m.Total_Fixed_Expense120014,50044,50074,500104,500134,500164,500Total130020,50053,00085,500118,000150,500183,000Cheltuieli totale135,500u.m.Total_Expenses140026,50061,50096,500131,500166,500201,500Profit brut104,500u.m.Operating_Income150032,50070,000107,500145,000182,500220,000
&LMonthly Income Statement&C&F&RPaula Ecklund
