Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Use the following information to prepare the September cash budget for PTO Manufacturing Co. The following information relates to expected cash receipts and cash payments for the month ended September 30.

a. Beginning cash balance, September 1, \(40,000.

b. Budgeted cash receipts from sales in September, \)255,000.

c. Raw materials are purchased on account. Purchase amounts are: August (actual), \(80,000; and September (budgeted), \)110,000. Payments for direct materials are made as follows: 65% in the month of purchase and 35% in the month following purchase.

d. Budgeted cash payments for direct labor in September, \(40,000.

e. Budgeted depreciation expense for September, \)4,000.

f. Other cash expenses budgeted for September, \(60,000.

g. Accrued income taxes payable in September, \)10,000.

h. Bank loan interest payable in September, $1,000.

Short Answer

Expert verified

The ending cash balance at the end of September will be $95,500.

Step by step solution

01

Introduction

Depreciation expense is the type of expenditure that is levied on the fixed assets that decreases its value overtime.

02

Cash budget

PTO Manufacturing Co

Cash budget

For the month of September

Particulars

Amount

Beginning cash balance

$40,000

Add: Cash receipts from sales

$255,000

Total cash available

$295,000

Less: Cash payments

Direct materials

$99,500

Direct labor

$40,000

Other expense

$60,000

Accrued income tax

$0

Interest on bank loan

$0

Total cash payments

$199,500

Ending cash balance

$95,500

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

For each of the following items 1 through 6, indicate yes if it describes a potential benefit of budgeting or no if it describes a potential negative outcome of budgeting.

2. Budgets are useful in assigning blame for unexpected results.

Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow:

Budgeted July August September

Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . \(64,000 \)80,000 \(48,000

Cash payments for merchandise . . . . . . . . . . . . . 40,400 33,600 34,400

Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of \)15,000 in cash; \(45,000 in accounts receivable; \)4,500 in accounts payable; and a \(5,000 balance in loans payable. A minimum cash balance of \)15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries (\(4,000 per month), and rent (\)6,500 per month). (1) Prepare a cash receipts budget for July, August, and September. (2) Prepare a cash budget for each of the months of July, August, and September. (Round all dollar amounts to the nearest whole dollar.)

  • Tyler Co. predicts the following unit sales for the next four months: April, 3,000 units; May, 4,000 units; June, 6,000 units; and July, 2,000 units. The companyโ€™s policy is to maintain finished goods inventory equal to 30% of the next monthโ€™s sales. At the end of March, the company had 900 finished units on hand. Prepare a production budget for each of the months of April, May, and June.

Coca-Cola recently redesigned its bottle to reduce its use of glass, thus lowering its bottleโ€™s weight and CO2 emissions. Which budgets in the companyโ€™s master budget will this redesign impact?

Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 90,000 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 450,000 units; third quarter, 525,000 units; and fourth quarter, 475,000 units. Company policy calls for the ending finished goods inventory of a quarter to equal 20% of the next quarterโ€™s budgeted sales. Prepare a production budget for both the second and third quarters that shows the number of transmissions to manufacture.

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