Prepare a cash budget for may

Assignment Help Cost Accounting
Reference no: EM13552644

Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of April 30 is given below:

1708_Cash budget.PNG

The company is in the process of preparing budget data for May. A number of budget items have already been prepared, as stated below:

(a) Sales are budgeted at $200,000 for May. Of these sales, $60,000 will be for cash; the remainder will be credit sales. One-half of a month's credit sales are collected in the month the sales are made, and the reminder is collected in the following month. All of the April 30 accounts receivable will be collected in May.

(b) Purchase of inventory are expected to total $120,000 during May. These purchases will all be on account. Forty percent of all purchases are paid for in the month of purchases; the remainder are paid in the following month. All of the April 30 accounts payable to suppliers will be paid during May.

(c) The May 31 inventory balance is budgeted at $40,000.

(d) Selling and administrative expenses for May are budget at $72,000, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,000 for the month.

(e) The note payable on the April 30 balance sheet will be paid during May, with $100 in interest, (All of the interest relates to May)

(f) New refrigerating equipment costing $6,500 will be purchased for cash during May.

(g) During May, the company will borrow $20,000 from its bank by giving a new note payable to the bank for that amount. The new note will be due in one year.

Required:

1. Prepare a cash budget for May. Suppose your budget with a schedule of expected cash collections from sales and a schedule of expected cash disbursements for merchandise purchase

2. Prepare a budgeted income statement for May. Use the absorption costing income statement formal as shown in Schedule 3.

Reference no: EM13552644

Questions Cloud

What is the average velocity of the train during this run : A train moving at a constant speed of 58.0 km/h moves east for 32.0 min, then in a direction 46.0° east of due north for 24.0 min, and then west for 63.0 min. What is the average velocity of the train during this run?
The length of vector x is 14 : If I have one cost function f(x) and I have 3 subject function (nonlinear function), the length of vector x is 14. Can I solve it using matlab function (fmincon)? And if I can, can you show me example?
Evaluate the frequency of the fork : A tuning fork is sounded above a resonating tube (one end closed) which resonates at a length of 0.32 m and again at 0.91 m. What is the frequency of the fork
Find out the molar mass of the acid : A 6.5g sample of diprotic acid requires 137.5mL of a .75M NaOH solution for complete neutralization. Determine the molar mass of the acid.
Prepare a cash budget for may : Prepare a cash budget for May. Suppose your budget with a schedule of expected cash collections from sales and a schedule of expected cash disbursements for merchandise purchase
Explain what is the rate constant at 15 degrees c : For the first-order reaction 1/2 N2O4(g) yields NO2(g); change in H = 28.6kJ the rate constant is k=6.84 x 10 to the 4 s-1 at -23 degrees C, and the activation energy is 53.7 kJ/mol. what is the rate constant at 15 degrees C.
A totem pole has representations of n animals : A totem pole has representations of n animals arranged in a vertical column
Depict a molecular orbital for 1,3,5,7-octatetraene : Draw a molecular orbital for 1,3,5,7-octatetraene. Make sure to include labels, relative energy, bonding/antibonding character, # of electrons and HOMO and LUMO.
In a system designed to measure cadmium stored in liver : In a system designed to measure cadmium stored in liver, a person’s liver receives a dose of 125 μGy from fast neutrons and 20 μGy from γ-rays. In addition, 1 % of these doses goes to the whole body.

Reviews

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

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