Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Managerial X MInbox (2,44 X Assignment Do HomewoX C Applied Les x C Yem Has $ X 1 Syllabus udent/PlayerHomework.aspx?homeworkid=571889057&questionId=10&flushed=false&ld=6035890¢erwin=yes 3-29:010:204:H6 - Summer 2020 Dis!

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Managerial X MInbox (2,44 X Assignment Do HomewoX C Applied Les x C Yem Has $ X 1 Syllabus udent/PlayerHomework.aspx?homeworkid=571889057&questionId=10&flushed=false&ld=6035890¢erwin=yes 3-29:010:204:H6 - Summer 2020 Dis! 22 assignment 6 of 10 (10 complete) the following Original Budgets ws: al budgets.) se its sales ed sales bud le of budget ve the bo Customers Specialized Learning Sales Budget For the Year Ended December 31, 2019 First Second Third Fourth Quarter Quarter Quarter Quarter Total Budgeted tablets to be sold 450 750 1,200 650 3,050 Sales price per unit $ 450 $ 450 $ 450||$ 450 S 450 $ Total sales 202,500 $ 337,500 $ 540,000 $ 292,500 $ 1,372,500 Schule of Cash Receipts from Customers First Second Third Fourth Quarter Quarter Quarter Quarter Total Total sales $ 202,500 $ 337,500 $ 540,000 $ 292,500 $ 1,372,500 First Second Third Fourth Quarter Quarter Quarter Quarter Total Cash Receipts from Customers: Accounts Receivable balance, December 31, 2018 s 30,000 1st Qtr-Cash sales (30%) 60,750 : cember 31, 2 ist qtr. 2nd qtr. n 3rd qtr olds and then a Print Done Managerial Inbox (2,44 Assignment X Do Homewo X C Applied Led X C Yem Hass 7 Syllabus ent/PlayerHomework.aspx?homeworkld=571889057&questionid=10&flushed=false&cid=6035890¢erwin-yes 29:010:204:H6 - Summer 2020 Disha 2 assignment 6 of 10 (10 complete) HV following 0 Original Budgets ws: udgets. its sales $ 30,000 60,750 sales bud 42,525 $ Ve the box of budget 99 225 101,250 70.875 stomers Accounts Receivable balance, December 31, 2018 1st Qt. Cash sales (30%) 1st Qtr.-Credit sales (70%), 30% collected in 1st qtr. 1st Qur.-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 salos (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 QtrCash sales (30%) 4th Qtr - Credit sales (70%), 30% collected in 4th qtr. $ 165,375 162,000 113.400 $ 264,600 87,750 61,425 440.775$ 413,775 $ 1,259,175 $ 133,275 $ 271,350 $ mber 31, 2 Total cash receipts from customers st qtr. Accounts Receivable balance, December 31, 2019: 4th Qtr-Credit sales (70%), 70% collected in 1st qtr of 2020 nd qtr. $ 143,325 rdqtr. Specialized Learning 3 and then a Print Done assignment 6 of 10 (10 complete) w lowing Original Budgets gets.) sales les bud Specialized Learning Cash Budget For the Year Ended December 31, 2019 First Second Third Quarter Quarter Quarter Fourth ve budgete Quarter Total $ Beginning cash balance 22,000 $ 133,275 20,933 $ 271,350 20,465 $ 440,775 20,065 $ 413,775 22.000 1,259,175 omers Cash receipts 155,275 292,283 461,240 433,840 Cash available 1,281,175 10,000 10.000 10,000 10.000 181,688 229,808 Cash payments: Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 236,080 39,200 29,200 58,232 14,000 17,835 61.775 2,500 19,355 37,200 20,155 65,825 2,500 450 20,355 71,900 40,000 705,808 119,600 77,700 263,975 10.000 1,830 aber 31,24 64,475 2,500 1,140 2,500 240 qtr. 0 Interest expenso 164,342 317.818 381,175 355,578 1.218.913 str. Total cash payments Ending cash balance before financing 80,065 (9.067) ons (25,535) ni 78.262 annons 62,262 non in Anni and then a Print Done assignment 6 of 10 (10 complete) wing i Original Budgets ets. 155,275 292,283 461,240 433,840 1,281,175 ales 10,000 10,000 bud 40,000 10,000 58,232 236,080 Cash available Cash payments: Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 10,000 229,808 29,200 705,808 adget 14,000 39,200 119,600 181,688 37,200 20,155 65,825 17,835 19,355 77,700 hers 61,775 64,475 263,975 20,355 71,900 2,500 1,140 2,500 0 2,500 450 2,500 240 10,000 1,830 Interest expense 164,342 317,818 381,175 355,578 1,218.913 Total cash payments (9,067) (20,000) (25,535) (20,000) 80,065 (20,000) 78.262 (20,000) 62,262 (20,000) (29,067) (45,535) 60.065 58,262 42.262 er 31, 2, Ending cash balance before financing Minimum cash balance desired Projected cash excess (de ciency) Financing: Borrowing Principal repayments Total effects of financing 30,000 0 46,000 0 0 (60,000) 0 (16,000) 76,000 (76,000) tr. 30,000 (60,000) (16,000) 0 46,000 20,465 $ qtr. $ 20.933 $ 20,065 $ 62,262 62,262 Ending cash balance and then a Print Done assignment 6 of 10 (10 complete) ollowing sales budget, schedule of budgeted cash receipts, and cash budget for idgets.) s sales budget to show fourth quarter sales of 900 tablets due to the expectation 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 ales budget.) - Reference budgeted cash receipts In the table, leave the omers Specialized Learning Sales Budget For the Year Ended December 31, 2019 Second Third Quarter Quarter Quarter Fourth Quarter Total 450 450 $ 750 450 $ 1.200 450 $ 900 450 $ 3,300 450 $ Budgeted tablets to be sold Sales price per unit Total sales $ 202,500 $ ber 31, 2018 337,500 $ 540,000 $ 405,000 S 1,485,000 atr. Print Done gtr atr. ng sales budget, schedule of budgeted cash receipts, and cash budget for Suppose a change in the receipt of cash from sales on ac (Click the icon to view the revised receipt of cash info mes budget to show fourth quarter sales of 900 tablets due to the expectation Read the requirements oudget.) geted cash receipts to include the increase in fourt pr receipts. (If a box is not used in 0 More Info rs First Second TI Quarter Quarter Qu 30% in the quarter of the sple 35% in quarter after the sale 33% two quarters after the sale 2% never collected First Second TH Quarter Quarter Qu 31, 2018 Print Done assig ore: 0 of 1 pt 6 of 10 (10 complete) 19: CYU22-2 (similar to) ecialized Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for Suppose a change in (Click the icon (Click the icon to view the original budgets.) Decialized Learning decided to revise its sales budget to show fourth quarter sales of 900 tablets due to the expectation Read the requiremer increased holiday sales (Click the icon to view the revised sales budget.) otal sales First Second Third Fourth Quarter Quarter Quarter Quarter Total Cash Receipts from Customers: Accounts Receivable balance, December 31, 2018 1st Qtr.-Cash sales st Qtr-Credit sales collected in 1st qtr. 1st Qtr.-Credit sales collected in 2nd qtr. 1st Qtr.-Credit sales collected in 3rd qtr. 2nd Otr-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. Enter any number in the edit fields and then click Check Answer. Decialized Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for Suppose 19: (Click Click the icon to view the original budgets.) Read the pecialized Learning decided to revise its sales budget to show fourth quarter sales of 900 tablets due to the expectation fincreased holiday sales. (Click the icon to view the revised sales budget.) Accounts Receivable balance, December 31, 2018 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 Qur.---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 Qur.-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 Enter any number in the edit fields and then click Check Answer. 1 part remaining Clear All Managerial X MInbox (2,44 X Assignment Do HomewoX C Applied Les x C Yem Has $ X 1 Syllabus udent/PlayerHomework.aspx?homeworkid=571889057&questionId=10&flushed=false&ld=6035890¢erwin=yes 3-29:010:204:H6 - Summer 2020 Dis! 22 assignment 6 of 10 (10 complete) the following Original Budgets ws: al budgets.) se its sales ed sales bud le of budget ve the bo Customers Specialized Learning Sales Budget For the Year Ended December 31, 2019 First Second Third Fourth Quarter Quarter Quarter Quarter Total Budgeted tablets to be sold 450 750 1,200 650 3,050 Sales price per unit $ 450 $ 450 $ 450||$ 450 S 450 $ Total sales 202,500 $ 337,500 $ 540,000 $ 292,500 $ 1,372,500 Schule of Cash Receipts from Customers First Second Third Fourth Quarter Quarter Quarter Quarter Total Total sales $ 202,500 $ 337,500 $ 540,000 $ 292,500 $ 1,372,500 First Second Third Fourth Quarter Quarter Quarter Quarter Total Cash Receipts from Customers: Accounts Receivable balance, December 31, 2018 s 30,000 1st Qtr-Cash sales (30%) 60,750 : cember 31, 2 ist qtr. 2nd qtr. n 3rd qtr olds and then a Print Done Managerial Inbox (2,44 Assignment X Do Homewo X C Applied Led X C Yem Hass 7 Syllabus ent/PlayerHomework.aspx?homeworkld=571889057&questionid=10&flushed=false&cid=6035890¢erwin-yes 29:010:204:H6 - Summer 2020 Disha 2 assignment 6 of 10 (10 complete) HV following 0 Original Budgets ws: udgets. its sales $ 30,000 60,750 sales bud 42,525 $ Ve the box of budget 99 225 101,250 70.875 stomers Accounts Receivable balance, December 31, 2018 1st Qt. Cash sales (30%) 1st Qtr.-Credit sales (70%), 30% collected in 1st qtr. 1st Qur.-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 salos (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 QtrCash sales (30%) 4th Qtr - Credit sales (70%), 30% collected in 4th qtr. $ 165,375 162,000 113.400 $ 264,600 87,750 61,425 440.775$ 413,775 $ 1,259,175 $ 133,275 $ 271,350 $ mber 31, 2 Total cash receipts from customers st qtr. Accounts Receivable balance, December 31, 2019: 4th Qtr-Credit sales (70%), 70% collected in 1st qtr of 2020 nd qtr. $ 143,325 rdqtr. Specialized Learning 3 and then a Print Done assignment 6 of 10 (10 complete) w lowing Original Budgets gets.) sales les bud Specialized Learning Cash Budget For the Year Ended December 31, 2019 First Second Third Quarter Quarter Quarter Fourth ve budgete Quarter Total $ Beginning cash balance 22,000 $ 133,275 20,933 $ 271,350 20,465 $ 440,775 20,065 $ 413,775 22.000 1,259,175 omers Cash receipts 155,275 292,283 461,240 433,840 Cash available 1,281,175 10,000 10.000 10,000 10.000 181,688 229,808 Cash payments: Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 236,080 39,200 29,200 58,232 14,000 17,835 61.775 2,500 19,355 37,200 20,155 65,825 2,500 450 20,355 71,900 40,000 705,808 119,600 77,700 263,975 10.000 1,830 aber 31,24 64,475 2,500 1,140 2,500 240 qtr. 0 Interest expenso 164,342 317.818 381,175 355,578 1.218.913 str. Total cash payments Ending cash balance before financing 80,065 (9.067) ons (25,535) ni 78.262 annons 62,262 non in Anni and then a Print Done assignment 6 of 10 (10 complete) wing i Original Budgets ets. 155,275 292,283 461,240 433,840 1,281,175 ales 10,000 10,000 bud 40,000 10,000 58,232 236,080 Cash available Cash payments: Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 10,000 229,808 29,200 705,808 adget 14,000 39,200 119,600 181,688 37,200 20,155 65,825 17,835 19,355 77,700 hers 61,775 64,475 263,975 20,355 71,900 2,500 1,140 2,500 0 2,500 450 2,500 240 10,000 1,830 Interest expense 164,342 317,818 381,175 355,578 1,218.913 Total cash payments (9,067) (20,000) (25,535) (20,000) 80,065 (20,000) 78.262 (20,000) 62,262 (20,000) (29,067) (45,535) 60.065 58,262 42.262 er 31, 2, Ending cash balance before financing Minimum cash balance desired Projected cash excess (de ciency) Financing: Borrowing Principal repayments Total effects of financing 30,000 0 46,000 0 0 (60,000) 0 (16,000) 76,000 (76,000) tr. 30,000 (60,000) (16,000) 0 46,000 20,465 $ qtr. $ 20.933 $ 20,065 $ 62,262 62,262 Ending cash balance and then a Print Done assignment 6 of 10 (10 complete) ollowing sales budget, schedule of budgeted cash receipts, and cash budget for idgets.) s sales budget to show fourth quarter sales of 900 tablets due to the expectation 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 ales budget.) - Reference budgeted cash receipts In the table, leave the omers Specialized Learning Sales Budget For the Year Ended December 31, 2019 Second Third Quarter Quarter Quarter Fourth Quarter Total 450 450 $ 750 450 $ 1.200 450 $ 900 450 $ 3,300 450 $ Budgeted tablets to be sold Sales price per unit Total sales $ 202,500 $ ber 31, 2018 337,500 $ 540,000 $ 405,000 S 1,485,000 atr. Print Done gtr atr. ng sales budget, schedule of budgeted cash receipts, and cash budget for Suppose a change in the receipt of cash from sales on ac (Click the icon to view the revised receipt of cash info mes budget to show fourth quarter sales of 900 tablets due to the expectation Read the requirements oudget.) geted cash receipts to include the increase in fourt pr receipts. (If a box is not used in 0 More Info rs First Second TI Quarter Quarter Qu 30% in the quarter of the sple 35% in quarter after the sale 33% two quarters after the sale 2% never collected First Second TH Quarter Quarter Qu 31, 2018 Print Done assig ore: 0 of 1 pt 6 of 10 (10 complete) 19: CYU22-2 (similar to) ecialized Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for Suppose a change in (Click the icon (Click the icon to view the original budgets.) Decialized Learning decided to revise its sales budget to show fourth quarter sales of 900 tablets due to the expectation Read the requiremer increased holiday sales (Click the icon to view the revised sales budget.) otal sales First Second Third Fourth Quarter Quarter Quarter Quarter Total Cash Receipts from Customers: Accounts Receivable balance, December 31, 2018 1st Qtr.-Cash sales st Qtr-Credit sales collected in 1st qtr. 1st Qtr.-Credit sales collected in 2nd qtr. 1st Qtr.-Credit sales collected in 3rd qtr. 2nd Otr-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. Enter any number in the edit fields and then click Check Answer. Decialized Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for Suppose 19: (Click Click the icon to view the original budgets.) Read the pecialized Learning decided to revise its sales budget to show fourth quarter sales of 900 tablets due to the expectation fincreased holiday sales. (Click the icon to view the revised sales budget.) Accounts Receivable balance, December 31, 2018 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 Qur.---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 Qur.-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 Enter any number in the edit fields and then click Check Answer. 1 part remaining Clear All

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Disruption In The Audit Market

Authors: Krish Bhaskar, John Flower

1st Edition

0367220660, 978-0367220662

More Books

Students also viewed these Accounting questions