Alex ltd started its operations

Reference no: EM131061668

Alex Ltd started its operations from 1 Jan 2013. Its budgeted sales for the next 6 months are as follows: Sales Revenue (Units) January 2,000 February 2,200 March 2,300 April 2,400 May 2,600 June 2,800 The selling price per unit is expected to be £30 per unit. All sales will be made on credit. For each monthly sales, customers pay 30% in the same month and the remaining 70% in the following month. The direct labour cost is fixed at £12,000 per month and is paid in the same month. Overhead costs are planned to be £8,000 each month including £2,000 for depreciation. Overhead costs are paid in the same month. For raw material purchases, the cost of raw material is 10% of units sold every month and it is paid two month in arrears. Company bought the equipment for £150,000 in Jan and payment was made over April to June. Opening cash balance at the start of Jan (1st) is £70,000. Required: Draw up a cash budget for the 6 months from 1 January to 30 June, with a column for each month. The budget should, among other things, show each end-of-month cash balance.

Reference no: EM131061668

Questions Cloud

Instability along frontal boundary : The forecast product you read on August 30 mentions that a cold front with instability along frontal boundary will be moving through your locality in northern Iow The weather event you are likely to be most concerned about during this frontal pass..

How much of each good will each consumer choose : Suppose the government transfers 100 units of B's good 1endowment to A. How will the consumers' choices of good 1 in competitiveequilibrium change? Explain. (You should answer without repeating the utilitymaximization calculations.)

Broussard company reported net income : Broussard Company reported net income of $2.9 million in 2014 Depreciation for the year was $504,000; account receivable increased $484,000; and accouts payable increased $284,000. Compute net cash flow from operating activities using the indirect..

Would this be good or bad for the economy : What are M1 and M2? What impact would this action (pulling money from checking accounts) have on the size of the M1 and M2 components of the money supply?

Alex ltd started its operations : Alex Ltd started its operations from 1 Jan 2013. Its budgeted sales for the next 6 months are as follows: Sales Revenue (Units) January 2,000 February 2,200 March 2,300 April 2,400 May 2,600 June 2,800 The selling price per unit is expected to be ..

What was the rate of increase for these automobiles : What was the rate of increase for these automobiles between the two time periods?

Explain how the money multiplier is supposed to work : Briefly explain in words how the money multiplier is supposed to work (i.e., how, under normal financial circumstances, a Fed purchase of Treasury securities is said to result in a multiplied expansion of the quantity of money in circulation)

Describing the nature of economics : Consider the use of thought experiments, the theory of value and the time factor.

The ending inventory shown in the trial balance : On September 30, 20X8, Wilfred Company sold inventory to Jackson Corporation, its Canadian subsidiary. The goods cost Wilfred $30,000 and were sold to Jackson for $40,000, payable in Canadian dollars. The goods are still on hand at the end of the ..

User Account

All Pages