Raw materials inventories budget

Assignment Help Accounting Basics
Reference no: EM131097256

Q: Brown and Jeffrey s, a West Midlands business, makes one standard product for use in the motor tr

Brown and Jeffrey s, a West Midlands business, makes one standard product for use in the motor trade. The product, known as the Fuel Miser, for which the business holds the patent, when fitted to the fuel system of production model cars has the effect of reducing petrol consumption. Part of the production is sold direct to a local car manufacturer, which fits the Fuel Miser as an optional extra to several of its models, and the rest of the production is sold through various retail outlets, garages, and so on. Brown and Jeffrey s assemble the Fuel Miser, but all three components are manufactured by local engineering businesses. The three components are codenamed A, B and C. One Fuel Miser consists of one of each component .The planned sales for the first seven months of the forthcoming accounting period, by channels of distribution and in terms of Fuel Miser units, are as follows:

Jan

Feb

Mar

Apr

May

June

July

Manufacturers

4,000

4,000

4,500

4,500

4,500

4,500

4,500

Retail, and so on

2,000

2,700

3,200

3,000

2,700

2,500

2,400


6,000

6,700

7,700

7,500

7,200

7,000

6,900

The following further information is available:

1 There will be inventories of finished units at 1 January of 7,000 Fuel Misers.

2 The inventories of raw materials at 1 January will be:

A 10,000 units

B 16,500 units

C 7,200 units

3 The selling price of Fuel Misers is to be £10 each to the motor manufacturer and £12 each to retail outlets.

4 The maximum production capacity of the business is 7,000 units a month. There is no possibility of increasing this output.

5 Assembly of each Fuel Miser will take 10 minutes of direct labour. Direct labour is paid at the rate of £7.20 an hour during the month of production.

6 The components are each expected to cost the following:

A £2.50

B £1.30

C £0.80

7 Indirect costs are to be paid at a regular rate of £32,000 each month.

8 The cash at the bank at 1 January will be £2,620.

The planned sales volumes must be met and the business intends to pursue the following policies for as many months as possible, consistent with meeting the sales targets:

  • Finished inventories at the end of each month are to equal the following month's total sales to retail outlets, and half the total of the following month's sales to the motor manufacturer.
  • Raw materials at the end of each month are to be sufficient to cover production requirements for the following month. The production for July will be 6,800 units.
  • Suppliers of raw materials are to be paid during the month following purchase. The payment for January will be £21,250.
  • Customers will pay in the month of sale, in the case of sales to the motor manufacturer, and the month after sale, in the case of retail sales. Retail sales during December were 2,000 units at £12 each.

Required: Prepare the following budgets in monthly columnar form, both in terms of money and units (where relevant), for the six months of January to June inclusive:

(a) Sales budget.*

(b) Finished inventories budget (valued at direct cost).†

(c) Raw materials inventories budget (one budget for each component).†

(d) Production budget (direct costs only).*

(e) Trade receivables budget.†

(f) Trade payables budget.†

(g) Cash budget.†

* The sales and production budgets should merely state each month's sales or production in units and in money terms. The other budgets should all seek to reconcile the opening balance of inventories, trade receivables, trade payables or cash with the closing balance through movements of the relevant factors over the month.

Reference no: EM131097256

The annual depreciation worked out

On January 1, 20X1, Robust Inc. purchased heavy-duty equipment for $400,000. On the date of installation, it was estimated that the machine has a useful life of 10 years an

Available on dollar-denominated bonds

Exchange Rate Effects Katina, Inc., is a U.S. firm that plans to finance with bonds denominated in euros to obtain a lower interest rate than is available on dollar-denomina

The requirements to elect s corporation status

1)In 2014, Tony and Rhonda acquired land for $600,000, with Tony furnishing $200,000 and Rhonda $400,000 of the purchase price. Title to the property is listed as equal join

Prepare an unadjusted trial balance

(a) Prepare an unadjusted trial balance, listing the accounts in their proper order.  (b) Based upon the unadjusted trial balance, determine the net income or net loss.

How much must you deposit at the end of each year in an

What will a deposit of $4,500 at 10% compounded semi-annually be worth if left in the bank for six years. How long does it take for $5,000 to grow into $6,724.44 at 10% compou

Did the amount of cash in-crease or decrease

In a recent business transaction, land was exchanged for cash. Did the amount of cash in-crease or decrease - One entity sold land. The other entity bought land. For the entit

What are steps involved in conducting comparable valuations

Explain how "relative valuation" works. What are the primary steps involved in conducting comparable valuations? Give some examples of common valuation "multiples" used.

Calculate the annual forward rates for one year

At the beginning of 2009, the Market Place was concerned with interest rate levels and the possibility of inflation. Calculate the annual forward rates for one year and two ye

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd