Calculate the budgeted cash collection for March

Assignment Help Managerial Accounting
Reference no: EM132792241

Question - Charlie Co. has planned the following sales and purchases for the next three months:

 

January

February

March

Budgeted Sales

$40,000

$50,000

$70,000

Budgeted purchase of inventory

$35,500

$46,700

$95,500

Customers pay 20% of the sales in cash at the time of the transaction and 80% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern:

Month of sale 60%

First month following sale 30%

Second month following sale 8%

Uncollectible 2%

The company pays 45% of the cost of the inventory in the month of purchase, and 55% during the following month.

The company requires a minimum cash balance of $5,000 to start a month. The beginning cash balance in March is budgeted to be $6,000.

The following additional information has been provided for March:

Operating expenses $25,000

Dividends paid in March $4,000

The operating expenses include $5,000 depreciation. All operating expenses are paid during each month.

Required -

a. Calculate the budgeted cash collection for March.

b. Calculate the balance of accounts payable at the end of March.

c. Prepare cash budget in good form for the month of March (The company can borrow in any dollar amount and will not pay interest until April).

Reference no: EM132792241

Questions Cloud

Analyse the competitive environment of urban mobility : Undertake a comparative analysis of what you believe to be the most relevant city-level urban mobility and wider macro-environmental factors of Manchester
Which must pay tax due to the sale of the property : If Passan sells his cottage in 2017 for $365,000, what is the MINIMUM amount on which he must pay tax due to the sale of the property?
Describe strategies for building your portfolio : In the realm of marketing, a successful branding strategy is one of the most important contributors to organizational success. A solid branding strategy can.
What is the maximum amount that simone can contribute : What is the MAXIMUM amount that Simone can contribute to an RRSP this year without incurring an over-contribution penalty?
Calculate the budgeted cash collection for March : The company requires a minimum cash balance of $5,000 to start a month. Calculate the budgeted cash collection for March
Based on principles of mental accounting : Based on the principles of mental accounting, how should McKinsey structure their compensation package to maximize the number of offers accepted (recruiting)?
What annual pension benefit will receive : Earnings to be $85,000 and the YMPE in the final year to be $55,300, what annual pension benefit will he receive when he retires after 20 years of service?
How often do you engage with or witness death in your work : How often do you engage with or witness death in your work? How has this experience or the lack of it shaped your view of death? Has it gotten easier or harder.
Describe the specific behaviors leaders : In a case study, identify an organization, and then describe the specific behaviors leaders (CEO, senior members, etc.) exhibit

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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