Question

In: Accounting

Question 2: Budget (20 marks in total) Lulu Company has the following budgeted sales for the...

Question 2: Budget (20 marks in total) Lulu Company has the following budgeted sales for the next six-month period: Month Unit Sales January 48,000 February 84,000 March 60,000 April 72,000 May 48,000 June 80,000 There were 69,000 units of finished goods in inventory at the beginning of January. Plans are to have an inventory of finished products that equals 100% of the following month sales plus 25% of the second month sales. Two kilograms of raw materials are required for each unit produced. From January, each kilogram of material costs $20 (up from $18 in December last year). Inventory levels for materials are equal to 40% of the needs for the next month. Lulu Company uses a FIFO inventory method for both raw material and finished goods. Required: 2a. Prepare a production budgets in units for January and February 2b. Prepare a materials usage budget in kilograms and dollars for January 2c. Prepare a materials purchases budget in kilograms and dollars for January 2d. List and explain some benefits to an organisation of preparing an operating budget, use the textbook and other relevant sources to support your answer

Solutions

Expert Solution

Solution 2a:

Production Budget - Lulu Company
Particulars January February
Sales units 48000 84000
Add: Desired ending inventory (100% of following month sales + 25% of Second month sales) 99000 78000
Less: Opening Inventory 69000 99000
Budgeted production units 78000 63000

Solution 2b:

Material Usage Budget - Lulu Company
Particulars January February
Budgeted production units 78000 63000
Material needed per unit (In Kg) 2 2
Budgeted usage of material (In Kg) 156000 126000
Budgeted usage of material in dollar:
Cost of material used in beginning inventory (156000*40%*$18) $1,123,200.00
Cost of material used from purchase made in january (156000*60%*$20) $1,872,000.00
Total usage of material in dollar $2,995,200.00

Solution 2c:

Material Purchase Budget - Lulu Company
Particulars January
Budgeted usage of material (In Kg) 156000
Add: Desired units of material in ending inventory (40% of next month production needs) (126000*40%) 50400
Less: units of material in beginning inventory 62400
Budgeted purchase of material (In Kg) 144000
Cost per Kg of material $20.00
Budgeted cost of raw material purchases in dollar $2,880,000.00

Solution 2d:

There are various benefits to an organization of preparing the operating budget. Some of are as under:

1. Operating budget helps organization to set direction of various functions. On the basis of budget targets were set for various departmenta and same help in their performance measurement.

2. Operating budget helps the organization in performance evaluation of the company. At the end of reporting period, actual results were compared with budget and root cause is identified if performance in not as per budget and responsibility is fixed.

3. Operating budget also helps in managing the cash flow. After preparing the budget, you have idea regarding collection and payments required for a particulars month and accordingly you can arrange the funds.

4. Operating budget helps the various function to execute the activities as per plan. If things are not happening as per plan, it will help respective function to take necessary steps.


Related Solutions

Question 1: Budget (20 marks in total) You are now preparing the budget for the Sheep...
Question 1: Budget (20 marks in total) You are now preparing the budget for the Sheep Drench department for the months of April and May. Sheep Drench manufacturing costs have been budgeted as follows: Direct materials $ 3.0 per unit Direct labour $ 1.5 per unit Factory overhead Variable $ 0.25 per unit Fixed $ 5,000 per month (Includes $1000 depreciation) Selling and administrative expenses, including depreciation of $400 per month, are all fixed and total $2500 per month. Other...
Question 2 (12 marks) Marsden makes contact tracing tracking devices and has the following sales budget...
Question 2 Marsden makes contact tracing tracking devices and has the following sales budget for the first six months of the year. January 40,000 units February 55,000 units March 60,000 units April 50,000 units May 45,000 units June 40,000 units The inventory of finished goods at the end of each month is budgeted to be 15% of the next month's sales. Due to unexpected sales activity in the prior year, at the beginning of January the finished goods inventory totaled...
6.         Question 6 [Total: 20 marks]                             &
6.         Question 6 [Total: 20 marks]                                                     Please discuss how “variation margin” and “margin call” are related in the context of daily settlement procedure.                                                                                [10 marks] b) What are the most important aspects of the design of a new futures contract?      [10 marks]
Eckert Company has budgeted the following unit sales:
Eckert Company has budgeted the following unit sales: 2016                             Units                                     April                            25,000                                     May                            50,000                                     June                           75,000                                     July                            45,000 Of the units budgeted, 40% are sold by the Southern Division at an average price of $15 per unit and the remainder are sold by the Eastern Division at an average price of $12 per unit. Instructions Prepare separate sales budgets for each division and for the company in total for the second quarter of 2017 by completing the chart. Do NOT...
2. Jo-Jo’s Yo-yos has the following budgeted sales and direct materials purchases: Month Budgeted Sales Budgeted...
2. Jo-Jo’s Yo-yos has the following budgeted sales and direct materials purchases: Month Budgeted Sales Budgeted direct materials purchases January $190,000 $30,000 February $210,000 $35,000 March $300,000 $45,000 Jo-Jo’s Yo-yos’ sales are 40% cash and 60% on credit. It collects credit sales 10% in the month of the sale, 50% in the month following the sale, and 36% in the second month following the sale. 4% of the sales are uncollectible. Jo-Jo’s Yo-yos’ purchases are 50% cash and 50% on...
QUESTION 3 [20 MARKS] PCL (Pty) Ltd gave you the following expenses that were budgeted to...
QUESTION 3 [20 MARKS] PCL (Pty) Ltd gave you the following expenses that were budgeted to produce 10,000 units in their factory as shown below: Pula Materials 70 Labour 25 Variable factory overheads 20 Fixed factory overhead (P100,000) 10 Direct Variable expenses 5 Selling expenses (10% were fixed costs) 13 Distribution expenses (20% were fixed) 7 Fixed Administrative expenses (P50,000) 5 Total cost of sale per unit 155 Required: Prepare a flexible budget for the production of 8,000 units.
Goldman has the following budget plans: Sales are budgeted at $440,000 for November, $420,000 for December,...
Goldman has the following budget plans: Sales are budgeted at $440,000 for November, $420,000 for December, and $410,000 for January. Collections are expected to be 65% in the month of sale and 35% in the month following the sale. The cost of goods sold is 80% of sales. The company would like to maintain ending merchandise inventories equal to 70% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. Other...
Sosa Company has provided the following budget information for the first quarter of 2016 Total sales...
Sosa Company has provided the following budget information for the first quarter of 2016 Total sales $297,500 Budgeted purchases of direct materials 39,450 Budgeted direct labor cost 38,880 Budgeted manufacturing overhead costs: Variable manufacturing overhead 3,645 Depreciation 600 Insurance and property taxes 9,120 Budgeted selling and administrative expenses: Salaries expense 5,000 Rent expense 3,000 Insurance expense 1,200 Depreciation expense 100 Supplies expense 2,975 Additional data related to the first quarter of 2016 for Sosa Company: a. Capital expenditures include $36,000...
-budgeted income statement – direct materials budget – production budget – sales budget -sales budget –...
-budgeted income statement – direct materials budget – production budget – sales budget -sales budget – production budget – direct materials budget – budgeted income statement Who would typically be responsible for the direct material quantity variance? -the production manager -the chief financial officer -the purchasing manager -the human resources manager Which of the following is not a component of the operating budget? -sales budget -selling and administrative budget -Budgeted balance sheet -raw materials purchases budget Top-down budgeting is: -when...
Question 3: Variance Analysis (20 marks in total) The following standard cost data relate to the...
Question 3: Variance Analysis (20 marks in total) The following standard cost data relate to the operation of Dragon Company for 2016. The standard cost per unit is based on the normal annual production of 15,000 units. Standard cost per unit Direct materials 4kg @ $5.00 per kg $ 20.00 Direct labour 2hrs @ $12.50 per hr $ 25.00 Variable overhead 2hrs @ $3.00 per hr $ 6.00 Fixed overhead 2 labour hrs @ $5.00 per hr $ 10.00 Total...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT