60.1K
Verified Solution
Link Copied!
Data regarding VeeLanceCorporation store's operations follow:
Sales are budgeted at $340,000 for November, $360,000 for December, and $350,000 for January.
Collections are expected to be 75% in the month of sale and 25% in the month following the sale.
The cost of goods sold is 71% of sales.
The the company desires an ending merchandise inventory equal to 75% 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 $21,400.
Monthly depreciation is $21,200.
Ignore taxes.
Balance SheetOctober 31
AssetsCash$22,200
Accounts receivable83,200
Merchandise inventory181,050
Property, plant and equipment (net of $596,000 accumulated depreciation)1,006,000
Total assets$1,292,450
Liabilities and Stockholders' EquityAccounts payable$196,200
Common stock640,000
Retained earnings456,250
Total liabilities and stockholders' equity$1,292,450.
Required:
a. Prepare a Schedule of Expected Cash Collections for November.
b. Prepare a Merchandise Purchases Budget for November.
c. Prepare Cash Budgets for November.
d. Prepare Budgeted Income Statement for November.
e. Prepare a Budgeted Balance Sheet for the end of November.
f.Explain, in your own words, the purpose of a budget. Does it guarantee performance? does it ensure that a company will be profitable?
g. Assume that the company desires a gross profit margin (ratio) of 25%. If the budget is met, will the company meet the desired goal? Explain.
Answer & Explanation
Solved by verified expert