You are consulting with the manager of an accounts receivable department of a large manufacturing company. the manager is concerned that some of the customer accounts are not being paid promptly under the current payment terms. the current payment terms specify 14 days for receipt of payment of all bills. since the manager did not have any hard evidence, you suggested that the manager collect some data that could then be analyzed. based on your advice, the manager collects a stratified random sample over a two month period (6 records for each day the company was open for business, including saturday). see the accompanying excel worksheet (the tab titled, data – case #1) for the sample data. the sample covered a typical 2-month period of the company’s business cycle. conduct the appropriate analysis and present your findings and conclusions as well as your recommendations to the accounts receivable manager below.

Your own record of all your transactions. a. check register b. account statement

1. list five staple convenience goods that you or your household buys on a regular basis. (you do not need to use complete sentences. 2.5 points) 2. list three impulse convenience goods that you or someone you know has purchased. (you do not need to use complete sentences. 2.5 points) 3. describe a shopping good that you or someone you know purchased. what kind of research did you or that person do before buying the product? (1-5 sentences. 3.0 points) 4. choose an example of a company you could start, and decide which business structure would make the most sense for that type of company (sole proprietorship, partnership, llc, c corporation, s corporation, or nonprofit corporation). explain why this structure would be good for this type of company. give at least 3 reasons. (3-6 sentences. 6.0 points) 5. if you were starting a new business, describe at least three departments to the company that you would need right away. why are these departments so important? (1-5 sentences. 3.0 points) 6. describe a product that you think has saturated its market. what makes you think it has saturated its market? (1-5 sentences. 3.0 points)

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding