business information systems

Latrobe Valley Product Gallery (LVPG) specialises in promoting and selling both (i) stand space at trade fairs and (ii) tickets for visitors to trade fairs in Latrobe Valley, Gippsland area. The company currently promotes and sells two different sized stand spaces, to new or returning exhibitors, for a number of Trade Fairs locally and overseas. LVPG also provides a number of additional value-added services to exhibitors for fees, such as organising exhibitor stands, developing marketing material for exhibitors to distribute at fairs, arranging travel and/or accommodation for exhibitors, and hospitality/catering for exhibitors to offer their customers attending the trade fair. LVPG also organise visitor tickets for the trade fairs, which also provide commission income. All these activities are managed through the efforts of a number of sales representatives. The company’s founder, Ms Diamantina Rose, like all small business owners, is always interested in finding ways to increase revenues and decrease expenses. need to caluculate all income and expensese form the trade and must use pivot table