Question
Big Apple Limited is a manufacturer and after-market automotive parts supplier. The company is currently struggling to prepare its cash and sales budget for the
Big Apple Limited is a manufacturer and after-market automotive parts supplier. The company is currently struggling to prepare its cash and sales budget for the current financial year. The company has approached you to help them as their Accountant has recently retired. You are given the following information on 1 June 2018. Below are Actual and Budgeted sales figures: Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. R45 000 R24 000 R57 000 R38 000 R75 000 R41 000 R68 000 R73 000 R30 000 60% credit 65% credit 40% cash 75% cash 55% cash 70% credit 40% credit 60% credit 50% credit On the 1 July 2018 there was a bank balance of R60 700. Debtors payment is follows: 40% in month of sale, 50% in first month after the month of sale and 10% in second month after the month of sale. Details July 2018 August 2018 Commission Income R14 000 R11 000 Depreciation on equipment - R8 000 Labour Costs R33 000 R29 000 Raw Material R26 400 R28 100 Manufacturing Overheads R7 000 R5 500 Non-Manufacturing Overheads R4 800 R6 100 Expenses are paid for in cash. Financial year-end is 31 August 2018. Required: Prepare a Sales budget for the months of 30 June 2018 to 31 August 2018. Prepare the Cash budget for the months of 31 July 2018 to 31 August 2018.
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