Light Up Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for theyear 2020.(Click the icon to view the additional information.)All sales are made on account with 70% of sales made in a quarter collected in the same quarter and 30% collected in the followingquarter.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 inputfield empty; do not enter a zero.)Schedule of Cash CollectionsAccounts receivable balance on 1-1-2020(Fourth-quarter sales from prior year)From first-quarter 2020 salesFrom second-quarter 2020 salesFrom third-quarter 2020 salesFrom fourth-quarter 2020 salesTotal collections12Quarters34 Data tableAccounts 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)47,000230,000240,000190,000250,000

Light Up 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 70% of sales made in a quarter collected in the same quarter and 30% 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.) 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 Schedule of Cash Collections Total collections 1 2 Quarters 3 4

Light Up 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 70% of sales made in a quarter collected in the same quarter and 30% 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.) 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 Schedule of Cash Collections Total collections 1 2 Quarters 3 4

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

For 2021, Walmart and Target had the following information (all values are in millions of dollars): Assume a 365-day year. a. What is each company's accounts receivable days? b. What is each company's inventory turnover? c. Which company is managing its accounts receivable and inventory more efficiently? Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Walmart Target (Income Statement) Sales 572,762 106,007 Cost of Goods Sold (Income Statement) 428,997 74,962 Accounts Receivable (Balance Sheet) 8,279 830 Inventory (Balance She 56,519 13,902 = X
Larry’s Kitchen Appliances makes all sales on credit. Total sales for the year ended 2020 was $380,750. The beginning balance in accounts receivable was $67,800 and the ending balance was $76,000. What was the amount of cash Larry’s collected from customers during 2020? Group of answer choices A)$372,550. b)$380,750. C)$388,950. d)$304,750. e)None of the above
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?
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?
The following select financial statement information from Candid Photography. 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 Candid Photography if industry average for accounts receivable turnover ratio is 3 times and days sales in receivables ratio is 150 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?
Using the following select financial statement information from Mover Supply Depot, compute 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 Mover Supply Depot if the competition collects in approximately 65 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?
Using the following select financial statement information from Mover Supply Depot, compute the accounts receivable turnover ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Mover Supply Depot if the industry average is 4 times?
Berry Farms has an accounts receivable balance at the end of 2018 of $425,650. The net credit sales for the year are $924,123. The balance at the end of 2017 was $378,550. What is the number of days sales in receivables ratio for 2018 (round all answers to two decimal places)?
View the data below and then answer the question below: Company Name: WaitRose Sales - $2,100 (20% cash, 80% credit) Inventory - $750 Depreciation - $1,500 Plant & Equipment - $2,000 Accounts Receivable - $225 Notes Payable - $165 Question: What is the average collection period for the year for Waitrose? (show your work and explain)
Wolf Computer Company began operations in 2018. The company allows customers to pay in installments formany of its products. Installment sales for 2018 were $1,000,000. If revenue is recognized at the point of delivery,$600,000 in gross profit would be recognized in 2018. If the company instead uses the cost recovery method,$100,000 in gross profit would be recognized in 2018.Required:1. What was the amount of cash collected on installment sales in 2018?2. What amount of gross profit would be recognized if the company uses the installment sales method?