S2 ADMINISTRATION AND IT
The film producers need to get some idea of how much money they need to set aside to pay the cast their wages.
Create the table below in Microsoft Excel, replace the CHARACTER and ACTOR columns with characters from your own movie. If you have more than 10, add your own information for DAILY RATE (£500-£3000) and NO. OF DAYS (50-500).
Add another column with the heading WAGES. Create a formula to calculate each actors wages for the movie. Use the function SUM to calculate the total wages bill.