Financial and Managerial Accounting
Financial and Managerial Accounting
7th Edition
ISBN: 9781259726705
Author: John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher: McGraw-Hill Education
bartleby

Concept explainers

Question
Book Icon
Chapter 20, Problem 29E

(1)

To determine

To prepare: Merchandise purchase budget for July, August, September, October.

(1)

Expert Solution
Check Mark

Explanation of Solution

Merchandise Purchase Budget
Particulars June Amount ($) July Amount ($) August Amount ($) September Amount ($) October Amount ($)
Budgeted sales 350,000 290,000 320,000 275,000 265,000
Next month’s cost of goods sold (Working note 1) 245,000 203,000 224,000 192,500 185,500
Ending inventory (Working note 2) 49,000 40,600 44,800 38,500 37,100
Add: Cost of goods sold 245,000 203,000 224,000 192,500
Required inventory 285,600 247,800 262,500 229,600
Less: Opening inventory 49,000 40,600 44,800 38,500
Inventory to be purchased 236,600 207,200 217,700 191,100
Table (1)

Working note:

Formula to calculate next month’s cost of goods sold,

    Cost of goods sold=Budgeted sales×70%
Next month’s cost of goods sold
Particulars June Amount ($) July Amount ($) August Amount ($) September Amount ($) October Amount ($)
Budgeted sales 350,000 290,000 320,000 275,000 265,000
Cost of goods sold ( Sales×70% ) 245,000 203,000 224,000 192,500 185,500
Table (2)

Working note:

Ending inventory
Particulars June Amount ($) July Amount ($) August Amount ($) September Amount ($) October Amount ($)
Next month’s cost of goods sold 245,000 203,000 224,000 192,500 185,500
Ending inventory ( Next month's  cost of goods  sold×20% ) 49,000 40,600 44,800 38,500 37,100
Table (3)

(2)

To determine

To prepare: Budgeted cash payments on account payables.

(2)

Expert Solution
Check Mark

Explanation of Solution

Budgeted Cash Payments on Account payables
Particulars September Amount ($) October Amount ($)
Payment for July purchases 35,490
Payment for August purchases 124,320 31,080
Payment for September purchases 54,425 130,620
Payment for October purchases 47,775
Total 214,225 209,475
Table (4)

(3)

To determine

To prepare: Budgeted accounts payable for September and October.

(3)

Expert Solution
Check Mark

Explanation of Solution

Budgeted cash payments on account payables
Particulars June Amount ($) July Amount ($) August Amount ($) September Amount ($)
Beginning accounts payable 0 177,450 190,890 194,355
Add: Budgeted purchases 236,600 207,200 217,700 191,100
Amount payable after purchases [ A ] 236,600 384,650 408,590 385,455
Cash disbursement
Payment for July purchases 59,1501 41,960 35,490
Payment for August purchases 51,800 124,380 31,080
Payment for September purchases 54,425 130,620
Payment for October purchases 47,725
Total Cash payments [ B ] 59,150 193,760 214,235 209,475
Ending accounts payable [ AB ] 177,450 190,890 194,355 175,980
Table (5)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 20 Solutions

Financial and Managerial Accounting

Ch. 20 - How does budgeting help management coordinate and...Ch. 20 - Why is the sales budget so important to the...Ch. 20 - What is the selling expense budget? What is the...Ch. 20 - Prob. 9DQCh. 20 - GOOGLE Google prepares a cash budget. What is a...Ch. 20 - Prob. 11DQCh. 20 - Prob. 12DQCh. 20 - Prob. 13DQCh. 20 - Prob. 14DQCh. 20 - Coca-cola recently redesigned its bottle to reduce...Ch. 20 - Budget motivation C1 For each of the following...Ch. 20 - Budgeting benefits C1 For each of the following...Ch. 20 - Prob. 3QSCh. 20 - Prob. 4QSCh. 20 - Prob. 5QSCh. 20 - Prob. 6QSCh. 20 - Prob. 7QSCh. 20 - Prob. 8QSCh. 20 - Prob. 9QSCh. 20 - Prob. 10QSCh. 20 - Prob. 11QSCh. 20 - Prob. 12QSCh. 20 - Prob. 13QSCh. 20 - Prob. 14QSCh. 20 - Prob. 15QSCh. 20 - Manufacturing: Production budget P1 Atlantic Surf...Ch. 20 - Prob. 17QSCh. 20 - Prob. 18QSCh. 20 - Prob. 19QSCh. 20 - Cash receipts, with uncollectible accounts P2 The...Ch. 20 - Cash receipts, with uncollectible accounts P2 Well...Ch. 20 - Prob. 22QSCh. 20 - Budgeted loan activity P2 Santos Co. is preparing...Ch. 20 - Prob. 24QSCh. 20 - Prob. 25QSCh. 20 - Prob. 26QSCh. 20 - Prob. 27QSCh. 20 - Prob. 28QSCh. 20 - Prob. 29QSCh. 20 - Prob. 30QSCh. 20 - Prob. 31QSCh. 20 - Prob. 32QSCh. 20 - Prob. 33QSCh. 20 - Prob. 1ECh. 20 - Prob. 2ECh. 20 - Prob. 3ECh. 20 - Prob. 4ECh. 20 - Exercise 20-5 Manufacturing: Direct labor budget...Ch. 20 - Prob. 6ECh. 20 - Prob. 7ECh. 20 - Prob. 8ECh. 20 - Prob. 9ECh. 20 - Prob. 10ECh. 20 - Prob. 11ECh. 20 - Prob. 12ECh. 20 - Prob. 13ECh. 20 - Prob. 14ECh. 20 - Prob. 15ECh. 20 - Prob. 16ECh. 20 - Prob. 17ECh. 20 - Prob. 18ECh. 20 - Prob. 19ECh. 20 - Prob. 20ECh. 20 - Prob. 21ECh. 20 - Prob. 22ECh. 20 - Prob. 23ECh. 20 - Prob. 24ECh. 20 - Prob. 25ECh. 20 - Prob. 26ECh. 20 - Prob. 27ECh. 20 - Prob. 28ECh. 20 - Prob. 29ECh. 20 - Prob. 30ECh. 20 - Prob. 31ECh. 20 - Prob. 32ECh. 20 - Prob. 33ECh. 20 - Prob. 34ECh. 20 - Prob. 35ECh. 20 - Prob. 1PSACh. 20 - Prob. 2PSACh. 20 - Prob. 3PSACh. 20 - Prob. 4PSACh. 20 - Prob. 5PSACh. 20 - Prob. 6PSACh. 20 - Prob. 7PSACh. 20 - Prob. 8PSACh. 20 - Prob. 1PSBCh. 20 - Prob. 2PSBCh. 20 - Prob. 3PSBCh. 20 - Prob. 4PSBCh. 20 - Prob. 5PSBCh. 20 - Prob. 6PSBCh. 20 - Prob. 7PSBCh. 20 - Prob. 8PSBCh. 20 - Prob. 20SPCh. 20 - Prob. 1BTNCh. 20 - Prob. 2BTNCh. 20 - ETHICS CHALLENGE C1 BTN 20-3 Both the budget...Ch. 20 - Prob. 4BTNCh. 20 - Prob. 5BTNCh. 20 - Prob. 6BTNCh. 20 - Prob. 7BTNCh. 20 - Prob. 8BTNCh. 20 - Prob. 9BTN
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education