Required: Prepare a quarterly cash budget for the company for Year 2. Discuss the advantages and disadvantages of budgetary control.

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter16: Cost-volume-profit Analysis
Section: Chapter Questions
Problem 18E: Carmichael Corporation is in the process of preparing next years budget. The pro forma income...
icon
Related questions
Question

 

Salsabella Berhad manufactures and sells an electrical component. The Covid-19 pandemic has affected the company’s operation due to several lockdown in the country. The company is struggling to manage its cash flows. The business’ bank balance at the end of the year is projected to be an overdraft of RM170,000. 

 

As an accountant for Salsabella Berhad, you have prepared the following budgetary information to be presented in a board meeting:

 

  1. Sales volumes are projected as follows:

Year 1

 

Year 2

 

Quarter 4

Quarter 1

Quarter 2

Quarter 3

Quarter 4

100,000 units

100,000 units

80,000 units

60,000 units

140,000 units

 

  1. The selling price of the component is currently RM11.00 per unit and this is expected to increase to RM12.00 per unit from the start of Quarter 2 in Year 2.
  2. All sales are on credit and customers settle their debts in the Quarter following sale.

Irrecoverable debts of 5% of total sales revenue are anticipated.

  1. The company normally holds inventory of 40,000 units at the end of each Quarter and wants this to continue.
  2. The electrical components are produced in batches of 4,000 units per batch. Each batch requires 400 direct labour hours and 1,600 kg of raw materials.
  3. Direct labour is projected at a rate of RM20.00 per hour for Quarters 1 and 2 and at RM21.00 thereafter.
  4. Raw materials currently cost RM8.00 per kg and are expected to increase by 5% with effect from the start of Quarter 3 in Year 2. The company has agreed an average of 90 days credit with its suppliers.
  5. General overheads are projected to be RM50,000 per month.

 

 

Required:

  1. Prepare a quarterly cash budget for the company for Year 2.
  2. Discuss the advantages and disadvantages of budgetary control.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Capital Budgeting
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
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT