Excel Berhad manufactures one product line – the Nexus. Sales of Nexus over the next few months are planned as follows: 1. Demand: July 180,000 units, August 200,000 units, September 240,000 units, October 180,000 units. The selling price for each Nexus is RM5. 2. Debtor receipts: Credit customers (receivables) are expected to pay as follows: 70% during the month of sale and 28% during the following month. The remaining credit customers are expected to go bad (that is, to be uncollectable). Credit customers who pay in the month of sale are entitled to deduct a 2 per cent discount from the invoice price. 3. Finished goods inventories: Inventories of finished goods are expected to be 50,000 units at 1 July. The business’s policy is that, in future, the inventories at the end of each month should equal 20 percent of the following month’s planned sales requirements. 4. Raw materials inventories: Inventories of raw materials is expected to be 50,000 kg on 1 July. The business’s policy is that, in future, the inventories at the end of each month should equal 50 percent of the following month’s planned production requirements. Each Nexus requires 0.5 kg of the raw material, which costs RM1.50 per kg. Raw materials are paid for in the month after purchase. 5. Labour and overheads: The direct labour cost of each Nexus is RM1.00. The variable overhead element of each Nexus is RM0.50. Fixed overheads, including depreciation of RM15,000, total RM50,000 a month. All labour and overheads are paid during the month in which they arise. 6. Cash in hand: The business plans to have a bank balance (in funds) at 1 August of RM20,000. Required: Question: A. Prepare the following budgets: (i) Finished inventories budget (expressed in units of Nexus) for each of the three months: July, August, and September.   (ii) Raw materials inventories budget (expressed in kg of the raw material) for the two months July and August.   (iii) Cash budget for August and September.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Excel Berhad manufactures one product line – the Nexus. Sales of Nexus over the
next few months are planned as follows:
1. Demand: July 180,000 units, August 200,000 units, September 240,000 units,
October 180,000 units. The selling price for each Nexus is RM5.


2. Debtor receipts: Credit customers (receivables) are expected to pay as follows: 70%
during the month of sale and 28% during the following month.
The remaining credit customers are expected to go bad (that is, to be uncollectable).
Credit customers who pay in the month of sale are entitled to deduct a 2 per cent
discount from the invoice price.


3. Finished goods inventories: Inventories of finished goods are expected to be 50,000
units at 1 July. The business’s policy is that, in future, the inventories at the end of
each month should equal 20 percent of the following month’s planned sales
requirements.


4. Raw materials inventories: Inventories of raw materials is expected to be 50,000 kg
on 1 July. The business’s policy is that, in future, the inventories at the end of each
month should equal 50 percent of the following month’s planned production
requirements.
Each Nexus requires 0.5 kg of the raw material, which costs RM1.50 per kg. Raw
materials are paid for in the month after purchase.


5. Labour and overheads: The direct labour cost of each Nexus is RM1.00. The variable
overhead element of each Nexus is RM0.50. Fixed overheads, including depreciation
of RM15,000, total RM50,000 a month.
All labour and overheads are paid during the month in which they arise.


6. Cash in hand: The business plans to have a bank balance (in funds) at 1 August of
RM20,000.
Required:

Question:
A. Prepare the following budgets:
(i) Finished inventories budget (expressed in units of Nexus) for each of the
three months: July, August, and September. 

 (ii) Raw materials inventories budget (expressed in kg of the raw material) for
the two months July and August. 

 (iii) Cash budget for August and September. 

 

Expert Solution
steps

Step by step

Solved in 2 steps with 8 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

 B. Comment on the cash balance for August and September.

C. Explain two (2) ways budgets are useful to managers.

 

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Income Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education