Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow • Sales are budgeted at $304,000 for November, $324,000 for December, and $224,000 for January. • Collections are expected to be 60% in the month of sale and 40% 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 90% of the next month's cost of goods sold. Payment fo merchandise is made in the month following the purchase. • Other monthly expenses to be paid in cash are $22,500. Monthly depreciation is $2,000. 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 Retained earnings at the end of December would be: Balance Sheet October 31 $33,500 84,000 205,200 919,000 $1,241,700 $ 253,000 754,000 234,700 $1,241,700

Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow • Sales are budgeted at $304,000 for November, $324,000 for December, and $224,000 for January. • Collections are expected to be 60% in the month of sale and 40% 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 90% of the next month's cost of goods sold. Payment fo merchandise is made in the month following the purchase. • Other monthly expenses to be paid in cash are $22,500. Monthly depreciation is $2,000. 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 Retained earnings at the end of December would be: Balance Sheet October 31 $33,500 84,000 205,200 919,000 $1,241,700 $ 253,000 754,000 234,700 $1,241,700

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…
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.…
The Bandeiras Corporation, a merchandising firm, has budgeted its activity for December according to the following information: Sales at $510,000, all for cash. Merchandise inventory on November 30 was $230,000. The cash balance at December 1 was $24,000. Selling and administrative expenses are budgeted at $78.000 for December and are paid in cash. • Budgeted depreciation for December is $37,000. • The planned merchandise inventory on December 31 is $260,000. • The cost of goods sold is 70% of the sales price. • All purchases are paid for in cash. • There is no interest expense or income tax expense. The budgeted cash receipts for December are: Multiple Choice $135,000 $375.000 $547,000 $510.000
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…
Munoz Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks. Required a. October sales are estimated to be $340,000, of which 40 percent will be cash and 60 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget. b. The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts. c. The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month's cost of goods sold. However, ending inventory of December is expected to be $12,900. Assume that all purchases are made…
Moore Wholesalers is preparing its merchandise purchases budget. Budgeted sales are $440,000 for April and $510,000 for May. Cost of goods sold is expected to be 65% of sales. The company’s desired ending inventory is 24% of the following month’s cost of goods sold.Compute the required purchases for April. Moore WholesalersPurchases Budget For the Month of AprilFor the Quarter EndedFor the Year Ended Beginning InventoryBudgeted Cost of Goods SoldDesired Ending Direct MaterialsDesired Ending InventoryDirect Materials per UnitDirect Materials PurchassRequired Merchandise Purchases for AprilUnits to Be ProducedTotal Inventory Required $ AddLess: Beginning InventoryBudgeted Cost of Goods SoldDesired Ending Direct MaterialsDesired Ending…
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…
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…
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.