1. Imagine you have received a spy’s spreadsheet that uses two columns of data, runs them through a formula, and then outputs the results in a third column. There are hundreds of thousands of rows of data, and the data consists of numbers between -500 and 1,000. The password to protect the cell is effectively unbreakable; it was never written down, was incredibly long, and no one alive today knows what it was. How might you go about figuring out the formula used for column C? 2. Brad is exploring Excel’s Sort tool and, in the Options menu, finds an interesting toggle: he can select between a default of Sort top to bottom and Sort left to right. Thinking through what the sort command does and the structure of a spreadsheet, what new trick can Brad perform if he switches to Sort left to right?

Symantec corp., located in cupertino, california, is one of the world's largest producers of security and systems management software. the company's consolidated balance sheets for the 2009 and 2008 fiscal years included the following ($ in thousands): current assets: receivables, less allowances of $21,766 in 2009 and $24,089 in 2008 $ 838,010 $ 758,700 a disclosure note accompanying the financial statements reported the following ($ in thousands): year ended 2009 2008 (in thousands) trade accounts receivable, net: receivables $ 859,776 $ 782,789 less: allowance for doubtful accounts (8,938) (8,990) less: reserve for product returns (12,828) (15,099) trade accounts receivable, net: $ 838,010 $ 758,700 assume that the company reported bad debt expense in 2009 of $2,000 and had products returned for credit totaling $3,230 (sales price). net sales for 2009 were $6,174,800 (all numbers in thousands).required: what is the amount of accounts receivable due from customers at the end of 2009 and 2008? what amount of accounts receivable did symentec write off during 2009? what is the amount of symentec’s gross sales for the 2009 fiscal year? assuming that all sales are made on a credit basis, what is the amount of cash symentec collected from customers during the 2009 fiscal year?

Tandard product costs deerfield company manufactures product m in its factory. production of m requires 2 pounds of material p, costing $4 per pound and 0.5 hour of direct labor costing, $10 per hour. the variable overhead rate is $8 per direct labor hour, and the fixed overhead rate is $12 per direct labor hour. what is the standard product cost for product m? direct material answer direct labor answer variable overhead answer fixed overhead answer standard product cost per unit answer

The largest elements of community corrections are