Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

home / study / business / operations management / operations management questions and answers / roseys roses has several questions for you that excel can

home / study / business / operations management / operations management questions and answers / roseys roses has several questions for you that excel can help answer. use student file ... (C) During a recent year, Roseys Roses had sales on account of $345,000, collections of $337,000, write-offs of $3,700, a beginning balance in accounts receivable of $37,000, and a beginning balance in the allowance for uncollectible accounts of $1,200. At year end, $34,000 of accounts receivable were current, $4,900 were 030 days past due, $1,500 were 3160 days past due, $500 were 6190 days past due, and $400 were over 90 days past due. The company believes 1.3 percent of sales will not be collected. They also have experience suggesting that 3 percent of all current receivables, 10 percent of receivables 030 days past due, 15 percent of receivables 3160 days past due, 20 percent of receivables 6190 days past due, and 30 percent of receivables over 90 days past due will not be collected. Use the third worksheet of the workbook to answer this problem: 1. Complete an allowance for uncollectible accounts analysis using the percentage of sales method. 2. Complete an allowance for uncollectible accounts analysis using the aging method.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Financial Accounting And Reporting Principles And Analysis

Authors: Peter Walton, Walter Aerts

2nd Edition

1408017725, 978-1408017722

More Books

Students also viewed these Accounting questions