Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

II, You are presented with the budgeted data shown in Sydney Ltd company for the period November 2017 to 2018 by your firm.It has been

image text in transcribed
II, You are presented with the budgeted data shown in Sydney Ltd company for the period November 2017 to 2018 by your firm.It has been extracted from the other functional budgets that have been prepared. You are also told the following: (a) The opening cash balance is 15,000 (b) Sales are 40% cash,60% credit. Credit sales are paid two months after the month of sale (c) Purchases are paid the month following purchase (d) 75% of wages are paid in the current month and 25% the following month. (e) Overheads are paid the month after they are incurred (f) Dividends are paid three months after they are declared. (g) Capital expenditure is paid two month after it is incurred The managing director is pleased with the above fig have increased by more than 100% in the period under review. In order to achieve this he has arranged a bank overdraft with a ceiling of 50,000 to accommodate the increased stock levels and wage b for overtime worked ures as the show sales will Sydney Lted Nve17 Dec17 Jan18 Feb18 Mar18 Apr18 May 18 Sales80,000 100,000 110,000 130,000 140,000 150,000 160,000 Purchases 40,000 60,000 80,000 90,000 110,000 130,000 140,000 Wages Overheads 10,000 10,000 15,000 15,000 15,000 20,000 20,000 Dividends Expenditure 10,000 12,000 16,000 20,000 24,000 28,000 32,000 20,000 30,000 40,000 Required 1. Prepare a cash budget for the 6 month period January to June 2018. 2. Comment upon your results in the light of your managing director's comments and offer advice

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

Advanced Management Accounting

Authors: Tom Groot, Frank Selto

1st Edition

0273730185, 978-0273730187

More Books

Students also viewed these Accounting questions

Question

I didnt know who to talk to.

Answered: 1 week ago

Question

Th e complaint department was closed over the lunch hour.

Answered: 1 week ago

Question

Th ey probably would have treated me like a criminal.

Answered: 1 week ago