| 127 |
Headcount and Payroll Plan
This template is prepared for planning number of employees and their salaries quarterly for different departments. Department names and job titles are editable. In addition to salaries, Fringe Benefit, compensations and variable pays by departments are also evaluated. On a secodary sheet, a dashboard is provided. SpreadsheetWEB version of the template allows to use, save and publish the template online.
|
| 287 |
Hotel Dashboard 2
This template is prepared for keeping track of the processes carried out in a hotel and analyzing the performance of the hotel with the aid of a dashboard. Daily inputs are tracked in a Data sheet. Inputs are dynamically converted into a dashboard. Revenue types, ADR, RevPAR, occupancy rate, monthly and yearly revenues are analyzed in the dashboard. SpreadsheetWEB version of the template carries the dashboard onto the web and may easily be updated.
|
| 60 |
Hotel Dashboard
This dashboard is prepared for displaying monthly hotel occupation performances.
|
| 20 |
HR Dashboard
This is a dashboard for employee by departments, salary distribution and number of employees by years analysis. Also, detailed information of a single employee can be reached easily.
|
| 102 |
Global Electricity Consumption Dashboard
This template is another example of building dashboards in Excel. It includes a worksheet containing source data that can be updated. The dashboard will refresh immediately with new data.
Also included in this template, information to deploy it as a web application via SpreadsheetWEB
|
| 61 |
Inventory Calculator
This template is prepared for simulating orders and inventory positions according to Safety Stock policy.
|
| 35 |
Retail Store Dashboard
This is a dashboard displaying the retail store sales, salesperson sales and marketing distribution by the selected month. Also monthly sales chart is available.
|
| 36 |
Revenue Forecast
This template is prepared for forecasting sales. 3 cases are analyzed: optimistic forecast, expected, pessimistic forecast. In the second sheet, comparison of 3 cases, monthly forecasted revenues and revenues by categories are dispplayed by charts.
|
| 38 |
Sales Dashboard
This dashboard provides the following analysis for a selected period: Revenues by Industry, Revenues by Region, Revenues by Product and Revenues by Sales Representative.
|