Based on this week’s discussion surrounding receivables and uncollectible accounts, in what ways could
computerized accounting software or spreadsheets continue an ongoing fraud scheme relating to receivables?
Using the KU library, research fraud schemes that involve receivables and share your findings.
3 During a recent year, Snick’s Board Shop had sales on account of$45,000, collections of $45,500, write-offs
of $800, a beginning balance inaccounts receivable of $5,000, and a beginning balance in the allowancefor
uncollectible accounts of $300. At year end $2,400 of accounts receiv-able were current, $700 were 0–30 days
past due, $300 were 31–60 dayspast due, $200 were 61–90 days past due, and $100 were over 90 dayspast
due. The company believes 1.5 percent of sales will not be collected.They also have experience suggesting
that 2 percent of all current receiv-ables, 11 percent of receivables 0–30 days past due, 16 percent of receivables 31–60 days past due, 25 percent of receivables 61–90 days past due,and 50 percent of receivables over
90 days past due will not be collected.Using the file ch7-12, complete the allowance for uncollectible
accountsanalysis for both standard methods. Save the file as ch7-12_student_name(replacing student_name
with your name). Print this completed worksheet.Chapter 7 Case Problem 4:ROSEY’S ROSESRosey’s Roses
has several questions for you that Excel can help answer. Usestudent file ch7-13 to solve 3 of these problems.
This file has three worksheetslabeled: Present and Future Values, Cost Prediction, and Allowance for Uncollectibles. Complete the file answering the questions below and then save the fileas ch7-13_student_name
(replacing student_name with your name). Print eachworksheet. (Note: This file has three worksheets.)
Chapter 7 Case Problem 4:ROSEY’S ROSESRosey’s Roses has several questions for you that Excel can help
answer. Usestudent file ch7-13 to solve 3 of these problems. This file has three worksheetslabeled: Present
and Future Values, Cost Prediction, and Allowance for Uncol-lectibles. Complete the file answering the
questions below and then save the fileas ch7-13_student_name (replacing student_name with your name).
Print eachworksheet. (Note: This file has three worksheets.)1 Present and Future Values (Calculate the answer
and then provide a tablefor each question. Use the first worksheet of the workbook to answer thisproblem.):a.
How much they would have to pay at the end of each year, assuming a2 percent rate of return, to yield $15,000
at the end of 4 years.b. How much they would have at the end of 4 years if they invested$1,000 at the end of
each year, earning 2 percent per year.c. How much they would have to invest today to have $15,000 in4 years,
earning 2 percent per year.d. How much they would have at the end of 4 years if they invested$4,000 today,
earning 2 percent per year.2 Rosey’s Roses is trying to better understand the behavior of their
deliveryexpenses. They have accumulated the delivery expenses over the last24 months and believe that
miles driven per month are a good predictor ofexpense behavior. Use the second worksheet of the workbook to
answerthis problem:a. Using the Hi-Lo method, calculate variable cost per mile, fixed costs,and a prediction of
delivery expense when they travel 12,000 miles ina month.Other