Learning Materials
Features
Discover
Chapter 22: Q14RQ (page 1228)
What is the capital expenditures budget?
The capital expenditure budget estimates the amount for the purchase of property, buildings, machinery, and equipment.
Over 30 million students worldwide already upgrade their learning with Vaia!
All the tools & learning materials you need for study success - in one app.
Get started for free
Preparing the financial budget—cash budget
Use the original schedule of cash receipts completed in Exercise E22-26, Requirement 1, and the schedule of cash payments completed in Exercise E22-27 to complete a cash budget for Marcel Company for January, February, and March.
Additional information: Marcel’s beginning cash balance is \(5,000, and Marcel desires to maintain a minimum ending cash balance of \)5,000. Marcel borrows cash as needed at the beginning of each month in increments of \(1,000 and repays the amounts borrowed in increments of \)1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 8% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month.
How is benchmarking beneficial?
Question: Preparing an operating budget—sales budget; inventory, purchases and COGS budget; and S&A expense budget Burton Office Supply’s March 31, 2018, balance sheet follows:
The budget committee of Burton Office Supply has assembled the following data: a. Sales in April are expected to be \(200,000. Burton forecasts that monthly sales will increase 2% over April sales in May. June’s sales will increase by 4% over April sales. July sales will increase 20% over April sales. b. Burton maintains inventory of \)15,000 plus 25% of the cost of goods sold budgeted for the following month. Cost of goods sold equal 50% of sales revenue. c. Monthly salaries amount to \(7,000. Sales commissions equal 5% of sales for that month. d. Other monthly expenses are as follows: • Rent: \)2,000 • Depreciation: \(200 • Insurance: \)100 • Income tax: $2,200
Requirements
1. Prepare Burton’s sales budget for April and May 2018. Round all calculations to the nearest dollar.
2. Prepare Burton’s inventory, purchases, and cost of goods sold budget for April and May.
3. Prepare Burton’s selling and administrative expense budget for April and May.
Preparing the financial budget—cash budget Hoppy Company requires a minimum cash balance of $3,500. When the company expects a cash deficiency, it borrows the exact amount required on the first of the month. Expected excess cash is used to repay any amounts owed. Interest owed from the previous month’s principal balance is paid on the first of the month at 14% per year. The company has already completed the budgeting process for the first quarter for cash receipts and cash payments for all expenses except interest. Hoppy does not have any outstanding debt on January 1. Complete the cash budget for the first quarter for Hoppy Company. Round interest expense to the nearest whole dollar.
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, \)4,800
Depreciation on manufacturing equipment, \(800
Cost of goods sold, \)14,800
Selling and administrative costs incurred and paid, \(500
Purchase of equipment, paid in 2019, \)2,000
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.)
What do you think about this solution?
We value your feedback to improve our textbook solutions.
Explanations 
Textbooks 
Exams 
GCSE 
IGCSE 
AS 
A Level 
International A Level 
University Admissions Tests 
Flashcards 
Vaia AI 
Notes 
Study Plans 
Study Sets 
Find a job 
Find a degree 
Student Deals 
Magazine 
Mobile App