Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
6th Edition
ISBN: 9780134486857
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 22, Problem 45AP
1.
To determine
Prepare the sales budget for A printing supply as on April 30, 2018.
2.
To determine
Prepare the inventory, purchase, and cost of goods sold budget for A printing supply as on April 30, 2018.
3.
To determine
Prepare the selling and administrative expense budget for A printing supply as on April 30, 2018.
4.
To determine
Prepare the schedule of cash receipts from customers for A printing supply as on April 30, 2018
5.
To determine
Prepare the schedule of cash payment for selling and administrative expense for A printing supply as on April 30, 2018
6.
To determine
Prepare the
7.
To determine
Prepare the
8.
To determine
Prepare the budgeted balance sheet for A printing supply as on April 30, 2018.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for
April
2024
and budgeted balance sheet at
April
30,
2024.
The
March
31,
2024,
balance sheet follows:
As
Tune
Printing Supply's controller, you have assembled the following additional information:
a.
April
dividends of
$6,000
were declared and paid.
b.
April
capital expenditures of
$16,200
budgeted for cash purchase of equipment.
c.
April
depreciation expense,
$500.
d.
Cost of goods sold,
45%
of sales.
e.
Desired ending inventory for
April
is
$22,800.
f.
April
selling and administrative expenses include salaries of
$32,000,
30%
of which will be paid in cash and the remainder paid next month.
g.
Additional
April
selling and administrative expenses also include miscellaneous expenses of
15%
of sales, all paid in
April.
h.
April
budgeted sales,
$86,000,
50%
collected in
April
and
50%
in
May.
i.
April…
Tune Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows:
As Tune Printing Supply's controller, you have assembled the following additional information:
a.
April dividends of $6,000 were declared and paid.
b.
April capital expenditures of $16,200 budgeted for cash purchase of equipment.
c.
April depreciation expense, $500.
d.
Cost of goods sold, 45% of sales.
e.
Desired ending inventory for April is $22,800.
f.
April selling and administrative expenses include salaries of
$32,000, 30% of which will be paid in cash and the remainder paid next month.
g.
Additional April selling and administrative expenses also include miscellaneous expenses of 15% of sales, all paid in April.
h.
April budgeted sales, $86,000, 50% collected in April and 50% in May.
i.
April cash payments of…
The controller of Arrowroot Company wishes to improve the company’s control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021:
June 30, 2021, cash balance
$
122,000
Dividends were declared on June 15*
40,000
Cash expenditures to be paid in July for operating expenses
81,600
Depreciation expense
12,200
Cash collections to be received
194,000
Merchandise purchases to be paid in cash
120,400
Equipment to be purchased for cash
45,800
Arrowroot Company wishes to maintain a minimum cash balance of
62,000
*Dividends are payable to shareholders of record on declaration date, 30 days after declaration.
Required:
1. Prepare a cash budget for the month ended July 31, 2021, indicating how much, if anything, Arrowroot will need to borrow to meet its minimum cash requirement. Leave no cells blank - be certain to enter "0" wherever required
Chapter 22 Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Ch. 22 - Managers are required to think about future...Ch. 22 - Prob. 2TICh. 22 - Managers use results to evaluate employees...Ch. 22 - Managers work with managers in other divisions.Ch. 22 - Prob. 5TICh. 22 - Match the budget types to the definitions.Ch. 22 - Prob. 7TICh. 22 - Prob. 8TICh. 22 - Prob. 9TICh. 22 - Prob. 10TI
Ch. 22 - Prob. 11TICh. 22 - Prob. 12TICh. 22 - Prob. 13TICh. 22 - Prob. 14TICh. 22 - Prob. 15TICh. 22 - Prob. 16TICh. 22 - A company can expect to receive which of the...Ch. 22 - A company prepares a five-year budget. This budget...Ch. 22 - Which of the following is the cornerstone of the...Ch. 22 - Prob. 4QCCh. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - Prob. 6QCCh. 22 - Use the following information to answer questions...Ch. 22 - The budgeted income statement is part of which...Ch. 22 - Prob. 9QCCh. 22 - Use the following information to answer questions...Ch. 22 - Suppose Mallcentral sells 1,000 hardcover books...Ch. 22 - Prob. 12QCCh. 22 - Information technology has made it easier for...Ch. 22 - Prob. 1RQCh. 22 - Prob. 2RQCh. 22 - Prob. 3RQCh. 22 - What is budgetary slack? Why might managers try to...Ch. 22 - Explain the difference between strategic and...Ch. 22 - Explain the difference between static and flexible...Ch. 22 - What is a master budget?Ch. 22 - In a manufacturing company, what are the three...Ch. 22 - Why is the sales budget considered the cornerstone...Ch. 22 - Prob. 10RQCh. 22 - What is the formula used to determine the amount...Ch. 22 - What are the two types of manufacturing overhead?...Ch. 22 - How is the predetermined overhead allocation rate...Ch. 22 - What is the capital expenditures budget?Ch. 22 - Prob. 15RQCh. 22 - What are the budgeted financial statements? How do...Ch. 22 - How does the master budget for a merchandising...Ch. 22 - What is the formula used to determine the amount...Ch. 22 - What budgets are included in the financial budget...Ch. 22 - What is sensitivity analysis? Why is it important...Ch. 22 - Budgeting benefits List the three key benefits...Ch. 22 - Budgeting types Consider the following budgets and...Ch. 22 - Preparing an operating budgetsales budget Brown...Ch. 22 - Preparing an operating budgetproduction budget...Ch. 22 - Preparing an operating budgetdirect materials...Ch. 22 - Preparing an operating budgetdirect labor budget...Ch. 22 - Preparing an operating budgetmanufacturing...Ch. 22 - Preparing an operating budgetcost of goods sold...Ch. 22 - Berry expects total sales of 359,000 in January...Ch. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Preparing a financial budgetcash budget Booth has...Ch. 22 - Prob. 12SECh. 22 - Preparing an operating budgetsales budget Trailers...Ch. 22 - Preparing an operating budgetinventory, purchases,...Ch. 22 - Victors expects total sales of 702,000 for January...Ch. 22 - Prob. 16SECh. 22 - Preparing a financial budgetcash budget Wilson...Ch. 22 - Victors expects total sales of 702,000 for January...Ch. 22 - Using sensitivity analysis in budgeting Refer to...Ch. 22 - Using sensitivity analysis in budgeting Riverbed...Ch. 22 - Prob. 21ECh. 22 - Preparing an operating budgetsales budget...Ch. 22 - Preparing an operating budgetsales and production...Ch. 22 - Preparing an operating budgetdirect materials,...Ch. 22 - Preparing an operating budgetcost of goods sold...Ch. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Prob. 27ECh. 22 - Preparing the financial budgetcash budget Use the...Ch. 22 - Preparing the financial budgetcash budget Hoppy...Ch. 22 - Preparing the financial budgetbudgeted balance...Ch. 22 - Preparing an operating budgetinventory, purchases,...Ch. 22 - Preparing an operating budgetselling and...Ch. 22 - Prob. 33ECh. 22 - Preparing a financial budgetcash budget,...Ch. 22 - Preparing a financial budgetcash budget You...Ch. 22 - Use the following June actual ending balances and...Ch. 22 - Using sensitivity analysis Rucker Company prepared...Ch. 22 - Preparing an operating budgetsales, production,...Ch. 22 - Preparing an financial budgetschedule of cash...Ch. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Completing a comprehensive budgeting...Ch. 22 - Preparing an operating budgetsales budget;...Ch. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Prob. 45APCh. 22 - Prob. 46APCh. 22 - Preparing an operating budgetsales, production,...Ch. 22 - Prob. 48BPCh. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Completing a comprehensive budgeting...Ch. 22 - Prob. 51BPCh. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Prob. 53BPCh. 22 - Belton Printing Company of Baltimore has applied...Ch. 22 - Using sensitivity analysis Holly Company prepared...Ch. 22 - Prob. 57PCh. 22 - Before you begin this assignment, read the...Ch. 22 - Prob. 1DCCh. 22 - Patrick works for McGills Computer Repair, owned...
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
- Fairview Medical Supply has applied for a loan. First American Bank has requested a budgeted balance sheet as of April 30, and a combined cash budget for April. As Fairview Medical Supply's controller, you have assembled the following information: a. March 31 equipment balance, $52,700; accumulated depreciation, $41,100. b. April capital expenditures of $42,700 budgeted for cash purchase of equipment. c. April depreciation expense, $500. d. Cost of goods sold, 60% of sales. e. Other April operating expenses, including income tax, total $13,400, 30%of which will be paid in cash and the remainder accrued at April 30. f. March 31 owners' equity, $93,600. g. March 31 cash balance, $40,100. h. April budgeted sales, $91,000, 70% of which is for cash. Of the remaining 30%, half will be collected in April and half in May. i. April cash collections on March sales, $29,200. j. April cash payments of March 31 liabilities incurred…arrow_forwardHugo Medical Supply has applied for a loan. Pacific Commerce Bank has requested a budgeted balance sheet as of April 30, and a combined cash budget for April. As Hugo Medical Supply's controller, you have assembled the following information: a. March 31 equipment balance, $52,600; accumulated depreciation, $41,300. b. April capital expenditures of $ 42,400 budgeted for cash purchase of equipment. c. April depreciation expense, $700. d. Cost of goods sold, 60%of sales. e. Other April operating expenses, including income tax, total $14,200, 35% of which will be paid in cash and the remainder accrued at April 30. f. March 31 owners' equity, $92,600. g. March 31 cash balance, $40,300. h. April budgeted sales, $90,000, 70% of which is for cash. Of the remaining 30%, half will be collected in April and half in May. i. April cash collections on March sales, $29,100. j. April cash payments of March 31 liabilities incurred for March…arrow_forwardThe controller of Optimum wishes to improve the company’s control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021: June 30, 2021, cash balance $ 130,000 Dividends were declared on June 15* 44,000 Cash expenditures to be paid in July for operating expenses 83,600 Depreciation expense 13,000 Cash collections to be received 198,000 Merchandise purchases to be paid in cash 122,400 Equipment to be purchased for cash 47,000 Optimum wishes to maintain a minimum cash balance of 70,000 *Dividends are payable to shareholders of record on declaration date, 30 days after declaration. Required: 1. Prepare a cash budget for the month ending July 31, 2021, indicating how much, if anything, Optimum will need to borrow to meet its minimum cash requirement. (Leave no cells blank - enter "0" wherever required). 2. Which of the following statement is true? a) The income…arrow_forward
- The controller of Optimum wishes to improve the company’s control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021: June 30, 2021, cash balance $ 130,000 Dividends were declared on June 15* 44,000 Cash expenditures to be paid in July for operating expenses 83,600 Depreciation expense 13,000 Cash collections to be received 198,000 Merchandise purchases to be paid in cash 122,400 Equipment to be purchased for cash 47,000 Optimum wishes to maintain a minimum cash balance of 70,000 *Dividends are payable to shareholders of record on declaration date, 30 days after declaration. Required: 1. Prepare a cash budget for the month ending July 31, 2021, indicating how much, if anything, Optimum will need to borrow to meet its minimum cash requirement. (Leave no cells blank - enter "0" wherever required). The controller of Optimum wishes to improve the company’s control…arrow_forwardThe controller of Optimum wishes to improve the company's control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021: June 30, 2021, cash balance Dividends were declared on June 15 Cash expenditures to be paid in July for operating expenses Depreciation expense Cash collections to be received Herchandise purchases to be paid in cash Equipment to be purchased for cash Optimun wishes to naintain a ninimum cash balance of $ 98,000 28, 000 75,600 9,800 182,000 114,400 42, 200 38,000 DIvidends are payable to shareholders of record on declaration date, 30 days after declaration. Required: 1. Prepare a cash budget for the month ending July 31, 2021, indicating how much, if anything, Optimum will need to borrow to meet its minimum cash requirement. (Leave no cells blank - enter "0" wherever required). ARROWROOT COMPANY Cash Budget for July 31, 2021 Total cash available before current financing Less disbursements Total disbursementsarrow_forwardDear Bartleby, I need assistance calculating interest for part b. b. Assume that management of SeaTech Inc. desires to maintain a minimum cash balance of $10,000 at the beginning of each month and has arranged a $50,000 line of credit with a local bank at an interest rate of 10% to ensure the availability of funds. Borrowing transactions are to occur only at the end of months in which the budgeted cash balance would otherwise fall short of the $10,000 minimum balance. Repayments of principal and interest are to occur at the end of the earliest month in which sufficient funds are expected to be available for repayment. (Use 360 days year for calculations.) Following are the budgeted income statements for the second quarter of 2019 for SeaTech Inc.: April May June Sales $ 112,000 $ 136,000 $ 152,000 Cost of goods sold* 76,800 91,200 100,800 Gross profit $ 35,200 $ 44,800 $ 51,200 Operating expenses† 17,600 20,000 21,600…arrow_forward
- The controller of Big River Inc. wishes to improve the company's control system by preparing a monthly cash budget. The following information relates to the month ending May 31, 2024 April 30, 2024, cash balance Dividends were declared on April 15 Cash expenditures to be paid in May for operating expenses Depreciation expense Cash collections to be received Merchandise purchases to be paid in cash Equipment to be purchased for cash Big River wishes to maintain a minimum cash balance of $122,000 40,000 81,600 12,200 194,000 120,400 45,800 62,000 "Dividends are payable to shareholders of record on declaration date, 30 days after declaration Required: 1. Prepare a cash budget for the month ended May 31, 2024, indicating how much, if anything. Big River will need to borrow to meet its minimum cash requirement. (Leave no cells blank - be certain to enter "0" wherever required.)arrow_forwardThe controller of Optimum wishes to improve the company's control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021: June 30, 2021, cash balance Dividends were declared on June 15* $130,000 44, 000 83,600 13,000 198,000 122,400 47,000 70, 000 Cash expenditures to be paid in July for operating expenses Depreciation expense Cash collections to be received Merchandise purchases to be paid in cash Equipment to be purchased for cash Optimum wishes to maintain a minimum cash balance of *Dividends are payable to shareholders of record on declaration date, 30 days after declaration. Required: 1. Prepare a cash budget for the month ending July 31, 2021, indicating how much, if anything, Optimum will need to borrow to meet its minimum cash requirement. (Leave no cells blank - enter "O" wherever required).arrow_forwardRequired: A) The business needs to have a sense of its future cash flows and therefore requires the preparation of the following: ▪ A cash budget, with a total column, for the quarter ending March 31, 2022, showing the expected cash receipts and payments for each month and the ending cash balance for each of the three months, given that no financing activities took place. B) Another team member who is preparing the Budgeted Balance Sheet for the business for the same quarter ending March 31, 2022 and has asked you to furnish him with the figures for the expected trade receivables and payables to be included in the statement. Is that a reasonable request? If yes, what should these amounts be? C) Upon receipt of the budget, the team manager, June Jackson, has now informed you that, in keeping with industry players, the management of Pelican Merchandising have indicated an industry requirement to maintain a minimum cash balance of $185,000 each month. She has also noted that management is…arrow_forward
- owa Imaging Center provided the financial information in Exhibit 5.15 below. Prepare a cash budget for the quarter ending March 20X1. For Blackboard you will enter your ENDING cash balance for the months of January 20X1, February 20X1, March 20X1, and the Quarter ending March 20X1. I want you to submit your work for this problem by email so I can review the entire document. Exhibit 5-15 Iowa Imaging Center Givens Revenues and Expenses Patient Revenues, 20X0 Estimated Patient Revenues, 20X1 Given 1 October $4,000,000 Given 2 January $4,300,000 November $4,200,000 February $4,350,000 December $4,300,000 March $4,400,000 Other Revenues, 20X1 Estimated Cash Outflows, 20X1a Given 3 January $90,000 Given 4 January $4,250,000…arrow_forwarda) The business needs to have a sense of its future cash flows and therefore requires the preparation of the following: ▪ A schedule of budgeted cash collections for trade receivables (sales on account) for each of the months January to March. ▪ A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months January to March. ▪ A cash budget, with a total column, for the quarter ending March 31, 2022, showing the expected cash receipts and payments for each month and the ending cash balance for each of the three months, given that no financing activities took place.PLEASE TAKE INTO CONSIDERATION THE DISCOUNTS!i.e the credit terms 4/30, n90 for accounts receivables& the credit terms 2/30, n60 for accounts payablearrow_forwardChung Limited is applying for additional bank overdraft finance to enable the company to make the plant and machinery purchase described below. The directors have has asked you to draw up a cash budget for the 6 months to 30 June 2020 to prove to the bank that that overdraft finance will be repaid by 30 June 2020. The company provides you with the following financial information: Month Sales Purchases Wages Overheads £ £ £ £ November 2019 (actual) 45,800 18,400 9,600 6,000 December 2019 (actual) 34,600 13,900 9,800 14,000 January 2020 (budgeted) 42,200 16,800 10,500 7,000 February 2020 (budgeted) 44,000 17,600 11,200 7,500 March 2020 (budgeted) 54,000 21,600 13,500 18,800 April 2020 (budgeted) 57,600 23,000 14,400 8,000 May 2020 (budgeted) 61,800 24,700 15,300 9,200 June 2020 (budgeted) 63,700 25,500 15,900 9,800 Notes: The bank balance at 1 January 2020…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:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial 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
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY