Data for RelyaTech Corp., a large merchandiser, is below: • Sales are budgeted at $300,000 for November, $320,000 for December, and $220,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. • RelyaTech 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. F merchandise is made in the month following the purchase. • Other monthly expenses to be paid in cash are $22,100. • Monthly depreciation is $26,000. • Ignore taxes. • (ID#95496) 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 30,000 82,000 180,000 1,014,000 $1,306,000 $ $ 246,000 750,000

Data for RelyaTech Corp., a large merchandiser, is below: • Sales are budgeted at $300,000 for November, $320,000 for December, and $220,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. • RelyaTech 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. F merchandise is made in the month following the purchase. • Other monthly expenses to be paid in cash are $22,100. • Monthly depreciation is $26,000. • Ignore taxes. • (ID#95496) 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 30,000 82,000 180,000 1,014,000 $1,306,000 $ $ 246,000 750,000

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

Croy Incorporated has the following projected sales for the next five months: Sales in Month April Units 3,590 May 3,840 June 4,520 4,130 3,990 July August Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct materials cost $3.50 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,715 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of direct materials purchased for April and May.
Ind
Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $360,000 for November, $380,000 for December, and $370,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 74% of sales. The company desires an ending merchandise inventory equal to 75% 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 $22,400. Monthly depreciation is $22,200. Ignore taxes. Balance Sheet October 31 Assets Cash $ 23,200 Accounts receivable 84,200 Merchandise inventory 199,800 Property, plant and equipment (net of $606,000 accumulated depreciation) 1,016,000 Total assets $ 1,323,200 Liabilities and Stockholders' Equity Accounts payable $ 197,200 Common stock 610,000 Retained earnings…
L Incorporated provided the following estimated sales data in the first five months of 2021: Month Estimated Sales (units) January 15,000 February ??? March 16,000 April ??? May 18,000 The desired ending inventory of finished goods is 20% of next month’s expected sales. Budgeted production for the month of February and April are 16,600 and 18,640 respectively. Each unit costs 120 to manufacture and is sold to yield gross profit of 25% based on cost. All sales are made on account. 20% is collected in the month of sale; 30% of the balance is collected in the following month, another 40% is collected two months after the month of sale while the rest are collected three months after the month of sale. Ending finished goods inventory in March shall be valued at
Executive officers of Fanning 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 Fanning'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 $25,000. Next year's ending inventory is budgeted to be $26,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. Complete this question by entering y Assessment Tool iFrame tabs below. Show Transcribed Text First Quarter Second Quarter $ 383,000 $ 304,000 527,000 470,000 Sales Required A Required B Required A Prepare y purchases budget using the sales manager's estimate. Note: Round…
Walnut Company has forecast sales for the next three months as follows: July 4,800 units, August 6,300 units, and September 8,300 units. Walnut's ending finished goods inventory policy is 45% of the next month's sales. July 1 inventory is projected to be 2,100 units. Selling and administrative costs are budgeted to be $24,000 per month plus $6 per unit sold. What are the budgeted selling and administrative expenses for July? Multiple Choice $58,410 $33,210 $52,800 $48,300
Answer?
Big Sound, a merchandising company specializing in home computer speakers, budgets its monthly cost of goods sold to equal 70% of sales. Its Inventory policy calls for ending Inventory at the end of each month to equal 20% of the next month's budgeted cost of goods sold. All purchases are on credit, and 25% of the purchases in a month is paid for in the same month. Another 60% is paid for during the first month after purchase, and the remaining 15% is paid for in the second month after purchase. The following sales budgets are set: July, $350,000; August, $290,000; September, $320,000; October, $275,000; and November, $265,000. (Hint For part 1, refer to Exhibits 22A.2 and 22A.3 for guidance, but note that budgeted sales are in dollars for this assignment.) Answer is not complete. (1) Compute the budgeted merchandise purchases for July, August, September, and October. July August 350,000 $ 245,000 595,000 49,000 $ 546,000 $ Budgeted ending inventory Cost of goods sold (estimated)…
Benham Foundries manufactures metal components. The inventory policy at Benham is to hold inventory equal to 145 percent of the average monthly sales for its main product. Sales for the main product for the following year are expected to be 450,000 units. Based on the inventory policy, the budget calls for the production of 420,000 units. Required: What is the beginning inventory of the main product? Beginning inventory units
Millen’s managers have made the following additional assumptions and estimates Estimated sales for July and August are $310,000 and $330,000, respectively. Each month’s sales are 20% cash sales and 80% credit sales. Each month’s credit sales are collected 30% in the month of sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. Each month’s ending inventory must equal 20% of the cost of next month’s sales. The cost of goods sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July. Monthly selling and administrative expenses are always $70,000. Each month $10,000 of this total amount is depreciation expense and the remaining $60,000 relates to expenses that are paid in the month they are incurred. The company does not plan to buy or sell any plant and equipment…
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,540 May 3,865 June 4,540 July 4,155 August 3,920 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct material costs $2.80 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Raw materials on hand at March 31 totaled 3,735 pounds. Required:1. Determine budgeted production for April, May, and June. (Do not round your intermediate calculations and round your final answer to the nearest whole number.) 2. Determine the budgeted cost of materials purchased for April, May, and June. (Use rounded Budgeted Production units in intermediate calculations. Round your answers to 2 decimal places.)
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 $176,000 105,600 70,400 17,600 $ 52,800 Second Quarter $206,000 123,600 82,400 20,600 $ 61,800 Third Quarter $216,000 129,600 86,400 21,600 $ 64,800 Fourth Quarter $266,000 159,600 106,400 26,600 $ 79,800 Total $864,000 518,400 345,600 86,400 $259,200 Historically, cost of goods sold is about 60 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 15 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 10 percent. Required a. Prepare a pro forma income statement…