Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this are better pictures Create a spreadsheet for items a through e. . Bateri Sale the Quarter March Hary Perry Man he 26 171 When

image text in transcribed
image text in transcribed
this are better pictures image text in transcribed
image text in transcribed
Create a spreadsheet for items a through e. . Bateri Sale the Quarter March Hary Perry Man he 26 171 When coming them to the one that and in the budget fewing tedd before trying w 2018 rep the budget for the first Production Mary February March 16600 SA125 Suded GI 2) 1700 Badpeted , Inty leto) 8. Prelon JYNO PAD tawy ruchododech pod 0.5 the entertag Manager 20 the following production and inventory conding Pendudget and change for the Leder in Direct Material Purchase For the Outer Ended March 2010 January February Budcho Fraldton 14700 STAD Meriols 3 3 3 8. Igea Materials 44/ Bad Bad Met W.070 Budete bry, Mat. La Mer Borders C 67078586 Soderin Purchasing ty for the Ouartered March 11. 2017 February Pendid Purchase Cost SD 526751870 320 B53361 de window Parachas For the trended March 11, 2011 22 CS3 B/PEO from 76730 288 Sto LCN Sales 52 24626 Sed collection des termine the dhe month of and the bet af December 2011.00 Prep the burde of the other Seder Schedule Cache For the Quarter Ended March 11, 2013 nuary February M Poriad End Cath sees 7870 Beste 37510 Songary 702,202) 2015 380 V4210 Fry G327) 50 162.712192 34.22 sode wil woon of purchases of win the other the remaining in the town The Sloths for the month of December 31, 2018 December 2013 257 March 2707 Cath Lustiges Prepare the budgeted wheel for the Sodine Schedule of Cash Disement For the arter Ended March 31, 2010 January February March Period End ad co Den 298 990 xved from Jor: 22676 LbO, GA 9234 2283 Feb. 28710 Lloga 28710 Mac 37 LLON 20594 losh Payments 2772/a3l 3700 APISA Create a spreadsheet for items a. through e. W Sedor Inmatures of layanach forint Sodanimated the former fw months of the 2010 hical wanita Moth Sin Unit 11.000 TED 25.000 March A 2.000 Pure the sales budget for the date Sales Budget For the Quarter Ended March 11. 2017 January February March Period End 5 15 3. lete SAS Renee 171 Ch Master When the annual but the manager in the wory shedd be on hand in case studie hanted. The manager dermed of the following budgeted we should be sufficient for the extra inventory Ending inventory December 2018 100 repare the production budget for the first warten Sedor Int. Production Budget For the Quarter Ended March 1, 2019 January February March Period End Sales 1500 Beyetded. I) 1100 Budget Bag. I wentary (1202700) 8. Bolechon 240 239 2 222 dfach to pounds of material and pound 0.50. Magerent budgets for me in the event the shortage from upplies Margement would be the 200 of the following production in ending with month Ending inventory of train materials at December 31, 2015 39.500 Prepare the materials true and purchaung budget for the best quan March Pried End Soderlos Direct Material Purchase Budget for the Quarter Ended March 312015 January February Bodgeted Production WO SSASO Materials 3 3 3 Budgeto Materials Quico Bulgated End Met. The 1,070 Budaptor Ery, Met TM (B) (1100 Materi Perdeses ise 6757707858 ! Sedertec Purchasing Budget For the Ouarter Ended March 11, 2019 Lanuary February March Period End Materials for hoxes 45670 Purchase Cost 2287598.70 24290 85835 so d Sodor's sales history indicates that of sales will be for cash and 6 of sales will be on Credit Using the information from the sales budget, the forecasted cash and credit sales can be determined Sodor Inc. Forecasted Cash Sales and Credit Sales For the Quarter Ended March 31, 2019 January February March Period End Sales Bodyl, 720 BIDO froma Cosh Solo (353) 78750 283500 Cond Sales (52) 522 500 Sodor has reviewed past collection history and has determined that credit sales will be collected as follow 70% is collected in the month of sale and 30% is collected the following month. The total credit sales for the month of December 31, 2018 were 5125,000 Prepare the budgeted schedule of cash receipts for the first quartet Sodor Inc. Schedule of Cash Receipts For the Quarter Ended March 31, 2019 January February March Period End Cash Soles 78750 283.500 December 2018 (25000$ 37500 3752 Jerry 1702,302) V6 2875 43875 February 602 303 75560 March (70%) 143323 2/6475122/235 306221 7600781 el Sodor will pay for 60% of its purchases of material in the month the material is purchased and the remaining 40% in the following month. The total credit purchases for the month of December 31, 2018 were 535,000 Cash Reipts Prepare the budgeted schedule of cash disbursements for the first quarter from Den 2018 (35000x406) Jer. 22875 llo2,407 70 9334 Feb. 28710 LLOR, Mar. 34280 (Lood logh Payments Sodor Inc. Schedule of Cash Disbursements For the Quarter Ended March 31, 2019 January February March Period End Laco Ly000 22835 2870 20574 2770/ 22310 32058 BL 115 Create a spreadsheet for items a through e. . Bateri Sale the Quarter March Hary Perry Man he 26 171 When coming them to the one that and in the budget fewing tedd before trying w 2018 rep the budget for the first Production Mary February March 16600 SA125 Suded GI 2) 1700 Badpeted , Inty leto) 8. Prelon JYNO PAD tawy ruchododech pod 0.5 the entertag Manager 20 the following production and inventory conding Pendudget and change for the Leder in Direct Material Purchase For the Outer Ended March 2010 January February Budcho Fraldton 14700 STAD Meriols 3 3 3 8. Igea Materials 44/ Bad Bad Met W.070 Budete bry, Mat. La Mer Borders C 67078586 Soderin Purchasing ty for the Ouartered March 11. 2017 February Pendid Purchase Cost SD 526751870 320 B53361 de window Parachas For the trended March 11, 2011 22 CS3 B/PEO from 76730 288 Sto LCN Sales 52 24626 Sed collection des termine the dhe month of and the bet af December 2011.00 Prep the burde of the other Seder Schedule Cache For the Quarter Ended March 11, 2013 nuary February M Poriad End Cath sees 7870 Beste 37510 Songary 702,202) 2015 380 V4210 Fry G327) 50 162.712192 34.22 sode wil woon of purchases of win the other the remaining in the town The Sloths for the month of December 31, 2018 December 2013 257 March 2707 Cath Lustiges Prepare the budgeted wheel for the Sodine Schedule of Cash Disement For the arter Ended March 31, 2010 January February March Period End ad co Den 298 990 xved from Jor: 22676 LbO, GA 9234 2283 Feb. 28710 Lloga 28710 Mac 37 LLON 20594 losh Payments 2772/a3l 3700 APISA Create a spreadsheet for items a. through e. W Sedor Inmatures of layanach forint Sodanimated the former fw months of the 2010 hical wanita Moth Sin Unit 11.000 TED 25.000 March A 2.000 Pure the sales budget for the date Sales Budget For the Quarter Ended March 11. 2017 January February March Period End 5 15 3. lete SAS Renee 171 Ch Master When the annual but the manager in the wory shedd be on hand in case studie hanted. The manager dermed of the following budgeted we should be sufficient for the extra inventory Ending inventory December 2018 100 repare the production budget for the first warten Sedor Int. Production Budget For the Quarter Ended March 1, 2019 January February March Period End Sales 1500 Beyetded. I) 1100 Budget Bag. I wentary (1202700) 8. Bolechon 240 239 2 222 dfach to pounds of material and pound 0.50. Magerent budgets for me in the event the shortage from upplies Margement would be the 200 of the following production in ending with month Ending inventory of train materials at December 31, 2015 39.500 Prepare the materials true and purchaung budget for the best quan March Pried End Soderlos Direct Material Purchase Budget for the Quarter Ended March 312015 January February Bodgeted Production WO SSASO Materials 3 3 3 Budgeto Materials Quico Bulgated End Met. The 1,070 Budaptor Ery, Met TM (B) (1100 Materi Perdeses ise 6757707858 ! Sedertec Purchasing Budget For the Ouarter Ended March 11, 2019 Lanuary February March Period End Materials for hoxes 45670 Purchase Cost 2287598.70 24290 85835 so d Sodor's sales history indicates that of sales will be for cash and 6 of sales will be on Credit Using the information from the sales budget, the forecasted cash and credit sales can be determined Sodor Inc. Forecasted Cash Sales and Credit Sales For the Quarter Ended March 31, 2019 January February March Period End Sales Bodyl, 720 BIDO froma Cosh Solo (353) 78750 283500 Cond Sales (52) 522 500 Sodor has reviewed past collection history and has determined that credit sales will be collected as follow 70% is collected in the month of sale and 30% is collected the following month. The total credit sales for the month of December 31, 2018 were 5125,000 Prepare the budgeted schedule of cash receipts for the first quartet Sodor Inc. Schedule of Cash Receipts For the Quarter Ended March 31, 2019 January February March Period End Cash Soles 78750 283.500 December 2018 (25000$ 37500 3752 Jerry 1702,302) V6 2875 43875 February 602 303 75560 March (70%) 143323 2/6475122/235 306221 7600781 el Sodor will pay for 60% of its purchases of material in the month the material is purchased and the remaining 40% in the following month. The total credit purchases for the month of December 31, 2018 were 535,000 Cash Reipts Prepare the budgeted schedule of cash disbursements for the first quarter from Den 2018 (35000x406) Jer. 22875 llo2,407 70 9334 Feb. 28710 LLOR, Mar. 34280 (Lood logh Payments Sodor Inc. Schedule of Cash Disbursements For the Quarter Ended March 31, 2019 January February March Period End Laco Ly000 22835 2870 20574 2770/ 22310 32058 BL 115

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions