Question
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.
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 $32 per unit.
In addition to meeting the current months sales demand, management wants to maintain and ending inventory balance of 10% of the next months sales.
The ending inventory balance at September 30th is 2,625 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......................................................................... | $ 42,000 | |
Common stock............................................................................. | 840,000 | |
Retained earnings......................................................................... | 448,400 | |
Total liabilities and stockholders equity..................................... | $1,330,400 |
Required:
a. prepare sales budget for october, november, december.
b.Prepare a Schedule of Expected Cash Collections for October, November and December.
c.Prepare a Merchandise Purchases Budget for October, November and December.
d.Prepare a Schedule of Expected Cash Disbursements for October, November and December.
e.Prepare Cash Budgets for October, November and December.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started