Ask Experts Questions for FREE Help !
Ask
    ambejo's Avatar
    ambejo Posts: 2, Reputation: 1
    New Member
     
    #1

    Mar 1, 2014, 10:12 PM
    Accounting Problem: Need solution - Thank You in advance
    Detail of product Z (to be launched in next year)

    January
    (Unit)
    February
    (Unit)
    March
    (Unit)
    April May
    (Unit) (units)
    Sales 1,000 1,200 1,400 1,600 1,800

    Notes: Unit selling price = $20
    Purchase price = $12

    Other information:
    · Closing stock to be maintained sufficient for 20% of the following month’s sales
    · All sales in credit in which 40% to be received in 1 months 55% in 2 months time and the rest to be treated as bad debts.
    · About 60% of creditors to be settled in 1 month time which entitled for 5% cash discount and the rest in two months time. (Purchases made in the month of production)
    · Monthly overhead estimated at $500 for the first two months thereafter will be increased by 20%. Overhead payable one month in arrears.
    · Monthly salary estimated at $800 and payable in the month of occurred.
    · Machinery costing $6,000 to be acquired in January and 10% of payment made immediately with the remaining amount settled by two equal instalments in the following months. Company’s policy is to provide depreciation at 20% on cost.
    · A monthly loan repayment of $1,000 will be paid in which $120 is interest.
    · Dividend of $15,000 will be paid in March
    · The bank balance at 1 January is $3,000 positive


    Required:
    Prepare a monthly cash budget for each of the four months to 30 April (ie for January, February, March and April), showing the cash balance at the end of each month.
    odinn7's Avatar
    odinn7 Posts: 7,691, Reputation: 1547
    Entomology Expert
     
    #2

    Mar 1, 2014, 10:18 PM
    What did you get so far when you tried to do this?
    ambejo's Avatar
    ambejo Posts: 2, Reputation: 1
    New Member
     
    #3

    Mar 28, 2014, 11:40 AM
    Hi odinn 7,

    All the while so far I did some searches online and there were plenty of formats and some Q&A samples. But unfortunately I'm totally lost on how to put the figures and the formats to be used for the cash budget.

    Even I tried to search for similar sample question and I could not find any.

    Thank You

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Accounting solution [ 1 Answers ]

GoodJob Ltd. Buys and sells home appliances and uses the perpetual inventory system. During the year 2011, the company had the following transactions: Jan 15 Purchased vacuum cleaners worth $57,000 from V Wholesalers, on account. Feb 4 Sold vacuum cleaners for $40,000 cash, which...

Problem 4.5A solution of chapter for the accounting cycle accruals and deffrals [ 1 Answers ]

Terrific temps fills temporary employment positions for local buisnesses.Some businesses pay in advance for services;others are billed after services have been performed.Advanced payments are credited to an account entitled unearned fees.Adjusting entries are performed on a monthly basis.An...

Advance accounting problems translation [ 0 Answers ]

Imperial Corp. a U.S. corporation, entered into a contract on November 1, 2013, to sell two machines to Crown Company, for 95,000 foreign currency units (FCU). The machines were to be delivered and the Amount collected on March 1, 2014. In order to hedge its commitment, Imperial entered into...

Salary advance accounting journal entries? [ 0 Answers ]

Salary advance accounting journal entries?

Advance Accounting [ 3 Answers ]

What basis of accounting normally is used in recording the assets and liabilities transferred to a new wholly owned subsidiary?


View more questions Search