Preparing a financial budget—schedule of cash receipts

Victors expects total sales of \(702,000 for January and \)349,000 for February. Assume that Victor'ssales are collected as follows:

50% in the month of the sale

30% in the month after the sale

16% two months after the sale

4% never collected

November sales totaled \(388,000, and December sales were \)407,000. Prepare a schedule of cash receipts from customers for January and February. Round answers to the nearest dollar.

Short Answer

Expert verified

Answer

Total cash receipts from the customers is $535,180 in the month of January and $450,220 in the month of February.

Step by step solution

01

Meaning of schedule of cash receipts

The structure and table formed for measuring the cash balances in the form of gained.

02

Preparation of schedule of cash receipts

Particulars

January

February

Total budgeted sales

$702,000

$349,000

Cash receipts from customers:



50 % in the month of sale

$351,000

$174,500

30% in the month after sale

$407,000*30% =$122,100

$702,000*30% =$210,600

16% two months after sales

$388,000*16% =$62,080

$407,000*16% =$65,120

Total cash receipts from customers

$535,180

$450,220

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.

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 a financial budget—schedule of cash payments

Jefferson Company has budgeted purchases of merchandise inventory of \(457,500 in January and \)533,250 in February. Assume Jefferson pays for inventory purchases 70% in the month of purchase and 30% in the month after purchase. The Accounts Payable balance on December 31 is $98,275. Prepare a schedule of cash payments for purchases for January and February.

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.

How is benchmarking beneficial?

Connor Company began operations on January 1 and has projected the following selling and administrative expenses:

Rent Expense $ 1,000 per month, paid as incurred

Utilities Expense 500 per month, paid in month after incurred

Depreciation Expense 300 per month

Insurance Expense 100 per month, 6 months prepaid on January 1

Determine the cash payments for selling and administrative expenses for the first three months of operations.

See all solutions

Recommended explanations on Business Studies Textbooks

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