Question

In: Accounting

URGENT 7.(a)From the following data prepare a flexible budget for production of 40000 units clearly showing...

URGENT
7.(a)From the following data prepare a flexible budget for production of 40000 units clearly

showing variable cost, fixed cost, and total cost. Budgeted capacity output is 1 lakh units and

the budgeted cost per unit is given below: (7.5+7.5=15 marks)

Direct Material Rs 95/unit.

Direct Labour Rs 50/unit.

Production overhead (75% variable) Rs 40/unit.

Administration overhead (100% fixed) Rs 5/unit.

Selling overhead (20% fixed) Rs10/unit.

(b) Prepare a Production Budget for the six months period ending on 30th June,2017 and find total

Production.

Stocks for the budgeted period:

Product As on 01 January, 2017 As on 30 June, 2017

A 6,000 10,000

B 9,000 8,000

other relevant data:

Product Normal loss in production Requirement to fulfill sales programme (units)

A 4% 60,000

B 2% 50,000

Expert Solution

a)	Flexible Budget

	Production			40000	units

	Variable Costs:
	Direct Material	(40000 x Rs. 95)		₹ 38,00,000.00
	Direct Labor	(40000 x Rs. 50)		₹ 20,00,000.00
	Production OH	(40000 x Rs. 40 x 75%)		₹ 12,00,000.00
	Selling OH	(40000 x Rs. 10 x 80%)		₹ 3,20,000.00
	Total Variable Costs		(A)	₹ 73,20,000.00

	Fixed Costs:
	Production OH	(100000 x Rs. 40 x 25%)		₹ 10,00,000.00
	Administrative OH	(100000 x Rs. 5)		₹ 5,00,000.00
	Selling OH	(100000 x Rs. 10 x 20%)		₹ 2,00,000.00
			(B)	₹ 17,00,000.00

	Total Cost		(A+B)	₹ 90,20,000.00

b)	Production Budget

	Particulars		A	B

	Estimated sales (in units)		60000	50000
Add:	Desired closing stock		10000	8000
			70000	58000
Less:	Estimated opening stock		6000	9000
	Estimated net production		64000	49000
Add:	Normal loss	(W.N.1)	2667	1000
	Estimated gross production		66667	50000

W.N.1

Normal Loss of A	=	64000 x 4/96
	=	2666.667

Normal Loss of B	=	49000 x 2/98
	=	1000

ekkarill92 answered 3 years ago

Using the following budgeted information for production of 9,000 and 14,000 units, prepare a flexible budget...

Using the following budgeted information for production of 9,000 and 14,000 units, prepare a flexible budget for 19,000 units. Lens Junction sells lenses for $45 each and is estimating sales of 16,000 units in January and 19,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $20 per hour. Desired inventory levels are: Jan. 31 Feb....

Using the following budgeted information for production of 9,000 and 15,000 units, prepare a flexible budget...

Using the following budgeted information for production of 9,000 and 15,000 units, prepare a flexible budget for 18,000 units. Production 9,000 units 15,000 units Expense A $14,400 $24,000 Expense B 22,000 22,000 Expense C 43,000 43,000 Total expenses $? 2. The production cost for a waterproof phone case is $6 per unit and fixed costs are $24,000 per month. How much is the favorable or unfavorable variance if 5,600 units were produced for a total of $57,100? Enter the amount...

Use the following data to prepare a flexible budget for possible sales/production levels of 5,000, 5,500,...

Use the following data to prepare a flexible budget for possible sales/production levels of 5,000, 5,500, and 6,000 units. Make sure to show the contribution margin at each activity level. Sales price $11.00 per unit Variable costs: Manufacturing $6.00 per unit Administrative $1.50 per unit Selling $.50 per unit Fixed costs: Manufacturing $14,000 Administrative $5,000

Prepare a flexible income statement budget for three production levels of Crow Co. Production: 150,000 units;...

Prepare a flexible income statement budget for three production levels of Crow Co. Production: 150,000 units; 180,000 units, 200,000 units. Price per unit: $120 Costs: Direct Material: 10% of total revenues, Direct Labor: 15% of total revenues, Factory Overhead: 5% of total revenues. Fixed Costs = $78,000 Expenses: Administrative Expenses: 15% of Gross Profit, Selling Expenses: 10% of Gross Profit Crow Co. Flexible Income Statement, Dec/31/20XY Production Level 150,000 180,000 200,000 Revenues

A. Complete a flexible budget for 20,000 units produced. Use the following information at a production...

A. Complete a flexible budget for 20,000 units produced. Use the following information at a production level of 15,000 units to complete the flexible budget: Budgeted units 15,000 Revenue $1,500,000 Expenses: Wages and Salaries ($200,000 + $10Q) $350,000 Utilities (variable) $300,000 Depreciation (fixed) $200,000 Total expenses $850,000 Net operating income $650,000 Q = units produced Budgeted units 20,000 Revenue Expenses: Wages and Salaries ($200,000 + $10Q) Utilities (variable) Depreciation (fixed) Total expenses Net operating income B. Calculate the activity variances...

1. A company's flexible budget for the range of 26,000 units to 40,000 units of production...

1. A company's flexible budget for the range of 26,000 units to 40,000 units of production showed variable overhead costs of $3.80 per unit and fixed overhead costs of $69,000. The company incurred total overhead costs of $169,400 while operating at a volume of 40,000 units. The total controllable cost variance is: 2. Parallel Enterprises has collected the following data on one of its products. During the period the company produced 25,000 units. The direct materials price variance is: Direct...

How do you prepare a flexible budget?

Assume no safety inventory Prepare a flexible income statement budget for three production levels of Crow...

Assume no safety inventory Prepare a flexible income statement budget for three production levels of Crow Co. Production: 5,000 units; 8,000 units, 10,000 units. Price per unit: $45 Costs of Goods Sold: Direct Material: 11% of total revenues, Direct Labor: 12% of total revenues, Factory Overhead: 5% of total revenues. Fixed Costs = $8,000 Expenses: Administrative Expenses: 5% of Gross Profit, Selling Expenses: 10% of Gross Profit. Tax Expense: 20% of operating profit Crow Co. Flexible Income Statement, Dec/31/20XY Production...

1. M&M Company decided to prepare a flexible budget using the following data: a) Sales price-$50...

1. M&M Company decided to prepare a flexible budget using the following data: a) Sales price-$50 per unit b) Direct Materials -$10 per unit c) Direct labor-$20 per unit d) Variable Overhead-$5 per unit e) Fixed Overhead $100,000 Prepare a flexible budget using the numbers listed above for 20,000, 30,000, and 40,000 units. Make sure your budget includes Contribution margin and Net Income. 2. M&M Company sold 30,000 units. Here are their actual numbers. Determine how much each actual number...

At a sales level of 30,000 the budget data for labor is as follows: 40000 hours...

At a sales level of 30,000 the budget data for labor is as follows: 40000 hours at $15 an hour. The actual data was 40000 hours at $11.25 an hour. Compute the Labor Rate Variance. Compute the Labor Efficiency Variance. What do you think could have caused the Direct Materials amount to be so high? List as many reasons as you can. For each reason listed, tell what the company can do to correct the situation. Use complete sentences and...