I want to do forecasting of volumes for a transaction processing business, how and what tool can i use?
398467
Not sure how detailed the volumes forecast has to be.\n\nI have created a few models in Excel and have also purchased a modeling tool.\n\nThe tool parameters depend on what industry you're in, and what period of growth are you forecasting.  One day, a week, a month, etc.\n\nFirst of all, if you have historical data, you can do a simple Excel model that trends the data.  If the volume is similar on given days, then the model could put the average volume in one column (A), and the average growth in another column (B).  The most recent historical volume could be in the third column (C).  Column D could have a formula that takes C * (1 + (B/A)).\n\nOtherwise, you can purchas a model similar to ProfitStars http://www.manageforperformance.com.
739955
Try SAP BW for free here:\n\nhttp://erp.wu-wien.ac.at/sapbw/01_index.htm
111356
Try using Yahoo Small Business.  They will help you with web hosting as well as facilitate transactions.
990889
If you are starting up a self storage business, then I suggest you get an accounting program like quickbooks which is easy to use and to set up. On quickbooks they have a chart of accounts already set up all you have to do is either change some of the accounts to what you want to call them or use the ones that they have. I hope this is what you was asking for.
524531
Check out Peachtree software. It maintains employee payroll, inventory, accounts payable / receivable, and a lot more.
789189
1\n\nIn the future, this site is excellent.\n\nhttp://www.onlineconversion.com/volume.htm
237555
Load Forecasting, as is self evident, is simply forecasting the load that will be demanded at a particular time. let me draw you an analogy:\n\nSuppose you run a restaurant that serves fresh fish (sushi maybe) and crushed ice slushes, and to complicate things, you do not have  a freezer. you need to get your fish and ice from stores across town and cant store them for long. In what quantities would you buy your supplies to squeeze the maximum profit from your business?\n\nWhat you need is an accurate demand prediction system. If you know exactly that 20 people are going to order fish and 9 people slushes today at lunch, you can get the exact amount of supplies. you would do well if you had some ball park figures that are close, though not perfectly correct. You would do good to know factors like: today is extremely hot, you would sell more slushes. there was an article in the newspaper today about fish in the town being contaminated with mercury, sale today will be half of what it was today.\n\nI hope the analogy helps make the need for forecasting clear. the "no freezer" part is important because we have no effective way of storing excess elecrical power. If the power demand goes above rated online generation capacity at any given time, the grid becomes unstable and there is a danger of a brown out or even a black out. Keeping generation capacity online without demand is a waste of resources. It is ideal to keep the capacity slightly above current demand.\n\nNow imagine you had a mathematical model into which you can feed all your parameters and churn out the exact prediction of the demand.. that might actually be possible if the system was simple. like your one outlet restaurant. now imagine you run a chain of stores across the town, in neighbouring towns and neighbouring states too. Almost impossible to model mathematically.\n\nthis is where neural networks and fuzzy logic step in. you show a neural network how the demand had been varying over the lasf few years, while also showing it the variation in factors that you think influences the demand, and the network eventually "learns" the model and can predict with resonable accuracy what the demand might be, so I can be prepared by bringing in the required amounts of generation capacity online.\n\nhere is a website that talks about employing neural networks for load prediction\nhttp://ceaspub.eas.asu.edu/PowerZone/LoadForecast/Forecasting technics.htm\n\nHere are some relevant publications\nhttp://neuron-ai.tuke.sk/competition/reports/DaliborZivcak.pdf\nhttp://neuron-ai.tuke.sk/competition/reports/ZviBoger.pdf\nhttp://www.actapress.com/PDFViewer.aspx?paperId=19022\nhttp://www.imi.aau.dk/~msk/publications/LFANN-CIMCA2005.pdf\nhttp://doi.ieeecomputersociety.org/10.1109/ICHIS.2004.27\nhttp://www.ewh.ieee.org/ecc/r10/Tencon2003/Articles/500.pdf
81910
The inventories of finished goods or raw material can be planned by forcasting the demand/sales of your finished goods. Now once you have this data and you know the ordering/delivery times, you can plan/manage inventory. To get a better management handle, use of statistical techniques is strongly recommended.
761602
This type of report is not one that is automatically generated by most accounting software, nor is it one that is normally produced by your accountant, but it is an important analysis for you to have and understand. For any new business, you should predict what gross sales volume level you will have to achieve before you reach the break-even point and then, of course, build to make a profit. For early-stage businesses, you should be able to assess your early prediction and determine how accurate they were, and monitor whether you are actually on track to make the profits you need. Even the mature business would be wise to look at their current break-even point and perhaps find ways to lower that benchmark to increase profits. The recent massive layoffs at large corporations are directed at this goal, lowering the break-even point and increasing profits. \n\n\n*Break-Even Is the Volume Where All Fixed Expenses Are Covered*\n\nYou will start a break-even analysis by establishing all the fixed (overhead) expenses of your business. Since most of these are done on a monthly basis, don’t forget to include the estimated monthly amount of line items that are normally paid on a quarterly or annual basis such as payroll taxes or insurance. For example, if your annual insurance charge is $9,000, use 1/12 of that, or $750 as part of your monthly budget. With the semivariable expense (such as phone charges, travel, and marketing), use that portion that you expect to spend each and every month. \n\nFor the purpose of a model break-even, let’s assume that the fixed expenses look as follows: \n\nAdministrative salaries     $1,500\nRent     800\nUtilities     300\nInsurance    150\nTaxes     210\nTelephone     240\nAuto expense     400\nSupplies     100\nSales and marketing     300\nInterest     100\nMiscellaneous     400\nTotal     $4,500\n\nThese are the expenses that must be covered by your gross profit. Assuming that the gross profit margin is 30 percent, what volume must you have to cover this expense? The answer in this case is 15,000—30 percent of that amount is $4,500, which is your target number. \n\nThe two critical numbers in these calculations are the total of the fixed expense and the percentage of gross profit margin. If your fixed expense is $10,000 and your gross profit margin is 25 percent, your break-even volume must be $40,000. \n\n\n*This Is Not a Static Number*\n\nYou may do a break-even analysis before you even begin your business and determine that your gross margin will come in at a certain percentage and your fixed expense budget will be set at a certain level. You will then be able to establish that your business will break even (and then go on to a profit) at a certain level of sales volume. But your prestart projections and your operating realities may be very different. After three to six months in business, you should compare projections to the real-world results and reassess, if necessary, what volume is required to reach break-even levels. \n\nAlong the way, expenses tend to creep up in both the direct and indirect categories, and you may fall below the break-even volume because you think it is lower than it has become. Take your profit and loss statement every six months or so and refigure your break-even target number.\n\n\n*Ways to Lower Break-Even*\n\nThere are three ways to lower your break-even volume, only two of them involve cost controls (which should always be your goal on an ongoing basis). \n\n1. Lower direct costs, which will raise the gross margin. Be more diligent about purchasing material, controlling inventory, or increasing the productivity of your labor by more cost effective scheduling or adding more efficient technology. \n\n2. Exercise cost controls on your fixed expense, and lower the necessary total dollars. Be careful when cutting expenses that you do so with an overall plan in mind. You can cut too deeply as well as too little and cause distress among workers, or you may pull back
341991
A business projection could mean several things and in varying degrees of complexity, so you really should ask your professor for more details. It could be a cash flow projection, a profit & loss projection, a marketing projection, etc.\n\nI'd think he/she is looking for a spreadsheet that tells how you plan to grow your business, when you'll be spending money, when you'll be making money. For example, if you plan to use resources/money in the first year to build and market your megaplex theater, you'll be bleeding money at that time. But once you launch the product, you'll be taking in money slowly and evetually break-even in some point in the future (hopefully) and then steadily be making money after that break-even point (again, hopefully).\n\nIf you're writing a business plan, usually you'd want to provide monthly forecasts for the first 24 months, then quarterly forecasts for years 3-5.
881584
For a small business you could either simply use an excel sheet, where u divide up the columns you need and use the calculation symbols for ease of any calculations. You can sum up, subtract etc easily. Just use the help/office assistant in Microsoft excel.\n\nAlternatively use SQL database system, you can get a person trained in software to create an sql system for you which will be quite easy to use and help in costs and all other functions for your data.
166806
use query to create sum of quantities...
55373
you have a number of options depending on your financial \n\n1) read lots of books I've listed a couple below from my personal library\n\nThe Data Warehouse Lifecycle Toolkit by Ralph Kimball gives you a good basic knowledge of datawarehousing.\n\nOnce you understand the concepts of datawharehousing you just have to know oracles syntax, so any decent dba books are good (i prefer the oreily series)\n\nAlso Oracle SQL Tuning Pocket Reference by Mark Gurrey is pretty usefull for speeding the whole wharehouse up.\n\n2) Attend a few of the oracle education courses. I havent attended one for a few years but they were verry usefull when I was learning. Go to the oracle site for more info on that. \n\nThe ideal solution is to do both but 2) is expensive  and one more bit of advice - learn the concepts before you touch oracle, and remember that your first attempt will be naff.\n\nremember that the only thing that will make you an expert is to know the majority of the stuff - and of course to have at least 5 total disasters under your belt
735575
Try this one -\nhttp://www.datapigtechnologies.com/
1120670
ok, going from memory\n\n\nc)analyze business transactions\ne) journalize\ni) post to ledger accounts\nd) prepare a trial balance\nh)journalize and post adjusting enteries\nb) prepare an adjusted trial balance\nf)journalize and post closing enteries\na) prepare a post closing trial balance\ng)prepare financial statements
350481
If you want to keeps your costs low.  Then you'll probably be using PHP and MySQL, or possibly Postgres.  The last two are the database programs to store your data.
592461
This takes a long time and the experience of someone who understands databases.  You will save time and money by using Microsoft Small Business Accounting, Quicken's Quickbooks, or Peachtree Accounting.