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

  Compute the east divisions roi for last year

Compute the East Division's ROI for last year; also compute the ROI as it would appear if the new product line is added. (Round your intermediate calculations and final answers to 2 decimal places.

  How much after tax cash will have if sell norses assets

Geoffery and Sue are equal owners of Norse Corporation. They are considering a sale of the business. How much after tax cash will they have if they sell Norse's assets. How much if they sell the stock. Geoffery and Sue are equal partners of Norse L..

  Compute accounting rate of return for this equipment

Adriana Lopez is considering the purchase of equipment for Success Systems that would allow the company to add a new product to its computer furniture line.

  Questionmichigan machining company machines metal parts for

questionmichigan machining company machines metal parts for the automotive industry. under the traditional

  Compute the activity rate

Compute the activity rate (i.e., predetermined overhead rate) for each activity cost pool. (Do not round intermediate calculation. Round your final answers to 2 decimal places. Omit the "tiny_mce_markerquot; sign in your response.)

  What is activity-based management

What is activity-based management? What is a non-value added activity and how much did non value-added activities cost ReadersNet.Com this past year?

  Calculate net present value of each of the options

Calculate net present value of each of the options and determine which option Crossroad should select using the NPV criterion and what non-financial factors should Crossroad consider before making its choice?

  Match each situation with fraud triangle

Match each situation with fraud triangle factor that best explain it an employee's monthly credit card payments are nearly 75 percent of their monthly earnings

  Questionpartnership starts its first year with the

questionpartnership starts its first year with the following capital balancesarthur capitalnbspnbsp

  Prepare a budgeted income statement for the year ending

Prepare a budgeted income statement for the year ending December 31, 2010. Calculate budgeted cost of goods sold.

  Which of the following should be disclosed in a summary

Which of the following subsequent events (post-balance-sheet events) would require adjustment of the accounts before issuance of the financial statements?

  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..

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