Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part A: Flexed Budget Bitcom Limited had the following budgeted and actual income statements for the month of December 2020. Sales in units Sales Direct

image text in transcribedimage text in transcribed

Part A: Flexed Budget Bitcom Limited had the following budgeted and actual income statements for the month of December 2020. Sales in units Sales Direct materials cost Direct labour cost Total fixed costs Budgeted 800 $560,000 $224,000 $80,000 $200,000 Actual 700 $525,000 $210,000 $73,500 $190,000 The accountant states that a flexed budget will assist with identifying the variances in managing the sales and the costs for December 2020. Required: Prepare a flexed budget for December 2020 with explanations for all variances. Show all workings. (13 marks) Part B: Cash Budgets Millbrook Manufacturing Limited has just been established on 30th September 2020. The company has prepared its first budgeted income statement for the next three months as follows: November 2020 $400,000 $110,000 December 2020 $500,000 $130,000 October 2020 Sales $200,000 Salary and wages $50,000 expense Rent expense $6,000 Utilities expense $1,000 Insurance $2,000 expense $6,000 $1,800 $2,000 $6,000 $2,200 $2,000 Other information: 1. Sales are made up of 50% cash sales and the remainder on credit. The terms of receipts for the credit sales are 80% to be collected in the next month and the remainder 20% in the following month. 2. 90% of the salary and wages are paid in the same month and the remainder 10% in the next month. 3. The quarterly rent was paid on 1st October 2020. 4. The annual insurance was paid on 1st October 2020. 5. All utilities are paid in the same month that they are incurred. 6. Plan to purchase of a motor vehicle in November 2020 for $10,000. The salvage value is $2,000 at the end of 4 years. 7. The cash balance as at 1st October 2020 is $15,000 (in overdraft). The CFO claims that th 2(Alt + A) on is likely to improve in November and December 2020 even though there is a current bank overdraft balance of $15,000 as at 1st October 2020. Required: Is the CFO correct in his prediction of the cash positions in November and December 2020? Prepare the cash budget for the months of October to December 2020 to prove your answer. Show all workings

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

Curriculum Alignment A Facilitators Developing Aligning And Auditing

Authors: Betty E. Steffy-English, Fenwick W. English

1st Edition

0803968485, 978-0803968486

More Books

Students also viewed these Accounting questions

Question

If du, what is d 2 g / dx 2 ? 8(x)=u + 2

Answered: 1 week ago