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…
Vinubhai
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
Answer the questions from the information provided. 2.1 Use the information provided below to calculate the number of units of Product Tex that must be produced for July and August. INFORMATION The estimated sales volume of Product Tex is 25 000 units for June, 21 000 units for July, 30 000 units for August and 36 000 units for September. The policy of management is to maintain an ending finished goods inventory each month equal to 20% of the current month’s budgeted sales and 30% of the following month’s budgeted sales. 2.2 Study the information provided below and calculate the expected value of closing inventory as at 31 December 2022, if the FIFO method of inventory valuation is used. INFORMATION The following information was supplied by Sunbeam Manufacturers for 2022 in respect of its finished goods: R Inventory on 01 January 640 000 Cost of production of finished goods manufactured 570 000 Cost of goods sold 435 000 Sales value of the goods sold…