Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Climbers expects total sales of $701,000 for January and $351,000 for February. November sales totaled $397,000 and December sales were $398,000. The following schedule of
Climbers expects total sales of $701,000 for January and $351,000 for February. November sales totaled $397,000 and December sales were $398,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 Climbers's sales are collected as follows: 40% in the month of the sale 20% in the month after the sale 35% 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 Total sales 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 More info January February Reference Cash Receipts from Customers January February 50% in the month of the sale 30% in the month after the sale 18% two months after the sale 2% never collected Total sales Print Done January February $ 701,000 $ 351,000 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 $ 71,460 119,400 $ 71,640 350,500 210,300 $ 541,360 $ 175,500 457,440 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