Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following information is available for Maple Limited: Month Sales Purchases Overheads June 2022 (actual) 35,500 16,400 9,400 July 2022 (actual) 42,800 15,400 8,600 August

The following information is available for Maple Limited: Month Sales Purchases Overheads June 2022 (actual) 35,500 16,400 9,400 July 2022 (actual) 42,800 15,400 8,600 August 2022 (budgeted) 38,000 17,200 15,000 September 2022 (budgeted) 39,500 16,900 15,000 October 2022 (budgeted) 40,000 20,400 9,000 The bank balance at 1 August 2022 was 22,000. Sales are 70% cash and 30% credit. Cash from credit sales is received in the month after the sale. Purchases are paid for; 0% in the month of purchase, 60% in the month following purchase, 40% one month later. " Overheads are paid in the current month. " Depreciation of 2,000 per month is included in overheads. Required a) Prepare the cash budget for Maple Limited for the 3 months ending 31 October 2022. [18 marks] b) Explain what is meant by 'sensitivity analysis' and explain what sensitivity analysis you would carry out on the cash budget of Maple Limited. [7 marks]

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_2

Step: 3

blur-text-image_3

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

Intelligent Accountant Strategies Concepts And Ideas To Transform Your Practice

Authors: Darren Gleeson

1st Edition

1925515575, 978-1925515572

More Books

Students also viewed these Accounting questions