Log out Go to App
Go to App

Learning Materials

Features

Discover

Chapter 22: Q26E (page 1234)

Preparing a financial budget—schedule of cash receipts, sensitivity analysis

Marcel Company projects the following sales for the first three months of the year: \(11,200 in January; \)12,300 in February; and $11,100 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar.

Requirements

1. Prepare a schedule of cash receipts for Marcel for January, February, and March. What is the balance in Accounts Receivable on March 31?

2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31?

Short Answer

Expert verified

Answer

Total cash receipts from the customers are $8,960 in the month of January, $12,080 in the month of February, and $11,340 in the month of March.

Step by step solution

01

Preparation of schedule of cash receipts

Particulars

January

February

March

Total budgeted sales

$11,200

$12,300

$11,100

Cash receipts from customers:




Cash sales (60%)

$6,720

$7,380

$6,660

Credit sales (40%) (50% in the month of sale)

$2,240

$2,460

$2,220

Credit sales (40%) (50% in the following month)

-

$2,240

$2,460

Total cash receipts from customers

$8,960

$12,080

$11,340

Account receivable on 31stMarch



$2,220

02

Preparation of revised schedule of cash receipts

Particulars

January

February

March

Total budgeted sales

$11,200

$12,300

$11,100

Cash receipts from customers:




Cash sales (60%)

$6,720

$7,380

$6,660

Credit sales (40%) (60% in the month of sale)

$2,688

$2,952

$2,664

Credit sales (40%) (30% in the following month)

-

$1,344

$1,476

Credit sales (40%) (10% in the second month following the sale)

-

-

$448

Total cash receipts from customers

$9,408

$6,324

$11,248

Account receivable on 31stMarch



$2,268

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

Crowley Company projects the following sales:

January February March

Cash sales (25%) \( 5,000 \) 5,500 \( 6,000

Sales on account (75%) 15,000 16,500 18,000

Total sales \) 20,000 \( 22,000 \) 24,000

Crowley collects sales on account in the month after the sale. The Accounts Receivable balance on January 1 is \(13,500, which represents December’s sales on account. Crowley projects the following cash receipts from customers:

January February March

Cash receipts from cash sales \) 5,000 \( 5,500 \) 6,000

Cash receipts from sales on account 13,500 15,000 16,500

Total cash receipts from customers \( 18,500 \) 20,500 $ 22,500

Recalculate cash receipts from customers if total sales remain the same but cash sales are only 20% of the total.

Preparing an operating budget—inventory, purchases, and cost of goods sold budget

Slate, Inc. sells tire rims. Its sales budget for the nine months ended September 30, 2018, follows:

Quarter Ended Nine-MonthTotal

March 31 June 30 September 30 Cash sales, 20% \( 28,000 \) 38,000 \( 33,000 \) 99,000

Credit sales, 80% 112,000 152,000 132,000 396,000 Total sales \( 140,000 \) 190,000 \( 165,000 \) 495,000

In the past, cost of goods sold has been 40% of total sales. The director of marketing and the financial vice president agree that each quarter’s ending inventory should not be below \(5,000 plus 10% of cost of goods sold for the following quarter. The marketing director expects sales of \)240,000 during the fourth quarter. The January 1 inventory was $38,000. Prepare an inventory, purchases, and cost of goods sold budget for each of the first three quarters of the year. Compute cost of goods sold for the entire nine-month period.

In a manufacturing company, what are the three types of budgets included in the master budget? Describe each type.

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

Puckett Company has provided the following budget information for the first quarter of 2018:

Total sales \( 216,000

Budgeted purchases of direct materials 40,600

Budgeted direct labor cost 36,800 Budgeted manufacturing overhead costs:

Variable manufacturing overhead 1,025

Depreciation 1,000

Insurance and property taxes 6,650

Budgeted selling and administrative expenses:

Salaries expense 14,000

Rent expense 2,500

Insurance expense 2,000

Depreciation expense 350

Supplies expense 4,320

Additional data related to the first quarter of 2018 for Puckett Company:

a. Capital expenditures include \)41,000 for new manufacturing equipment to be purchased and paid in the first quarter.

b. Cash receipts are 75% of sales in the quarter of the sale and 25% in the quarter following the sale.

c. Direct materials purchases are paid 50% in the quarter purchased and 50% in the next quarter.

d. Direct labor, manufacturing overhead, and selling and administrative costs are paid in the quarter incurred.

e. Income tax expense for the first quarter is projected at \(49,000 and is paid in the quarter incurred.

f. Puckett Company expects to have adequate cash funds and does not anticipate borrowing in the first quarter.

g. The December 31, 2017, balance in Cash is \)25,000, in Accounts Receivable is \(21,600, and in Accounts Payable is \)16,500.

Requirements

1. Prepare Puckett Company’s schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018.

2. Prepare Puckett Company’s cash budget for the first quarter of 2018.

Match the following statements to the appropriate budgeting objective or benefit: developing strategies, planning, directing, controlling, coordinating and communicating, and benchmarking.

1. Managers are required to think about future business activities.

2. Managers use feedback to identify corrective action.

3. Managers use results to evaluate employees’ performance.

4. Managers work with managers in other divisions.
See all solutions

Recommended explanations on Business Studies Textbooks

Nature of Business

Read Explanation

Financial Performance

Read Explanation

Corporate Finance

Read Explanation

Influences On Business

Read Explanation

Managerial Economics

Read Explanation

Intermediate Accounting

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