need help

System
System Posts: 100,534 🤖 Admin 🤖
could somebody help me out with this question please, it would be most appreciated.<BR><BR>You have recently been promoted to the post of management accountant with Northern Products Ltd, a company formed four years ago. The company has always used budgets to help plan its production of two products, the Exe and the Wye. Both products use the same material and labour but in different proportions.<BR><BR>You have been asked to prepare the budget for quarter 1, the 12 weeks ending 24th march 2000. In previous budgets, the closing stocks of both raw materials and finished products were the same as opening stocks. You questioned whether or not this was the most efficient policy for the company.<BR><BR>As a result, you have carried out an investigation into the stock levels required to meet the maximum likely sales demand for finished goods and production demand for raw materials. You conclude that closing stocks of finished goods should be expressed in terms of day sales for the next quarter and closing stocks of raw materials in terms of days production for the next quarter.<BR><BR>Your findings are included in the data below, which also shows data provided by the sales and production directors of Northern Products Ltd.<BR><BR>Product Data Exe Wye<BR>Budgeted Sales in units, quarter 1 930 units 1,320 units<BR>Budgeted Sales in units, quarter 2 930 units 1,320 units<BR>Budgeted material per unit (litres) 6 litres 9 litres<BR>BUdgeted labour hours per unit 12 hours 7 hours<BR>Opening units of finished stock 172 units 257 units<BR>Closing units of finished stocks (days sales next quarter) 8 days 9 days<BR>Failure rate of finished production* 2% 3%<BR>Finance and other costs of keeping a unit in stock per quarter £4.00 £5.00<BR><BR>*FAiled products are only discovered on completion of production and have no resdual value.<BR><BR>Other accounting data <BR><BR>Weeks in accounting period 12 weeks<BR>Days per week for production and sales 5 days<BR>Hours per week 35 hours<BR>Number of employees 46 employees<BR>Budgeted labour rate per hour £6.00<BR>Overtime premium for hours worked in excess of 35 hrs per wk 30%<BR>Budgeted cost of material per litre £15.00<BR>Opening raw material stocks (litres) 1,878 litres<BR>Closing raw material stocks (days production next quarter) 5 days<BR>Financing and other costs of keeping a raw material in stock per quarter £1.00<BR><BR><BR>Task 1.1<BR><BR>a) Calcualte the following information for quarter 1, the 12 weeks ending 24th March 2000<BR><BR>1) the number of production days<BR>2) the closing finished stock for Exe and Wye in units<BR>3) the labour hours available before overtime has to be paid<BR><BR>b) Prepare the following budget in units for Exe and Wye, including any faulty production:<BR><BR>1) the production budget in units for Exe and Wye, including any faulty production<BR>2) the materal purchases budget in litres and value<BR>3) the production labour budget in hours and value, including any overtime payments.<BR><BR>c) Calcualte the savings arising from the change in the required stock levels for the 12 weeks ending 24th March 2000.<BR><BR><BR>Many Thanks<BR><BR>Sebula<BR>

Comments

  • System
    System Posts: 100,534 🤖 Admin 🤖
    need help

    I can mail u the answer if u let me know your email
  • System
    System Posts: 100,534 🤖 Admin 🤖
    need help

    my email is: steviecosty@tiscali.co.uk<BR><BR>many thanks<BR><BR>sebula
Privacy Policy