1. Use the information and instructions located in Chapter 7 Case Problem 4 located at the end of chapter seven in your textbook.
2. You'll be starting with the ch7-13 Excel template provided in the Excel files submodule in Module 5 and creating several reports using the features and formatting modeled in chapter six.
3. Save the spreadsheet using the naming convention in the textbook.
4. For part c of #2, please place the chart on the cost prediction worksheet. You should have three worksheets in your workbook when you are done. You can ignore the instructions involving printing and views, just complete the reports and submit the workbook to the associated dropbox.

Rosey's Roses Present and Future Values Future need: Term (in years): Interest rate: Annuity payment required: Year 0 1 2 3 4 Interest Annuity Annuity investment: Term (in years): Interest rate: Future value: Year 0 1 2 3 4 Interest $ 15,000.00 4 2% Investment ($1,000.00) 4 2% Annuity Investment Future need: Term (in years): Interest rate: Invest now: Year 0 1 2 3 4 Interest Current investment: Term (in years): Interest rate: Future value: Year 0 1 2 3 4 Interest $ 15,000.00 4 2% Investment ($4,000.00) 4 2% Investment Rosey's Roses Predicting Costs Month Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 High Expense Low Expense Difference Hi-Lo Method Variable cost/unit sold Fixed cost Delivery expense when 12,000 miles driven= Least Squares / Regression Method Variable cost/unit sold Fixed cost Delivery expense when 12,000 miles driven= Miles Driven 5,400 5,700 6,300 4,200 7,500 3,500 8,000 5,300 5,100 4,700 6,300 7,500 10,200 8,800 7,500 6,900 7,900 7,200 9,500 9,800 11,300 13,000 6,500 5,900 Delivery Expense $ 12,000 $ 12,100 $ 12,600 $ 10,100 $ 13,750 $ 10,000 $ 18,000 $ 12,000 $ 11,000 $ 10,100 $ 13,000 $ 15,000 $ 20,000 $ 15,700 $ 14,500 $ 12,950 $ 18,000 $ 13,500 $ 18,000 $ 19,000 $ 21,000 $ 24,000 $ 14,000 $ 10,500 Rosey's Roses Allowance for Uncollectible Accounts Aging Method Information Amount Past experience ratio Past experience ratio for % of sales method Facts: Accounts receivable balance (beg) Sales on account Collections on account Write-offs of accounts receivable Accounts receivable balance (end) Percentage of Sales Method Allowance for uncollectible accounts (beg) Write-offs of accounts receivable Uncollectible accounts expense Allowance for Uncollectible accounts (end) Aging Method Allowance for uncollectible accounts (beg) Write-offs of accounts receivable Uncollectible accounts expense Allowance for uncollectible accounts (end) Current 0 - 30 Days Past 31 - 60 Days 61 - 90 Days Due Past Due Past Due > 90 Days Past Due Total