Help Solving?

Given Data GRAVAT SALES COMPANY Minimum ending cash balance Geling price pe Recent and forecast sales in January February 12.000 210 CRAVAT SALES COMPANY Hudget Apre MEY 3 Quarter Ta Saudet Budgeted es in uns Saling priceperunt Total sales 33,000 8.10 267300 April May June 20 000 24 000 28.000 33 000 41.000 65.000 40,000 35.000 32.00 Apart September Th. Schedule of expected cash collections February March sales Art Maya June Toll cash collection Desdancing in percentage of next month's Sales Cesta se (per $ 485 Purchases paid as follows: in modo purchase In following month 50% tc. Merchandise purchases budget Budgeted with A budgeted ending Total needs Loss being any Required ut purchases Unitost Required dollar purchases 24.750 Collection on Swecolected current mom Salas colected for mom polected and monitorowing 30% BO 10 Variable monthly experie Son per te $ 100 10. Budgeted cash disbursements for inventory purchase Marth purchases Are puthases My purchase June purchases Total cash payment Fuad monthly expenses Wages and sales Insurance Depreciation Mecano 5 $ $ 5 5 22.000 14.000 1.200 1.500 3.000 CRAVAT SALES COMPANY Cash Budget For the Three Month Ending June 30 Land purchased in May Divide care achter $ 5 30.000 12.000 Apre May June Quarter Balance sheet of March 31: 14.000 Cathao, ging Alt recept from some Totalt Les distants Purchase of inventory Salomon Cau 5 Accounts February $19.440 March 150 Inventory 4.750 Prepaid in Finde, niet of depresion Tetats 178.200 1200X750 14.400 172.700 499 337 50 Mecane Dividend paid Land he Ency ofrece Derdinaments France Bonews Repayments Liabilities and Stockholders' Equity Accounts payable Dividends payable Capital Reeders Telas med holders .00 75 12.000 300,000 T1034 400 33750 To financing Cash Banding 5 1000 5300.000 Agreement with Bank Bowing increme Mamborong interese per mon Repayment incremen Teatret podchquarter Required minimum cabine 5 CRAVAT SALES COMPAN Budgeted Income Statement For the Three Month Ended June 30 1.000 100% 12.000 5 Bas CRAVAT SALES COMPANY Budgeted Income Statement For the Three Months Ended June 30 Sales in units Sales Variable expenses Cost of goods sold Commissions Contribution margin Fixed expenses: Salaries and wages Utilities Insurance expired Depreciation Miscellaneous Not operating income Loss interest expense Net income CRAVAT SALES COMPANY Budgeted Balance Sheet June 30 Assets Cash Accounts receivable Inventory Unexpired Insurance Fixed assets, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable, purchases Dividends payable Loans payable, bank Capital stock, no par Retained earnings Total abilities and equity Accounts receivabitat June 30: May sales June sales Total Retained earnings at June 30: Balance, March 31 Add net income Total Lese dividends declared Balance, June 30 12.000 8.1 June Quarter Given Data CRAVAT SALES COMPANY Minimum ending cash balance Selling price (per uni Recent and forecast sales in units January actual February (actual March actual April May June July August September 20.000 24.000 26.000 33.000 41,000 65.000 40,000 36.000 32.000 75% Desired ending inventories (percentage of red month's sales) Cost of the (per unit) 485 Purchases paid as follows: In month of purchase In following month 50% Collection on sales Sales collected current month Sales collected following month Sales collected and month following 30 50% 10% Variable monthly expenses Sales commissions pere) Fixed monthly expenses: Wages and sales Us Insurance Depreciation Miscellaneous 22.000 14.000 1.200 1.500 3.000 30.000 12.000 June Quarter 14.000 Land purchased in May Dividenda dedilared each quarter Balance sheet at March 31: Asset Cash Accounts receivable February sales March was Inventory (24.750 units) Prepaid insurance Find assets ned of depreciation Tous 19.440 158.760 178.200 120.0375 14400 172,700 40.375 Liabilities and Stockholders' Equity Accounts payable Dividends payable Capital stock Retained earnings Totales and stockholders' equity 76.990.75 12.000 300.000 $10.343.75 4.3375 Agreement with Bank: Borrowing increments Maximum borrowing amount Interest rate per month Repayment increments Total of interest paid each quarter Required minimum cash balance 1,000 $300.000 1 100% 12.000 CRAVAT SALES COMPANY Budgeted Balance Sheet June 30 Assets Cash Accounts receivable Inventory Unexpired insurance Fixed assets, net of depreciation Total assets Liabilities and Stockholders'Equity Accounts payable, purchases Dividends payable Loans payable, bank Capital stock, no par Retained earings Total liabilities and equity Accounts receivable at June 30: May sales June sales Total Retained earnings at June 30: Balance, March 31 Add net incombe Total Less dividends declared Balance, June 30 OUWPANT Budget Agre See May 1. Sales Budget Bargeld sales Sating proper uit Totales 33.000 81 w Fibrary 20.000 34.000 25.000 33.000 Gom My 41.200 Scheme of species cash con February 40.000 00 12200 A Tito cash belons Desige Pathful push 99% 20.750 1. Merchandise purchases huge Bafted Ade budget antingenter Twe Les teen Required phases UN Frequired cedar pucha 1 Budgeted cash disbursement forventny purchase Marsha Alps Mary purchases up Taha Collection on sale Selected SON Bu pe Wand 22.000 00 1.200 1900 1300 CRAVAT SALES CONFWNY Cuih Budget For the Thanth Ende 10 Land 30.000 2000 May Banshee March 11 Cashbace, beginning As rochn from our Taware Listillaram | Pantheory Baca 14,30 Acco . 75.50 Mac Pregun Fees, 1egration 17200 120,0075 00 1127001 499, Miscus Odens Land purchases Lepty Accra De Excel www.br Fan Borrow agen 75 2000 300.000 70475 Tanang Cash blonde, entno Agent with an Bergen mm botwing amount 1.00 00.000 Rent 1,000 100% 12.900 Parama tree AINT SALES COMPANY sted Income Statement on Month Ende uno Sint Swes VO C Com Controman Sales and was Us norep Open | Net puta come Lasten Net income Given Data GRAVAT SALES COMPANY Minimum ending cash balance Geling price pe Recent and forecast sales in January February 12.000 210 CRAVAT SALES COMPANY Hudget Apre MEY 3 Quarter Ta Saudet Budgeted es in uns Saling priceperunt Total sales 33,000 8.10 267300 April May June 20 000 24 000 28.000 33 000 41.000 65.000 40,000 35.000 32.00 Apart September Th. Schedule of expected cash collections February March sales Art Maya June Toll cash collection Desdancing in percentage of next month's Sales Cesta se (per $ 485 Purchases paid as follows: in modo purchase In following month 50% tc. Merchandise purchases budget Budgeted with A budgeted ending Total needs Loss being any Required ut purchases Unitost Required dollar purchases 24.750 Collection on Swecolected current mom Salas colected for mom polected and monitorowing 30% BO 10 Variable monthly experie Son per te $ 100 10. Budgeted cash disbursements for inventory purchase Marth purchases Are puthases My purchase June purchases Total cash payment Fuad monthly expenses Wages and sales Insurance Depreciation Mecano 5 $ $ 5 5 22.000 14.000 1.200 1.500 3.000 CRAVAT SALES COMPANY Cash Budget For the Three Month Ending June 30 Land purchased in May Divide care achter $ 5 30.000 12.000 Apre May June Quarter Balance sheet of March 31: 14.000 Cathao, ging Alt recept from some Totalt Les distants Purchase of inventory Salomon Cau 5 Accounts February $19.440 March 150 Inventory 4.750 Prepaid in Finde, niet of depresion Tetats 178.200 1200X750 14.400 172.700 499 337 50 Mecane Dividend paid Land he Ency ofrece Derdinaments France Bonews Repayments Liabilities and Stockholders' Equity Accounts payable Dividends payable Capital Reeders Telas med holders .00 75 12.000 300,000 T1034 400 33750 To financing Cash Banding 5 1000 5300.000 Agreement with Bank Bowing increme Mamborong interese per mon Repayment incremen Teatret podchquarter Required minimum cabine 5 CRAVAT SALES COMPAN Budgeted Income Statement For the Three Month Ended June 30 1.000 100% 12.000 5 Bas CRAVAT SALES COMPANY Budgeted Income Statement For the Three Months Ended June 30 Sales in units Sales Variable expenses Cost of goods sold Commissions Contribution margin Fixed expenses: Salaries and wages Utilities Insurance expired Depreciation Miscellaneous Not operating income Loss interest expense Net income CRAVAT SALES COMPANY Budgeted Balance Sheet June 30 Assets Cash Accounts receivable Inventory Unexpired Insurance Fixed assets, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable, purchases Dividends payable Loans payable, bank Capital stock, no par Retained earnings Total abilities and equity Accounts receivabitat June 30: May sales June sales Total Retained earnings at June 30: Balance, March 31 Add net income Total Lese dividends declared Balance, June 30 12.000 8.1 June Quarter Given Data CRAVAT SALES COMPANY Minimum ending cash balance Selling price (per uni Recent and forecast sales in units January actual February (actual March actual April May June July August September 20.000 24.000 26.000 33.000 41,000 65.000 40,000 36.000 32.000 75% Desired ending inventories (percentage of red month's sales) Cost of the (per unit) 485 Purchases paid as follows: In month of purchase In following month 50% Collection on sales Sales collected current month Sales collected following month Sales collected and month following 30 50% 10% Variable monthly expenses Sales commissions pere) Fixed monthly expenses: Wages and sales Us Insurance Depreciation Miscellaneous 22.000 14.000 1.200 1.500 3.000 30.000 12.000 June Quarter 14.000 Land purchased in May Dividenda dedilared each quarter Balance sheet at March 31: Asset Cash Accounts receivable February sales March was Inventory (24.750 units) Prepaid insurance Find assets ned of depreciation Tous 19.440 158.760 178.200 120.0375 14400 172,700 40.375 Liabilities and Stockholders' Equity Accounts payable Dividends payable Capital stock Retained earnings Totales and stockholders' equity 76.990.75 12.000 300.000 $10.343.75 4.3375 Agreement with Bank: Borrowing increments Maximum borrowing amount Interest rate per month Repayment increments Total of interest paid each quarter Required minimum cash balance 1,000 $300.000 1 100% 12.000 CRAVAT SALES COMPANY Budgeted Balance Sheet June 30 Assets Cash Accounts receivable Inventory Unexpired insurance Fixed assets, net of depreciation Total assets Liabilities and Stockholders'Equity Accounts payable, purchases Dividends payable Loans payable, bank Capital stock, no par Retained earings Total liabilities and equity Accounts receivable at June 30: May sales June sales Total Retained earnings at June 30: Balance, March 31 Add net incombe Total Less dividends declared Balance, June 30 OUWPANT Budget Agre See May 1. Sales Budget Bargeld sales Sating proper uit Totales 33.000 81 w Fibrary 20.000 34.000 25.000 33.000 Gom My 41.200 Scheme of species cash con February 40.000 00 12200 A Tito cash belons Desige Pathful push 99% 20.750 1. Merchandise purchases huge Bafted Ade budget antingenter Twe Les teen Required phases UN Frequired cedar pucha 1 Budgeted cash disbursement forventny purchase Marsha Alps Mary purchases up Taha Collection on sale Selected SON Bu pe Wand 22.000 00 1.200 1900 1300 CRAVAT SALES CONFWNY Cuih Budget For the Thanth Ende 10 Land 30.000 2000 May Banshee March 11 Cashbace, beginning As rochn from our Taware Listillaram | Pantheory Baca 14,30 Acco . 75.50 Mac Pregun Fees, 1egration 17200 120,0075 00 1127001 499, Miscus Odens Land purchases Lepty Accra De Excel www.br Fan Borrow agen 75 2000 300.000 70475 Tanang Cash blonde, entno Agent with an Bergen mm botwing amount 1.00 00.000 Rent 1,000 100% 12.900 Parama tree AINT SALES COMPANY sted Income Statement on Month Ende uno Sint Swes VO C Com Controman Sales and was Us norep Open | Net puta come Lasten Net income