Question: Amber Electronic Ltd is preparing its budget for the months of March and April 2020. Presented below are the actual and budgeted sales prepared by

Amber Electronic Ltd is preparing its budget for the months of March and April 2020.

Presented below are the actual and budgeted sales prepared by the Financial Controller of Amber Electronics Ltd. The projected next year's collection to be 30% to be cash sales and 70% as credit sales. Cash collection for credit sales will be 80% in the month of sale and

the balance to be collected in the following month.

Actual and Projected Sales for the months of January through to April 2020

January $100,000

February $180,000

March $220,000

April $190,000

To meet the above sales, purchases of inventory are made on first day of the month and are paid at the end of the following month. Purchases of inventory amounts to 70% of the total sales and no extra inventory is required.

A fixed operating cost amounting to $10,000 including a depreciation expense of $2,000, is incurred and paid at the end of every month.

In March, the Financial Controller is planning to buy an equipment costing $30,000. This equipment will be installed in April at a cost of $5,000. These costs are to be paid to two separate suppliers in the month of purchase and installation respectively.

The opening cash balance is $10,000.

Required:

a)

Prepare a monthly cash budget for the end of months of March and April only.

(6 marks)

b)

Explain to Amber Electronic's management what the cash budget prepared in part

a) reveals about their business.

(4 marks)

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!