Homework HW-8 Share the super shot of budget cash and bu Scholas Leg dereva how to 500 Suhde of Cash Racepta tom Cuers First Second THE Quarter First fecund That Querter Quarter Cash from Customers De 14 Q-Creed Agr Question 1, CYU22-2 (art expectation of day Fourth Queter THE Fourt Quarter Quarter Tote Suppor am Fant More info 30% 11% 32% - Pret HW S 78.57% 1.57 of 2 pots P0.57 of 1 atte of infor pt of a roma Done Save Scholastic Leaming had prewed the towing sales budget, schedule of budgeted cash receipts, and cash201 het vew the original ) Stolat Lening decided to revise ts sales bolped to show fourth quarter sales of 900 tatiets due to the expectation of nonosed ho to the ed es bulget) Sand They Fest Quarter Quarter Quarter Quarter Total Scand Th Frat Overtr Fourt Quarter **** Caen Meeps bron Customer Noco Roceratis tance December 11, 2018 -Cees deed in to M-10P Car-Ce cofein A pe 10400 164-ION TET ENGE 18 UHDALEST MINY DE DER END dur Or Sef Or-Cash sa e On-Cooki sessi Q-Chitth C-Chass O-Cds colected 40 tasheep frestas dpca GID Suchergenfrums on accounts as we view her Schalde Lening Saus Budget Fourth For the Year End December 31, 2018 First Second The Quar Quarter 150 1.200 4501 4501 337.500 $40.000 400 450 wo 450 405.000 202.500 Print Done References Bed to be sold Saw pric T ONEE 400 LA000 Original Budgets Scholastic Learning Sales Budget For the Year Ended December 31, 2019 First Second Third Quarter Quarter Quarter $ Budgeted tablets to be sold Sales price per unit $ Total sales Schdule of Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, December 31, 2018 1st Qtr-Cash sales (30%) 1st Qtr.-Credit sales (70 %), 30% collected in 1st qtr. 1st Qtr-Credit sales (70 %), 70% collected in 2nd qtr. 2nd Qtr-Cash salos (30%) 2nd Qtr-Credit sales (70%), 30% collected in 2nd qtr. 2nd Qtr-Credit sales (70%), 70% collected in 3rd qtr. 3rd Otr-Cash sales (30%) Print 450 750 650 3,050 450 $ 450 $ 450 $ 450 450 $ 202,500 $ 337,500 $ 540,000 $ 292,500 $ 1,372,500 First Second Third Fourth Quarter Quarter Quarter Quarter $ 202,500 $ 337,500 $ 540,000 $ 292,500 First Second Third Fourth Quarter Quarter Quarter Quarter $ 99,225 101,250 70,875 $ 30,000 60,750 42,525 Done Fourth Quarter 1,200 Total $ 165,375 162.000 Total 1,372,500 Total 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, 2019: 4th Qtr-Credit sales (70%), 70% collected in 1st qtr of 2020 Beginning cash balance Cash receipts Cash available Cash payments: Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses 133,275 $ 271,350 $ $ 143,325 Scholastic Learning Cash Budget For the Year Ended December 31, 2019 First Second Quarter Quarter $ 22,000 $ 133,275 155,275 10,000 58,232 14,000 17,835 61,775 20,933 $ 271,350 292,283 10,000 181,688 37,200 20,155 65,825 162,000 113,400 $ 264,600 87,750 61,425 440,775 $ 413,775 $ 1,259,175 Fourth Quarter Total Third Quarter 20,465 $ 440,775 461,240 10,000 236,080 39,200 20,355 71,900 20,065 $ 413,775 433,840 10,000 229,808 29,200 19,355 64,475 22,000 1,259,175 1,281,175 40,000 705,808 119,600 77,700 263,975 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 Principal repayments Total effects of financing Ending cash balance i For the Year Ended December 31, 2019 First Second Quarter Quarter 22,000 $ 20,933 $ 133,275 271,350 440,775 155,275 292,283 461,240 10,000 10,000 10,000 58,232 181,688 236,080 14,000 37,200 39,200 17,835 20,155 20,355 61,775 65,825 71,900 2,500 2,500 2,500 0 450 1,140 164,342 317,818 381,175 (9,067) (25,535) 80,065 (20,000) (20,000) (20,000) (29,067) (45,535) 60,065 30,000 46,000 0 0 0 (60,000) 30,000 46,000 (60,000) $ 20,933 $ 20,465 $ 20,065 $ $ Third Quarter 20,465 $ Fourth Quarter Total 20,065 $ 22,000 413,775 1,259,175 433,840 1,281,175 10,000 40,000 229,808 705,808 29,200 119,600 19,355 77,700 64,475 263,975 2,500 10,000 240 1,830 355,578 1,218,913 78,262 62,262 (20,000) (20,000) 58,262 42,262 0 76,000 (16,000) (76,000) (16,000) 0 62,262 62,262 Homework HW-8 Share the super shot of budget cash and bu Scholas Leg dereva how to 500 Suhde of Cash Racepta tom Cuers First Second THE Quarter First fecund That Querter Quarter Cash from Customers De 14 Q-Creed Agr Question 1, CYU22-2 (art expectation of day Fourth Queter THE Fourt Quarter Quarter Tote Suppor am Fant More info 30% 11% 32% - Pret HW S 78.57% 1.57 of 2 pots P0.57 of 1 atte of infor pt of a roma Done Save Scholastic Leaming had prewed the towing sales budget, schedule of budgeted cash receipts, and cash201 het vew the original ) Stolat Lening decided to revise ts sales bolped to show fourth quarter sales of 900 tatiets due to the expectation of nonosed ho to the ed es bulget) Sand They Fest Quarter Quarter Quarter Quarter Total Scand Th Frat Overtr Fourt Quarter **** Caen Meeps bron Customer Noco Roceratis tance December 11, 2018 -Cees deed in to M-10P Car-Ce cofein A pe 10400 164-ION TET ENGE 18 UHDALEST MINY DE DER END dur Or Sef Or-Cash sa e On-Cooki sessi Q-Chitth C-Chass O-Cds colected 40 tasheep frestas dpca GID Suchergenfrums on accounts as we view her Schalde Lening Saus Budget Fourth For the Year End December 31, 2018 First Second The Quar Quarter 150 1.200 4501 4501 337.500 $40.000 400 450 wo 450 405.000 202.500 Print Done References Bed to be sold Saw pric T ONEE 400 LA000 Original Budgets Scholastic Learning Sales Budget For the Year Ended December 31, 2019 First Second Third Quarter Quarter Quarter $ Budgeted tablets to be sold Sales price per unit $ Total sales Schdule of Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, December 31, 2018 1st Qtr-Cash sales (30%) 1st Qtr.-Credit sales (70 %), 30% collected in 1st qtr. 1st Qtr-Credit sales (70 %), 70% collected in 2nd qtr. 2nd Qtr-Cash salos (30%) 2nd Qtr-Credit sales (70%), 30% collected in 2nd qtr. 2nd Qtr-Credit sales (70%), 70% collected in 3rd qtr. 3rd Otr-Cash sales (30%) Print 450 750 650 3,050 450 $ 450 $ 450 $ 450 450 $ 202,500 $ 337,500 $ 540,000 $ 292,500 $ 1,372,500 First Second Third Fourth Quarter Quarter Quarter Quarter $ 202,500 $ 337,500 $ 540,000 $ 292,500 First Second Third Fourth Quarter Quarter Quarter Quarter $ 99,225 101,250 70,875 $ 30,000 60,750 42,525 Done Fourth Quarter 1,200 Total $ 165,375 162.000 Total 1,372,500 Total 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, 2019: 4th Qtr-Credit sales (70%), 70% collected in 1st qtr of 2020 Beginning cash balance Cash receipts Cash available Cash payments: Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses 133,275 $ 271,350 $ $ 143,325 Scholastic Learning Cash Budget For the Year Ended December 31, 2019 First Second Quarter Quarter $ 22,000 $ 133,275 155,275 10,000 58,232 14,000 17,835 61,775 20,933 $ 271,350 292,283 10,000 181,688 37,200 20,155 65,825 162,000 113,400 $ 264,600 87,750 61,425 440,775 $ 413,775 $ 1,259,175 Fourth Quarter Total Third Quarter 20,465 $ 440,775 461,240 10,000 236,080 39,200 20,355 71,900 20,065 $ 413,775 433,840 10,000 229,808 29,200 19,355 64,475 22,000 1,259,175 1,281,175 40,000 705,808 119,600 77,700 263,975 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 Principal repayments Total effects of financing Ending cash balance i For the Year Ended December 31, 2019 First Second Quarter Quarter 22,000 $ 20,933 $ 133,275 271,350 440,775 155,275 292,283 461,240 10,000 10,000 10,000 58,232 181,688 236,080 14,000 37,200 39,200 17,835 20,155 20,355 61,775 65,825 71,900 2,500 2,500 2,500 0 450 1,140 164,342 317,818 381,175 (9,067) (25,535) 80,065 (20,000) (20,000) (20,000) (29,067) (45,535) 60,065 30,000 46,000 0 0 0 (60,000) 30,000 46,000 (60,000) $ 20,933 $ 20,465 $ 20,065 $ $ Third Quarter 20,465 $ Fourth Quarter Total 20,065 $ 22,000 413,775 1,259,175 433,840 1,281,175 10,000 40,000 229,808 705,808 29,200 119,600 19,355 77,700 64,475 263,975 2,500 10,000 240 1,830 355,578 1,218,913 78,262 62,262 (20,000) (20,000) 58,262 42,262 0 76,000 (16,000) (76,000) (16,000) 0 62,262 62,262