Publisher's Synopsis
Microsoft Excel is and remains an indispensable tool for anyone involved in analyzing and reporting the data. Often, though, just those who use it daily continues to do things the same way without wondering if there is a faster way to get the result with a higher quality and precision, greatly increasing the productivity of both personal and corporate.The manual shows the multiple functions of CONTROLLOPLUS software platform built on Excel, proposing a management control model replicable in very different contexts.In the first four chapters describe the objectives of a management control system and techniques to implement it.The chapter 5 shows the use of CONTROLLOPLUS in a real case.CONTROLLOPLUSproduces a monthly management control system for product and cost centers. The software provides the definition and subsequently Budget (per month) to Actual Sales, Costs of Trade, Costs of Production, Purchasing, Personnel, Investment.The software processes the monthly report related to:1.revenue,2.gross margin and net,3.mix by product, 4.cost of goods sold,5.budget of indirect costs to cost centers, 6.Statement, Balance Budget, 7.Analysis of Needs / Covers,8.Analysis of Cash Flows, 9.Balance Sheet and the main indicators of solidity, liquidity and profitability. Finally, the software provides for the Analysis of Variances Budget / Actual quantity and value for -Sales by product-Production Direct costs per product, -analysis of variances for product Margin-analysis of variances in value of Indirect costs for each cost center.The text is updated to Excel 2007.