Question: SECTION B. QUESTION 1 (20 marks). The data below has been extracted from a prepared functional cash budget of Netcitizen Ltd from November 2022 to

 SECTION B. QUESTION 1 (20 marks). The data below has been

SECTION B. QUESTION 1 (20 marks). The data below has been extracted from a prepared functional cash budget of Netcitizen Ltd from November 2022 to March 2023. Your financial director just sent you an email to use this information to prepare the next quarter's budget (January to March 2024) following the adjustments. Periods: Nov 22 Dec 22 Jan 23 Feb 23 Mar 23 E Sales/Revenue 80,000 100,000 110,000 130,000 140,000 Purchases 40,000 60,000 80,000 90,000 1 10,000 Wages 10,000 12,000 16,000 20,000 24,000 Overheads 10,000 10,000 15,000 15,000 15,000 You are also provided with the following. a. Sales are composed of 40% cash and 60% credit. Credit sales are paid a month after sales. b. Purchases are paid the month following purchase. c. 75% of wages are paid in the current month and 25% the following month. d. Overheads are paid the month after they are incurred. e. Total cash balance at the end of last year (December 2023) was $5,000. Required: a. Prepare a cash budget for the three months - January to March 2024 (16 marks) b. What is your professional advice to management if the first quarter ends in deficit? (4marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!