Concept explainers
Jason Allen is one of Texas's premiere party planners. She purchases a variety of supplies, such as plastic tableware, stemware, and decorations, throughout the year. Jason has prepared the following purchases budget for the coming year:
1st Quarter
|
2nd Quarter
|
3rd Quarter
|
4th Quarter
|
||||||
---|---|---|---|---|---|---|---|---|---|
Budgeted purchases
|
$400,000 | $500,000 | $515,000 | $595,000 |
Historically, Jason 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 Jason had a $250,000 accounts payable balance.
Prepare Jason's
1st Quarter
|
2nd Quarter
|
3rd Quarter
|
4th Quarter
|
Annual
|
|||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A/P from last year
|
$enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $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 |
The management requires to prepare a cash budget to analyze cash receipts and expenses going to be incurred in the future which helps in identifying the requirement of cash whether the cash balance will be sufficient or not indicating finance requirement.
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 2 images
- At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: \table[[Cash balance, September 1 (from a summer job), $8, 430 At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: \table[[Cash balance, September 1 (from a summer job), $8,430arrow_forwardRobert Williams is one of Texas's premiere party planners. She purchases a variety of supplies, such as plastic tableware, stemware, and decorations, throughout the year. Robert has prepared the following purchases budget for the coming year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted purchases $360,000 $500,000 $515,000 $595,000 Historically, Robert 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 Robert had a $250,000 accounts payable balance.Prepare Robert'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 $enter a dollar amount $enter a dollar amount $enter a dollar amount $enter a dollar amount $enter a dollar amount…arrow_forwardDhapaarrow_forward
- Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: April $ 430,000 Мay $ 630,000 June Total Budgeted sales (all on account) $ 200,000 $ 1,260,000 From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $360,000, and March sales totaled $390,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month and in total, for the…arrow_forwardScholar Suppliers manufactures backpacks for students. The backpacks come in two sizes: Small, and Large. Scholar Suppliers anticipates the following sales volumes and prices for the coming period: Size Sales Volume Selling Price Small 3,000 backpacks $25 each Large 6,000 backpacks $75 each What is the budgeted level of revenue for the coming period?arrow_forwardKaja Kallas produces luxury collection of dolls. She is preparing her budget for the coming year. The budgeted selling price for each doll is $30 and the budgeted materials cost for each doll is 50% of selling price while the budgeted labour cost is 20% of selling price. Each doll is expected to incur direct expenses of $1 on top of the budgeted materials and labour costs. Equipment depreciation is budgeted to be $9,000 per annum and Ms. Kallas budgeted administration expenses are $1,200 per month. Demand in September is budgeted to be 10,000 dolls with demand rising to 10,500 dolls in October and 11,025 in November. What is Ms. Kallas budgeted gross profit for November? $86,250 $87,450 $88,200 $99,225arrow_forward
- Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: May April $ 490,000 $ 690,000 June $ 220,000 Total $1,400,000 Budgeted sales (all on account) From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are. negligible and can be ignored. February sales totaled $420,000, and March sales totaled $450,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?arrow_forwardPerfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. Please provide me with the answers for the cells in yellow. greatly appreciate your help!arrow_forwardMichael 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…arrow_forward
- sarrow_forwardSilver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 20% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $430,000, and March sales totaled $460,000. April May June $ 500,000 $ 700,000 $ 240,000 Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. February sales March sales April sales May sales June sales Total cash collections Required 1 Required 2 Prepare a schedule of expected…arrow_forwardSilver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) April $300,000 May $500,000 June $200,000 Total $1,000,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month and in total, for the second…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education