User Account

All Pages

Prepare the cash budget with supporting schedules

Assignment Help Managerial Accounting
Reference no: EM132559013

Haverford Company has the following information related to preparing the first quarter 2021 Cash Budget.

a. Budgeted Sales and Budgeted Purchases for 2021 are detailed below:

                                Sales                    Material Purchases

4th Quarter 2020           $310,000                $180,000

1st Quarter 2021          $575,000                 $245,000

2nd Quarter 2021            $525,000                $325,000

3rd Quarter 2021                 $595,000              $360,000

4th Quarter 2021                 $450,000                  $220,000

The company collects 35% of sales immediately. The remaining 65% is collected in the quarter following the sale. In addition 20% of purchases are paid for immediately. The remainder are paid for in the quarter following the sale.

b. Labor costs are fixed at $58,000 per quarter.

c. Selling and Administrative expenses are $80,000 per quarter plus 10% of sales. Included in the $80,000 is depreciation of $15,000.

d. Haverford has historically paid $6,000 in cash dividends each quarter.

e. The company plans to purchase new equipment in 2021 using cash on hand. The equipment will cost $100,000. The company will pay $60,000 in the 1st quarter and $40,000 in the 2nd quarter.

f. The cash account began 2021 with a balance of $22,000. The company must maintain a minimum balance of $18,000.

Required:

Question 1: Prepare the Cash Budget with supporting schedules for cash collections and cash disbursements for the FIRST QUARTER ONLY.

Question 2: Do you recommend the equipment purchase? Write a email to the president of the company with your recommendations.

Question 3: Calculate the 12/31/21 ending balance of Accounts Receivable and Accounts Payable.

Reference no: EM132559013

Questions Cloud

Find what the degree of operating leverage is : Morse Company reports total contribution margin of $82,010 and pretax net income of $13,900 for the current month. What The degree of operating leverage is
Prepare the entry to record the sale for cash : The corporation sold 100 common shares and 150 preferred shares for a lump sum of $ 100,000. Prepare the entry to record the sale for cash
What commission c should : Suppose you have hired a new worker, unfortunately you do not know if the worker is a shirker or a hard worker.
Server virtualization : Explain Windows Azure capabilities for virtual machines and managing hybrid cloud, including Windows Azure's Internet as Service (IaaS) and storage capabilities
Prepare the cash budget with supporting schedules : Prepare the Cash Budget with supporting schedules for cash collections and cash disbursements for the FIRST QUARTER ONLY.
How much is the taxable income : Jacob was an OFW employed by I-Tech Corporation in the USA. Jacob retired. How much is the taxable income
Distinguish between the two types : Suppose a bank is faced with two types of borrowers - a high risk borrower that should be charged an interest rate
Find the chi-square critical value for goodness : Find the Chi-Square critical value for goodness of fit where alpha is the level of significance and k is the number of possible outcomes for each trial.
What is the cost of the units in ending inventory : On January 10th, the company sells 4,000 units. Using the Weighted Average method of inventory costing, what is the cost of the units in Ending Inventory

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Plot the data in the order of the dates

Plot the data in the order of the dates. (To earn full credit for this graph you must plot all required points for each curve. While plotting the points a tool

  Prepare a contribution margin income statement

Prepare a contribution margin income statement separating all variable and fixed costs into their own categories and determine the breakeven point in units and dollars. Also, determine the number of units and dollars that need to be sold to make a ..

  An unfavorable change in business is remotely possible

Tohono Company's 2013 master budget included the following fixed budget report. It is based on an expected production and sales volume of 20,000 units.

  What is the activity rate for activity of receiving orders

What is the activity rate for the activity of receiving orders? Craftsman Inc. manufactures high-quality metal instruments using an activity-based costing

  Mountaineering model or the touring model

The firm will now be able to produce up to 23,000 pairs of either the mountaineering model or the touring model. The sales are between 17,000 and 21,000 units o

  Variable costing-segment reporting

Michaels Company segments its income statement in its east and west divisions.The company's entire sales, contribution margin ratio, and net operating income are $600,000, 50%, and $50,000, respectively.

  Rondell pharmacy-break-even-cost structure

"Breakeven analysis isn't very useful to the company because companies require to do more than break even to survive in the long run." Describe why you agree or disagree with this statement.

  Determine jenson college should outsource housekeeping

Determine whether Jenson College should outsource housekeeping, assuming that 50% of fixed costs can be eliminated if the service is outsourced.

  What was chen return on equity for the year

What was Chen's return on equity (ROE) for the year? Chen's Salons Inc. (Chen) net income for 2020 was $79,500. Chen's return on assets (ROA)

  Explain what a cost objective is and give two examples

Explain what a cost objective is and give two examples.

  What budget is needed to prepare the direct materials budget

What budget is needed to prepare the direct materials budget?General and administrative expense budget/Production budget/Overhead budget

  Determine the net present value of the investment in machine

Determine the net present value of the investment in the machine. The management of Kunkel Company is considering the purchase of a $22,000 machine.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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