Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Dale Ltd just started business and manufactures a single Product A. The product details are as follows: Selling price per unit of Product A: 80
Dale Ltd just started business and manufactures a single Product A. The product details are as follows: Selling price per unit of Product A: 80 Particulars Quantity of inputs per unit of Product A Price () Direct material 4 kg 9/kg Direct labour 5 hours 13/hr Dale Ltd is considering its budget for the next year and has made the following estimates of sales demand in units for the Product A from July to October Month Original Sales in units New Sales in units July 430 August 450 September 520 October 580 It is company policy to hold closing stocks (ending inventories) of finished goods at the end of each month equal to 60% of the following months sales demand. There is no opening stock (beginning inventories) of finished goods at the beginning of July. The inventory (stock) details of the direct materials are budgeted as follows: Particulars June July August September Closing Stock in kgs (Ending Inventory) 280 270 310 290 Additional information: (1) The opening cash balance on 1st July is 6,500. (2) Cash is collected from customers for sales in the following manner: Month of sale (after giving them 2% cash discount) 25% Month following the sale 50% Two months following sale 20% Amount uncollectible (bad debts) 5% There were no sales receipts prior to July. (3) (35% of purchases are paid for in cash in the month of purchase, and the balance is paid in the following month. The purchases made in June were 2,520. (4) Labour charges of 3,500 per month are paid every month. (5) Overheads are incurred at 1,200 per month out of which 200 per month is depreciation on machinery. (6) The company paid 7,500 to buy a machine in September. Prepare the following budgets for July, August and September: 1.Prepare a sales budget for Product A in amount (). 1.5 marks 2.Prepare a production budget for Product A in units. 3 marks 3.Prepare a raw material budget in kgs and in amount (). 6 marks 4.Prepare a direct labour budget in amount (). 1.5 marks 5.Prepare a cash budget showing cash inflows (receipts) and cash outflows (payments) for July, August and September, showing the final closing cash balance at the end of each month. 8 marks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started