• April 2018

    FriSatSunMonTueWedThuTax week
    --1   2   3   4   5   52
    6   7   8   9   1011121
    131415161718192
    202122232425263
    27282930---4
    • 6th - Start of 2018-2019 tax year
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
    • 2nd - Easter Monday (E,W,NI)
  • May 2018

    FriSatSunMonTueWedThuTax week
    ----1   2   3   4
    4   5   6   7   8   9   105
    111213141516176
    181920212223247
    252627282930318
    • 7th - May Bank Holiday (E,W,NI,S)
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
    • 28th - Spring Bank Holiday (E,W,NI,S)
    • 31st - Employee P60s due
  • June 2018

    FriSatSunMonTueWedThuTax week
    1   2   3   4   5   6   7   9
    8   9   101112131410
    1516171819202111
    2223242526272812
    2930-----13
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
  • July 2018

    FriSatSunMonTueWedThuTax week
    --1   2   3   4   5   13
    6   7   8   9   10111214
    1314151617181915
    2021222324252616
    2728293031--17
    • 6th - Forms P11D, P11D(b) and P9D due
    • 6th - Form 42 Due
    • 12th - Battle of the Boyne - Bank Holiday (NI)
    • 19th - HMRC cheque payments due
    • 19th - Payment of 2017/18 Class 1A NIC due
    • 22nd - HMRC BACS payments due
    • 31st - Payment of 2017/18 Class 2 NIC due
  • August 2018

    FriSatSunMonTueWedThuTax week
    -----1   2   17
    3   4   5   6   7   8   9   18
    1011121314151619
    1718192021222320
    2425262728293021
    31------22
    • 6th - Summer Bank Holiday (S)
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
    • 27th - Summer Bank Holiday (E,W,NI)
  • September 2018

    FriSatSunMonTueWedThuTax week
    -1   2   3   4   5   6   22
    7   8   9   1011121323
    1415161718192024
    2122232425262725
    282930----26
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
  • October 2018

    FriSatSunMonTueWedThuTax week
    ---1   2   3   4   26
    5   6   7   8   9   101127
    1213141516171828
    1920212223242529
    262728293031-30
    • 5th - Personal Income Tax Statement
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
    • 31st - Paper Self Assessment Tax Return Deadline
  • November 2018

    FriSatSunMonTueWedThuTax week
    ------1   30
    2   3   4   5   6   7   8   31
    9   10111213141532
    1617181920212233
    2324252627282934
    30------35
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
    • 30th - St. Andrew's Day (S)
  • December 2018

    FriSatSunMonTueWedThuTax week
    -1   2   3   4   5   6   35
    7   8   9   1011121336
    1415161718192037
    2122232425262738
    28293031---39
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
    • 25th - Christmas Day
    • 26th - Boxing Day
  • January 2019

    FriSatSunMonTueWedThuTax week
    ----1   2   3   39
    4   5   6   7   8   9   1040
    1112131415161741
    1819202122232442
    2526272829303143
    • 1st - New Year's Day
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
    • 31st - Online Self Assessment Tax Return Due
  • February 2019

    FriSatSunMonTueWedThuTax week
    1   2   3   4   5   6   7   44
    8   9   101112131445
    1516171819202146
    2223242526272847
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
  • March 2019

    FriSatSunMonTueWedThuTax week
    1   2   3   4   5   6   7   48
    8   9   101112131449
    1516171819202150
    2223242526272851
    293031----52
    • 17th - St. Patrick's Day (NI)
    • 19th - HMRC cheque payments due
    • 22nd - HMRC BACS payments due
UK Tax Week

   07 Dec - 13 Dec

63

 

Getting Started With Movie Magic Budgeting

No comments

Summary

Movie Magic Budgeting is an innovative budgeting and cost estimation tool used by production professionals all around the world.

Tagged: Production Accounting, Software, Movie Magic, Training, Budgeting

Getting Started with Movie Magic Budgeting

Movie Magic Budgeting

Movie Magic Budgeting allows simple or complex film and television production budgets to be created with ease and accuracy.

There are four major steps to budgeting in Movie Magic Budgeting. First a broad category of accounts are created in the Topsheet. Secondly, accounts are added to the Accounts Level. Next the Budget Preferences and tables are defined (i.e. Units, Globals, Groups, Fringes, Locations, Sets, Currencies). Finally amounts can be entered into the Details Level, applying the Fringes, Globals, Groups, and other properties as necessary with reference to 4th Level worksheets if required.

TIP: Even with a broken down schedule the script should always be read carefully before budgeting as, for example, a 'village in flames' can be created using different VFX and SFX techniques.

Navigating the Budget

Movie Magic Budgeting offers intuitive navigation with a combination of easy-to-use toolbars, tabs and menus. TheMovie Magic Budgeting Toolbar offers access to all major features of the program it also allows easy navigation between budget levels. Budget levels can be navigated using theNavigation Ball, clicking on the corresponding Toolbar icon or by entering an Account number and clicking on the Go button. Keyboard shortcut keys are also available throughout the application used in combination with the Control (CTRL) key in Windows® or the Command (CMD) key on a Mac®. 

 

MMB Toolbar

Image: Movie Magic Budgeting Toolbar

Getting Started

To create a blank Budget, selectCreate Blank Budgetfrom theFileMenu. To create a new Budget from a template, selectNew Budgetfrom theFileMenuor use the shortcut CTRL + N or CMD + N. A range of budget templates are provided. Multiple Budgets can be opened and viewed in separate windows within the application.

TIP: To track Budget and Revision select Budget Info…from theFile Menu.


Select Budget Template

Image: Select Budget Template

Topsheet

The Budget Topsheet provides a summary of the Budget. To navigate to the Topsheet click on the button labeled Tin the Toolbar, select Topsheet from the Go to Menu or use theNavigation Ball Up Arrow. Category names (or major Account names) of a Budget, such as Art Direction, Set Construction, and Production Staff as well as their Account Numbers are entered in the Topsheet. New Categories can be added by selectingInsert Rowfrom theEdit Menuor by using the keyboard shortcut CTRL + I or CMD + I. With the exception of Contractual Charges and Applied Credits, monetary amounts are not entered on the Topsheet, they are entered in the Details Level.

Right-clicking (CTRL + clickon the Mac®) on the green bar on the Topsheet allows Original & Variance Columns to be shown or hidden, Fringe Total Columns to be shown or hidden and Original Column Totals to be updated in order to track changes to the budget. Above the Topsheet, Session and Change Totals are also shown along with the Budget Total.

 

Budget Topsheet

Image: Budget Topsheet

Production Total

Production Totals can be added to the Topsheet by selecting the Category row above where the Production Total row is to be inserted. Go to Edit and select Insert Production Total. ALevel Break, titled "Untitled Production Total", will be displayed above the selected row.

Contractual Charges

Contractual Charges are entered as a flat rate or a percentage by selecting Insert Contractual Charge from theEdit Menu. Examples include Contingency, Bond Fees, and Insurance Charges. Specific Budget amounts can be excluded from the calculation by value or by Group. For example copyright fees do not typically need insurance or bonding. Contractual Charges are usually placed on the after the last Level Break and before the Budget Grand Total. They can be assigned an Account Number.

 

Contractual Charge

Image: Contractual Charge

Applied Credits

The Applied Credit tool helps track production incentives applied against a Budget. Go to Edit and select Insert Applied Creditto add an Applied Credit below the Grand Total. A Net Total will appear to reflect the Budget total after the credits. Depending on shooting location, different credits may apply to different lines of detail. Using Groups to specify these items allows complex credits to be applied.

 

Applied Credits

Image: Applied Credits

Account Level

Each Category in the Topsheet is made up of Accounts, for example, a specific crew position or equipment package. To navigate to the Account Level click on the button labeledAin the Toolbar or select Accounts from theGotoMenu. The shortcut is CTRL + E or CMD + E. With the exception of Category Fringe rows, which can be setup in Budget Preferences, monetary amounts and other budget information are not entered here. Account Level information is a summary of data entered at the Details Level.

 

Account Level

Image: Account Level

Budget Setup

The following options are available from theSetup Menu, allowing the behaviour, structure and presentation of the Budget to be controlled. To avoid having to repeat the setup process, a Budget Template can be saved by selecting Make Template from the File Menu. New Budgets can then be created using the Template.

Budget Preferences

Budget Preferences can be set by selecting Budget Preferences from the Setup Menu. Options are grouped into six sections; General Properties, Fringe, Detail Level, Currency, Totals, Account Format, and Optional Columns.

 

Budget Preferences

Image: Budget Preferences

Captions

Captions are budget labels, such as Category Description, Total, Groups, or Set. Movie Magic Budgeting allows these captions to be replaced with alternative text which can be especially helpful if budgeting in another language.

 

Budget Captions

 

Currencies

The default currency is the US Dollar, but any currency can be used to calculate the Budget. Add the currencies to be used in budgeting into the Currency table. They can be applied in the Dedicated Currency Column at the Details Level of a budget. To setup Currencies the keyboard shortcut is CTRL + 6or CMD + 6.

 

Currency Setup

Image: Currency Setup

Globals

A key feature, Globals represent assigned values used throughout a budget. Wherever the Global shortcut letter or code is entered into a Budget the assigned value will be displayed. Change the Global value while preparing the Budget and it will automatically update throughout. Globals are assigned to Global Groups for quick reference. To setup Globals the keyboard shortcut is CTRL + G or CMD + G.

 

 Global Table

Image: Globals Table

Fringes

Fringes are additional charges for a contracted price of a budgeted item. Typical Fringes include payroll taxes, such as FICA, FUI, SUI, and Workers' Compensation in the United States or Social Security contributions, such as National Insurance, in the United Kingdom. As with Globals, if changes need to be made to a Fringe, edit the Fringe table and changes will automatically occur throughout. To setup Fringes the keyboard shortcut is CTRL + 3 or CMD + 3.

 

 Fringe Table

Image: Fringe Table

Groups

Grouping lines of Detail allows for including or excluding them collectively from a budget, without actually deleting anything. This is useful for budget comparisons in"what-if" scenarios.  A number of settings exist that control the Budget calculation of non-grouped detail lines, whether or not to show Fringe amounts in Group Totals and how to handle Group status conflicts where an item of detail is included in two groups and only one is included. To add or update an existing Group use the keyboard shortcut CTRL + 4 or CMD + 4.

 

Set Up Groups

Image: Setup Groups Table

Locations & Sets

Locations and Sets can be added to the Budget in order to help analyse costs in more detail. To setup Locations use the keyboard shortcutCTRL + 5orCMD + 5, for Sets use CTRL + 8 or CMD + 8.

Details Level

The Details Level is where monetary values are entered. To navigate to the Details Level click on the button labeledDin the Toolbar or select Details from the Go to Menu. The keyboard shortcut is CTRL + K or CMD + K. To enter data Tab to or click between fields. In a blank Description field type in a Name or Description of the expense. In the Amount field, type a number amount or Global. In the Units field type in a Unit or Unit shortcut. (If a Global is used, this is unnecessary). In the next field, X (quantity), enter the quantity of the line item (default is 1). Finally in the Rates field enter the Detail Rate, or use a Global once again.

 

Details Level

Image: Details Level


Import from Movie Magic Scheduling

Information exported from Movie Magic Scheduling, such as lists of characters and number of action vehicles, can be imported into lines of Detail in the Budget using the Library Manager. First select a row at the Details Level, then select Show Library Manager from the Library Menuand click on Insert Data.

TIP: To copy and paste into the same level, i.e. from Topsheet to Topsheet, of the same, or a second Budget use the shortcuts CTRL + C and CTRL + V or CMD + C and CMD + V.

4th Level

The 4th Level offers an additional spreadsheet-style application to further break down information from the Details Level. The 4th Level data can be linked to corresponding data on the Details Level. The linkable data ensures that changes made to 4th Level data will be updated wherever they occur throughout the budget.

Budget Notes

The Note Tool allows short messages to be attached to individual Topsheet, Accounts, Details, and 4th Level lines. To attach a Note select a line and go to the Data Menu, select Note.  Alternatively right-click(Mac:CMD + click) on highlighted row and selectNote. The Note window will open. Type the Note directly into the window. Select the Include in Print Reportbox to include the current Note when printing a budget report. Any budget lines with attached Notes are indicated with a red pin icon to the right of each line.

TIP: To add a new line to a Note, type Alt-Enter.

Sub-Budgets

The Create Sub Budget feature is a quick and easy method to see a new Budget version without affecting an original Budget. Go toFileand select Create Sub Budget…By filtering, it is possible to choose what is included in a Sub Budget. For example, a Budget may be viewed by isolating a specific Currency or Location cost without altering the original Budget.

 

Create Sub Budget

Image: Create Sub-Budget

Budget Comparison

To compare several different Budgets at once go to File and select Budget Comparison. The Create Budget Comparison Report window will open. Select a number of budgets to compare and click on the Add button. Select the type of report with which the Budget Comparison is to be generated; Variance, Average or Both. Next, select how the Budget Comparison report is to be viewed: All Accounts, Topsheet or by specified Account. Finally, clickOK to generate the report.

Tip: Budgets can also be compared against Vista Accounting Cost Reports (*.vis) at the Accounts Level.

 

Budget Comparisons

Image: Budget Comparison

Reports

Movie Magic Budgeting provides a range of specific reports, from the Topsheet and tables to the columns in the Details Level. Once the Budget has been entered, the layout and settings for the Budget Report can be set by going to Fileand selecting Print Setup. 

The Print Selection tab allows information shown on the report to be defined, including Budget Levels, Setup tables and Budget Information. The Account Range can also be specified. The Print Setting  stab allows additional columns from the Details Level to be shown and other formatting to be set. To update the Budget Header or Footer, click the Edit Header/Footer button and select the text to edit by choosing either Topsheet Only or Report. 

To print, click on the Print icon. Alternatively reports can be previewed or saved as a .PDF file to share electronically.

TIP: If printing by Account Range, the Print Account option will revert to the All default setting once the Print Setup window is closed and reopened again.


Report Design

Image: Report Design

 

Further Information

A very useful source of further information is Entertainment Partners' YouTube channel, BroadcastEP. A range of videos are available covering many aspects of Budgeting and Scheduling with Movie Magic. To watch them visit http://www.youtube.com/broadcastep.

About the Author  

Laurence Sargent is a Director of Sargent-Disc, the European distributor of Movie Magic Budgeting and Movie Magic Scheduling. Founded in 1986, Sargent-Disc is affiliated with Entertainment Partners and is the market leader in the provision of integrated payroll and residuals, accounting and software services for the entertainment industry in the UK

Based at Pinewood Studios Sargent-Disc offer Movie Magic training and support throughout Europe. Clients include the major Hollywood studios, broadcasters, independent film and television producers and a broad range of clients within the entertainment industry. Sargent-Disc supports a range of organisations including Women in Film and TV, The Production Guild and is also an official BAFTA partner.

For more information visit www.sargent-disc.com or email info@sargent-disc.com




No comments