what was average female total compensation recorded in 2020

Download the file Receivables and open using excel. The file contains information on outstanding receivables at the end of the year and informaiton about whether they were written off the following year. Sheet "Dec 31 20XX" contains information about purchases that were made on account during the year and were still outstanding on Dec 31st, at the end of the fiscal year. Column A displays customer number. Column B displays the amount outstading of a particular purchase. Column C presents the date the transaction with the customer occured. Column D contains information that was collected after the end of the fiscal year pertaining to these receivables. If the receivable was not paid off (written off by the company), the cell contains the value 1. If the receivable was paid off, the column contains the value 0. Sheet "Customer Desc" contains information about the customers. Column A displays customer number. Column B contains an indicator variable for a new customer. Column C displays information about the state in which the customer resides. Additional information - the company grants its customers 90 days to pay off their receivable. anyhing over 90 days is considered overdue. directions: a) Calculate the age of each receivable at the end of the year. Age = end of year date (cell B1) - date purchased. b) Create a variable to indicate whether the recievable is overdue or not (age>90). c) find the characteristics of each customer (new / state) by using the vlookup function. Answer the following questions: - 1. What was the percentage of total value of recievables that were overdue at the end of the year? (enter an answer between 0 and 1 - round your answer to three decimal points, for example 43.67% should be entered as 0.437) 2. What was the average age of the overdue receivables at the end of the year? (round your answer to the nearest integer, for example 63.8 should be entered as 64) 3. What percentage of the dollar amount of overdue receivables was written off the following year? (enter an answer between 0 and 1 - round your answer to three decimal points, for example 43.67% should be entered as 0.437) 4. What was the total outstading receivables of NY customers? 5. What was the percentage of writeoffs from new clients? (enter an answer between 0 and 1 - round your answer to three decimal points, for example 43.67% should be entered as 0.437) Download the file Receivables and open using excel. The file contains information on outstanding receivables at the end of the year and informaiton about whether they were written off the following year. Sheet "Dec 31 20XX" contains information about purchases that were made on account during the year and were still outstanding on Dec 31st, at the end of the fiscal year. Column A displays customer number. Column B displays the amount outstading of a particular purchase. Column C presents the date the transaction with the customer occured. Column D contains information that was collected after the end of the fiscal year pertaining to these receivables. If the receivable was not paid off (written off by the company), the cell contains the value 1. If the receivable was paid off, the column contains the value 0. Sheet "Customer Desc" contains information about the customers. Column A displays customer number. Column B contains an indicator variable for a new customer. Column C displays information about the state in which the customer resides. Additional information - the company grants its customers 90 days to pay off their receivable. anyhing over 90 days is considered overdue. directions: a) Calculate the age of each receivable at the end of the year. Age = end of year date (cell B1) - date purchased. b) Create a variable to indicate whether the recievable is overdue or not (age>90). c) find the characteristics of each customer (new / state) by using the vlookup function. Answer the following questions: - 1. What was the percentage of total value of recievables that were overdue at the end of the year? (enter an answer between 0 and 1 - round your answer to three decimal points, for example 43.67% should be entered as 0.437) 2. What was the average age of the overdue receivables at the end of the year? (round your answer to the nearest integer, for example 63.8 should be entered as 64) 3. What percentage of the dollar amount of overdue receivables was written off the following year? (enter an answer between 0 and 1 - round your answer to three decimal points, for example 43.67% should be entered as 0.437) 4. What was the total outstading receivables of NY customers? 5. What was the percentage of writeoffs from new clients? (enter an answer between 0 and 1 - round your answer to three decimal points, for example 43.67% should be entered as 0.437)