Chapter 22: Q7RQ (page 1228)
What is a master budget?
A master budget isa set of almost every divisional budgetof a business entity.
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 a financial budget—schedule of cash payments
Marcel Company has the following projected costs for manufacturing and selling and administrative expenses:
January February March Direct materials purchases \( 3,100 \) 3,500 $ 4,800 Direct labor costs 3,300 3,500 3,600 Depreciation on plant 550 550 550 Utilities for plant 650 650 650 Property taxes on plant 200 200 200 Depreciation on office 550 550 550 Utilities for office 250 250 250 Property taxes on office 170 170 170 Office salaries 3,500 3,500 3,500
All costs are paid in month incurred except: direct materials, which are paid in the month following the purchase; utilities, which are paid in the month after incurred; and property taxes, which are prepaid for the year on January 2. The Accounts Payable and Utilities Payable accounts have a zero balance on January 1. Prepare a schedule of cash payments for Marcel for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31.
Preparing an operating budget—production budget Bailey Company expects to sell 1,500 units of finished product in January and 1,750 units in February. The company has 180 units on hand on January 1 and desires to have an ending inventory equal to 80% of the next month’s sales. March sales are expected to be 1,820 units. Prepare Bailey’s production budget for January and February.
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:
Budgeted total sales, all on account $ 305,500 Budgeted direct materials to be purchased and used 40,000 Budgeted direct labor cost 12,500 Budgeted manufacturing overhead costs: Variable manufacturing overhead 2,600 Depreciation 800 Insurance and property taxes 1,100 Budgeted cost of goods sold 71,300 Budgeted selling and administrative expenses: Salaries expense7,000 Rent expense 3,500 Insurance expense 2,000 Depreciation expense 350 Supplies expense 3,055 Budgeted cash receipts from customers 263,500 Budgeted income tax expense 44,000 Budgeted purchase and payment for capital expenditures
(additional equipment) 34,000
Additional information:
a. Direct materials purchases are paid 50% in the quarter purchased and 50% in the next quarter.
b. Direct labor, ma following budgeted income statement manufacturing overhead, selling and administrative costs, and income tax expense are paid in the quarter incurred.
c. Accounts payable at December 31, 2018 are paid in the first quarter of 2019. Requirements
1. Prepare Ballentine Company’s budgeted income statement for the first quarter of 2019.
2. Prepare Ballentine Company’s budgeted balance sheet as of March 31, 2019.
Preparing a financial budget—schedule of cash receipts and schedule of cash payments
Agua Cool is a distributor of bottled water. For each of the items, compute the amount of cash receipts or payments Agua Cool will budget for September. The solution to one item may depend on the answer to an earlier item.
a. Management expects to sell equipment that cost \(14,000 at a gain of \)7,000. Accumulated depreciation on this equipment is \(5,000.
b. Management expects to sell 7,100 cases of water in August and 9,000 cases in September. Each case sells for \)14. Cash sales average 20% of total sales, and credit sales make up the rest. Three-fourths of credit sales are collected in the month of the sale, with the balance collected the following month.
c. The company pays rent and property taxes of $4,500 each month. Commissions and other selling expenses average 30% of sales. Agua Cool pays one-half of commissions and other selling expenses in the month incurred, with the balance paid the following month.
Preparing a financial budget—cash budget, sensitivity analysis
Leichter Auto Parts, a family-owned auto parts store, began January with \(10,500 cash. Management forecasts that collections from credit customers will be \)11,000 in January and \(15,200 in February. The store is scheduled to receive \)8,500 cash on a business note receivable in January. Projected cash payments include inventory purchases (\(15,600 in January and \)14,800 in February) and selling and administrative expenses (\(2,900 each month).
Leichter Auto Part'sbank requires a \)10,000 minimum balance in the store’s checking account. At the end of any month when the account balance falls below \(10,000, the bank automatically extends credit to the store in multiples of \)1,000. Leichter Auto Parts borrows as little as possible and pays back loans in quarterly installments of \(2,000, plus 4% APR interest on the entire unpaid principal. The first payment occurs three months after the loan.
Requirements
1. Prepare Leichter Auto Part'scash budget for January and February.
2. How much cash will Leichter Auto Parts borrow in February if collections from customers that month total \)14,200 instead of $15,200?
What do you think about this solution?
We value your feedback to improve our textbook solutions.
