Log out Go to App
Go to App

Learning Materials

Features

Discover

Chapter 22: Q52PGB (page 1257)

Preparing a financial budget—schedule of cash receipts, schedule of cash payments, cash budget

Beasley Company’s budget committee provides the following information:

December 31, 2017, account balances:

Cash \( 32,000 Accounts Receivable 19,000 Merchandise Inventory 16,000 Accounts Payable 15,000 Salaries and Commissions Payable 2,900 Budgeted amounts for 2018:

January February Sales, all on account \) 84,000 $ 84,400 Purchases, all on account 41,000 41,600 Commissions Expense 4,200 4,220 Salaries Expense 5,000 5,000 Rent Expense 2,200 2,200 Depreciation Expense 500 500 Insurance Expense 200 200 Income Tax Expense 1,900 1,900

Requirements

1. Prepare the schedule of cash receipts from customers for January and February 2018. Assume cash receipts are 80% in the month of the sale and 20% in the month following the sale.

2. Prepare the schedule of cash payments for purchases for January and February 2018. Assume purchases are paid 70% in the month of purchase and 30% in the month following the purchase.

3. Prepare the schedule of cash payments for selling and administrative expense for January and February 2018. Assume 25% of the accrual for Salaries and Commissions Payable is for commissions and 75% is for salaries. The December 31 balance will be paid in January. Salaries and commissions are paid 70% in the month incurred and 30% in the following month. Rent and income tax expenses are paid as incurred. Insurance expense is an expiration of the prepaid amount.

4. Prepare the cash budget for January and February. Assume no financing took place.

Short Answer

Expert verified

The ending balance of cash is $61,200 for January and $90,780 for February.

Step by step solution

01

Preparation of schedule of cash receipts from customers 

Baxter Company

Schedule of cash receipts from customers

For January and February, 2018

January

February

Total Sales

$84,000

$84,400

Cash receipts from customers (80% of Sales)

$67,200

$67,520

Cash receipts from last quarter

$19,000

$16,800

Total cash received from customers

$86,200

$84,320

02

Preparation of schedule of cash payments

Baxter Company

Schedule of cash payments from purchases

For January and February, 2018

January

February

Total purchases

$41,000

$41,600

Cash payments:

Purchases (70%)

$28,700

$29,120

Remaining purchases (40%)

$15,000

$12,300

Total cash paid

$43,700

$41,420

03

Preparation of schedule of cash payments 

Baxter Company

Schedule of selling and administrative expenses

For January and February, 2018

January

February

Salaries

$5,000

$5,000

Commission

$4,200

$4,220

Rent

$2,200

$2,200

Income tax expense

$1,900

$1,900

Total

$13,300

$13,320

04

Preparation of schedule of cash budget

Puckett Company

Cash Budget

For the first quarter, 2018

January

February

Opening cash balance

$32,000

$61,200

Cash receipts

$86,200

$84,320

Cash paid for purchases

$43,700

$41,420

Cash paid for expenses

$13,300

$13,320

Cash ending balance

$61,200

$90,780

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Start your free trial

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

What are the two types of manufacturing overhead? How do they affect the manufacturing overhead budget calculations?

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

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 an operating budget—direct materials, direct labor, and manufacturing overhead budgets

Grady, Inc. manufactures model airplane kits and projects production at 650, 500, 450, and 600 kits for the next four quarters. Direct materials are 4 ounces of plastic per kit and the plastic costs \(1 per ounce. Indirect materials are considered insignificant and are not included in the budgeting process. Beginning Raw Materials Inventory is 850 ounces, and the company desires to end each quarter with 10% of the materials needed for the next quarter’s production. Grady desires a balance of 200 ounces in Raw Materials Inventory at the end of the fourth quarter. Each kit requires 0.10 hours of direct labor at an average cost of \)10 per hour. Manufacturing overhead is allocated using direct labor hours as the allocation base. Variable overhead is \(0.20 per kit, and fixed overhead is \)165 per quarter. Prepare Grady’s direct materials budget, direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number.

Preparing a financial budget—cash budget

Booth has \(12,500 in cash on hand on January 1 and has collected the following budget data:

January February

Sales \) 529,000 \( 568,000

Cash receipts from customers 443,000 502,200

Cash payments for direct materials purchases 180,624 160,284

Direct labor costs 135,010 113,348

Manufacturing overhead costs (includes

depreciation of \)900 per month) 55,058 53,922

Assume direct labor costs and manufacturing overhead costs are paid in the month incurred. Additionally, assume Booth has cash payments for selling and administrative expenses including salaries of \(40,000 per month plus commissions that are 1% of sales, all paid in the month of sale. The company requires a minimum cash balance of \)20,000. Prepare a cash budget for January and February. Round to the nearest dollar. Will Booth need to borrow cash by the end of February?
See all solutions

Recommended explanations on Business Studies Textbooks

Managerial Economics

Read Explanation

Organizational Behavior

Read Explanation

Intermediate Accounting

Read Explanation

Human Resources

Read Explanation

Managers

Read Explanation

Introduction to Business

Read Explanation
View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free