Cash disbursements schedule Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format given here and the following information in its preparation.Sales: February $493,000; March $517,000; April $539,000; May $627,000; June $660,000; July $651,000Purchases: Purchases are calculated as 65% of the next month's sales, 12% of purchases are made in cash, 55% of purchases are paid for 1 month after purchase, and the remaining 33% of purchases are paid for 2 months after purchase.Rent: The firm pays rent of $8,020 per month.Wages and salaries: Base wage and salary costs are fixed at $5,700 per month plus a variable cost of 7.3% of the current month's sales.Taxes: A tax payment of $54,700 is due in June.Fixed asset outlays: New equipment costing $74,900 will be bought and paid for in April.Interest payments: An interest payment of $30,100 is due in June.Cash dividends: Dividends of $13,000 will be paid in April.Principal repayments and retirements: No principal repayments or retirements are due during these months.Complete the cash disbursements schedule for Maris Brothers, Inc. below: (Round to the nearest dollar.)Schedule of Projected Cash Disbursements for Maris Brothers, Inc.MarAprSalesDisbursementsPurchasesCash1 month delay2 month delayRentWages and salaryFixedVariableTaxesFixed assetsInterestCash dividendsTotalDisbursements$Feb$$$$$$$$$$$$$$$MayJunJulMore infoA Schedule of Projected Cash Disbursements for Maris Brothers, Inc.FebAprMaySales DisbursementsPurchasesCash1 month delay2 month delayRentWages and salaryFixedVariableTaxesFixed assetsInterestCash dividendsTotalDisbursementsMarPrintDoneJunJul- X

The cash disbursement schedule means the budget is prepared for the cash payments related to the…

Cash disbursements schedule Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format given here and the following information in its preparation.

Cash disbursements schedule Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format given here and the following information in its preparation.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Schedule of cash collections of accounts receivable OfficeMart Inc. has "cash and carry" customers…

A: ThevManagement will prepare budget in order to estimate the future profit and loss from the…

Q: Required: Using the preceding data: 1. Complete the schedule of expected cash collections. 2.…

A: Budgeting -Budgeting is the process of estimating future operations based on past performance.…

Q: The controller of Big River Inc. wishes to improve the company's control system by preparing a…

A: Budget means the expected value of future. Budget will be compared with actual value and variance is…

Q: Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for…

A: Budgeting - Budgeting is the process of estimating future operations based on past performance. %…

Q: Toyota & Sons is a family-owned auto-parts store. You are the management accountant of the concern…

A: A cash budget is an estimate of a corporation's cash flows for a given time span. A cash budget is…

Q: Required Information [The following information applies to the questions displayed below.] Beech…

A: Budgets are prepared to show the financial effect that the activities that the company is planning…

Q: The business needs to have a sense of its future cash flows and therefore requires the preparation…

A: Schedule of cash collected from trade receivables refers to the table which displays the flow of…

Q: Kelsey is preparing its master budget. Budgeted sales and cash payments for merchandise purchases…

A: Introduction:The cash budget is created to keep track of all cash receipts and payments made over…

Q: The following information was taken from Splish Brothers Inc. cash budget for the month of June…

A: CASH BUDGET Cash Budget is a detailed budget of cash income and cash expenditure incorporating both…

Q: (Click the icon to view the cash payments schedule.) Carmen Company has prepared the following…

A: A cash budget is an estimate of the business's projected cash inflows and outflows for a given time…

Q: Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur…

A: Companies making sales on account must have a sound collection policy. The company making sales on…

Q: Pelican Merchandising & More is a family-owned store. The business is now approaching theend of…

A: Disclaimer : Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the…

Q: of the is a concern and have been given the task of preparing the cash budget for the business for…

A: Budget is the estimation of revenue and expense prior to start the operation. To manage the working…

Q: Record the entry for the annual budget at the beginning of the year. (General Fund) Record the…

A: The objective of the question is to understand how to record the annual budget at the beginning of…

Q: Assets Cash Minden Company Balance Sheet April 30 Accounts receivable Inventory Buildings and…

A: Budgeting is the process of estimating future operations based on past performance. % are estimated…

Concept explainers

Conversion Cycle

Conversion cycle is also known as cash cycle or net operating cycle. Conversion cycle refers to how much time a company takes to turn its investments which is done from stock or any other financial resources into cash flows from sales.

Question

Cash disbursements schedule Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format given here and the following information in its preparation.
Sales: February $493,000; March $517,000; April $539,000; May $627,000; June $660,000; July $651,000
Purchases: Purchases are calculated as 65% of the next month's sales, 12% of purchases are made in cash, 55% of purchases are paid for 1 month after purchase, and the remaining 33% of purchases are paid for 2 months after purchase.
Rent: The firm pays rent of $8,020 per month.
Wages and salaries: Base wage and salary costs are fixed at $5,700 per month plus a variable cost of 7.3% of the current month's sales.
Taxes: A tax payment of $54,700 is due in June.
Fixed asset outlays: New equipment costing $74,900 will be bought and paid for in April.
Interest payments: An interest payment of $30,100 is due in June.
Cash dividends: Dividends of $13,000 will be paid in April.
Principal repayments and retirements: No principal repayments or retirements are due during these months.
Complete the cash disbursements schedule for Maris Brothers, Inc. below: (Round to the nearest dollar.)
Schedule of Projected Cash Disbursements for Maris Brothers, Inc.
Mar
Apr
Sales
Disbursements
Purchases
Cash
1 month delay
2 month delay
Rent
Wages and salary
Fixed
Variable
Taxes
Fixed assets
Interest
Cash dividends
Total
Disbursements
$
Feb
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
May
Jun
Jul
More info
A Schedule of Projected Cash Disbursements for Maris Brothers, Inc.
Feb
Apr
May
Sales Disbursements
Purchases
Cash
1 month delay
2 month delay
Rent
Wages and salary
Fixed
Variable
Taxes
Fixed assets
Interest
Cash dividends
Total
Disbursements
Mar
Print
Done
Jun
Jul
- X

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Cash disbursement schedule

VIEW

Step 2: Cash Disbursement Schedule for Maris Brothers Inc.

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.

Similar questions

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: a. Sales are budgeted to be $163,000. About 85% of sales is cash; the remainder is on account. b. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. c. Food and supplies purchases, all on account, are expected to be $103,000. La Famiglia pays 25% in the month of purchase and 75% in the month following purchase. d. Most of the work is done by the owners, who typically withdraw $6,000 a month from the business as their salary. (Note: The $6,000 is a payment in total to the two owners, not per person.) Various part-time workers cost $7,300 per month. They are paid for their work weekly, so on average 90% of their wages are paid in the month incurred and the remaining 10% in the next month. e. Utilities average $5,950 per month. Rent on the building is $4,100 per month. f. Insurance is paid…
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income *Includes $28,000 of depreciation each month. April May June $ 600,000 $1,100,000 $ 560,000 420,000 770,000 392,000 180,000 330,000 168,000 111,000 48,000 159,000 105,000 46,000 64,800 44,000 169,800 108,600 90,000 $ 21,000 $ 160,200 $ 59,400 $ 48,000 July $460,000 322,000 138,000 67,000 41,600 b. Sales are 20% for cash and 80% on account. c. Sales on account are collected over a three-month period with 10%…
Pelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending March 31, 2022. (i) Extracts from the sales and purchases budgets are as follows: Month Cash Sales Cash Purchases 2021 - 2022 Sales On Purchases On Account Account November 2021 December 2021 January 2022 February 2022 March 2022 $138,100 $156,500 $170,975 $135,740 $480,000 $345,000 $600,000 $650,000 $700,000 $800,000 $25,800 $44,625 $30,400 $380,000 $400,000 $480,000 $226,420 $55,100 $540,000 (ii) An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 55% in the month of sale 35% in the first month following the sale 8% in the second…
Please provide complete and correct answer for both requirements and show all work like explanation , computation , formula with steps. Answer in text. Million thanks !
K Video Brian's Restaurant Supply is preparing its cash budgets for the first two months of the upcoming year. Here is the information about the company's upcoming cash receipts and cash disbursements: (Click the icon to view the information.) Requirements 1. Prepare schedules of (a) budgeted cash collections, (b) budgeted cash payments for purchases, and (c) budgeted cash payments for operating expenses. Show totals for each month and totals for January and February combined. 2. Prepare a combined cash budget. If no financing activity takes place, what is the budgeted cash balance on February 28? Requirement 1a. Prepare a schedule of budgeted cash collections for January and February. Show totals for each month and totals for January and February combined. Brian's Restaurant Supply Cash Collections Budget For the Months Ended January 31 and February 28 Cash sales Collection on credit sales Total cash collections January More info a. Sales are 60% cash and 40% credit. Credit sales are…
1. Calculate the expected cash collections for July. 2. Calculate the expected cash disbursements for merchandise purchases for July. 3. Prepare a cash budget for July.
The amount of prepaid expense reflected in the disbursement section of the cash budget is the same amount that is found on the monthly operating statement. True False
Tamarisk Garden Center has the following cash budget information available for the month of August: Beginning cash balance Cash receipts from sales and collections on account Collection of note receivable and interest Cash disbursements for operating expenses The company would have to $129,000 eTexthonk and Media 115,000 8,100 If the company has a policy of maintaining an end of the month cash balance of $120,000, determine the amount the company would have to borrow or the amount of excess cash it will have to invest in August. 96,400 SUPPORT
Dear Bartleby, could you please assist with solving the following question concerning cash collections from sales? Also could you please provide the calculations for solving this, thank you. b. Prepare a schedule of cash collections from sales, by month and in total, for the second quarter of 2019. Soprano Co. is in the process of preparing the second quarter budget for 2019, and the following data have been assembled: The company sells a single product at a selling price of $40 per unit. The estimated sales volume for the next six months is as follows: March 6,000 units June 8,000 units April 7,000 units July 9,000 units May 10,000 units August 6,000 units All sales are on account. The company's collection experience has been that 40% of a month's sales are collected in the month of sale, 55% are collected in the month following the sale, and 5% are uncollectible. It is expected that the net realizable value of accounts receivable (i.e., accounts…
Hello - Where does the opening balance of cash come from (how is it derived) in Step 3. Preparing a Cash Budget? (see included picture. THANK YOU!! pz