prepare the cash collections budget for Batter Up

Assignment Help Accounting Basics
Reference no: EM131824813

Problem - Per historical data, 75% of the Batter Up's credit sales are collected in the month following the sale, 12% are collected 2 months after the sale, 7% are collected three months after the sale and 6% are never collected.

Projected sales for the 4th quarter (October through December) of 2010 are comprised of the following:

Batter UpProjected Sales BudgetFor the Quarter Ended December 31
         
  Month 4th
Quarter
  October November December
Type of Sale        
Cash sales (15%)  $102,000  $109,500  $112,500  $324,000
Credit sales (85%)        578,000        620,500        637,500     1,836,000
Total sales revenue  $680,000  $730,000  $750,000  $2,160,000

The total cost of direct materials purchases in December is estimated at $562,000. Batter Up pays 55% of its direct materials purchases in the month of purchase and pays the remaining 45% in the month after purchase.

Additional estimated ending balance information for December 31 is as follows:

Account

December 31
Balance

Cash

$450,000

Allowance for uncollectible accounts

($765)

Property, plant and equipment

$3,343,200

Accumulated depreciation

$1,565,060

Common stock and retained earnings

$2,765,300

Employees are paid twice a month for the work they peform during the month; therefore, the direct labor cost of each month is paid in the current month.

Manufacturing overhead costs are paid in the month in which they are incurred with the exception of depreciation on the plant and equipment and insurance and property taxes on the plant.

Depreciation on the plant and equipment is a non-cash expense.

Insurance and property taxes on the plant are paid on a semiannual basis, in January and July, rather than on a monthly basis as reflected in the budget.

Operating expenses are paid in the month in which they are incurred with the exception of depreciation on the office equipment and bad debt expense related to credit sales.

Depreciation on the office equipment and bad debt expense are both non-cash expenses.

Batter Up has no budgeted capital expenditures.

Income taxes are paid on a quarterly basis and since Batter Up has a December 31 fiscal year end, the first income tax payment is not required until April 15.

Dividends are paid on a quarterly basis to its shareholders. Batter Up plans to pay $25,000 in cash dividends in January for the company's earnings in the fourth quarter of the previous year.

Because of the success of Batter Up, financing has not been required.

Required -

1. Prepare the 2011 cash collections budget for the 1st quarter for Batter Up.

2. Prepare the 2011 cash payments budget for the 1st quarter for Batter Up.

3. Prepare the 2011 combined cash budget for the 1st quarter for Batter Up.

Reference no: EM131824813

Questions Cloud

What are the limitations of confidentiality : Describe how to help system (family) members to identify and interrupt harmful interaction patterns and practice healthy interaction patterns.
Problem regarding the mammal life spans : Mammal life spans. Data were collected on life spans (in years) and gestation lengths (in days) for 62 mammals.
Create a change model to implement your change vision : Create a change model to implement your change vision. Identify the specific steps needed to implement a change and effectively respond to the pressure.
Determining the office productivity : Office productivity. Office productivity is relatively low when the employees feel no stress about their work or job security.
prepare the cash collections budget for Batter Up : The total cost of direct materials purchases in December is estimated at $562,000. Prepare the 2011 cash collections budget for the 1st quarter for Batter Up
Determining the reproducing bacteria : Suppose that there is only sufficient space and nutrients to support one million bacterial cells in a petri dish.
Which of the given drugs is more likely to be important : Where will profits be higher: when demand for a patented drug is highly inelastic or when demand for a patented drug is highly elastic?
Represents the claimed population mean : Identify which value represents the sample mean and which value represents the claimed population mean.
Discuss the possible changes to current criminal procedure : In your opinion, discuss at least two (2) possible changes to current criminal procedure that you can foresee in the second half of the 21st century.

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