Homework Help is Here – Start Your Trial Now!
Business
Accounting
Passing Through Inc. is a merchandising company that buys goods for resale. Passing Through Inc. is preparing a cash oudget for the month of March 2021 and has collected the following estimated data: NOTE: If some of the boxes below have IVALUE in them it means you haven't entered your student number on the Cover tab. 1 Estimated monthly sales in units: January February 1,300 1,400 March Аpril May 1,500 1,350 1,550 2 Average selling price is estimated to be 15.30 per unit. All sales are credit sales. Estimated collection pattern for credit sales is 30% in the month of sale, 50% in the month after sale and 20% two months after 3 the sale. 4 The company would like to have ending inventory each month equal to 20% of next months sales. 5 Cost of purchases are estimated to be 7.60 per unit and are paid in the month of purchase. 6. Estimated variable operating expenses are 10% of the sales dollar value for that month and they are paid in the month incurred. Estimated annual fixed expenses are presented below. All the expenses are incurred uniformly throughout the year except insurance expenses which are paid in 4 quarterly instalments (March, June, September and December). Annual Fixed Operating Expenses Advertising Depreciation 12,288.00 13,728.00 13,400.00 12,150.00 14,400.00 Insurance Property Taxes Sales and Admin Salaries Required: Prepare Passing Through Inc.'s cash budget for March 2021. Assume an opening cash balance of: To help you organize this, you will need to: a) Determine the sales budgeted for the first quarter and the amount of cash collected in March. b) Determine the merchandise purchase requirements for March. c) Determine the total cash disbursements for March (purchases, variable operating expenses and fixed operating expenses). d) Prepare the cash budget in good form (only 4 lines are required - opening cash balance plus receipts minus disbursements equals ending cash balance). 22,400.00

Passing Through Inc. is a merchandising company that buys goods for resale. Passing Through Inc. is preparing a cash oudget for the month of March 2021 and has collected the following estimated data: NOTE: If some of the boxes below have IVALUE in them it means you haven't entered your student number on the Cover tab. 1 Estimated monthly sales in units: January February 1,300 1,400 March Аpril May 1,500 1,350 1,550 2 Average selling price is estimated to be 15.30 per unit. All sales are credit sales. Estimated collection pattern for credit sales is 30% in the month of sale, 50% in the month after sale and 20% two months after 3 the sale. 4 The company would like to have ending inventory each month equal to 20% of next months sales. 5 Cost of purchases are estimated to be 7.60 per unit and are paid in the month of purchase. 6. Estimated variable operating expenses are 10% of the sales dollar value for that month and they are paid in the month incurred. Estimated annual fixed expenses are presented below. All the expenses are incurred uniformly throughout the year except insurance expenses which are paid in 4 quarterly instalments (March, June, September and December). Annual Fixed Operating Expenses Advertising Depreciation 12,288.00 13,728.00 13,400.00 12,150.00 14,400.00 Insurance Property Taxes Sales and Admin Salaries Required: Prepare Passing Through Inc.'s cash budget for March 2021. Assume an opening cash balance of: To help you organize this, you will need to: a) Determine the sales budgeted for the first quarter and the amount of cash collected in March. b) Determine the merchandise purchase requirements for March. c) Determine the total cash disbursements for March (purchases, variable operating expenses and fixed operating expenses). d) Prepare the cash budget in good form (only 4 lines are required - opening cash balance plus receipts minus disbursements equals ending cash balance). 22,400.00

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

Looking for the answers. Thanks in advance!

Passing Through Inc. is a merchandising company that buys goods for resale. Passing Through Inc. is preparing a cash budget for the month of March 2021 and has collected the following estimated data: NOTE: If some of the boxes below have #VALUE in them it means you haven't entered your student number on the Cover tab. 1 Estimated monthly sales in units: January 1,300 February 1,400 March 1,500 April 1,350 May 1,550 2 Average selling price is estimated to be 15.30 per unit. All sales are credit sales. Estimated collection pattern for credit sales is 30% in the month of sale, 50% in the month after sale and 20% two months after 3 the sale. 4 The company would like to have ending inventory each month equal to 20% of next months sales. 5 Cost of purchases are estimated to be 7.60 per unit and are paid in the month of purchase. 6. Estimated variable operating expenses are 10% of the sales dollar value for that month and they are paid in the month incurred. Estimated annual fixed expenses are presented below. All the expenses are incurred uniformly throughout the year except 7 insurance expenses which are paid in 4 quarterly instalments (March, June, September and December). Annual Fixed Operating Expenses Advertising 12,288.00 Depreciation 13,728.00 13,400.00 Insurance Property Taxes 12,150.00 Sales and Admin Salaries 14,400.00 Required: Prepare Passing Through Inc.'s cash budget for March 2021. Assume an opening cash balance of: To help you organize this, you will need to: 22,400.00 a) Determine the sales budgeted for the first quarter and the amount of cash collected in March. b) Determine the merchandise purchase requirements for March. c) Determine the total cash disbursements for March (purchases, variable operating expenses and fixed operating expenses). d) Prepare the cash budget in good form (only 4 lines are required - opening cash balance plus receipts minus disbursements equals ending cash balance).
Transcribed Image Text:Passing Through Inc. is a merchandising company that buys goods for resale. Passing Through Inc. is preparing a cash budget for the month of March 2021 and has collected the following estimated data: NOTE: If some of the boxes below have #VALUE in them it means you haven't entered your student number on the Cover tab. 1 Estimated monthly sales in units: January 1,300 February 1,400 March 1,500 April 1,350 May 1,550 2 Average selling price is estimated to be 15.30 per unit. All sales are credit sales. Estimated collection pattern for credit sales is 30% in the month of sale, 50% in the month after sale and 20% two months after 3 the sale. 4 The company would like to have ending inventory each month equal to 20% of next months sales. 5 Cost of purchases are estimated to be 7.60 per unit and are paid in the month of purchase. 6. Estimated variable operating expenses are 10% of the sales dollar value for that month and they are paid in the month incurred. Estimated annual fixed expenses are presented below. All the expenses are incurred uniformly throughout the year except 7 insurance expenses which are paid in 4 quarterly instalments (March, June, September and December). Annual Fixed Operating Expenses Advertising 12,288.00 Depreciation 13,728.00 13,400.00 Insurance Property Taxes 12,150.00 Sales and Admin Salaries 14,400.00 Required: Prepare Passing Through Inc.'s cash budget for March 2021. Assume an opening cash balance of: To help you organize this, you will need to: 22,400.00 a) Determine the sales budgeted for the first quarter and the amount of cash collected in March. b) Determine the merchandise purchase requirements for March. c) Determine the total cash disbursements for March (purchases, variable operating expenses and fixed operating expenses). d) Prepare the cash budget in good form (only 4 lines are required - opening cash balance plus receipts minus disbursements equals ending cash balance).
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Money Management and Achieving Financial Goals
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS