Reference no: EM13789268
Welnor Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:
o Sales are budgeted at $320,000 for November, $340,000 for December, and $330,000 for January.
o Collections are expected to be 75% in the month of sale, 20% in the month following the sale, and 5% uncollectible.
o The cost of goods sold is 65% of sales.
o The company desires ending merchandise inventory to equal 80% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase.
o Other monthly expenses to be paid in cash are $21,000.
o Monthly depreciation is $16,000.
o Ignore taxes.
Statement of Financial Position
October 31
Assets
Cash $22,000
Accounts recievable (net of allowance for uncollectible accounts) $82,000
Merchandise inventory $166,400
Property, plant and equipment (net of $658,000 accumulated depreciation $1,170,000
Total assets $1,440,400
Liabilities and Stockholders' Equity
Accounts payable $199,000
Common Stock $840,000
Retained Earnings $401,000
Total Liabilities and stockholders' equity $1,440,400
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.
|
Resulting configuration of share ownership
: What percent of ownership must be sold to grant the 100 percent three-year return? What is the resulting configuration of share ownership?
|
|
Levels of total expenditures or total costs
: The dairy farm company, a small producer of milk and cheese, has estimated the quantities of milk and cheese that it can produce with three levels of total expenditures or total costs.
|
|
What is the divisions return on investment
: Heavey Fabrication is a division of a major corporation. Last year the division had total sales of $21,120,000, net operating income of $2,006,400, and average operating assets of $6,000,000. The company's minimum required rate of return is 12%. What..
|
|
Key component for knowledge management
: Business intelligence is a key component for knowledge management. Decision support systems (DSSes) are the foundation of business intelligence and add a modeling selection to user interface.
|
|
Schedule of expected cash collections
: Welnor Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $320,000 for November, $340,000 for December, and $330,000 for January. Prepare a Schedul..
|
|
Compute the value of risk ratios
: Compute the value of each of the following risk ratios.
|
|
An appreciation of the nations currency leads
: A decrease in interests rats causes investment to increase. Explain - An appreciation of the nation's currency leads foreigners to demand less of the country's exports. Explain
|
|
Clinics revenue and spending variances
: lassey Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the following information: Revenue should be $41.80 per patient-visit. Personnel expenses should be $35,400 per month plus $10.60 per patient-visit. Prepare..
|
|
What are some of the elements of sarbanes-oxley
: From a practical perspective, what are some of the elements of Sarbanes-Oxley and Which of the following would be classified as tangible personal property, as opposed to other property categories, such as fixtures or intangible property
|