Question

ABC Company, a retailer, prepares its master budget on a quarterly basis. The following data has...

ABC Company, a retailer, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master for the first quarter. a. As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances. ASSETS LIABILITIES AND EQUITY Cash $ 47,000 Accounts Payable $ 92,000 Accounts Receivable 224,000 Capital Stock 500,000 Inventory 60,000 Retained Earnings 109,000 Buildings and Equipment (net of depreciation) 370,000 TOTAL ASSETS $701,000 TOTAL LIABILITIES AND EQUITY $701,000 b. Actual sales for December and budgeted sales for the next four months are as follows: December (actual) $280,000 January 500,000 February 700,000 March 400,000 April 300,000 c. Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December credit sales. d. The Company’s gross profit rate is 40% of sales. e. Monthly expenses are budgeted as follows: salaries and wages, $27,000 per month; advertising, $70,000 per month; shipping, 5% of sales; depreciation, $14,000 per month; other expenses, 3% of sales. f. At the end of each month, inventory is to be on hand equal to 25% of the following month’s sales needs, stated at cost. g. One-half of a month’s inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. h. During February, the company will purchase a new copy machine for $1,700 cash. During March, other equipment will be purchased for cash at a cost of $84,500. i. During January, the company will declare and pay $45,000 in cash dividends. j. The company must maintain a minimum cash balance of $30,000. An open line of credit is available at a local bank for any borrowing that may be needed during the quarter. All borrowing is done at the beginning of the month and all repayments are made at the end of a month. Borrowings and repayments of principal must be in multiples of $1,000. Interest is paid only at the time of payment of principal. The annual interest rate is 12%. REQUIRED: Using the above data, complete the following: 1. Schedule of Expected Cash Collections 2. Inventory Purchases Budget 3. Schedule of Cash Disbursements for Purchases 4. Schedule of Cash Disbursements for Expenses 5. Cash Budget 6. Income Statement for quarter ending March 31 7. Balance Sheet as of March 31

Homework Answers

Answer #1

As per the given question,

Thank you ..All d best...Kindly rate

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Cash $ 47,000 Accounts receivable 205,600 Inventory 58,800 Buildings and equipment (net) 357,000 Accounts payable $ 87,225 Common stock 500,000 Retained earnings 81,175 $ 668,400 $ 668,400 Actual sales...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debit Credit Cash $ 46,000 Accounts receivable 204,800 Inventory 58,650 Buildings and equipment (net) 356,000 Accounts payable $ 86,925 Common stock 500,000 Retained earnings 78,525 $ 665,450 $ 665,450...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Balance Sheet March 31 Assets Liabilities and Stockholders' Equity Cash $ 2,525 Merchandise purchases payable $2,400 Accounts receivable 2,040 Dividends payable 710 Inventory 3,400 Stockholders' equity 8,005 Prepaid Insurance 150 Fixtures 3,000 Total assets $11,115 Total liabilities and equity $11,115 Actual and forecasted sales for selected...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Balance Sheet March 31 Assets Liabilities and Stockholders' Equity Cash $ 2,525 Merchandise purchases payable $2,400 Accounts receivable 2,040 Dividends payable 710 Inventory 3,400 Stockholders' equity 8,005 Prepaid Insurance 150 Fixtures 3,000 Total assets $11,115 Total liabilities and equity $11,115 Actual and forecasted sales for selected...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods as of March 31:   Cash $ 8,000   Accounts receivable 20,000   Inventory 36,000   Building and equipment, net 120,000   Accounts payable 21,750   Common shares 150,000   Retained earnings 12,250 a. The gross margin is 25% of sales. b. Actual and budgeted sales data are as follows:   March (actual) $ 50,000   April $ 60,000   May $ 72,000   June $ 90,000   July $ 48,000 c. Sales are 60% for...
Required: Prepare a master budget for San Marcos Collectibles for the third quarter of 2016. The...
Required: Prepare a master budget for San Marcos Collectibles for the third quarter of 2016. The following component budgets must be included: Sales Budget Cost of Goods Sold, Inventory and Purchases Budget Operating Expense Budget Budgeted Income Statement Schedule of Expected Cash Collections Schedule of Expected Cash Disbursements - Merchandise Purchases Schedule of Expected Cash Disbursements - Operating Expenses Combined Cash Budget Budgeted Balance Sheet San Marcos Collectibles is a merchandising business located downtown in San Marcos, Texas. The owners...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods as of March 31:   Cash $ 8,000   Accounts receivable 20,000   Inventory 36,000   Building and equipment, net 120,000   Accounts payable 21,750   Common shares 150,000   Retained earnings 12,250 a. The gross margin is 25% of sales. b. Actual and budgeted sales data are as follows:   March (actual) $ 50,000   April $ 60,000   May $ 72,000   June $ 90,000   July $ 48,000 c. Sales are 60% for...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods...
The following data relate to the operations of Soper Company, a wholesale distributor of consumer goods as of March 31:   Cash $ 8,000   Accounts receivable 20,000   Inventory 36,000   Building and equipment, net 120,000   Accounts payable 21,750   Common shares 150,000   Retained earnings 12,250 a. The gross margin is 25% of sales. b. Actual and budgeted sales data are as follows:   March (actual) $ 50,000   April $ 60,000   May $ 72,000   June $ 90,000   July $ 48,000 c. Sales are 60% for...
Problem 8-29 Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] The following data relate...
Problem 8-29 Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,800 Accounts receivable $ 25,200 Inventory $ 47,400 Building and equipment, net $ 114,000 Accounts payable $ 28,425 Common stock $ 150,000 Retained earnings $ 16,975 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 63,000 April $...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT