Question: Please help with both requirements Homework: Unit III Comprehensive Problem Progressive Leaming had prepared the following sales budget schedule of budgeted cash receipts, and cash

Please help with both requirements
Please help with both requirements Homework: Unit III Comprehensive Problem Progressive Leaming
had prepared the following sales budget schedule of budgeted cash receipts, and
cash budget for 2005 the view the original budg Progressive Learning decided
to revise ts sales budget to show fourth quarter sales of 900
tats due to the expectation of increased holiday sales (Click the loon
to view the revised sales budget) www Cash Recepts from Customers Accounts
Racevate e December 31, 2004 al Q-Cash sa Tat Requirement 1 Revise
the schedule of budgeted cash recepts to include the increase in fourth
quarter sales and the change in the sning of customer receipts (
an input fald is not used in the table, save the input
fad amply not zen Round your answers to the nearest) Schule of

Homework: Unit III Comprehensive Problem Progressive Leaming had prepared the following sales budget schedule of budgeted cash receipts, and cash budget for 2005 the view the original budg Progressive Learning decided to revise ts sales budget to show fourth quarter sales of 900 tats due to the expectation of increased holiday sales (Click the loon to view the revised sales budget) www Cash Recepts from Customers Accounts Racevate e December 31, 2004 al Q-Cash sa Tat Requirement 1 Revise the schedule of budgeted cash recepts to include the increase in fourth quarter sales and the change in the sning of customer receipts ( an input fald is not used in the table, save the input fad amply not zen Round your answers to the nearest) Schule of Cash Receipts from Customers Cet des colected in a Or-Cheese 1st Or-Cred sales collected in 3 2 Or-Cash a Cress cod 34 Cash Etext pages Calculator Question 2, CYUM7-2 (similar to) Part 1 of 2 First Quartar First Quarter Second Third Quarter Quarter Fourth Quarter Second Third Fourth Quarter Quarter Quarter Total Mackenzie Langston 06/23/22 2:47 PM MacBook Pro HW Score: 0%, 0 of 100 points O Point: 0 of 25 Suppose a change in the receipt of cash from sales on account is as folos (Click the icon to view the revised receipt of ces information Read the requirements Clear all Check anewer Save Progressive Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for 20253 (Click the icon to view the original budgets) Progressive Learning decided to revise its sales budget to show fourth quarter sales of 900 tablets due to the expectation of increased holiday sales (Click the icon to view the revised sales budget) Total sales Cash Receipts from Customers: Accounts Receivable balance, December 31, 2024 1st Cer-Cash sales 1st Q-Credit sales collected in 1st 1st Or-Credit sales collected in 2nd gr 1st Qu-Credit sales collected in 3rd pr 2nd Or-Cash sales 2nd Or-Credit sales collected in 2nd gr 2nd QtrCredit sales collected in 3rd gr 2nd Or-Credt sales collected in 4th gr 3rd Q-Cash sales 3rd Qt-Credt sales collected in 3rd gir) 3rd Qtr-Credit sales collected in 4th gr 4th Qur-Cash sales 4th C-Credit sales collected in 4th g Total cash receipts from customers Etext pages Calculator First Quarter Second Third Fourth Quarter Quarter Quarter Total Suppose a change in the receipt of cash from sales on account is as follows: (Click the icon to view the revised receipt of cash information.) Read the requirements Clear all Comprehensive Problem nd the follow ginal budge revise its sa vised sales. ors: December 31 din 1st qtr d in 2nd qtr. d in 3rd qtr ed in 2nd qtr ed in 3rd qtr. ted in 4th qtr ed in 3rd qtr. ted in 4th qtr. ted in 4th qtr tomers culator Original Budgets Budgeted tablets to be sold Sales price per unit Total sales Total sales Question 2, CYUM7-2 (similar to) Progressive Learning Sales Budget For the Year Ended December 31, 2025 First Third Quarter Quarter $ $ Schdule of Cash Receipts from Customers 450 450 $ 202,500 $ Cash Receipts from Customers: Accounts Receivable balance, December 31, 2024 1st Qtr-Cash sales (30%) 1st Qt-Credit sales (70%), 30% collected in 1st qtr. 1st Qtr-Credit sales (70%), 70% collected in 2nd gr 2nd Qtr-Cash sales (30%) Print Second Quarter $ $ 750 450 $ 337,500 $ First Quarter 30,000 60,750 42.525 1,200 450 $ 540,000 $ Done $ 99,225 101,250 Fourth Quarter HW Score: 0%, 0 of 100 points First Second Third Quarter Quarter Quarter Total 202.500 $337,500 $540,000 $ 292,500 $1,372.500 Second Quarter Third Fourth Quarter Quarter Total 3,050 450 650 450 $ 292,500 $1,372,500 Fourth Quarter Total follows: Clear all ov ge sa 35 or 31 r. tr. tr. qtr. qtr. qtr. atr qtr qtr Original Budgets 1st Qtr-Credit sales (70 %) , 30% collected in 1st qtr. 1st Qtr-Credit sales (70 %). 70% collected in 2nd qtr. 2nd Qtr-Cash sales (30%) 2nd Qtr-Credit sales (70 %), 30% collected in 2nd qtr. 2nd Qtr-Credit sales (70%), 70% collected in 3rd qtr. 3rd Qtr.-Cash sales (30%) 3rd Qtr-Credit sales (70 %), 30% collected in 3rd qtr. 3rd Qtr-Credit sales (70%), 70% collected in 4th qtr. 4th Qtr-Cash sales (30%) 4th Qtr-Credit sales (70%), 30% collected in 4th qtr. Total cash receipts from customers Accounts Receivable balance, December 31, 2025: 4th Qtr-Credit sales (70%), 70% collected in 1st qtr of 2026 Beginning cash balance i $ $ Print 42,525 $ 99,225 101,250 70,875 Progressive Learning Cash Budget For the Year Ended December 31, 2025 First Quarter 133,275 $ 271,350 $ $ 143,325 $ Done 165,375 162,000 113,400 $ 264,600 87,750 61,425 440,775 $ 413,775 $1,259,175 Second Third Quarter Quarter 22,000 $ 20,933 $ 20,465 $ 20,065 $ Fourth Quarter Total 22,000 - X folla Clear all llov dge s sa les f ber 31 atr. qtr. qtr. d qtr. d qtr h qtr. d qtr. h qtr. th qtr Original Budgets Beginning cash balance. Cash receipts Cash available Cash payments: Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes. Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (de ciency) Financing Borrowing Cash Budget For the Year Ended December 31, 2025 First Quarter $ Print 22,000 $ 20,933 $ 133,275 271,350 155,275 10,000 58,232 14,000 17,835 61,775 2,500 0 164,342 (9,067) (20,000) (29,067) Second Quarter 30.000 292,283 10,000 181,688 37,200 20,155 65,825 2,500 450 46,000 Third Quarter Done 20,465 $ 440,775 461,240 10,000 236,080 39,200 20,355 71,900 317,818 (26.535) 80,065 (20,000) (20,000) (45,535) 60,065 2,500 1,140 381,175 0 Fourth Quarter 20,065 $ 413,775 433,840 10,000 229,808 29,200 19,355 64,475 2,500 240 355,578 78,262 (20,000) 58,262 0 Total 22,000 1,259,175 1,281,175 40,000 705,808 119,600 77,700 263,975 10,000 1,830 1,218,913 62,262 (20,000) 42,262 76,000 X follows Clear all 31 tr. tr. tr. tr. atr atr, Original Budgets Beginning cash balance Cash receipts Cash available Cash payments: Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes Interest expense Total cash payments Ending cash balance before financing i Minimum cash balance desired Projected cash excess (de ciency) Financing: Borrowing Principal repayments Total effects of financing Ending cash balance es $ Print 22,000 $ 133,275 155,275 10,000 58,232 14,000 17,835 61,775 2,500 0 30,000 0 20,933 $ 30,000 20,933 $ 271,350 10,000 181,688 37,200 20,155 65,825 2,500 450 164,342 317,818 (9,067) (25,535) (20,000) (20,000) (29,067) (45,535) 292,283 46,000 0 20,465 $ Done 440,775 461,240 10,000 236,080 39,200 20,355 71,900 2,500 1,140 381,175 80,065 (20,000) 60,065 0 (60,000) 46,000 (60,000) 20,465 $ 20,065 $ 20,065 $ 22,000 413,775 1,259,175 433,840 10,000 229,808 29,200 19,355 64,475 2,500 240 355,578 78,262 (20,000) 58,262 0 (16,000) (16,000) 62,262 1,281,175 40,000 705,808 119,600 77,700 263,975 10,000 1,830 1,218,913 62,262 (20,000) 42,262 76,000 (76,000) 0 62,262 I Cle budget to show fourth quarter sales of 900 tablets due to the expectation get.) 024 Reference Budgeted tablets to be sold Sales price per unit Total sales Progressive Learning Sales Budget For the Year Ended December 31, 2025 First Third Quarter Quarter $ $ 450 450 $ 202,500 $ Print Second Quarter Read the requirements. 750 450 $ 337,500 $ 1,200 450 $ 540,000 $ Done Fourth Quarter Total 900 450 $ 405,000 $1,485,000 3,300 450 X More info 30% in the quarter of the sale 35% in quarter after the sale 33% two quarters after the sale 2% never collected Print Done X ,C Requirements 1. Revise the schedule of budgeted cash receipts to include the increase in fourth quarter sales and the change in the timing of customer receipts. 2. How will the changes in cash receipts affect the cash budget? Print Done - X Progressive Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for 2025: (Click the icon to view the original budgets.) Progressive Learning decided to revise its sales budget to show fourth quarter sales of 900 tablets due to the expectation of increased holiday sales. (Click the icon to view the revised sales budget) Total sales Cash Receipts from Customers: Accounts Receivable balance, December 31, 2024 1st Qtr-Cash sales 1st Qtr-Credit sales collected in 1st qtr. 1st Qtr.-Credit sales collected in 2nd qtr. 1st Qtr-Credit sales collected in 3rd qtr 2nd Qtr-Cash sales 2nd Qtr-Credit sales collected in 2nd qtr 2nd Qtr-Credit sales collected in 3rd qtr. 2nd QtrCredit sales collected in 4th otr Etext pages Calculator 23 Suppose a change in the receipt of cash from sales on account is as follows: (Click the icon to view the revised receipt of cash information.) Read the requirements. First Second Third Fourth Quarter Quarter Quarter Quarter stv ST Total Clear all Check answer > Progressive Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for 2025: (Click the icon to view the original budgets.) Progressive Learning decided to revise its sales budget to show fourth quarter sales of 900 tablets due to the expectation of increased holiday sales. (Click the icon to view the revised sales budget.) 1st Qtr-Credit sales collected in 2nd qtr. 1st Qtr-Credit sales collected in 3rd qtr. 2nd Qtr-Cash sales 2nd Qtr.-Credit sales collected in 2nd qtr. 2nd Qtr-Credit sales collected in 3rd qtr. 2nd Qtr-Credit sales collected in 4th qtr. 3rd Qtr-Cash sales 3rd Qtr-Credit sales collected in 3rd qtr. 3rd Qtr-Credit sales collected in 4th qtr. 4th Qtr-Cash sales 4th Qtr-Credit sales collected in 4th qtr.. Total cash receipts from customers Etext pages Calculator HEIDS Suppose a change in the receipt of cash from sales on account is as follows: (Click the icon to view the revised receipt of cash information.) Read the requirements. Clear all Check

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!