Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: • Sales are budgeted at $230,000 for November, $210,000 for December, and $200,000 for January. . Collections are expected to be 40% in the month of sale and 60% in the month following the sale. • The cost of goods sold is 65% of sales. • The company would like to maintain ending merchandise inventories equal to 55% 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 $22,900. Monthly depreciation is $13,900. Ignore taxes. ● · Assets Cash Balance Sheet October 31 Accounts receivable Merchandise inventory Property, plant and equipment, net of $574,300 accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity Expected cash collections in December are; $ 22,300 72,300 82,225 1,096,300 $ 1,273, 125 $ 256,300 822,300 194,525 $ 1,273, 125

Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: • Sales are budgeted at $230,000 for November, $210,000 for December, and $200,000 for January. . Collections are expected to be 40% in the month of sale and 60% in the month following the sale. • The cost of goods sold is 65% of sales. • The company would like to maintain ending merchandise inventories equal to 55% 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 $22,900. Monthly depreciation is $13,900. Ignore taxes. ● · Assets Cash Balance Sheet October 31 Accounts receivable Merchandise inventory Property, plant and equipment, net of $574,300 accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity Expected cash collections in December are; $ 22,300 72,300 82,225 1,096,300 $ 1,273, 125 $ 256,300 822,300 194,525 $ 1,273, 125

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

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…
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…
Sagar
Tillman Cycles manufactures chainless bicycles. On March 31, Tillman Cycles had 210 bikes in inventory. The company has a policy that the ending inventory in any month must be 20% of the following month's expected sales. Tillman Cycles expects to sell the following number of bikes in each of next four months: E (Click the icon to view the data) Prepare a production budget for the second quarter, with a column for each month and for the quarter. ..... Tillman Cycles Production Budget For the Months of April through June Data Table April May June Quarter Unit sales 1050 1150 1390 3590 Plus: Desired ending inventory April. 1,050 bikes Total needed May 1,150 bikes Less: Beginning inventory June. 1,390 bikes Units to produce July . 1,200 bikes Print Done
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
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $460,000 for November, $440,000 for December, and $430,000 for January. Collections are expected to be 45% in the month of sale and 55% in the month following the sale. The cost of goods sold is 80% 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 $25,200. Monthly depreciation is $16,200. Ignore taxes. Balance SheetOctober 31 Assets Cash $ 20,000 Accounts receivable 70,000 Merchandise inventory 153,000 Property, plant and equipment, net of $572,000 accumulated depreciation 1,094,000 Total assets $ 1,337,000 Liabilities and Stockholders' Equity Accounts payable $ 254,000 Common stock 820,000 Retained earnings…
Beckett Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: (Click the icon to view additional information.) Inventory at the start of the year was 850 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales. Each planter requires four pounds of polypropylene (a type of plastic). The company wants to have 20% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.10 per pound. Read the requirements. Data table For the Months of January through March January February March Quarter Number of planters to be sold Units to be produced 3,425 3,400 3,525 10,350 January. 3,400 4 Multiply by: Quantity of direct materials needed per unit Quantity needed for production February 3,500…
Hardev
s
11 Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: • Sales are budgeted at $210,000 for November, $190,000 for December, and $180,000 for January Collections are expected to be 50% in the month of sale and 50% in the month following the sale. The cost of goods sold is 55% of sales. The company would like to maintain ending merchandise inventories equal to 45% 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 $22,700. Monthly depreciation is $13,700. Ignore taxes. Assets Cash Balance Sheet October 31 Accounts receivable. Merchandise inventory. Property, plant and equipment, net of $574,500 accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings. Total liabilities and stockholders' equity $ 22,500 72,500 51,975 1,096, 500 $ 1,243,475 $ 256,500. 822,500…
Capid Corporation is a wholesaler of industrial goods. Capid purchases 40% of its industrial goods in the month prior to the sale and 60% in the month of the sale. Capid’s cost of goods sold is 75% of sales. Capid budgeted sales of industrial goods are: November $135,000 December $150,000 January $125,000 What is the dollar value of Capid’s purchases in November and December?