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

  An analysis of the transactions of cavernous homes inc

an analysis of the transactions of cavernous homes inc. yields the following totals at december 31 2009 cash 2200

  What is the markets expectation of the yield

One year Treasury securities yield 5 percent. Three year Treasury securities yield 5.2 percent. Assume the pure expectations theory holds. What is the market's expectation of the yield on two year Treasury securities one year from today?

  Insert the capital letter from the list above

Insert the capital letter from the list above for the best control plan to prevent the system failure from occurring.

  Provide a rationale for the us publicly traded company that

magine that you are a financial manager researching investments for your client that align with its investment goals.

  Estimate of cost of capital with target capital structure

estimate of cost of capital with target capital structure mix of debt and equity.cost of capital coleman technologies

  Concepts of elasticities

Groupon is a popular group purchasing and daily deals website. In a recent advertisement, a local restaurant to sold buffet vouchers at a steep discount on its website.

  How the use of ifrs is enforced within your chosen country

Discuss whether and how the use of IFRS is enforced within your chosen country. Evaluate whether the firm's accounts are comparable with their key global competitors.

  Bank evaluation process

Assume that you are nearing graduation and have applied for a job with a local bank. The bank's evaluation process requires you to take an examination that covers several financial analysis techniques.

  What reservations might you have about relying on the model

The relationship between total operating cost and quantity produced. What reservations might you have about relying on the above model for decision-making purposes?

  Assets and costs are proportional to sales debt and equity

questions 1.the most recent financial statements for live co. are shown hereincome statementbalance

  Discuss your findings in part a, and recommend the preferred

Use a risk-adjusted discount rate approach to calculate the net present value of each project, given that project X has an RADR factor of 1.20 and project Y has an RADR factor of 1.40. The RADR factors are similar to project betas. Discuss your findi..

  Arbitrage and financial decision making

Honda Motor Company is considering offering a $2000 rebate on its minivan, lowering the vehicle's price from $30,000 to $28,000. The marketing group estimates that this rebate will increase sales over the next year from 40,000 to 55,000 vehicles. Sup..

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