Concept explainers
Cash budgeting, budgeted balance sheet. (Continuation of 6-42) (Appendix)
Refer to the information in Problem 6-42.
Budgeted balances at January 31, 2018 are as follows:
Cash | ? |
Accounts receivable | ? |
Inventory | ? |
Property, plant and equipment (net) | $1,175,600 |
Accounts payable | ? |
Long-term liabilities | 182,000 |
Stockholders’ equity | ? |
Selected budget information for December 2017 follows:
Cash balance, December 31, 2017 | $ 124,000 |
Budgeted sales | 1,650,000 |
Budgeted materials purchases | 820,000 |
Customer invoices are payable within 30 days. From past experience, Skulas’s accountant projects 40% of invoices will be collected in the month invoiced, and 60% will be collected in the following month.
Accounts payable relates only to the purchase of direct materials. Direct materials are purchased on credit with 50% of direct materials purchases paid during the month of the purchase, and 50% paid in the month following purchase.
Fixed
All property, plant, and equipment acquired during January 2018 were purchased on credit and did not entail any outflow of cash.
There were no borrowings or repayments with respect to long-term liabilities in January 2018.
On December 15, 2017, Skulas’s board of directors voted to pay a $160,000 dividend to stockholders on January 31, 2018.
- 1. Prepare a
cash budget for January 2018. Show supporting schedules for the calculation of collection of receivables and payments of accounts payable, and for disbursements for fixed manufacturing and nonmanufacturing overhead. - 2. Skulas is interested in maintaining a minimum cash balance of $120,000 at the end of each month. Will Skulas be in a position to pay the $160,000 dividend on January 31 ?
- 3. Why do Skulas’s managers prepare a cash budget in addition to the revenue, expenses, and operating income budget?
- 4. Prepare a budgeted balance sheet for January 31, 2018 by calculating the January 31, 2018 balances in (a) cash (b) accounts receivable (c) inventory (d) accounts payable and (e) plugging in the balance for stockholders’ equity.
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
Additional Business Textbook Solutions
Managerial Accounting (5th Edition)
Managerial Accounting (4th Edition)
Construction Accounting And Financial Management (4th Edition)
Horngren's Financial & Managerial Accounting, The Financial Chapters (6th Edition)
Intermediate Accounting (2nd Edition)
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
- Prepare a budgeted income statement for the month ending March 31, 2016.arrow_forwardRelevant data from the operating budget of The Framers are: Other data: Capital assets were sold in quarter 1 and $8,000 was collected in quarter 1 and $500 collected in quarter 2. Dividends of $500 will be paid in May The beginning cash balance was $50,000 and a required minimum cash balance is $10,000. Prepare a cash budget for the first two quarters of the year.arrow_forwardBudgeted selling and administrative expenses for King Tire Co. In P7-2 for the year ended December 31, 2016, were as follows: Required: 1. Prepare a selling and administrative expense budget, in good form, for the year 2016. 2. Using the information above and the budgets prepared in P7-2, prepare a budgeted income statement for the year 2016, assuming an income tax rate of 40%.arrow_forward
- Prepare a revenue budget for the year ending December 31, 2016.arrow_forwardA. Discuss the purpose of the cash budget. B. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?arrow_forwardA companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971arrow_forward
- Roman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement for the year ended December 31, 2016, assuming that income from operations is taxed at a rate of 30%.arrow_forwardQUESTION 2 REQUIRED Prepare the Cash Budget for January, February and March 2021. (Provide separate monetary columns for each month.) INFORMATION Ricoh Limited is planning the business activities of Project Haz for the first three months of 2021. Some of the items in the Statement of Financial Position as at 31 December 2020 are expected to be as fallows: Current assets Debtors/Accounts receivable R 600 000 20 000 Bank Current liabilities Creditors (for material purchases) 100 000 Additional information The following forecasts have been made by Ricoh Limited for the first three months of 2021: 1. Direct materials The costs of production include the following: R26 per unit Direct labour R22 per unit 2. The sales manager anticipates the following sales volumes at a constant price of R160 per unit: January February March 2 300 units 2 500 units 3 400 units All the sales are on credit and debtors pay their accounts in the month after the sale. 3. The purchases manager expects to purchase…arrow_forwardConsider the following June actual ending balances and July 31, 2024 budgeted amounts for Octovios: 1(Click the icon to view the information.) Prepare a budgeted balance sheet for July 31, 2024. (Hint: It may be helpful to trace the effects of each transaction on the accounting equation to determine the ending balance of each account.) Complete the accounting equation for the July operating information. (Use a minus sign or parentheses to enter account reductions and contra asset balances and activity. If an input field is not used in the equation leave it empty; do not enter a zero. Abbreviations used: A/P = Accounts Payable, A/R = Accounts Receivable, Accum. Deprec. = Accumulated Depreciation, Merch. = Merchandise.) Stock- Merch. (Accum. Accounts holders' Cash + A/R + Inventory + Furniture + Deprec.) = Payable + equity…arrow_forward
- not graded... please help Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $74,000 on May 1, 2019. The following budgeted transactions for May 2019 present data related to anticipated cash receipts and cash disbursements: 1. For May, budgeted cash sales are $50,000 and budgeted credit sales are $490,000. (Credit sales for April were $450,000.) In the month of sale, 40% of credit sales are collected, with the balance collected in the month following sale. 2. Budgeted merchandise purchases for May are $270,000. (Merchandise purchases in April were $240,000.) In the month of purchase, 70% of merchandise purchases are paid for, and the balance is paid for in the following month. 3. Budgeted cash disbursements for salaries and operating expenses for May total $155,000. 4. During May, $25,000 of principal repayment and $4,000 of interest payment are due to the bank. 5. A $20,000 income…arrow_forwardREQUIRED Use the information given below to answer the following questions: Prepare the Cash Budget for January, February and March Comment on the cash position of the company for the budgeted INFORMATION Some of the items in the Statement of Financial Position as at 31 December 2021 of Lomax Ltd are as follows: Current assets R Accounts receivable 1 300 000 Bank 235 000 Current liabilities Accounts payable (for material purchases) 95 000 Other current liabilities 700 000 The following forecasts have been made by Lomax Ltd for the first three months of 2022 for the bricks that it produces which are sold in pallets (with each pallet comprising 500 bricks): The sales manager anticipates the following credit sales: January February March 2 160 pallets 2 340 pallets 2 250 pallets The bricks are sold at a constant price of R500 per pallet. Ten percent (10%) of the sales are for cash and the rest is on credit. Debtors…arrow_forwardConsider the following June actual ending balances and July 31, 2024 budgeted amounts for Octovios: 1(Click the icon to view the information.) Prepare a budgeted balance sheet for July 31, 2024. (Hint: It may be helpful to trace the effects of each transaction on the accounting equation to determine the ending balance of each account.) Complete the accounting equation for the July operating information. (Use a minus sign or parentheses to enter account reductions and contra asset balances and activity. If an input field is not used in the equation leave it empty; do not enter a zero. Abbreviations used: A/P = Accounts Payable, A/R = Accounts Receivable, Accum. Deprec. = Accumulated Depreciation, Merch. = Merchandise.) Stock- Merch. (Accum. Accounts holders' Cash + A/R + Inventory + Furniture + Deprec.) = Payable + equity…arrow_forward
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,