Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Aretes expects total sales of $699,500 for January and $347,000 for February. November sales totaled $392,000 and December sales were $425,000. The following schedule of
Aretes expects total sales of $699,500 for January and $347,000 for February. November sales totaled $392,000 and December sales were $425,000. The following schedule of cash receipts for January and February was prepared based upon the collection history given: (Click the icon to view the collection history.) (Click the icon to view the schedule of cash receipts.) Now assume that Aretes's sales are collected as follows: 30% in the month of the sale 20% in the month after the sale 45% two months after the sale 5% never collected Prepare a revised schedule of cash receipts for January and February (If an input field is not used in the table leave the input field empty, do not enter a zero.) Cash Receipts from Customers January February Total sales January February Cash Receipts from Customers: Nov.-Credit sales, collection of Nov. sales in Jan. Dec.- Credit sales, collection of Dec. sales in Jan. Dec.-Credit sales, collection of Dec. sales in Feb. Jan.-Credit sales, collection of Jan. sales in Jan. Jan.-Credit sales, collection of Jan. sales in Feb. Feb.-Credit sales, collection of Feb. sales in Feb. Total cash receipts from customers Reference - Cash Receipts from Customers January February $ 699,500 $ 347,000 Total sales January February $ 113,680 127,500 $ 123,250 Cash Receipts from Customers: Nov.-Credit sales, collection of Nov. sales in Jan. Dec.-Credit sales, collection of Dec. sales in Jan. Dec.-Credit sales, collection of Dec. sales in Feb. Jan. - Credit sales, collection of Jan. sales in Jan. Jan.-Credit sales, collection of Jan. sales in Feb. Feb.-Credit sales, collection of Feb. sales in Feb. Total cash receipts from customers 279,800 209,850 138,800 471,900 $ 520,980 $ More Info -X 40% in the month of the sale 30% in the month after the sale 29% two months after the sale 1% never collected Print Done
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started