Shimmer Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2020. (Click the icon to view the additional information.) All sales are made on account with 65%of sales made in a quarter collected in the same quarter and 35%collected in the following quarter. Calculate the cash collected from receivables in each of the 4 quarters of 2020(If an input field is not used in the table, leave the input field empty; do not enter a zero.) Schedule of Cash Collections Accounts receivable balance on 1-1-2020 (Fourth-quarter sales from prior year) From first-quarter 2020 sales From second-quarter 2020 sales From third-quarter 2020 sales From fourth-quarter 2020 sales Total collections 1 2 Quarters Data table 3 4 Accounts receivable (January 1, 2020) Budgeted sales in Quarter 1 (January 1 to March 31, 2020) Budgeted sales in Quarter 2 (April 1 to June 30, 2020) Budgeted sales in Quarter 3 (July 1 to September 30, 2020) Budgeted sales in Quarter 4 (October 1 to December 31, 2020) $ - X 49,000 240,000 225,000 190,000 275,000

Shimmer Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2020. (Click the icon to view the additional information.) All sales are made on account with 65%of sales made in a quarter collected in the same quarter and 35%collected in the following quarter. Calculate the cash collected from receivables in each of the 4 quarters of 2020(If an input field is not used in the table, leave the input field empty; do not enter a zero.) Schedule of Cash Collections Accounts receivable balance on 1-1-2020 (Fourth-quarter sales from prior year) From first-quarter 2020 sales From second-quarter 2020 sales From third-quarter 2020 sales From fourth-quarter 2020 sales Total collections 1 2 Quarters Data table 3 4 Accounts receivable (January 1, 2020) Budgeted sales in Quarter 1 (January 1 to March 31, 2020) Budgeted sales in Quarter 2 (April 1 to June 30, 2020) Budgeted sales in Quarter 3 (July 1 to September 30, 2020) Budgeted sales in Quarter 4 (October 1 to December 31, 2020) $ - X 49,000 240,000 225,000 190,000 275,000

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter9: Accounting For Receivables

Section: Chapter Questions

Problem 10EA: Millennial Manufacturing has net credit sales for 2018 in the amount of $1,433,630, beginning...

See similar textbooks

Similar questions

SimpleFlight Inc has a policy of keeping accounts receivables at 47 days of sales. In 2019 they received $95M in revenue. In 2020 they expect to receive $100 M in revenues. What do you forecast their account receivables to be in 2020? (enter answer in $M, with two decimal points precision)
Lotus fabrics wants to forecast its accounts receivable for the year 2021 with the following annual information. Also state two advantages of forecasting of accounts receivables for the entity. Receivable days assumption = 60 days Payable days assumption = 72 days Forecasted revenue = 325,000 Forecasted cost of goods sold = 180,250 Choices: 51,195 53,425 49,800 41,705
.
Khoury Home carried out the following operations during the 2nd quarter of the year 2020: Sales $ 250,000 HT; Purchases $ 80,000 excl. What is the amount of VAT to be paid to the Public Treasury knowing that the VAT rate is 11%:
Based on the provided information in the attached image, please calculate the following simpe equations; (It's super simple, just tiny simple mathematical calculations that should take only 2 minutes, I'm just lost with the wording...) Average collection period, = Days to sell inventory, = Accounts payable payment period, = Amborse's cash-to-cash cycle, = The company's bank loan =
Husemann Co.'s assets include notes receivable from customers. During fiscal 2019, the amount of notes receivable averaged $525,000, and the interest rate of the notes averaged 4.2%. b-2. Prepare a horizontal model to show the collection of this amount. (Use amounts with + for increases and amounts with – for decreases.)
The following five transactions occurred in 2018: First purchase (cash) 150 units @ $155 Second purchase (cash) 160 units @ $160 Sales (all cash) 410 units @ $320 Paid $38,000 cash for salaries expense Paid cash for income tax at the rate of 25 percent of income before taxes What is the balance sheets AND cash flows statements for 2018 for LIFO and weighted average? cash balance for FIFO?
Can you help me wit the spreadsheet in the picture attached. this is the rest of the information given. for my homeowrk please help asap The fiscal period is one month. Merchandise Inventory at November 30 is $265 000. Supplies on hand November 30 are valued at $11 400. Equipment depreciation is 25 percent per year, using the declining-balance method. Round off the depreciation to the nearest dollar. $450 interest is owed on the bank loan. $1300 is owed to employees.
Starlight Enterprises has net credit sales for 2019 in the amount of $2,600,325, beginning accounts receivable balance of $844,260, and an ending accounts receivable balance of $604,930. Compute the accounts receivable turnover ratio and the number of days sales in receivables ratio for 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Starlight Enterprises if the industry average is 1.5 times and the number of days sales ratio is 175 days?
Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
Millennial Manufacturing has net credit sales for 2018 in the amount of $1,433,630, beginning accounts receivable balance of $585,900, and an ending accounts receivable balance of $621,450. Compute the accounts receivable turnover ratio and the number of days sales in receivables ratio for 2018 (round answers to two decimal places). What do the outcomes tell a potential investor about Millennial Manufacturing if industry average is 2.6 times and number of days sales ratio is 180 days?
The following select financial statement information from Vortex Computing. Compute the accounts receivable turnover ratios and the number of days sales in receivables ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Vortex Computing if industry average for accounts receivable turnover ratio is 4 times and days sales in receivables ratio is 85 days?