Capital expenditures budget On January 1, 2016, the controller of Omicron Inc. is planning capital expenditures for the years 2016-2019. The following interviews helped the controller collect the necessary information for the capital expenditures budget: Director of Facilities: A construction contract was signed in late 2015 for the construction of a new factory building at a contract cost of $10,000,000. The construction is scheduled to begin in 2016 and be completed in 2017. Vice President of Manufacturing Once the new factory budding is finished, we plan to purchase $1.5 million in equipment in late 2017.1 expect that an additional 5200.000 will be needed early in the following year (20181 to test and install the equipment before we can begin production If sates continue to grow. I expect we'll need to invest another $1,000,000 in equipment in 2019. Chief Operating Officer: We have really been growing lately I wouldn't be surprised if we need to expand the size of our new factory building m 2019 by at least 35%. Fortunately, we expect inflation to have minimal impact on construction costs over the next four years. Additionally, I would expect the cost of the expansion to be proportional to the size of the expansion Director of Information Systems: We need to upgrade our information systems to wireless network technology. It doesn't make sense to do this until after the new factory building is completed and producing product. During 2018, once the factory is up and running, we should equip the whole facility with wireless technology. I think it would cost us $800,000 today to install the technology. However, prices have been dropping by 25% per year, so it should be less expensive at a later date. Chief Financial Officer: I am excited about our long-term prospects. My only short-term concern is managing our cash flow while we expend the $4,000,000 of construction costs on the portion of the new factory building scheduled to be completed in 2016. Use this interview information to prepare a capital expenditures budget for Omicron Inc. for the years 2016-2019.

Capital expenditures budget On August 1, 20Y4. the controller of Handy Dan Tools Inc. is planning capital expenditures for the years 20Y5-20Y8. The controller interviewed several Handy Dan executives to collect the necessary information for the capital expenditures budget. Excerpts of the interviews are as follows: Director of Facilities: A construction contract was signed in May 20Y4 for the construction of a new factory building at a contract cost of $9,000,000. The construction is scheduled to begin in 20Y5 and completed in 20Y6. Vice President of Manufacturing: Once the new factor)' building is finished, we plan to purchase $3-6 million in equipment in late 20Y6. I expect that an additional $500,000 will lx-needed early in the following year (20Y7) to test and install the equipment before we can begin production. If sales continue to grow, I expect we'll need to invest another half million in equipment in 20Y8. Vice President of Marketing: We have really been growing lately. I wouldn't be surprised if we need to expand the size of our new factory building in 20YS by at least 25%. Fortunately, we expect inflation to have minimal impact on construction costs over the next four years. Additionally, 1 would expect the cost of the expansion to Ik- proportional to the size of the expansion. Director of Information Systems: We need to upgrade our information systems to wireless network technology. It doesn't make sense to do this until after the new factory building is completed and producing product. During 20Y7, once the factor)' is up and running, we should equip the whole facility with wireless technology. I think it would cost us $400,000 today to install the technology. However, prices have been dropping by 10% per year, so it should be less expensive at a later date. President: I am excited about our long-term prospects. My only short-term concern is financing the $5,000,000 of construction costs on the portion of the new factor)' building scheduled to be completed in 20Y5. Use the interview information above to prepare a capital expenditures budget for Handy Dan Tools Inc. for the years 20Y5-20Y8.

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…

Emmanuel Macron has the following budgeted business transactions for the month of May 2020: insurance refund received: $500; payments to be made to materials suppliers: $15,000; payments to be made to employees: $4,000; cash expected from customers: $25,000; budgeted depreciation charge on non-current assets: $800; budgeted interest paid to bank: $40; personal drawings: $2,000. At 1 May 2020, Emmanuel is budgeting an overdraft at the bank of $4,000. What is Emmanuel's budgeted cash position at the end of May 2020? $340 overdrawn $340 cash in the bank $460 cash in the bank $460 overdrawn

Preparing a financial budget—budgeted income statement and balance sheet Ballentine Company has the following post-closing trial balance on December 31, 2018: The company’s accounting department has gathered the following budgeting information for the first quarter of 2019: Additional information: Direct materials purchases are paid 50% in the quarter purchased and 50%, in the next quarter. Direct labor, ma following budgeted income statement nufacturing overhead selling and administrative costs, and income tax expense are paid in the quarter incurred. Accounts payable at December 31, 2018 are paid in the first quarter of 2019. Requirements Prepare Ballentine Company’s budgeted income statement for the first quarter of 2019. Prepare Ballentine Company’s budgeted balance sheet as of March 31, 2019.

Completing a comprehensive budgeting problem—merchandising company Belton Printing Company of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for the month of April 2018 and a balance sheet at April 30, 2018. The March 31, 2018a balance sheet follows: As Belton Printings controller, you have assembled the following additional information: April dividends of $7,000 were declared and paid. April capital expenditures of $17,000 budgeted for cash purchase of equipment. April depreciation expense, $800. Cost of goods sold, 55% of sales. Desired ending inventory For April is $24,800. April selling and administrative expenses includes salaries of $29,000, 20% of which Will be paid in cash and the remainder paid next month. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April. April budgeted sales, $86,000, 80% collected in April and 20% in May. April cash payments of March 31…

Relevant 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.

Echo Amplifiers prepared the following sales budget for the first quarter of 2018: It also has this additional information related to its expenses: Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018.

Completing a comprehensive budgeting problem—merchandising Company Alliance Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2018 and a balance sheet at April 30, 2018. The March 31, 2018, balance sheet follows: As Alliance Printing Supply’s controller, you have assembled the following additional information: April dividends of $7,000 were declared and paid. April capital expenditures of $16,300 budgeted for cash purchase of equipment. April depreciation expense, $1,000. Cost of goods sold, 40% of sales. Desired ending inventory for April is $22,400. April selling and administrative expenses include salaries of $37,000, 30% of which will be paid in cash and the remainder paid next month. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April. April budgeted sales, $89,000, 80% collected in April and 20°/0 in May. April cash payments of March 31…

Preparing the financial budget—budgeted balance sheet Barker, Inc. has the following balance sheet at December 31, 2018: Barker projects the following transactions for 2019: Sales on account, $20,000 Cash receipts from customers from sales on account, $17,600 Purchase of raw materials on account, $7,000 Payments on account, $3,500 ‘ Total cost of completed products, $16,600, which includes the following: Raw materials used, $7,100 Direct labor costs incurred and paid, $3,900 Manufacturing overhead costs incurred and paid, 154,800 Depreciation on manufacturing equipment, $800 Prepare a budgeted balance sheet for Barker, Inc. for December 31, 2019. (Hint: it may be helpful to trace the effects of each transaction on the accounting equation to determine the ending balance of each account.) Cost of goods sold, $14,800 Selling and administrative costs incurred and paid, $500 Purchase of equipment, paid in 2019, $2,000

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). 2. Which of the following statement is true? a) The income…

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…

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…

Solution Summary: The author explains that budgeting is a process to prepare the financial statement by the manager to estimate the organization's future actions.

Concept explainers

Videos

Want to see the full answer?

Chapter 21 Solutions