Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please explain each step also.. The following information relates to XY Ltd: Month Wages incurred () Materials purchases () Overhead () Sales () February 6,000

image text in transcribed

please explain each step also..

The following information relates to XY Ltd: Month Wages incurred () Materials purchases () Overhead () Sales () February 6,000 20,000 10,000 30,000 March 8,000 30,000 12,000 40,000 April 10,000 25,000 16,000 60,000 May 9,000 35,000 14,000 50,000 June 12,000 30.000 18,000 70,000 10,000 25,000 16,000 60,000 August 9,000 25,000 14,000 50,000 September 9,000 30,000 14,000 50,000 July (0) It is expected that the cash balance on 31st May will be 22,000. (ii) The wages are paid within the month they are incurred. (iii) It is company policy to pay creditors for materials three months after receipt. (iv) Debtors are expected to pay two months after delivery. (v) Included in the overhead figures is 2,000 per month which represents depreciation on two cars and one delivery van. (vi) There is a one-month delay in paying the overhead expenses. (vii) 10% of the monthly sales are for cash and 90% are sold on credit. (viii) A commission of 5% is paid to agents on all the sales on credit but this is not paid until the month following the sales to which it relates; this expense is not included in the overhead figures shown. (ix) It is intended to repay a loan of 25,000 on 30th June. (x) Delivery is expected in July of a new machine costing 45,000 of which 15,000 will be paid on delivery and 15,000 in each of the following two months. (xi) Assume that overdraft facilities are available if required. Required: a) Prepare a cash budget for each of the three months of June, July and August. b) 'Experts stress that one of the most vital uses of management accounts is regularly to monitor cash flow-moneys coming into the company each month minus moneys going out.' (Financial Times) Comment on the above statement, including in your answer the chief benefits obtained from the preparation of cash budgets

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Fundamental Accounting Principles

Authors: Larson Kermit, Tilly Jensen

Volume I, 14th Canadian Edition

71051503, 978-1259066511, 1259066517, 978-0071051507

Students also viewed these Accounting questions