Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 3: PANDA LTD PANDA Ltd's budgeted sales for Dec - May months are as follows: Production (UNITS) Sales (UNITS) December 500 400 January 600

image text in transcribed
image text in transcribed
QUESTION 3: PANDA LTD PANDA Ltd's budgeted sales for Dec - May months are as follows: Production (UNITS) Sales (UNITS) December 500 400 January 600 500 February 650 600 March 700 650 April 750 700 May 800 750 The selling price per unit will be 130. All sales will be made on credit. The business plans to offer a cash discount (of 5% of the amount owed) to those customers who pay within the same of the month of sale. Customers for 70% of units sold are expected to qualify for the discount. Remaining 30% of the sales is expected to be paid during the next month (l.e one month later). It is planned that sufficient finished goods inventories for each month's sales should be available at the end of the previous month. The selling price per unit will be 130. All sales will be made on credit. The business plans to offer a cash discount (of 5% of the amount owed) to those customers who pay within the same of the month of sale. Customers for 70% of units sold are expected to qualify for the discount Remaining 30% of the sales is expected to be paid during the next month (.e one month later). it is planned that sufficient finished goods inventories for each month's sales should be available at the end of the previous month. For raw material purchases, the cost of raw material is $30 per unit. It is bought in the month of production and paid one month in arrears (le later). The direct labour cost, which is variable with the level of production, is planned to be 18 per unit of finished production and it is paid in the month of production. Overhead costs are planned to be $11,000 each month including 5,000 for depreciation. Overhead costs are paid in the same month. Company bought an equipment for 180,000 in Jan and equal payments were made over Jan-Mar. Opening cash balance at the start of Jan (15) is 70,000. Required: Draw up a cash budget for the 3 months from 1 January to 31 March, with a column for each month. The budget should, among other things, show each end-of-month cash balance. (30 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

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

Accounting And Finance For Non Specialists

Authors: Peter Atrill, Eddie McLaney

12th Edition

129233469X, 9781292334691

More Books

Students also viewed these Accounting questions