Prepare the finished and raw materials inventories budget

Assignment Help Finance Basics
Reference no: EM131437383

Question: Lewisham Ltd manufactures one product line - the Zenith. Sales of Zeniths over the next few months are planned as follows:

1. Demand

                                                                          units

                                    July                              180,000

                                    August                         240,000

                                    September                   200,000

                                    October                        180,000

Each Zenith sells for £3.

2. Debtor receipts

    Credit customers (recievables) are expected to pay as follows:

              70% during the month of sale

              28% during the following month

The reminder of the credit customers are expected to go bad (that is, to be uncollectable).

credit customers who pay in the month of sale are entitled to deduct a 2 percent discount from the invoice price.

3. Finished goods inventories Inventories of finished goods are expected to be 40,000 units at 1 July. The business's policy is that, in future, the inventories at the end of each month should equal 20 per cent of the following month's planned sales requirements.

4. Raw materials inventories Inventories of raw materials is expected to be 40,000 kg on 1 July. The business's policy is that, in future, the inventories at the end of each month should equal 50 per cent of the following month's planned production requirements. Each Zenith requires 0.5 kg of the raw material, which costs £1.50 per kg. Raw materials are paid for in the month after purchase.

5. Labour and overheads The direct labour cost of each Zenith is £0.50. The variable overhead element of each Zenith is £0.30. Fixed overheads, including depreciation of £25,000, total £47,000 a month. All labour and overheads are paid during the month in which they arise.

6. Cash in hand The business plans to have a bank balance (in funds) at 1 August of £20,000.

Required: Prepare the following budgets:

(a) Finished inventories budget (expressed in units of Zenith) for each of the three months July, August and September.

(b) Raw materials inventories budget (expressed in kg of the raw material) for the two months July and August.

(c) Cash budget for August and September.

Reference no: EM131437383

Questions Cloud

Discuss the effects of collective trauma : contemplating and discussing the effects of collective trauma upon future generations among American military personnel who have served in combat situations. Use the required reading assignments and other resources to share comparisons and beliefs..
Analysis on the current state of the compensation system : Conduct an analysis on the current state of the compensation system of Google and address the compensation of special groups including executives, role of unions in compensating the employees, any international compensation, and any other extraordina..
Examine different segments of the population : Explain the type of incentive to providers for efficiency in the delivery of healthcare services. Explain who bears financial risk- the provider, the patient or CDHP. Examine different segments of the population describe which socioeconomic group is ..
With a meals on wheels project for the homeless : With a meals on wheels project for the homeless discuss how a customer final approval will be received, the criteria that was met for the customer to agree that the project was successfully completed, the lessons learned as the project is completed. ..
Prepare the finished and raw materials inventories budget : Finished goods inventories Inventories of finished goods are expected to be 40,000 units at 1 July. The business's policy is that, in future, the inventories at the end of each month should equal 20 per cent of the following month's planned sales ..
Review literature related to the unifying-overarching : Reviews literature related to the unifying/overarching them within the core specializations identified. The focus of the literature review is to determine how the topic has been addressed in the available research literature, extending knowledge i..
What is a beta adrenergic receptor : What is a beta adrenergic receptor? What do alpha adrenergic receptors do?
Describe the pathophysiologic changes : Describe the pathophysiologic changes to the immune system when exposed to allergens and the clinical manifestations of these changes.
General characteristics of archaea : What are the general characteristics of archaea? What are the differences between bacteria and archaea.

Reviews

Write a Review

Finance Basics Questions & Answers

  Keenan corporation is expected to maintain a constant 66

keenan co. is expected to maintain a constant 6.6 percent growth rate in its dividends indefinitely. if the company has

  You are considering the purchase of an industrial warehouse

you are considering the purchase of an industrial warehouse. the purchase price is 1 million. you expect to hold the

  The most votes in the upcoming election

A congressman's district has recently been allocated $45 million for projects. The congressman has decided to allocate the money to four ongoing projects. However, the congressman wants to allocate the money in a way that will gain him the most votes..

  What is the net income for pjs last year

The firm's debt ratio was 47%, sales were $38 million, and the capital intensity ratio was .88 times. What is the net income for PJ's last year? (Do not round intermediate steps.)

  This project would require an initial cash outlay of

this project would require an initial cash outlay of 5500000 and would generate annual net cash inflows of 1100000 per

  Harry jones has invested onethird of his funds in share 1

harry jones has invested one?third of his funds in share 1 amp two?thirds of his funds in share 2. his assessment of

  What is the overall rate of return on the portfolio

Using current exchange rates, what is today's value of the investor's portfolio in U.S. dollars if the UK investment decreased 5% (in local currency) and the Japan investment increased 1% (in local currency)?

  Identify the main concerns in analysis of accounts

a. identify the main concerns in analysis of accounts receivable.b. describe information other than that usually

  How much must be saved annully

How much must be saved annully, beginning one year from now, in order to accumulate $10,000 over the next 10 years, earning 12% annually?

  A financial analyst should include interest

A financial analyst should include interest and dividend payments when calculating a project's cash flows.

  Find required additional external capital

The Landis Company had 2004 sales of $100 million. The balance sheet items that vary directly with sales and the profit margin are as follows:

  What is the impact of different accounting treatments

Why is it so important to understand the notes to financial statements when performing an FSA? Of the major types of notes, which, if any, has a greater impact on the results of an FSA? Why? How are the notes used in conjunction with the finan..

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