29 Jun Question Cash Budget Spears Limited is engaged in manufacturing of
Question
Cash Budget
Spears Limited is engaged in manufacturing of special component (KWQ 12) be used in for calculators. As a step towards reducing uncertainty over the financeneeds of the new business, the finance manager has asked you to prepare a cashbudget for Spears Ltd for the nine (9) months period from 1 January 2014 till 30September 2014.
You have collected some raw data from the concerned department heads and tabulated them as follows:
a) The following are sales for the nine month period are as follows:
Sales Forecast
Month Estimated Sales Units
January 250,000 February 255,000 March 264,000
April 290,000 May 315,000 June 340,000
July 365,000 August 270,000 September 257,000
The estimated selling price per special component is $5.00.
The collections for the above sales forecast are as follows:
i. Collection from customers within the month of sale = 10% ( deemed to becash sales)
ii. Collection from customers following the month of sale = 50%
iii. Collection from customers following the second month of sales = 30%
iv. 10% of the sales are estimated to become irrecoverable.
b) Direct materials are acquired one month prior to production and are paid thefollowing month of purchase. One special component (KWQ 12) uses 2 units ofdirect materials. The company keeps stock of 25% of the next monthsestimated sales.
Balance of direct materials as at 31 December 2013 amounts to 140,000 unitsof direct material at $0.25 per unit. There is no change in the cost directmaterial.
2
c) The Direct Labour cost is paid in the month when such costs are incurred.The number of hours estimated are as follows:
January February March April May June July August September
120,000 125,000 130,000 128,000 142,000 154,000 165,000 178,000 190,000
The company pays $1.50 per direct labour hour.
d) Operating Expenses are estimated to be $332,000 per month and this is paidend of the month in which it is incurred. Included in the operating expenses aredepreciation charges worth $15,000.
e) Income tax payments of $ 60,000 are due both in March and June 2014.
f) Spears Ltd’s Cash on Hand on 31 December 2013 was $500,000
To receive full credit on this assignment, please show all workings, including
formulas and calculations used to arrive at the financial values.
Required:
Prepare the following budgets:
1) Sales [4.5 marks]
2) Direct Materials Purchase Budget [9 marks]
3) Direct Labour Budget [4.5 marks]
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.