Prepare the direct labour budget

Assignment Help Managerial Accounting

Reference no: EM13168771

Lance Limited manufactures a special component (WKQ 14) that is used in the making of calculators. As a step towards reducing uncertainty over the finance needs of the new business, the finance manager has asked you to prepare a cash budget for Lance Ltd for the eight (8) months period from 1 March 2014 till 31 October 2014.

You have collected some raw data from the concerned department heads and tabulated them as follows:

a) The following projected sales figures are given:

Sales Forecast Month Estimated Sales Units

March 260,000 April 250,000 May 270,000 June 280,000 July 300,000 August 290,000 September 310,000 October 270,000 November 280,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 be cash 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 the following month of purchase. One special component (WKQ 14) uses 2 units of direct materials. The company keeps stock of the direct materials, equal to 25% of the next month's requirements.
Balance of direct materials as at end of February 2014 amounts to 130,000 units of direct material at $0.30 per unit. There is no expected change in the direct material costs.

c) The Direct Labour cost is paid in the month when such costs are incurred.

The number of hours estimated are as follows: March April May June July August September October 130,000 135,000 140,000 148,000 152,000 154,000 150,000 148,000

The company pays $2.50 per direct labour hour.

d) Operating Expenses are estimated to be $332,000 per month and this is paid at the end of the month in which it is incurred. Included in the operating expenses are depreciation charges worth $16,000 per month.

e) Income tax payments of $60,000 are due both in June and September 2014.

f) Lance Ltd's Cash on Hand at the end of February 2014 was $350,000

Credit for this assignment will be given on the workings, formulas and calculations used to arrive at the financial values.

Required:

Prepare the following budgets:

1) Sales

2) Direct Materials Purchase Budget

3) Direct Labour Budget

4) A monthly cash budget for the 8-month period of March to 31 October 2014.

Reference no: EM13168771

Questions Cloud

How much total interest will amos pay on this payment plan : Amos could borrow $104,000from its bank to finance the purchase at an annual rate of 8%. Should Amos borrow from the bank or use the manufacturer's payment plan to pay for the equipment?

How many moles of naoh were in this volume : a titration required 18.38 ml of 0.1574 M NaOH solution. How many moles of NaOH were in this volume?

State the ka of butanoic acid : What is the pH after 13.3 mL of base is added? The Ka of butanoic acid is 1.5 X 10^-5.

State the metal is obtained from seawater in a process : Magnesium is used in lightweight alloys for airplane bodies and other structures. The metal is obtained from seawater in a process that includes precipitation, neutralization, evaporation

Prepare the direct labour budget : Prepare the budgets Sale, direct Materials Purchase Budget and direct Labour Budget

Explain what is the ph before any base is added : A 25.0 mL sample of 0.150M hydrocyanic acid is titrated with a 0.150M NaOH solution. What is the pH before any base is added? The Ka of hydrocyanic acid

Compute the ph of the titration mixture : A 25.0 mL sample of a 0.115 M solution of acetic acid is titrated with a 0.144 M solution of NaOH. Calculate the pH of the titration mixture after 10.0, 20.0, and 30.0 mL of base have been added.

State what mass of naoh could this buffer neutralize : What mass of NaOH could this buffer neutralize before the pH rises above 4?

Corporate tax return problem : Cara Siler, Janna Funk, and Valerie Cloward each own one-third of the common stock of Blue Catering Services Inc. (BCS). BCS was incorporated on February 4, 2008.

User Account

All Pages