In addition to meeting the current months sales demand

Assignment Help Accounting Basics

Reference no: EM13568353

Weldon Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:

The company sells each unit for $45.
Budgeted Sales:

Month	October	November	December	January
Sales in Units	30,000	25,000	40,000	30,000

Collections are expected to be 70% in the month of sale, 30% in the month following the sale.
The A/R balance at September 30th will be collected in full in October.
The cost of the merchandise is $28 per unit.
In addition to meeting the current month's sales demand, management wants to maintain and ending inventory balance of 10% of the next month's sales.
The ending inventory balance at September 30th is 3,000 units.
Payment for merchandise is made as follows:½ paid in the month of the purchase, ½ paid the month following the purchase.
The A/P balance at September 30th will be paid in full in October.
Other monthly expenses to be paid in cash are $300,000.

	Balance Sheet
	September 30

	Assets
	Cash.............................................................................................	$ 16,000
	Accounts receivable.....................................................................	250,000
	Inventory.....................................................................................	84,000
	Property, plant and equipment (net of $500,000 accumulated depreciation)............................	980,400
	Total assets...................................................................................	$1,330,400

	Liabilities and Stockholders' Equity
	Accounts payable.........................................................................	$ 40,000
	Common stock.............................................................................	840,000
	Retained earnings........................................................................	450,400
	Total liabilities and stockholders' equity.....................................	$1,330,400

Required:

Prepare a Sales Budget for October, November and December.
Prepare a Schedule of Expected Cash Collections for October, November and December.
Prepare a Merchandise Purchases Budget for October, November and December.
Prepare a Schedule of Expected Cash Disbursements for October, November and December.
Prepare Cash Budgets for October, November and December.

Reference no: EM13568353

Questions Cloud

Show how you can realize a guaranteed profit from covered : suppose that the current spot exchange rate is euro1.50pound and the one-year forward exchange rate is euro1.60pound.

Actual results for february appear below prepare a flexible : pie guys pizzeria is owned and operated by three brothers. data concerning the pizzerias monthly revenues and costs

Compute the nominal interest rate per annum in both the us : due to the integrated nature of their capital markets investors in both the u.s. and u.k. require the same real

They pay a coupon rate of 9 with semi-annual payments if : podunk communications bonds mature in 6 12 years with a par value of 1000. they pay a coupon rate of 9 with

In addition to meeting the current months sales demand : weldon industrial gas corporation supplies acetylene and other compressed gases to industry. data regarding the stores

In order for a derivatives market to function most : in order for a derivatives market to function most efficiently two types of economic agents are needed hedgers and

A key component of being a doctoral learner is the ability : 75 words apa formatsummarize these resources in one sentences each.a key component of being a doctoral learner is the

What is the internal rate of return irr of a project costs : -what is the internal rate of return irr of a project costs 45000 if it is expected to generate 15047 per year for

Evaluate the usefulness of relative ppp in predicting : evaluate the usefulness of relative ppp in predicting movements in foreign exchange rates ona. short-term basis for

User Account

All Pages