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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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