Michael Jones is one of Texas's premiere party planners. She purchases a variety of supplies, such as plastic tableware, stemware, and decorations, throughout the year. Michael has prepared the following purchases budget for the coming year:     1st Quarter   2nd Quarter   3rd Quarter   4th Quarter   Budgeted purchases   $ 280,000   $ 480,000   $ 495,000   $ 575,000   Historically, Michael has paid for 40% of her purchases in the quarter of purchase and 60% in the quarter following purchase. On December 31 of this year Michael had a $ 250,000 accounts payable balance. Prepare Michael's cash payments budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)       1st Quarter   2nd Quarter   3rd Quarter   4th Quarter   Annual   A/P from last year   $ 250,000   $ enter a dollar amount   0   0   $ enter a dollar amount                           1st quarter purchases   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   2nd quarter purchases   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   3rd quarter purchases   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   4th quarter purchases   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   Total   $ enter a total amount   $ enter a total amount   $ enter a total amount   $ enter a total amount   $ enter a total amount Calculate the accounts payable balance at the end of 4th Quarter. Accounts Payable balance at the end of 4th Quarter   $ enter the accounts payable balance at the end of 4th quarter in dollars

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter9: Profit Planning And Flexible Budgets
Section: Chapter Questions
Problem 50E: Use the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces...
icon
Related questions
Question

Michael Jones is one of Texas's premiere party planners. She purchases a variety of supplies, such as plastic tableware, stemware, and decorations, throughout the year. Michael has prepared the following purchases budget for the coming year:

   
1st Quarter
 
2nd Quarter
 
3rd Quarter
 
4th Quarter
 
Budgeted purchases
  $ 280,000   $ 480,000   $ 495,000   $ 575,000  


Historically, Michael has paid for 40% of her purchases in the quarter of purchase and 60% in the quarter following purchase. On December 31 of this year Michael had a $ 250,000 accounts payable balance.

Prepare Michael's cash payments budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)

     
1st Quarter
 
2nd Quarter
 
3rd Quarter
 
4th Quarter
 
Annual
 
A/P from last year
  $ 250,000   $ enter a dollar amount   0   0   $ enter a dollar amount
                       
 
1st quarter purchases
  enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount
 
2nd quarter purchases
  enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount
 
3rd quarter purchases
  enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount
 
4th quarter purchases
  enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount   enter a dollar amount
 
Total
  $ enter a total amount   $ enter a total amount   $ enter a total amount   $ enter a total amount   $ enter a total amount


Calculate the accounts payable balance at the end of 4th Quarter.

Accounts Payable balance at the end of 4th Quarter   $ enter the accounts payable balance at the end of 4th quarter in dollars
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning