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

  Questionthe project paper focuses on a suggested topic

questionthe project paper focuses on a suggested topic related to art architecture music history or literature. the

  Determine the ending inventory under a perpetual inventory

Farman Appliance Mart began operations on May 1. It uses a perpetual inventory system. During May, the company had the following purchases and sales for its Model 25 Sureshot camera.

  A series of monthly cash flows is deposited into an account

a series of monthly cash flows is deposited into an account that earns 12 nominal interest compounded monthly. each

  What is the recognized profit or loss on the sale

What is the recognized profit or loss on the sale of the building and the character of the gain?

  Determine the overhead volume variance

Colly, Inc. pays 20% of the cost of purchases in the month purchased and 60% in the month after and 20% in the month after that, how much cash will be disbursed in the month after a $108,000 purchase.

  Find how much direct labor should be budgeted for june

Looker Hats is planning to sell 600, and produce felt hats 700 during June. Each hat requires 1/2 yard of felt and 1/4 hour of direct labor. Felt costs $3.00 per yard and employees of the company are paid $20 per hour. Find How much direct labor s..

  Support recommendation to board of directors

As the company accountant you must give the necessary information to support your recommendation to Board of Directors.

  Compute break even point in units of product

Compute break even point in units of product (2) break even point in sales (3) the number of units product that must be produced and sold to achieve a profit of Rs.10000 and (4) the sales revenue required to achieve a profit of Rs.10000.

  Complete the cash budget for january and february

Complete the cash budget for January and February below. (List multiple items under receipts, disbursements and financing from largest to smallest amounts, e.g. 10, 5, 2.)

  Current liabilities section of balance sheet for new wave

Determine the fixed asset turnover ratio for 2012 and 2011 and Does the change in the fixed asset turnover ratio from 2011 to 2012 indicate a favorable or an unfavorable trend?

  Plan journal entries to record the preceding transactions

Plan journal entries to record the preceding transactions on the assumption that the bonus method is used.

  Calculate the depreciation expense for each year

Calculate the depreciation expense for each year of the assets life - Calculate the accumulated depreciation and net book value of the machine at December 31, 2011, under each of the three methods.

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