Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: • Sales are budgeted at $340,000 for November, $320,000 for December, and $310,000 for January. . Collections are expected to be 80% in the month of sale and 20% in the month following the sale. • The cost of goods sold is 75% of sales. • The company would like to maintain ending merchandise inventories equal to 60% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. • Other monthly expenses to be paid in cash are $24,000. • Monthly depreciation is $15,000. ● Ignore taxes. Assets Cash Balance Sheet October 31 Accounts receivable Merchandise inventory Property, plant and equipment, net of $572,000 accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity The cost of December merchandise purchases would be: $ 20,000 70,000 153,000 1,094,000 $ 1,337,000 $ 254,000 820,000 263,000 $ 1,337,000

Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: • Sales are budgeted at $340,000 for November, $320,000 for December, and $310,000 for January. . Collections are expected to be 80% in the month of sale and 20% in the month following the sale. • The cost of goods sold is 75% of sales. • The company would like to maintain ending merchandise inventories equal to 60% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. • Other monthly expenses to be paid in cash are $24,000. • Monthly depreciation is $15,000. ● Ignore taxes. Assets Cash Balance Sheet October 31 Accounts receivable Merchandise inventory Property, plant and equipment, net of $572,000 accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity The cost of December merchandise purchases would be: $ 20,000 70,000 153,000 1,094,000 $ 1,337,000 $ 254,000 820,000 263,000 $ 1,337,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The following information relates to the next FOUR (4) questions: Pierce Creations is a retailer of fashion accessories. Budget data regarding the store's operations follow: Budgeted Sales: September $ 350,000 October November $ 320,000 $ 310,000 Expected Collections: 70% in the month of sale 20% in the month following the sale 5% in the second month following the sale 5% uncollectible Cost of Goods Sold: 60% of Sales Desired Ending Inventory of Merchandise: 50% of next month's Cost of Goods Sold Payment for Merchandise Purchased: 60% in the month of purchase 40% in the month following the purchase General and administrative expenses per month is $58,000 (of which depreciation, $18,000). 5 Budgeted October cash disbursements for merchandise purchases would be: A. $ B. $ С. $ D. $ 189,000 193,800 199,200 323,000 E. None of the above.
Executive officers of Adams Company are wrestling with their budget for the next year. The following are two different sales estimates provided by two difference sources. Source of Estimate First Quarter Second Quarter Third Quarter Fourth Quarter Sales manager $ 378,000 $ 316,000 $ 271,000 $ 480,000 Marketing consultant 512,000 469,000 403,000 648,000 Adams’s past experience indicates that cost of goods sold is about 60 percent of sales revenue. The company tries to maintain 15 percent of the next quarter’s expected cost of goods sold as the current quarter’s ending inventory. This year’s ending inventory is $30,000. Next year’s ending inventory is budgeted to be $31,000. Required Prepare an inventory purchases budget using the sales manager’s estimate. Prepare an inventory purchases budget using the marketing consultant’s estimate.
Executive officers of Munoz Company are wrestling with their budget for the next year. The following are two different sales estimates provided by two different sources. Source of Estimate Sales manager Marketing consultant First Quarter $ 388,000 517,000 Complete this question by entering your answers in the tabs below. Sales Munoz's past experience indicates that cost of goods sold is about 60 percent of sales revenue. The company tries to maintain 20 percent of the next quarter's expected cost of goods sold as the current quarter's ending Inventory. This year's ending Inventory is $35,000. Next year's ending Inventory is budgeted to be $36,000. Required a. Prepare an Inventory purchases budget using the sales manager's estimate. b. Prepare an Inventory purchases budget using the marketing consultant's estimate. Required A Required B Prepare an inventory purchases budget using the sales manager's estimate. Note: Round your final answers to nearest whole dollar amount. Total inventory…
Keggler's Supply is a merchandiser of three different products. Beginning inventories for March are footwear, 21,000 units; sports gear, 81,500 units; and apparel, 49,000 units. Management believes each of these inventories is too high and begins a new policy that ending inventory in any month should equal 31% of the budgeted sales units for the following month. Budgeted sales units for March, April, May, and June follow. Footwear Sports gear Apparel FOOTWEAR Required: 1. Prepare a merchandise purchases budget (in units only) for each product for each of the months of March, April, and May. Budgeted sales units Add: Desired ending inventory Next period budgeted sales units Ratio of ending inventory to future sales Less: Beginning inventory units Total required units Less: Beginning inventory units Units to purchase SPORTS GEAR Total required units Budgeted Sales in Units March April May 15,000 23,500 32,000 69,500 89,000 95,500 42,000 38,000 32,000 Add: Desired ending inventory Next…
Rooney Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rooney's policy is to maintain an ending inventory balance equal to 10 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $77,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is $179,400, and 13,800 orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. per sales order b. Determine the amount of sales order processing cost that Nozama.com would receive if it had 7,900 sales orders.
Problem 8-25 (Algo) Cash Budget with Supporting Schedules; Changing Assumptions [LO8-2, L08-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income "Includes $28.000 of depreciation each month. April May June $ 600,000 $1,100,000 $ 560,000 420,000 770,000 392,000 180,000 330,000 168,000 July $ 460,000 322,000 138,000 111,000 48,000 159,000 105,000 67,000 46,000 64,800 41,600 44,000 169,800 108,600 90,000 $ 21,000 $ 160,200 $ 59,400 $ 48,000 b. Sales are…
Top executive officers of Rundle Company, a merchandising firm, are preparing the next year's budget. The controller has provide everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $ 1,998,800 1,425,000 475,000 266,000 $ 209,000 Cost of goods sold is usually 75 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales a fixed cost of $76,000. The president has announced that the company's goal is to increase net income by 10 percent. Required The following items are independent of each other: a. Prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal? b. The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 1 percent. Prepare a…
Acme Company sells lumber and general building supplies to building contractors. Data regarding the store's operations follow: Sales are budgeted at $360,000 for November, $330,000 for December, and $310,000 for January. Collections are expected to be 90% in the month of sale and 10% in the month following the sale. The cost of goods sold is 70% of sales. The company desires to have an ending merchandise inventory equal to 70% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase. Other monthly expenses to be paid in cash are $25,700. Monthly depreciation is $18,000. Ignore taxes.
Top executive officers of Tildon Company, a merchandising firm, are preparing the next year’s budget. The controller has provided everyone with the current year’s projected income statement. Current Year Sales revenue $ 1,600,000 Cost of goods sold 1,120,000 Gross profit 480,000 Selling & administrative expenses 190,000 Net income $ 290,000 Cost of goods sold is usually 70 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $30,000. The president has announced that the company’s goal is to increase net income by 15 percent. Required The following items are independent of each other: Prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal? The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production…
Sound Investments, Inc., is a large retailer of stereo equipment. The controller is about to prepare the budget for the first quarter of 20x2. Past experience has indicated that 70 percent of the store's sales are cash sales. The collection experience for the sales on account is as follows: 85 percent during month of sale 10 percent during month following sale 5 percent uncollectible The total sales for December 20x1 are expected to be $203,000. The controller feels that sales in January 20x2 could range from $113,000 to $173,000. Required: 1. Demonstrate how financial planning can be used to project cash receipts in January of 20x2 for three different levels of January sales. Use the following columnar format. Cash receipts in January 20x2: From December sales on account From January cash sales From January sales on account Total cash receipts Total Sales in January, 20x2 113,000 $ 143,000 $ 173,000 $ 0 $ 0 $ 0
Weller Industrial Ges Corporation supplies acetylene and other compressed geses to industry. Dets regarding the store's operations follow: Sales are budgeted at $300,000 for November, $320,000 for December, and $310,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 76% of sales. The company desires an ending merchandise inventory equal to 80% 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 $20, 600. Monthly depreciation is $20,400. Ignore taxes Balance Sheet October 31 Assets Cash $ 21,400 Accounts receivable 82,400 Merchandise inventory 182,400 Property, plant and equipment (net of $590,000 accumulated depreciation) 1,000,000 Total assets $1,286, 200 Liabilities and Shareholder's Equity Accounts payable $ 195,400 Common shares 550,000 Retained earnings 540,800 Total liabilities and…