How to prepare a monthly cash budget

Assignment Help Accounting Basics
Reference no: EM132748128

Question: Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are:

September: 350000

October: 500,000

November: 400,000

Sales for August were $400,000. All sales are on account. Galaxy Lighting Company estimates that 60% of the accounts receivable are collected in the month of sale with the remaining 40% collected the following month. The units sell for $25 each. The cash balance for September 1 is $100,000.

Generally, 60% of purchases are due and payable in the month of purchase with the remainder due the following month. Purchase cost per unit for materials is $15. The company maintains an end-of-the-month inventory of 10% of next month's unit sales.

Selling and administrative expenses paid in cash are $120,000 per month.

How to prepare a monthly cash budget for September for Galaxy Lighting Company?

Reference no: EM132748128

Questions Cloud

What price would you expect to be able to sell : Currently a bond of comparable risk is priced to provide a yield to maturity of 8% with a $1,000 face value, What price would you expect to be able to sell
Develop personal operative paradigm : Develop a personal "operative paradigm" based on a review of the paradigmatic assumptions and concepts involved in each of the three basic methodological approa
What virtualizaton product do you recommend : Superior Technical College's IT Department is planning to use virtual machines in its computer lab. What virtualizaton product do you recommend?
How much can kelly afford to pay monthly for her house : Kelly is looking at purchasing her first house and is concerned with how much she is able to afford. Assume she makes $84,000/yr in gross annual income.
How to prepare a monthly cash budget : Sales for August were $400,000. All sales are on account. Galaxy Lighting Company estimates that 60% of the accounts receivable are collected in the month.
What is the balance of accumulated depreciation-equipment : If the company uses the double-declining-balance method of depreciation, what is the balance of the Accumulated Depreciation-Equipment account at December 31.
Show the allocation of dividends for all three years : Timber Ridge Corporation was organized on January 1, 2015. During its first year, the corporation issued 40,000 shares of $5 par value preferred stock.
What is target conversion and administrative cost per unit : If company management desires a return equal to 30% of the final selling price, what is the target conversion and administrative cost per unit?
How does coca cola company account for goodwill : How does Coca Cola Company account for Goodwill, Trademarks and Other Intangible Assets? Does Coca Cola Company make any acquisitions during 2019?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How many pounds of clay would Stillwater Corporation need

At the beginning of? January, 480 pounds of clay were in inventory. How many pounds of clay would Stillwater Corporation need to purchase in Month? 2

  Decide how to plan to structure audit report for evidence

Evaluate the evidence provided by the Apollo Shoes Case Study. Compose an audit report, which reflects the appropriate length, sections, and content for the provided information.

  what was the selling price of D

If A was allocated $187 500 of the joint production costs under the net realisable value method, what was the selling price of D

  1 beech soda inc uses a perpetual inventory system the

1 beech soda inc. uses a perpetual inventory system. the companys beginning inventory of a particular product and its

  What is the standard deviation of your portfolio

If you invest 58.33% of your money in security-X and the remaining in security-Y, what is the standard deviation of your portfolio

  What is their recognized gain

They made major capital improvements through their 10-year ownership, which totaled $50,000. What is their recognized gain

  The company sells the toys for 4 each and it produces and

a company that manufactures toys has just developed a 50000 molding machine for producing a special toy. the machine

  Compute the amount required to purchase this bond

Compute the amount required to purchase this bond at the beginning of the 4 year period. Provide the journal entry to record the purchase

  Find and calculate the constant growth stock valuation

Calculate the Constant Growth Stock Valuation (CGSV) and compare it to the current stock price. How the chosen company is spending their money

  Prepare an annotated table of entities and activities

Prepare an annotated table of entities and activities. Indicate on this table the groupings, bubble numbers, and bubble titles to be used in preparing a level 0 logical DFD.

  Discuss the quality of financial information

What is the importance of understanding various inventory valuation methods in determining the quality of reported profits?Discuss The Quality of Financial

  Compute the return on sales

Compute the return on sales, turnover on capital, and ROI for the three companies, and comment on the relative performance of the companies

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