Define roster schedules and automatically calculate associated wage costs for staff, Area, and Department by day and week. A base wage and up to six additional wage loadings are definable while Department, Area and staff can be configured to suit almost any business strucure and size. Wage classifications, and staff can be freely added with two staff work periods per day to accommodate split shifts. Standard Excel print functions are available.
Build a roster to your specifications, allocate staff automatically, and generate a printable roster, all at the click of a button. Compact and user friendly with default values for ease of use. You can set maximum hours worked, maximum continuous hours, minimum break, maximum days worked in a row, and force a Yes or No work status. Print an easy to read schedule table and quickly build consecuative rosters. Full operational instructions.
Calculate the optimum number of customer service staff to minimise your costs. Determine the number of customers waiting, average waiting time, and service staff utilization. Review the impact of changes in service point numbers on total costs. The model considers customer arrival and service rates, the cost of service staff, and the loss of profit contribution due customer waiting time (dissatisfaction).
Apply your QuickBooks Profit and Loss data to a flexible and easy to read Excel layout with the capacity to automate budget creation. The Budget Compiler allows you to select the amount of detail displayed and use the data for performance review and budget formulation. The created budget can be imported to the Quickbooks budget. This enhances budget development, and provides significant time saving in performance reviews and budget creation.
Import your monthly MYOB Profit and Loss data to a flexible and easy to read Excel layout with the capacity to automate budget creation. The PL Compiler allows you to select the amount of detail displayed and use the data for performance review and budget formulation. It improves understanding of business operations, enhances budget development, and provides significant time saving in performance reviews and budget creation.
Calculate the Product or Service Mix that maximizes overall profit. Up to six unique outputs can be handled with ten specific resource inputs. Outputs are the result of any process including manufactured items and the provision of services. Resources are anything needed to produce or provide the output i.e materials, labor, machine time etc. The model considers the resource demand, profit contribution and any minimum or maximum requirements.
Identify the true costs and profits associated with your products and suppliers. This software is suitable for all resale business operations regardless of size. It allows you to build a complete product/supplier database with cost, profit, and sensitivity analysis for each profile, each supplier and the Total Business. From this you can critically compare suppliers and products to determine true profit contributions.
The Business Valuation Model Excel combines relative indicators for future performance with basic financial data to value any business. This valuation method can be used for business purchase, sale, or establishment. The model uniquely applies your intuitive business and market knowledge to provide a 3 year forecast with sensitivity analysis, investment return, and a business valuation. Easy to use and interpret.