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 1 year 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...

A company's flexible budget for 5,732 units of production showed sales $112,768; variable costs $42,130; and...

A company's flexible budget for 5,732 units of production showed sales $112,768; variable costs $42,130; and fixed costs $22,109. The flexible budget operating income expected if the company produces and sells 4,249 units is: Answer to nearest whole dollar without any commas, decimal points, or words (e.g. 1000 not 1,000.00 or increase 1000). Enter a negative number as -10 not (10).