Prepare a cash budget for January and February

Assignment Help Accounting Basics
Reference no: EM133124447

Question - Sunland Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows.


January

February

Sales

$338,400

$376,000

Direct materials purchases

112,800

117,500

Direct labor

84,600

94,000

Manufacturing overhead

65,800

70,500

Selling and administrative expenses

74,260

79,900

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 $940 of depreciation per month.

Other data:

1. Credit sales: November 2021, $235,000; December 2021, $300,800.

2. Purchases of direct materials: December 2021, $94,000.

3. Other receipts: January-Collection of December 31, 2021, notes receivable $14,100; February-Proceeds from sale of securities $5,640.

4. Other disbursements: February-Payment of $5,640 cash dividend.

The company's cash balance on January 1, 2022, is expected to be $56,400. The company wants to maintain a minimum cash balance of $47,000.

Required -

1. Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases for January and February.

2. Prepare a cash budget for January and February in columnar form.

Reference no: EM133124447

Questions Cloud

Record Cullumber entries related to the note on July : Cullumber Financial Services loaned Sharp Inc. $120,000 cash in exchange for a one-year, Record Cullumber entries related to the note on July
Explain why you streaked both cultures : Describe the process by which the vio gene was transferred from the donor to the recipient - Explain why you streaked both cultures
Basic molecular biology of bacteria : Basic Molecular Biology of Bacteria - Mechanisms of Gene Transfer - Prepare a suspension by obtaining a fresh, pure culture of the organism and inoculating
Cobalt mining marginal environmental damage curve : As more cobalt is used globally, mining operations open in areas that are exponentially more environmentally sensitive. What does this tell you about the slope
Prepare a cash budget for January and February : The company's cash balance on January 1, 2022, is expected to be $56,400. Prepare a cash budget for January and February in columnar form
Inclusions of feather bedding provisions : Explain how bargaining over the inclusions of feather bedding provisions in a union contract can result in more efficient contracts than bargaining over wages a
How many units each month must be produced to break even : A concrete product manufacturer produces CHBs at a material cost of 1.50 each, at a labor cost of 1.0 each, and a variable cost of 2.35 each. The CHBs are sold
Examine the plates exposed to the airborne : Examine the plates exposed to the airborne and external body surfaces bacteria. Count the number of colonies formed by the different microorganisms
Creating the software cost : Shaughnessy Consulting, LLC currently enjoys a patent on software that estimates economic damages for clients involved in personal injury lawsuits. Demand for m

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd