Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Healthy Health Berhad is a manufacturing company that produces sport equipment for indoor games. As a new appointed manager, you were asked to prepare

image text in transcribed

Healthy Health Berhad is a manufacturing company that produces sport equipment for indoor games. As a new appointed manager, you were asked to prepare the company's operational budget and cash budget for the year 2022. The following are the budgeted data of Healthy Health Berhad for the first quarter of year 2022: March Sales Wages Overheads January RM 50,000 17,000 13,000 February RM RM 55,000 70,000 18,000 24,500 14,500 20,000 The following information is available regarding direct materials: January February RM RM March RM April RM Opening stock 5,500 3,000 5,000 6,000 Material usage 13,000 18,000 22,000 Additional information: 1. 10% of sales are for cash and the balance is received in the following month. The amount received in January for December's 2021 sales is RM35,500. 2. Wages are paid in the month they are incurred. 3. Overhead include RM2,000 per month for depreciation. Overhead are settled in the following month. RM9,000 is to be paid in January for December's 2021 overheads. 4. 60% purchases of direct materials are paid in the month of purchase and balance will be paid one month after purchased. The amount paid in January for December's 2021 credit purchases is RM5,500. 5. A motor vehicle will be sold in February. The motor vehicle was bought three years ago at RM50,000 and its depreciated at 20% per annum using a straight-line method. There will be a foreseeable gain on disposal of the motor vehicle of RM5,000. 6. The company invests RM50,000 as a fixed deposit in January 2022 and expected to receive interest on fixed deposit of 18% per annum at the end of each quarter. 7. New equipment will be purchased in February 2022 with cost RM50,000. Only half of the cost will be paid in the month of purchased while, the balance will be paid in April 2022. 8. Advertising cost will be incurred in January 2022 amounting to RM3,000 but will be paid in early February 2022. 9. The opening cash balance in January is RM56,250. Required: a. Prepare the Cash Budget for Healthy Health for the first quarter of year 2022. (17 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Managerial Decision Modeling With Spreadsheets

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

3rd Edition

9780136115830

Students also viewed these Accounting questions

Question

Construct a pie chart for the data in Exercise 1.

Answered: 1 week ago

Question

Construct a frequency polygon for the data in Exercise 7.

Answered: 1 week ago

Question

Construct a frequency bar graph for the data in Exercise 1.

Answered: 1 week ago