Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:
Sales are budgeted at $ for November, $ for December, and $ for January.
Collections are expected to be in the month of sale and in the month following the sale.
The cost of goods sold is of sales.
The company desires an ending merchandise inventory equal to of the cost of goods sold in the following month.
Payment for merchandise is made in the month following the purchase.
Other monthly expenses to be paid in cash are $
Monthly depreciation is $
Ignore income tax.
tabletableWeller Industrial Gas CorporationBalance SheetOctober AssetsCash$
Required
use excel to
aprepare a schedule of Expected Cash collections for november and december
bprepare a merchandise purchases budget for november and december
cprepare a Schedule of expected cash disbursement for november and december
dprepare a cash budget for november and december
eprepare a budgeted income statements for november and december
