Chapter 22: Q1RQ (page 1228)
Question: List the four budgeting objectives.
Answer
Four budgeting objectives are:
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—cash budget
You recently began a job as an accounting intern at Reilly Golf Park. Your first task was to help prepare the cash budget for April and May. Unfortunately, the computer with the budget file crashed, and you did not have a backup or even a paper copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct the budget.
Reilly Golf Park eliminates any cash deficiency by borrowing the exact amount needed from First Street Bank, where the current interest rate is 6% per year. Reilly Golf Park first pays interest on its outstanding debt at the end of each month. The company then repays all borrowed amounts at the end of the month with any excess cash above the minimum required but after paying monthly interest expenses. Reilly does not have any outstanding debt on April 1.
Complete the cash budget. Round interest expense to the nearest whole dollar.
Preparing an operating budget—sales budget
Yarbrough Company manufactures T-shirts printed with tourist destination logos. The following table shows sales prices and projected sales volume for the summer months:
Projected Sales in Units T-Shirt Sizes Sales Price June July August Youth $ 7 575 500 525 Adult—regular 17 625 900 825 Adult—oversized 18 400 500 475 Prepare a sales budget for Yarbrough Company for the three months.
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:
a. April dividends of \(7,000 were declared and paid.
b. April capital expenditures of \)16,300 budgeted for cash purchase of equipment.
c. April depreciation expense, \(1,000.
d. Cost of goods sold, 40% of sales.
e. Desired ending inventory for April is \)22,400.
f. April selling and administrative expenses include salaries of \(37,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 10% of sales, all paid in April.
h. April budgeted sales, \)89,000, 80% collected in April and 20% in May.
i. April cash payments of March 31 liabilities incurred for March purchases of inventory, \(8,600.
j. April purchases of inventory, \)8,600 for cash and $37,400 on account. Half the credit purchases will be paid in April and half in May.
Requirements
1. Prepare the sales budget for April.
2. Prepare the inventory, purchases, and cost of goods sold budget for April.
3. Prepare the selling and administrative expense budget for April.
4. Prepare the schedule of cash receipts from customers for April.
5. Prepare the schedule of cash payments for selling and administrative expenses for April.
6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance.
7. Prepare the budgeted income statement for April.
8. Prepare the budgeted balance sheet at April 30, 2018.
Budgeting types Consider the following budgets and budget types.
Cash Cost of Goods Sold
Flexible Master
Operational Sales
Static Strategic
Which budget or budget type should be used to meet the following needs?
a. Upper management is planning for the next five years.
b. A store manager wants to plan for different levels of sales.
c. The accountant wants to determine if the company will have sufficient funds to pay expenses.
d. The CEO wants to make companywide plans for the next year.
Question: Completing a comprehensive budgeting problem—manufacturing company
The Gerard Tire Company manufactures racing tires for bicycles. Gerard sells tires for \(90 each. Gerard is planning for the next year by developing a master budget by quarters. Gerard’s balance sheet for December 31, 2018, follows:
Other data for Gerard Tire Company:
a. Budgeted sales are 1,500 tires for the first quarter and expected to increase by 200 tires per quarter. Cash sales are expected to be 10% of total sales, with the remaining 90% of sales on account.
b. Finished Goods Inventory on December 31, 2018, consists of 300 tires at \)33 each.
c. Desired ending Finished Goods Inventory is 30% of the next quarter’s sales; first quarter sales for 2020 are expected to be 2,300 tires. FIFO inventory costing method is used.
d. Raw Materials Inventory on December 31, 2018, consists of 600 pounds of rubber compound used to manufature the tires.
e. Direct materials requirements are 2 pounds of a rubber compound per tire. The cost of the compound is \(8.50 per pound.
f. Desired ending Raw Materials Inventory is 40% of the next quarter’s direct materials needed for production; desired ending inventory for December 31, 2019 is 600 pounds; indirect materials are insignificant and not considered for budgeting purposes.
g. Each tire requires 0.4 hours of direct labor; direct labor costs average \)12 per hour.
h. Variable manufacturing overhead is \(4 per tire.
i. Fixed manufacturing overhead includes \)6,000 per quarter in depreciation and \(16,770 per quarter for other costs, such as utilities, insurance, and property taxes.
j. Fixed selling and administrative expenses include \)12,500 per quarter for salaries;
k. Variable selling and administrative expenses include supplies at 2% of sales. l. Capital expenditures include \)15,000 for new manufacturing equipment, to be purchased and paid in the first quarter.
m. Cash receipts for sales on account are 70% in the quarter of the sale and 30% in the quarter following the sale; December 31, 2018, Accounts Receivable is received in the first quarter of 2019; uncollectible accounts are considered insignificant and not considered for budgeting purposes.
n. Direct materials purchases are paid 60% in the quarter purchased and 40% in the following quarter; December 31, 2018, Accounts Payable is paid in the first quarter of 2019. o. Direct labor, manufacturing overhead, and selling and administrative costs are paid in the quarter incurred.
p. Income tax expense is projected at \(1,500 per quarter and is paid in the quarter incurred.
q. Gerard desires to maintain a minimum cash balance of \)55,000 and borrows from the local bank as needed in increments of
Requirements
1. Prepare Gerard’s operating budget and cash budget for 2019 by quarter. Required schedules and budgets include: sales budget, production budget, direct materials budget, direct labor budget, manufacturing overhead budget, cost of goods sold budget, selling and administrative expense budget, schedule of cash receipts, schedule of cash payments, and cash budget. Manufacturing overhead costs are allocated based on direct labor hours. Round all calculations to the nearest dollar.
2. Prepare Gerard’s annual financial budget for 2019, including budgeted income statement and budgeted balance sheet.
What do you think about this solution?
We value your feedback to improve our textbook solutions.
