Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: • Sales are budgeted at $290,000 for November, $310,000 for December, and $210,000 for January. • Collections are expected to be 65% in the month of sale and 35% in the month following the sale. • The cost of goods sold is 80% of sales. • The company desires to have an ending merchandise inventory at the end of each month equal to 70% 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 $21,100. • Monthly depreciation is $21,000. • Ignore taxes. Assets Cash Balance Sheet October 31 Accounts receivable Merchandise inventory Property, plant and equipment, net of $624,000 accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity The cash balance at the end of December would be: $ 25,000 77,000 162,400 1,026,000 $ 1,290,400 $ 239,000 740,000 311,400 $1,290,400

Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: • Sales are budgeted at $290,000 for November, $310,000 for December, and $210,000 for January. • Collections are expected to be 65% in the month of sale and 35% in the month following the sale. • The cost of goods sold is 80% of sales. • The company desires to have an ending merchandise inventory at the end of each month equal to 70% 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 $21,100. • Monthly depreciation is $21,000. • Ignore taxes. Assets Cash Balance Sheet October 31 Accounts receivable Merchandise inventory Property, plant and equipment, net of $624,000 accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity The cash balance at the end of December would be: $ 25,000 77,000 162,400 1,026,000 $ 1,290,400 $ 239,000 740,000 311,400 $1,290,400

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

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…
Use the following information for questions 5 & 6: Dilly Farm Supply is in a small town in the rural west. Data regarding the store's operations follow: • Sales are budgeted at $290,000 for November, $310,000 for December, and $210,000 for January. • Collections are expected to be 65% in the month of sale and 35% in the month following the sale. • The cost of goods sold is 80% of sales. • The company desires to have an ending merchandise inventory at the end of each month equal to 70% 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 $21,100. ● Monthly depreciation is $21,000. • Ignore taxes. Assets Cash A/R Inventory PP&E, net of $624,000 accumulated depreciation Total assets Liabilities and Stockholders' Equity A/P Common Stock Retained Earnings Total liabilities and stockholders' equity 5. 6. Balance Sheet October 31 a. b. Expected cash collections in December are: C. d. a. b.…
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.
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: OctoberNovemberDecemberCash sales$ 60,000$ 55,000$ 75,000Credit sales60,00066,00082,500Total$ 120,000$ 121,000$ 157,500 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month following the month of sale. Customers are granted a 1.5% discount for payment within 10 days of billing. Approximately 75% of collectible credit sales take advantage of the cash discount. Inventory purchases each month are 100% of the cost of the following month’s projected sales. (The gross profit rate for Timpco is approximately 30%.) All merchandise purchases are made on credit, with 20% paid in the month of purchase and the remainder paid in the following month. No cash discounts for early payment are…
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…
please answer do not image format
(The following information applies to the questions displayed below.] Shadee Corporation expects to sell 600 sun shades in May and 800 in June. Each shade sells for $180. Shadee's beginning and ending finished goods inventories for May are 75 and 50 shades, respectively. Ending finished goods inventory for June will be 60 shades. Required: 1. Determine Shadee's budgeted total sales for May and June, 2. Determine Shadee's budgeted production in units for May and June. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine Shadee's budgeted total sales for May and June Budgeted Total Sales May Juna
The following is a schedule of the projected unit sales of Western Company, which manufactures casual wear. Each unit sells for $25. The company began the period with a beginning accounts receivable balance of $10,000. Choose the correct answer from the options provided. Budgeted unit sales Percentage of sales collected in the quarter of the sale Percentage of sales collected in the quarter after the sale. Quarter First Second Third Fourth 1,500 1,300 1,400 1,300 Knowledge Check 01 What is the amount of budgeted sales revenue for the fourth quarter? O $32,500 $33,750 O $35,000 $37,500 $8,125 O $8,750 O $9,375 O $28,125 Year 5,500 75% 25% Knowledge Check 02 What is the amount of cash that is expected to be collected during the second quarter as a result of sales made during the first quarter?
s
Stuart Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Stuart's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of sold. April's budgeted cost of goods sold is $80,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 quar Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) January February March $ 57,000 $…
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow: Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income First Quarter Second Quarter Third Quarter Fourth Quarter $ 174,000 $ 264,000 87,000 132,000 87,000 132,000 $ 214,000 107,000 107,000 21,400 17,400 26,400 $ 69,600 $ 85,600 $ 105,600 Historically, cost of goods sold is about 50 percent of sales revenue. Selling and administrative expenses are about 10 percent of sales revenue. Fred Arvada, the chief executive officer, told Mr. Long that he expected sales next year to be 10 percent for each respective quarter above last year's level. However, Rita Banks, the vice president of sales, told Mr. Long that she believed sales growth would be only 5 percent. Required a. Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. b. Prepare…