Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PART C - Financial Budget The following cash flow and costs projection is available for the last 6-months of 2022: Cash collection from customer Cash
PART C - Financial Budget The following cash flow and costs projection is available for the last 6-months of 2022: Cash collection from customer Cash payment for supplier Direct labour costs Manufacturing overhead Selling and administrative expense Quarter 3 RM35,500 RM64,034 RM16,110 RM106,432 RM9,630 Quarter 4 RM37,500 RM67,202 RM16,965 RM106,508 RM9,750 Upon discussion with Mimi, you have drafted the following key cash transactions for your budgeting consideration: 1. The expected cash balance at the start of Quarter 3 is at RM300,000. 2. All direct labour costs, manufacturing overhead and selling and administrative expenses are expected to be paid in cash in the quarter incurred. 3. The machinery purchased at RM20,000 for the production of the Asian BBQ is expected to be paid as two-equal cash instalments in Quarter 3 and Quarter 4 respectively. 4. The company would like to maintain a minimum cash balance of RM100,000 every quarter. Any excess of cash will be used to repay borrowings and interests. Required: Show all workings on a Microsoft Excel spreadsheet. Marks are granted based on the correct answer, and, the relevant Excel cell-reference, formulae and/or functions used. Prepare the Cash Budget for the last 6-months of 2022. Show the ending cash balance for each quarter. (10 marks)
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