60.1K

Verified Solution

Link Copied!

Information pertaining to Noskey Corporation's sales revenue follows: Cash sales Credit sales Total sales November 2021 (Actual) $ 140,000 312,000 $ 452,000 December 2021 (Budgeted) $ 136,000 444,000 $ 580,000 January 2022 (Budgeted) $ 84,000 228,000 $ 312,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next month's projected total sales (stated at cost) plus 30% of projected sales for the current month (stated at cost). All inventory purchases are on account; 25% is paid in the month of purchase, and the remainder is paid in the month following the month of purchase. Purchase costs are approximately 60% of the selling price. Required: Determine for Noskey: 1. Budgeted cash collections in December 2021 from November 2021 credit sales. 2. Budgeted total cash receipts in January 2022. 3. Budgeted total cash payments in December 2021 for inventory purchases. Required 1 Required 2 Required 3 Budgeted total cash receipts in January 2022. Cash sales in January NOSKEY CORPORATION Budgeted Total Cash Receipts January 2022 Collections from credit sales in January: Total collectible from credit sales Percentage to be collected in January Collections from credit sales in December: Total collectible from credit sales Percentage to be collected in January Budgeted total cash receipts in January 84,000 $ 129,960 X 60 % 77,976 168,720 x 40 % 67,488 229,464 Required 1 Required 2 Required 3 Budgeted total cash payments in December 2021 for inventory purchases. NOSKEY CORPORATION Budgeted Total Cash Payments Total inventory purchases in November: For November sales: For December sales: December 2021 Percentage of November purchases to be paid in December Payment in December for purchases in November Budgeted purchases in December: For December sales: For January sales: Percentage of December purchases to be paid in December Payment in December for purchases in December Budgeted cash payment in December for inventory purchases $ 324,960 235,440 $ 560,400 25 % 140,100 $ 58,860 243,720 $ 302,580 75 % 226,935 $ 367,035

Answer & Explanation Solved by verified expert

See Answer