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

Solutions

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

Related Solutions

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?
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).
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT