ae d

Weller industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the stores operations toliow - Sales are budgeted at $330,000 for November, $350,000 for Decembet, and $340,000 for Lanuary - Collections ate expected to be 80% in the month of sale and 20 s in the mpnth following the sale: - The cost of goods sold is 70 s of sales. - The company desires an ending merchandise inventory equal to 70% of the cost of goods sold in the fobowing month. - Payment for merchandise la made in the month following the purctiase - Other monthly expenses to be paid in cash ate $21,300 - Monthly depreciation is $21100. - Ignore taxes a Prepare a Schedule of Eipected, Cash Collections for Noveinber and December. 6. Prepatea Merchendise Putchases Qucget for Novenber and December. CPrepare Cish Budgets for November and oecember. di Prepare Budgeted income Statements for Navember and Decemben e. Preparea Gudgered Bolance Sheet for the end of Decembin. Completei this question by entering your answers in thin tabs below. Heppare a Sctiedile of Fupestad Cath cosections for Fiovember and pecemoor Merchandise inventory Property, plant and equipeent (net of $595,000 accualated depreciatbon) Total assets Liabilities and Stockholders: Equity. Accounts payable Conmon stock Retained carnings Total Habilftes and stockholders'i equity Required: a. Prepare a Schedule of Expected Cash Collections for November and December b. Prepare a Merchandise Purchases Budget for November and December c. Prepare Cash Budgets for November and December d. Prepare Budgeted income Statements for November and December. e. Prepare a Buctgeted Batance.Sheet for the end of December. Complete this question by entering your answers in the tabs below. Drepare a Schedule of Expected Cash Collections for November and December. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. c. Prepare Cash Budgets for November and December. d. Prepare Budgeted Income Statements for November and December e. Prepare a Budgeted Balance Sheet for the end of December: Complete this question by entering your answers in the tabs below. Prepare a Merchandise Purchases Budget for November and December. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. c Prepare Gash Budgets for November and December. d. Prepare Budgeted Income Statements for November and December. e Prepare a Budgeted Balance Sheet for the end of Decemben. Complete this question by entering your answers in the tabs below. Prepare Cash Budgets for November and December. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. c. Prepare Cash Budgets for November and December. d. Prepare Budgeted Income Statements for November and December. e. Prepare a Budgeted Balance Sheet for the end of December. Complete this question by entering your answers in the tabs below. Prepare Budgeted Income Statements for Novembar and December. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. c. Prepare Cash Budgets for November and Decembet. d. Prepare Budgeted Income Statements for November and December. e. Prepare a Budgeted Balance Sheet for the end of December. Complete this question by entering your answers in the tabs below. Prepare a Budgeted Balance Sheet for the end of December