Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company manufactures a single product. Budget and standard cost details for next year include: Selling price per unit RM45.00 Variable production cost per unit

A company manufactures a single product. Budget and standard cost details for next year include: Selling price per unit RM45.00 Variable production cost per unit RM3.75 Fixed production costs RM55,000 Fixed selling and distribution costs RM20,000 Sales commission 8% of selling price Sales 100,000 units Nesam Sdn Bhd has been engaged in the process of forecasting its financing needs over the next quarter and has made the following forecasts of planned cash receipts and disbursements: RM RM RM January 750,000 Mei 780,000 September 620,000 February 690,000 June 665,000 October 712,000 March 730,000 July 720,000 November 525,000 April 750,000 August 750,000 December 630,000 a) 60% of credit sales are realized in the month following the sale and the remainder in the second month following. b) The raw materials are 55% of the current sales and Creditors are paid in the month following the month of purchases. c) The wages and salaries are paid based on 10% of sales in the month. The utility for the firm is 5% of sales in the month of their incurrence. d) Furthermore, the monthly rent expenses are RM8,000 and Office supplies RM800. e) RM5,000 tax payments are to be made in the first month of each quarter. f) A 5% annual interest on a RM400,000 term loan will be paid monthly. g) The beginning cash balance for the budget period is RM90,000 with a minimum cash balance of RM45,000 and an increase to RM60,000 in August and RM75,000 in September. h) Any short-term financing needed to maintain the minimum cash balance should be paid off the month after the financing month with an annual interest rate of 15% per annum. Prepare a monthly cash budget for the three-month period ended 30th June 2023. (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

Investment Analysis And Portfolio Management

Authors: Frank K. Reilly, Keith C. Brown

6th Edition

003025809X, 978-3540014386

More Books

Students also viewed these Finance questions

Question

What is cultural diversity?

Answered: 1 week ago

Question

Does it have at least one-inch margins?

Answered: 1 week ago

Question

Does it have correct contact information?

Answered: 1 week ago

Question

Does it exceed two pages in length?

Answered: 1 week ago