FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Weldon Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data 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 65% in the month of sale, 30% in the month following the sale, and 5% uncollectible. Beginning November
accounts receivable is $93,000. - The cost of goods sold is 75% of sales.
- The company purchases 70% of its compressed gases in the month prior to the month of sale and 30% in the month of sale. Payments for purchases are 40% in the month of purchase and 60% in the following month.
- Other monthly expenses to be paid in cash are $22,900.
- The Monthly
depreciation is $21,000. - The company has a desired ending cash balance of at least $35,000. It has an available line-of-credit for borrowing, if necessary, at 12% interest per annum.
- Assume that after the company acquired land and paid dividends in November, such that the beginning cash balance in December is $45,000.
1. What are Expected Cash Collections for December?
2. What are merchandise purchases for December?
3. What are disbursements related to merchandise purchases in December?
4. What is the ending cash balance in December given the beginning balance above?
5. Ignoring taxes, what is income for December?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Tim Tam Inc., a merchandising company, is considering opening a new distribution center on July 1, 20Y1. Budgeted sales for July, August and September are estimated to be $200,000, $300,000, and $450,000, respectively. The company expects to sell 30% of its merchandise for cash and the remainder on account. Of the sales on account, 60% are expected to be collected in the month of the sale and 40% in the month following the sale. Determine the expected cash collection in September. Group of answer choices $90,000 $408,000 $356,000 $126,000arrow_forwardFranklin Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Franklin'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 $79,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. 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 January February March Budgeted cost of goods sold $ 56,000 $ 60,000 $ 66,000 Plus: Desired ending inventory 6,000 Inventory needed 62,000 Less: Beginning…arrow_forwardThe company pays for its purchases within 10 days of purchase, so assume that one-third of the purchases of any month are due and paid for in the following month. The cost of the merchandise purchased is $10 per case. At the end of each month, it is desired to have an inventory equal in units to 75% of the following month's sales in units. Exclusive of bad debts, total budgeted selling and general administrative expenses for the fiscal year are estimated at$80,600, of which $19,000 is fixed expense (which includes a $5,200 annual depreciation charge). this is incurred fixed expenses uniformly throughout the year. The balance of the selling and general administrative expenses varies with sales. Expenses are paid as incurredRequirementl.arrow_forward
- Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech’s managers have made the following additional assumptions and estimates: Estimated sales for July, August, September, and October will be $410,000, $430,000, $420,000, and $440,000, respectively. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 35% in the month of sale and 65% 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 30% of the cost of next month’s sales. The cost of goods sold is 70% 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…arrow_forwardABC Company's raw materials purchases for June, July, and August are budgeted at $43,000, $33,000, and $58,000, respectively. Based on past experience, ABC expects that 60% of a month's raw material purchases will be paid in the month of purchase and 40% in the month following the purchase. Required: Prepare an analysis of cash disbursements from raw materials purchases for ABC Company for August. Budgeted raw material purchases August cash payments: Current month's purchases Prior month's purchases Total cash payments June July Augustarrow_forwardWeller 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…arrow_forward
- Sales are budgeted at $360,000 for November, $370,000 for December, and $350,000 for January. . Collections are expected to be 40% in the month of sale and 60% in the month following the sale. • The cost of goods sold is 60% of sales. • The company desires an ending merchandise inventory equal to 20% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. • The November beginning balance in the accounts receivable account is $71,000. • The November beginning balance in the accounts payable account is $258,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. Complete this question by entering your answers in the tabs below. Required A Required B Prepare a Schedule of Expected Cash Collections for November and December. Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total…arrow_forwardRooney 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 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. 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 January $ Budgeted cost of goods sold Plus: Desired beginning inventory Inventory needed Less: Desired beginning inventory Required purchases (on account) $…arrow_forwardWeldon 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 $350,000 for January.• Collections are expected to be 75% in the month of sale, 20% in the month following the sale, and 5% uncollectible.• The cost of goods sold is 65% of sales.• The company desires an ending merchandise inventory equal to 60% 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 $21,900.• Monthly depreciation is $20,000.• Ignore taxes. Balance Sheet October 31 Assets: Cash $16,000 Accounts receivable (net of allowances for uncollectable accounts $74,000 Merchandise inventory $140,400 Property, plant and equipment (net of $500,000 accumulated depreciation) $1,066,000 Total Assets: $1,296,400…arrow_forward
- McFarland Company makes 70 percent of its sales in cash. Credit sales are collected as follows: 70 percent in the month of sale and 30 percent in the month following the sale. McFarland's budgeted sales for upcoming months follow: $ 24,200 42,000 40,000 38,000 June July August September Required: Compute McFarland's expected cash receipts for August Budgeted Cash Receiptsarrow_forwardPalmgren Company produces consumer products. The sales budget for four months of the year is presented below. Unit Sales Dollar Sales July 32,500 $970,000 August 34,500 1,062,200 September 40,500 1,206,000 October 36,000 1,141,300 Company policy requires that ending inventories for each month be 25 percent of next month’s sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.arrow_forwardBieber Company produces floor mats used in gyms and dojos. The sales budget for four months of the year is as shown in the table. Company policy requires that ending inventories for each month be 15 percent of next month’s sales. At the beginning of April, the beginning inventory of mats met that policy. 1.Compute for the number of units produced for the month of May. 2.Compute for the number of units produced for the month of July.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education