Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Shellix Sdn Bhd supplies acetylene and other compressed gases to industry. Data regarding the store's operation are as follows: i. Sales are budgeted at RM490,000
Shellix Sdn Bhd supplies acetylene and other compressed gases to industry. Data regarding the store's operation are as follows: i. Sales are budgeted at RM490,000 for November, RM470,000 for December and RM480,000 for January. ii. Collections are expected to be 80% in the month of sales, 15% in the month following the sales, and 5% uncollectible. iii. The cost of goods sold is 50% of sales. iv. The company purchases 80% of its merchandise in the month prior to the month of sale and 20%in the month of sale. Payment for merchandise is made in the month following the purchase. v. Other monthly expenses to be paid in cash are RM41,400. vi. Monthly depreciation is RM20,000. vii. Ignore taxes. Statement of Financial Position as at 31 October Assets RM Cash 25,000 Account receivables 71,000 Inventory 163,800 Property, plant and equipment (net of RM504.000 accumulated depreciation) 1,088,000 Total Asset 1.347,800 Liabilities and Stockholder's equities Account payable Common stock Retained earnings Total liabilities and stockholder's equities 232,000 700,000 415,800 1.347.800 Required: a) Prepare a Schedule of expected cash collection for November and December. (4 marks) b) Prepare a merchandise purchase budget for November and December (4 marks) c) Prepare cash budget for November and December. (4 marks) d) Prepare budgeted Profit or Loss Account for November and December. (7 marks) e) Prepare a Budgeted Statement of Financial Position as at 31 December
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started