Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following cash flow and costs projection is available for the last 6-months of 2022: Quarter 3 Quarter 4 Cash collection from customer RM35,500

 

The following cash flow and costs projection is available for the last 6-months of 2022: Quarter 3 Quarter 4 Cash collection from customer RM35,500 RM37,500 Cash payment for supplier RM64,034 RM67,202 Direct labour costs RM16,110 RM16,965 Manufacturing overhead Selling and administrative expense RM106,432 RM106,508 RM9,630 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.

Step by Step Solution

3.34 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

Cash Budget For last 6 Months of 2022 Quarter Quarter Particulars 3 Opening Balance 300000 100... 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

Engineering Economic Analysis

Authors: Donald Newnan, Ted Eschanbach, Jerome Lavelle

9th Edition

978-0195168075, 9780195168075

More Books

Students also viewed these Accounting questions

Question

why might a government impose a tariff on a product? LO6

Answered: 1 week ago