The Published - EquityUK Buyouts Booklet
|
|
Equity Stagemanagement Committee - Open Meeting - Buy out contracts
|
Chronology
It began with an Open Meeting
EquitySM Meeting February 2016When it came to sending a motion to the ARC the committee had two burning issues BuyOuts and Digs. The Digs motion went to ARC, the Buyou Calculator directly to the Equity Council.
At the Stage Management Open Meeting regarding Buy-outs on January 29th, the need for some form of ‘buy-out calculator’ was re-iterated. Annual Rep Conference (ARC) May 2016Exploring development of a BuyOut Calculator(above) Council's decision to fund the BuyOut Calculator motion reported in the October 2016 council report. Alex Burke led on this project. The Project was supported by Caron Lyon. Several Excel spreadsheet development professionals were approached. Scope and cost was secured. Our developer was engaged to work with us in January 2017.
Wheels in MotionALPHA 2017 - 18
Versions 1 to 3 during the Alpha phase were tested between the committee with Fiona Mott providing deep insight to the intricacies of correctly calculating basic earning following the rates set out in the Commercial Agreement. BETA 2019
News rates for the Commercial Agreement are due to be announced and shortly behind will follow the new West End agreed rates along with the prevalence of buyout contracts the committee needed to test the calculator to prepare it for launch. In February the committee recruited 20 Stage and Company Managers working on the Commercial Agreement having accepted buyouts who are agreed to use the calculate. Was their deal was a good one?
June 10th there is a reporting phase in readiness for the first sign off before the calculator is adapted to accommodate the remaining Equity Theatre Agreements. #WatchThisSpace
|
BETA TESTING PROGRAMME
Resource Documents and Relevant Links
Stay in the LoopYou can follow us on twitter @EquitySM and join our Facebook group Stage Management : Meet Equity where you can talk with members of the Equity Stage Management Specialist committee, the Equity Stage Management Councillor and each other about issues affecting your work and the work of Equity. It's quick and easy to ask questions, make suggestions, raise concerns and get answers.
ProposalBuild a self contained workbook for each of the 5 contracts.
Develop workbooks using the Excel version contained within Microsoft Office 365 for Windows. (Members with a version of Excel prior to Excel 2007 will NOT be able to use the workbook).
The workbook(s) will be loaded onto the Equity website. Equity members will download the workbook to their local PC.
One workbook will be used for each 'contract'. The user can 'insert' as many time sheets / contracts as they see fit in to a single workbook.
CalculatorUSER VIEW
Control worksheet - where the user will be able to automatically generate a new 'blank' timesheet / payslip for the week Summary worksheet - week by week listing of Equity derived pay, the week equivalent 'buyout' wage can be entered here here to give weekly and cumulative figures.
Start worksheet - place holder to aid cumulative calculations
Timesheet Payslip worksheet - there will be a number of these for each week, as determined by the user.
End worksheet - place holder to aid cumulative calculations
ADMIN VIEW
Rate Card worksheet - the rates for each position & year are maintained in this sheet. When new rates are issued they should be added to this sheet. Parameters / Rules worksheet - the contract rules for the contract in question are maintained in this sheet
The workbook will be relatively simple and intuitive to use.
ASSUMPTIONS
The workbook will be fully automated where possible. Wherever possible drop down selections will be offered to the user to avoid illegal data being entered.
Data validation will be implemented wherever possible.
Data entry re 'BUY OUT' rates will be actioned following newly announced negotiated rates by the SM Committee.
| ||||||||
