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

  What would be the present value of the loan

FIN 100- At what amount could this loan be sold for to another bank if loans of similar quality carried an 8.5 percent interest rate? That is, what would be the present value (PV) of this loan?

  Calculate company a’s weighted average cost of debt

Calculate Company A’s weighted average cost of debt, given the following information: (a) Tax Rate: 25%, (b) Average Price of Outstanding Bonds: $975, (c) Coupon Rate: 4%, (d) NPER: 25, (e) Debt: $23,000,000, (f) Equity: $20,000,000, and (g) Preferre..

  Significant factors driving your decision as a financial ma

Provide a rationale for the U.S. publicly traded company that you selected, indicating the significant factors driving your decision as a financial manager.

  Appropriate categories of revenue and expenses

Prepare a one-page income statement for the first year of the business you are planning to open, using appropriate categories of revenue and expenses.

  How do we model the government’s payment of the tax rebate

Why is the (1 − tax rate) in the WACC? How do we model the government’s payment of the tax rebate on interest—through a flow or in the rate?

  Performing vertical analysis using excel

Performing Vertical Analysis using Excel and Performing Horizontal Analysis using Excel, which demonstrate the completion of vertical and horizontal analysis using Excel.

  Compute the company’s current ratio

Compute the company's current ratio if it invests $50,000 of the borrowed funds in fixed assets and keeps the rest as cash or short-term investments. To what dollar amount can current liabilities grow before the company violates the debt contract?

  How is hedging different when using futures vs. forwards

How is hedging different when using futures vs. forwards?

  Explain why some companies that issue bonds engage in

explain why some companies that issue bonds engage in interest rate swaps in financial markets. why do they not simply

  Calculating maturity risk premium

The real risk free rate is 3 percent, and inflation is expected to be 3 percent for the next 2 years. A 2-year Treasury security yields 6.2 percent.

  What is its weighted average cost of capital

A company has 100 million shares outstanding trading for $8 per share. It also has $900 million in outstanding debt. If its equity cost of capital is 15%, and its debt cost of capital is 12%, and its effective corporate tax rate is 40%, what is its w..

  Should the project be purchased

Compute both the traditional payback period (PB) and the discounted payback period (DPB) for a project that costs $270,000 if it is expected to generate $75,000 per year for five years? The firm's required rate of return is 11 percent. Should the ..

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