Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Computer Accounting With QuickBooks Online

Authors: Donna Kay

2nd Edition

1260888061, 9781260888065

More Books

Students also viewed these Accounting questions

Question

=+What action steps will you take to handle this situation?

Answered: 1 week ago