Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Illuminate Ltd. is a company that produces various coloured lights that is distributed through gift shops located in major shopping centres across Fiji. One of

Illuminate Ltd. is a company that produces various coloured lights that is distributed through gift shops located in major shopping centres across Fiji. One of its best sellers is the Aura coloured lights. In 2021, the company projects selling 100 000 of Aura lights in April, 120 000 in May, and 140 000 in June. The Aura light sells for $20 and has the following standard unit production costs at a monthly volume of 100 000 units:

Raw materials $5.00

Direct labour 8.00

Variable overhead 2.00

Fixed overhead 0.50

The budgeted fixed production costs include non-cash expenses of $20 000. Under-or overapplied overhead is closed to the Cost of Goods Sold each month. Other monthly expenses include distribution expenses of 10 percent of sales and administrative expenses of $5 000.

The Company currently has 40 000 Aura lights on hand and sufficient raw materials to produce 100 000 additional units. The company desires to have sufficient quantities of the finished product on hand at the end of each month to supply 50 percent of the following months sales and sufficient raw materials to supply 80 percent of the following months production.

The Company believes in cash on the barrel head. It pays all debts immediately and it does not sell on account. The current March 31 cash balance is $10 000.

REQUIRED

[Note: Each budget must have a proper title/heading]

(a). Prepare a production budget (in units) for April and May. (7 marks)

(b). Prepare a purchases budget for April. (5 marks)

(c). Prepare a Cash budget for April. (13 marks)

(d). Write a memo to the senior management on Illuminates cash position in April and give your recommendations (use proper memo format). (5 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

Statistical Analysis Microsoft Excel 2013

Authors: Conrad Carlberg

1st Edition

0789753111, 9780789753113

More Books

Students also viewed these Accounting questions