Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: • Sales are budgeted at $291,000 for November, $311,000 for December, and $211,000 for January. • Collections are expected to be 70% in the month of sale and 30% in the month following the sale. • The cost of goods sold is 75% of sales. • The company desires to have an ending merchandise inventory at the end of each month equal to 80% 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,200. • Monthly depreciation is $21,500. 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 Expected cash collections in December are: $ 25,500 77,500 162,900 1,027,000 $ 1,292,900 $ 240,000 741,000 311,900 $ 1,292,900

Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: • Sales are budgeted at $291,000 for November, $311,000 for December, and $211,000 for January. • Collections are expected to be 70% in the month of sale and 30% in the month following the sale. • The cost of goods sold is 75% of sales. • The company desires to have an ending merchandise inventory at the end of each month equal to 80% 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,200. • Monthly depreciation is $21,500. 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 Expected cash collections in December are: $ 25,500 77,500 162,900 1,027,000 $ 1,292,900 $ 240,000 741,000 311,900 $ 1,292,900

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

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.
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.…
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 kes. 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…
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…
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…
Kent Company has a sales budget for next month of $1,000,000. Cost of goods sold is expected to be 25 percent of sales. All goods are paid for in the month following purchase. The beginning inventory of merchandise is $50,000, and an ending inventory of $64,000 is desired. Beginning accounts payable is $160,000. For Kent Company, the ending accounts payable should be: Select one: O A. $341,000 B. $414,000 C. $264,000 D. $356,000
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…
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?
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: October November December Cash sales $ 80,000 $ 71,000 $ 83,000 Credit sales 80,000 85,200 91,300 Total $ 160,000 $ 156,200 $ 174,300 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…
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…
Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: • Sales are budgeted at $293,000 for November, $313,000 for December, and $213,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 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,400. • Monthly depreciation is $22,500. Ignore taxes. Assets Cash 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 difference between cash receipts and cash disbursements for December…
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 15 percent of the following month’s cost of goods sold. April’s budgeted cost of goods sold is $82,000. Required Complete the inventory purchases budget by filling in the missing amounts. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.