Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Timone Limited, a beer wholesaling company has the following budgeted information: Month Sales values (before trade discount) GH Purchases GH Operating costs GH May 960,000

Timone Limited, a beer wholesaling company has the following budgeted information:

Month

Sales values (before trade discount)

GH

Purchases

GH

Operating costs

GH

May

960,000

800,000

115,000

June

1,020,000

600,000

110,000

July

810,000

900,000

120,000

August

1,200,000

1,100,000

130,000

September

1,410,000

700,000

125,000

Additional information:

  1. 20% of sales are cash terms and cash customers enjoy a 5% trade discount based on the selling price. The remaining sales are on credit terms, 70% of which are collected in the month following sale and 30% of which are collected in the second month following sale.

  1. Timone Limited sets its selling price on a uniform mark up of 50% of the cost of goods sold for both cash and credit sales.

  1. All purchases are bought on credit and paid in the following month after purchase.

  1. Timone Limited will buy a new meat cutting machine at a cash price of GH300,000 on 1 August. The old meat cutting machine, with a cost and carrying amount of GH210,000 and GH156,000 as at 1 August, will be traded in against the new machine at a trade-in allowance of GH120,000. At all times, Timone Limited has only one meat cutting machine in operation and it is the only non-current asset of the company.

  1. The operating costs include the monthly depreciation expense of the meat cutting machine.

All monthly operating costs, other than the depreciation expense, are paid in the month when they are incurred. Both the old and new meat cutting machines are depreciated at 20% per annum on a straight-line basis.

  1. The expected cash balance as at 30 June is GH308,000. Required:
    1. Prepare a monthly cash budget for July, August and September together with a total column for the quarter.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Smoke And Mirrors Inc Accounting For Capitalism

Authors: Nicolas Vron, Matthieu Autret, Alfred Galichon, George Holoch

1st Edition

0801444160, 978-0801444166

More Books

Students also viewed these Accounting questions

Question

List the different categories of international employees. page 642

Answered: 1 week ago

Question

Explain the legal environments impact on labor relations. page 590

Answered: 1 week ago