The Warrenburg Antique Mall expects to make purchases of direct material in the first quarter of 2024 as shown. Purchases in December 2023 are expected to be $92,000. The company expects that 60 percent of a month's purchases will be paid in the month of purchase and 40 percent will be paid in the following month. Estimate cash disbursements related to purchases for each month of the first quarter of 2024. Budgeted purchases Payment on material purchased prior month Payment on material purchased this month Total cash payment A: D: G: B: E: H: 2023 Dec. $92,000 Answer Jan. $95,000 A D G C: F: 1: 2024 Feb. $120,000 B E H Mar. $85,000 C F

The Warrenburg Antique Mall expects to make purchases of direct material in the first quarter of 2024 as shown. Purchases in December 2023 are expected to be $92,000. The company expects that 60 percent of a month's purchases will be paid in the month of purchase and 40 percent will be paid in the following month. Estimate cash disbursements related to purchases for each month of the first quarter of 2024. Budgeted purchases Payment on material purchased prior month Payment on material purchased this month Total cash payment A: D: G: B: E: H: 2023 Dec. $92,000 Answer Jan. $95,000 A D G C: F: 1: 2024 Feb. $120,000 B E H Mar. $85,000 C F

Fundamentals Of Financial Management, Concise Edition (mindtap Course List)

10th Edition

ISBN:9781337902571

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter15: Working Capital Management

Section: Chapter Questions

Problem 10P: CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of...

See similar textbooks

Related questions

Q: pls give ur work in excell w formula

A: The calculation of operating income and earning before interest and tax is done by considering the…

Q: Define and expain

A: Detailed Explanation of Nursing1. Patient Care:Direct Care: Nurses provide hands-on care to…

Q: Concord Corporation's charter authorized issuance of 96,000 shares of $10 par value common stock and…

A: The company issues either common shares or preferred shares. When the company issues these shares…

Q: the customer per small p the customer per large p= s Stork Enterprises have f gnize this tax…

A: A. Total tax charged to the customer per small package = 6% x $45 = $2.70Overall charge per small…

Q: need part d, e, f answered

A: Income tax expense for the year is calculated by adjusting deferred tax liability and deferred tax…

Q: anuty What general internal control v

A: Given case is: All-Around Sound Co. discovered a fraud whereby one of its front office…

Q: Define Volcker rule

A: Volcker Rule is a regulation that implies restrictions on the banks to involve in the stock market…

Q: What the agi

A: AGI means Adjusted Gross Income. It is the total income on which income tax payable would be…

Q: Need help for part C an D

A: In case of realisation of assets, outsider liabilities have first right on such realisation , such…

Q: Define unicorn

A: The term Unicorn in finance was popularized by Aileen Lee, a popular venture capitalist &…

Q: 1. Why is there a cost associated with retained earnings? 2. What is Coleman's estimated cost of…

A: Given: The firm tax rate is 25% The current price of coleman’s is 12% The current price of firm is…

Q: Duing July Year 6 W Mandrake. Bought further goods on credit for $ 700 Paid payable $ 400 by cheque…

A: Statement of financial means the balance sheet where all the real and personal account are show.…

Q: I, J, K

A: i. Payment of interest would include an outflow of cash and also an increase in interest expense.

Q: w to calculate WAC

A: The weighted average cost of capital, commonly regarded as the WACC is the total cost of all the…

Q: Selected Stock Transactions The following selected accounts appear in the ledger of Parks…

A: The cash dividend is part of the corporation's current earnings or accumulated profits which is…

Q: Calculate the ROA, ROE, NOPAT , EVA

A: a. ROATo calculate the ROA we will use the following formula,therefore the ROA will be,b. ROETo…

Concept explainers

Master Budget

A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.

Sales Budget and Selling

A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.

Question

The Warrenburg Antique Mall expects to make purchases of direct material in the first quarter of
2024 as shown. Purchases in December 2023 are expected to be $92,000. The company expects
that 60 percent of a month's purchases will be paid in the month of purchase and 40 percent will
be paid in the following month. Estimate cash disbursements related to purchases for each month
of the first quarter of 2024.
Budgeted purchases
Payment on material purchased prior month
Payment on material purchased this month
Total cash payment
A:
D:
G:
B:
E:
H:
2023
Dec.
$92,000
Answer
Jan.
$95,000
A
D
G
C:
F:
2024
Feb.
$120,000
B
E
H
Mar.
$85,000
с
F
I

Expert Solution

This question has been solved!

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

SEE SOLUTION Check out a sample Q&A here

Step 1: Define cash payments:

VIEW

Step 2: Compute cash payments:

VIEW

Solution

VIEW

Step by step

Solved in 3 steps with 2 images

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

Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
Cash budget Pasadena Candle Inc. pays 40% of its purchases on account in the month of the purchase and 60% in the month following the purchase. If purchases are budgeted to be 40,000 for August and 36,000 for September, what are the budgeted cash payments for purchases on account for September?
Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
From the following information, prepare a monthly cash budget for the three months ending 31st December 2023. Month June July August September October November December Materials Wages 1,800 650 2,000 750 2,400 750 2,250 750 2.300 800 2,500 2,600 900 1,000 The credit terms are as follows: 10% of sales are in cash. 3 months to debtors. 2 months from Creditors. Sales 3,000 3,250 3,500 3,750 4,000 4,250 4,500 The lag in payment for wages is 1/4 month and 1/2 month for overheads. The cash and bank balance on 1st October is expected to be RO 1,500. Other information is given as follows: Admin. Selling, etc 160 160 175 175 200 200 225 Production 225 225 250 300 300 350 350 Preference share dividends @ 5% on RO 50,000 are to be paid on 1st December. Calls on 250 equity shares @RO 2 per share are expected on 1st November. Dividends from investments amounting to RO 250 are expected on 31st December. Income tax (advance) is to be paid in December RO 1,500 Plant and machinery are to be installed…
In May 2022, the budget committee of Concord Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. 2. 3. 4. (a) Expected sales: June $430,000, July $516,000. Cost of goods sold is expected to be 75% of sales. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sold. The beginning inventory at June 1 will be the desired amount. Your answer is correct. Compute the budgeted merchandise purchases for June. (b) Budgeted Cost of Goods Sold Add V Total Less V CONCORD STORES Merchandise Purchases Budget For the Month Ending June 30, 2022 Desired Ending Merchandise Inventory Beginning Merchandise Inventory Required Merchandise Purchases eTextbook and Media V CONCORD STORES Budgeted Income Statement (Partial) $ Prepare the budgeted multiple-step income statement for June through gross profit. $ $ 322500 116100 438600 (96750) 341850 Attempts: 2 of 3 used
In May 2022, the budget committee of Concord Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. 2. 3. 4. (a) Expected sales: June $430,000, July $516,000. Cost of goods sold is expected to be 75% of sales. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sold. The beginning inventory at June 1 will be the desired amount. Compute the budgeted merchandise purchases for June. CONCORD STORES Merchandise Purchases Budget $ $
Whispering Winds Landscaping Company is preparing its budget for the first quarter of 2022. The next step in the budgeting process is to prepare cash receipts and cash payments schedules. To that end the following information has been collected.Clients usually pay 60% of their fee in the month that service is provided, 30% the month after, and 10% the second month after receiving service.Actual service revenue for 2021 and expected service revenues for 2022 are: November 2021, $130,000; December 2021, $100,000; January 2022, $144,000; February 2022, $161,000; March 2022, $170,000.Purchases of landscaping supplies are paid 30% in the month of purchase and 70% the following month. Actual purchases for 2021 and expected purchases for 2022 are: December 2021, $21,000; January 2022, $19,600; February 2022, $22,400; March 2022, $27,500. Determine the account receivable balances at March 31, 2022.
Use the information given from Arlon Manufacturers to prepare the Cash Budget for each of the first three months of operations (i.e. January, February, and March 2024). Use separate monetary columns for each month.
What is the budgeted cash receipts value from customers during the year?
Waterway Company prepares monthly cash budgets. Relevant data from operating budgets for 2027 are as follows. January February Sales $460,800 $512,000 Direct materials purchases 153,600 160,000 Direct labor 115,200 128,000 Manufacturing overhead 89,600 96,000 Selling and administrative expenses 101,120 108,800 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses, which include $1,280 of depreciation per month. Other data: 1. Credit sales: November 2026, $320,000; December 2026, $409,600. 2. Purchases of direct materials: December 2026, $128,000. 3. Other receipts: January-Collection of December 31, 2026, notes…
Sunland Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected.Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service.Actual service revenue for 2019 and expected service revenues for 2020 are November 2019, $93,620; December 2019, $83,630; January 2020, $102,120; February 2020, $123,950; and March 2020, $133,630.Purchases of landscaping supplies (direct materials) are paid 60% in the month of purchase and 40% the following month. Actual purchases for 2019 and expected purchases for 2020 are December 2019, $16,410; January 2020, $13,540; February 2020, $18,970; and March 2020, $23,150.(a)Prepare the following schedules for each month in the first quarter of 2020 and for the quarter in total:(1) Expected collections…
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows. Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses Other data: 1. 2. 3. January February $360,000 $400,000 125,000 100,000 4. 120,000 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses that include $1,000 of depreciation per month. 90,000 70,000 79,000 75,000 85,000 Credit sales: November 2021, $250,000; December 2021, $320,000. Purchases of direct materials: December 2021, $100,000. Other receipts: January-Collection of December 31, 2021, notes…