/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q16SE Preparing a financial budget鈥攕... [FREE SOLUTION] | 91影视

91影视

Log out

Learning Materials

Features

Discover

Chapter 22: Q16SE (page 1231)

Preparing a financial budget鈥攕chedule 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.

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 schedule of cash receipts is prepared to record the cash received from the customers.

02

Preparation of schedule of cash receipts

Particulars

January

February

Total budgeted merchandise inventory

$457,500

$533,250

Cash payments:



70 % in the month of purchase

$320,250

$373,375

30% in the month after purchase

$98,275

$457,500*30% =$137,250

Total cash payments

$418,525

$510,625

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 91影视!

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

Preparing a financial budget鈥攕chedule of cash receipts

Berry expects total sales of \(359,000 in January and \)405,000 in February. Assume that Berry鈥檚 sales are collected as follows:

80% in the month of the sale

10% in the month after the sale

6% two months after the sales

4% never collected

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

Completing a comprehensive budgeting problem鈥攎erchandising 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鈥檚 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.

Preparing a financial budget鈥攕chedule 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?

Preparing an operating budget鈥攄irect 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鈥檚 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鈥檚 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.

Understanding the components of the master budgetThe following are some of the components included in the master budget of amerchandising company.

a. Budgeted balance sheet

b. Sales budget

c. Capital expenditures budget

d. Budgeted income statement

e. Cash budget

f. Inventory, purchases, and cost of goods sold budget

g. Selling and administrative expense budget

List the items of the master budget in order of preparation.
See all solutions

Recommended explanations on Business Studies Textbooks

Insurance

Read Explanation

Operational Management

Read Explanation

Accounting

Read Explanation

Introduction to Business

Read Explanation

Change Management

Read Explanation

Business Data Analytics

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.