Survey Of Accounting
5th Edition
ISBN: 9781259631122
Author: Edmonds, Thomas P.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 14, Problem 18P
Problem 7-18A Preparing an inventory purchases budget and schedule of cash payments
Humboldt, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget for April, May, June, and July.
April | May | June | July | |
Budgeted cost of goods sold | $37,500 | $34,000 | $30,000 | $45,000 |
Humboldt had a beginning inventory balance of $1,800 on April 1 and a beginning balance in accounts payable of $7,400. The company desires to maintain an ending inventory balance equal to 10 percent of the next period’s cost of goods sold. Humboldt makes all purchases on account. The company pays 60 percent of accounts payable in the month of purchase and the remaining 40 percent in the month following purchase.
Required
- a. Prepare an inventory purchases budget for April, May, and June.
- b. Determine the amount of ending inventory Humboldt will report on the end-of-quarter pro forma
balance sheet . - c. Prepare a schedule of cash payments for inventory for April, May, and June.
- d. Determine the balance in accounts payable Humboldt will report on the end-of-quarter pro forma balance sheet.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Exercise 7-7A Preparing an inventory purchases budget
Lumpkin Company sells lamps and other lighting fixtures. The purchasing department manager pre-
pared the following inventory purchases budget. Lumpkin'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 $40,000.
Budgeted cost of goods sold
Plus: Desired ending inventory
Inventory needed
Less: Beginning inventory
Required purchases (on account)
January
$30,000
3,200
33,200
6,000
$27,200
February
$32,000
4-41
March
$35,000
?
Planning for Profit at
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.
PROBLEM 7-C PURCHASES BUDGET
The following are budgeted data for the Emerald Company, a merchandising company:
Budgeted Sales (at retail): January - P300,000; February - P340,000; March - P400,000; April -
P350,000. Cost of goods sold as a percentage of sales is 60%. The desired ending inventory is
75% of next month's sales.
Required:
1. Assuming that the company had inventory on hand of P70,000 (at cost) on January 1, how
much must be the purchases for January (at cost)?
Exercise 14-7A (Algo) Preparing an inventory purchases budget LO 14-3
Perez Company selts lamps and other lighting fixtures. The purchasing department manager prepared the following inventory
purchases budget Perez's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of goods
sold. Aprif's budgeted cost of goods sold is $85,000
Required
a. Complete the inventory purchases budget by fillng 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 belovw.
Reg A
Reg and C
Complete the inventory purchases budget by filling in the missing amounts.
Inventory Purchases Budget
January
February
March
Butgeted cost of goods sold
61,000 s 67,000
57,000 $
9,150
Inventory needed…
Chapter 14 Solutions
Survey Of Accounting
Ch. 14 - Prob. 1QCh. 14 - Prob. 2QCh. 14 - 3.What are the three levels of planning? Explain...Ch. 14 - 4.What is the primary factor that distinguishes...Ch. 14 - 5.What is the advantage of using a perpetual...Ch. 14 - Prob. 6QCh. 14 - Prob. 7QCh. 14 - 8. Ken Shilov, manager of the marketing...Ch. 14 - Prob. 9QCh. 14 - 10.What is the normal starting point in developing...
Ch. 14 - 11. How does the level of inventory affect the...Ch. 14 - 12.What are the components of the cash budget?...Ch. 14 - 13.The primary reason for preparing a cash budget...Ch. 14 - 14.What information does the pro forma income...Ch. 14 - 15.How does the pro forma statement of cash flows...Ch. 14 - Exercise 7-1A Budget responsibility Teresa...Ch. 14 - Exercise 7-2A Preparing a sales budget Parliament...Ch. 14 - Prob. 3ECh. 14 - Exercise 7-4A Preparing sales budgets with...Ch. 14 - Exercise 7-5A Determining cash receipts from...Ch. 14 - Exercise 7-6A Using judgment in making a sales...Ch. 14 - Exercise 7-7A Preparing an inventory purchases...Ch. 14 - Exercise 7-8A Preparing a schedule of cash...Ch. 14 - Exercise 7-9A Determining the amount of expected...Ch. 14 - Exercise 7-10A Preparing inventory purchases...Ch. 14 - Exercise 7-11A Preparing a schedule of cash...Ch. 14 - Prob. 12ECh. 14 - Exercise 7-13A Preparing a cash budget The...Ch. 14 - Exercise 7-14A Determining amount to borrow and...Ch. 14 - Prob. 15ECh. 14 - Problem 7-16A Behavioral impact of budgeting...Ch. 14 - Prob. 17PCh. 14 - Problem 7-18A Preparing an inventory purchases...Ch. 14 - Prob. 19PCh. 14 - Problem 7-21A Preparing a cash budget Fayette...Ch. 14 - Prob. 21PCh. 14 - Problem 7-22A Preparing budgets with multiple...Ch. 14 - Problem 7-23A Preparing a master budget for retail...Ch. 14 - ATC 7-1 Business Applications Case Preparing and...Ch. 14 - ATC7-2 Group Assignment Master budget and pro...Ch. 14 - ATC 7-4 Writing Assignment Continuous budgeting...Ch. 14 - Ethical Dilemma Bad budget system or unethical...
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
- Exercise 14-7A (Algo) Preparing an inventory purchases budget LO 14-3 Rooney Company sells lamps and other lighting fotures. The purchasing department manager prepared the following inventory purchases budget Rooney's policy is to maintain an ending inventory balance equal to 20 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. Red A Rea B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January February March 550,000 $ 62.000 $ 60.000 Budgeted cost of goods soldarrow_forwardPROBLEM 7-C PURCHASES BUDGET The following are budgeted data for the Emerald Company, a merchandising company Budgeted Sales (at retail): January - P300,000; February - P340,000; March - P400,000; April P350,000. Cost of goods sold as a percentage of sales is 60%. The desired ending inventory 75% of next month's sales. Required: 2. How much is the desired ending inventory (at cost) for the month of February?arrow_forwardPROBLEM 7-C PURCHASES BUDGET The following are budgeted data for the Emerald Company, a merchandising company: Budgeted Sales (at retail): January - P300,000; February - P340,000; March - P400,000; April - P350,000. Cost of goods sold as a percentage of sales is 60%. The desired ending inventory is 75% of next month's sales. Required: 3. Assume that all purchases are paid for in the month following the month of purchase. How much cash disbursements for purchases would appear in the April cash budget?arrow_forward
- PROBLEM 7-C PURCHASES BUDGET The following are budgeted data for the Emerald Company, a merchandising company: Budgeted Sales (at retail): January P300,000; February P340,000; March P400,000; April - P350,000. Cost of goods sold as a percentage of sales is 60%. The desired ending inventory is 75% of next month's sales. Required: 1. Assuming that the company had inventory on hand of P70,000 (at cost) on January 1, how much must be the purchases for January (at cost)? 2. How much is the desired ending inventory (at cost) for the month of February? 3. Assume that all purchases are paid for in the month following the month of purchase. How much cash disbursements for purchases would appear in the April cash budget?arrow_forwardPROBLEM 7-C PURCHASES BUDGET The following, are budgeted data for the Emerald Company, a merchandising company: Budgeted Sales (at retall): January - P300,000; February - P340,000; March - P400,000; April - P350,000. Cost of goods sold as a percentage of sales is 60%. The desired ending inventory is 75% of pext month's sales. Required: 1. Assuming that che company had Ioventory on hand of P70,000 (ar cost) ọn January 1, how much must be the purchases for January (at cost)? 2. How much is the destred ending Inventory (at cost) for the month of February? 3. Assume that all purchases are paid for In the month following the month of purchase. How much cash disbursernents for purchases would appear in the April cash budget?arrow_forwardAssume a merchandising company provides the following information from its master budget for the month of May: Sales Cost of goods sold Selling and administrative expenses Accounts receivable, May 1st Accounts receivable, May 31st If all of the company's sales are on account, what is the amount of cash collections from customers included in the cash budget for May? Multiple Choice $109,000 $106,000 $129,000 $ 125,000 $ 90,000 $ 24,000 $ 16,000 $ 35,000 $125,000arrow_forward
- b. a. Prepare a schedule of cash payments for Fein Company for the month of August. OBJECTIVE 3 C. Exercise 9-45 Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is R7,360. b. Actual sales for April and May are as follows: d. F. a. April May Cash sales R180,000 Credit sales to 00 R530,000 Total sales R389,000 c. Credit sales are collected over a three-month period: R 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. d. Inventory purchases average 64% of a month's total B sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month. Salaries and wages total R117,500 per month, including a R45,000…arrow_forwardक A merchandising company provides the following information from its master budget for the month of Cash collections from customers Cost of goods sold Cash paid for merchandise purchases Selling and administrative expenses Cash paid for selling and administrative expenses Accounts receivable, June 1 $122,000 $ 87,000 $82,000 $29,000 $30,000 $14,000 $20,000 Accounts receivable, June 30 If all of the company's sales are on account, what is the budgeted net operating income for June? (Ignore interest and taxes.) (All answers are whole numbers - unless specified otherwise. You should NOT include the $ sign or a comma. E.g., you should type 1000 for one thousand. Negative numbers should be added with a minus sign, e.g., -1000 for a decrease or loss of one thousand.) Budgeted net operating income for September = $ 灣 Next > < Prev. 1 of 23 Airarrow_forwardAssume the following informaiton for Greg's Games for the month of June: Budgeted Cost of Goods Sold =$38,000; Desired Ending Merchandise Inventory =$48,000; Beginning Merchandise Inventory = $33,000. Calculate the budgeted purchases for the company in June. A. $43,000 B. $33,000 C. $53,000 D. $38,000arrow_forward
- Preparing an Accounts Payable Schedule Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: April $374,400 May 411,100 June 416,700 Wight typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?arrow_forwardCurrent assets as of December 31: Cash............ Accounts receivable.. Inventory..........….... Buildings and equipment, net. Accounts payable Common shares..... Retained earnings. Caption The following data relate to the operations of Gaudreau Company, which distributes consumer goods: ……………….. ****** b. Actual and budgeted sales data are as follows: December (actual) January... February. March April... Heading $6,000 $36,000 $9,800 $110,885 $32,550 $100,000 $30,135 a. The gross margin is 30% of sales. (In other words, cost of goods sold is 70% of sales.) $60,000 $70,000 $80,000 Index $85,000 $55,000 c. Sales are 40% for cash and 60% on credit. Credit sales are collected in the month following sale. The accounts receivable at December 31 are the result of December credit sales. d. Each month's ending inventory should equal 20% of the following month's budgeted cost of goods sold. e. One-quarter of a month's inventory purchases is paid for in the month of purchase; the other…arrow_forwardRequired A. Prepare the following operating budget for Lavish Towel for the month of May. 1. Sales budget 4. DL budget 2. Production budget 5. MOH budget 3. DM purchases budget 6. SG&A budget B. Prepare the budgeted COGS schedule and income statement for May. Assume there is no beginning orending WIP inventory in May. Lavish uses the FIFO method inventory valuation C. Explain how the pieces from this budgeted income statement would affect Lavish's Cash budget, as well as its budgeted balance sheet for May.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
The management of receivables Introduction - ACCA Financial Management (FM); Author: OpenTuition;https://www.youtube.com/watch?v=tLmePnbC3ZQ;License: Standard YouTube License, CC-BY