Concept explainers
Cash budgeting, budgeted
Refer to the information in Problem 6-42.
Budgeted balances at January 31, 2018 are as follows:
Cash | ? |
? | |
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
HORNGRENS COST ACCOUNTING W/ACCESS
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 September 30, 2016.arrow_forwardPrepare 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_forward
- Prepare a revenue budget for the year ending December 31, 2016.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_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_forwardONLY ANSWER QUESTION (B) the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade…arrow_forwardQuestion 6. Please fill in the blanks in the same format as the questionarrow_forward
- HW 2022.1.3. The Sunstate Bank has asked Dell Printing Co. for a budgeted balance sheet for the year ended December 31, 2022. The following information is available: 1.+The cash budget shows an expected cash balance of $75,000 at December 31, 2022. 2- The 2022 sales budget shows total annual sales of $800,000. All sales are made on account and accounts receivable at December 31, 2022 are expected to be 10% of annual sales. 3.+ The merchandise purchases budget shows budgeted cost of goods sold for 2022 of $600,000 and ending merchandise inventory of $95,000. 20% of the ending inventory is expected to have not yet been paid at December 31, 2022. 4.-The December 31, 2021 balance sheet includes the following balances: Equipment $294,000, Accumulated Depreciation $122,000, Common Stock $270,000, and Retained Earnings $48,000. 5.+ The budgeted income statement for 2022 includes the following: depreciation on equipment $15,000, federal income taxes $21,000, and net income $49,000. The income…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_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_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 LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub