Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information:
Wolfpack Company Balance Sheet June 30 |
||
Assets | ||
Cash | $ | 81,600 |
Accounts receivable | 59,600 | |
Inventory | 42,800 | |
Buildings and equipment, net of depreciation | 152,000 | |
Total assets | $ | 336,000 |
Liabilities and Stockholders’ Equity | ||
Accounts payable | $ | 57,000 |
Common stock | 100,000 | |
Retained earnings | 179,000 | |
Total liabilities and stockholders’ equity | $ | 336,000 |
Budgeting Assumptions:
Required:
1. For the month of July, calculate the following:
a. Budgeted sales
b. Budgeted merchandise purchases
c. Budgeted cost of goods sold
d. Budgeted net operating income
2. Prepare a budgeted balance sheet as of July 31.
SOLUTION
1A. Budgeted sales-
Particulars | Amount ($) |
Expected cash collection in July | 92,000 |
Less: June's Accounts receivable | (59,600) |
Cash collection of July Sales | 32,400 |
30% of July Total Sales | 32,400 |
Total Sales of July month (32,400/30%) | 108,000 |
1B. Budgeted merchandise purchases
Particulars | Amount ($) |
Expected cash disbursement in July for Merchandise | 66,300 |
Less: June's Accounts payable | (57,000) |
Cash disbursement of July Merchandise purchases | 9,300 |
20% of July Total Merchandise purchases | 9,300 |
Total Merchandise purchases of July month (9,300/20%) | 46,500 |
1C. Budgeted Cost of goods sold = Inventory used to make July Sales.
= Opening balance of Inventory + Inventory Purchased in July - Closing balance of Inventory on July 31
= 42,800 + 46,500 - 24,500 = 64,800
1D. Budgeted net operating income
Particulars | Amount ($) |
Sales | 108,000 |
Less: Cost of goods sold | 64,800 |
Gross Profit | 43,200 |
Less: Expenses - | |
Selling and Administrative expense | 18,560 |
Depreciation | 3,040 |
Net Operating Income | 21,600 |
2. Budgeted balance sheet
Amount ($) | |
Assets | |
Cash (81,600+92,000-66,300-18,560) | 88,740 |
Accounts receivable (108,000*70%) | 75,600 |
Inventory | 24,500 |
Building & Equipment (152,000-3,040) | 148,960 |
Total assets | 337,800 |
Liabilities and Shareholder's Equity | |
Accounts payable (46,500*80%) | 37,200 |
Common stock | 100,000 |
Retained earnings (179,000+21,600) | 200,600 |
Total liabilities and Shareholder's Equity | 337,800 |
Wolfpack Company is a merchandising company that is preparing a budget for the month of July....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 78,400 Accounts receivable 65,800 Inventory 35,200 Buildings and equipment, net of depreciation 214,000 Total assets $ 393,400 Liabilities and Stockholders’ Equity Accounts payable $ 60,400 Common stock 100,000 Retained earnings 233,000 Total liabilities and stockholders’ equity $ 393,400 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 91,400 Accounts receivable 67,200 Inventory 31,000 Buildings and equipment, net of depreciation 165,000 Total assets $ 354,600 Liabilities and Stockholders’ Equity Accounts payable $ 62,600 Common stock 100,000 Retained earnings 192,000 Total liabilities and stockholders’ equity $ 354,600 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 79,200 Accounts receivable 68,600 Inventory 40,200 Buildings and equipment, net of depreciation 213,000 Total assets $ 401,000 Liabilities and Stockholders’ Equity Accounts payable $ 56,000 Common stock 100,000 Retained earnings 245,000 Total liabilities and stockholders’ equity $ 401,000 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $75,000 Accounts receivable Inventory Buildings and equipment, net of depreciation 59,600 33,600 226,000 394,200 Total assets Liabilities and Stockholders' Equity Accounts payable s 52,200 Common stock 100,000 242,000 $ 394,200 Retained earnings Total liabilities and stockholders' equity Budgeting Assumptions: 1. All sales are on account. Thirty percent of the credit...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information Wolfpack Company Balance Sheet June 30 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets 87,400 50,200 44,400 246,000 $428,006e Liabilities and Stockholders Equity Accounts payable Common stock Retained earnings $36,006 100,000 292,000 Total liabilities and stockholders' equity $428,000 Budgeting Assumptions 1. All sales are on account. Thirty percent of the credit sales are...
Please help with each requirment 10 Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: $ 75,200 60,000 Wolfpack Company Balance Sheet June 30 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity 210.000 $ 392,000 $ 52,000 100,000 240,000 $ 392,000 Budgeting Assumptions: 1. All sales are...
answer the required 1A-D and 2 Check my work Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Balance Sheet Cash Accounts receivable $ 75,200 60,000 46,800 210,000 Inventory Buildings and equipment, net of depreciation $392,000 Total assets Liabilities and Stockholders' Equity payable Common stock Retained earnings $ 52,000 100,000 240,000 392,000 Total 1iabilities and stockholders equity Budgeting Assumptions: 1, All sales are on account. Thirty percent...
Exercise 8-18 Cash Flows; Budgeted Income Statement and Balance Sheet [LO8-2, LO8-3, LO8-9, LO8-10] Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 75,000 Accounts receivable 50,000 Inventory 30,000 Buildings and equipment, net of depreciation 150,000 Total assets $ 305,000 Liabilities and Stockholders’ Equity Accounts payable $ 35,300 Common stock 100,000 Retained earnings 169,700 Total liabilities and stockholders’...
Exercise 8-18 (REV) Cash Flows; Budgeted Income Statement and Balance Sheet [LO8-2, LO8-3, LO8-9, LO8-10] Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 92,200 Accounts receivable 50,400 Inventory 30,800 Buildings and equipment, net of depreciation 177,000 Total assets $ 350,400 Liabilities and Stockholders’ Equity Accounts payable $ 53,400 Common stock 100,000 Retained earnings 197,000 Total liabilities and...
Exercise 8-18 Cash Flows; Budgeted Income Statement and Balance Sheet [LO8-2, L08-3, L08-9, L08- 10] Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity 89,00 54,28 48.eee 238,888 $ 422,eee 257.ee $ 422,de...