Production Budget is a budget which describes us the actual units to be Manufactured , it tell the company how much inventory to be maintained for future sales ,
production Budget Comprises of all the expenses ,raw material ,labour and over heads which are required to produce the goods
statement showing the Budget for the production for 8000 units
| Particulars | RAte /per qty | Amount ( 8000units) | Total |
| Material | 70 | 8000*70 | 560000 |
| Labour | 25 | 8000*25 | 200000 |
| VAriable overhead ( direct ) | 5 | 8000*5 | 40000 |
| Total Prime cost | 100 | 8000*100 | 800000 |
| Add Production Overheads : | |||
| Fixed overhead | 12.5 (100000/8000) | 8000*12.5 | 100000 |
| Variable Over heads | 20 | 8000*20 | 160000 |
| Work cost | 132.5 | 8000*132.5 | 1060000 |
| Add Administrative expenses ( fixed) | 6.25 =(50000/8000) | 8000*6.25 | 50000 |
| Cost of Production | 138.75 | 8000*138.75 | 1110000 |
| Add selling Expense : | |||
| Fixed 10% of 13 # | 1.63 =(13000/8000) | 8000*1.63 | 13000 |
| variable 90% of 13 | 11.70 | 8000*11.70 | 93600 |
| Add distribution expenses | |||
| Fixed 20% of 7 ## | 1.75 = (14000/8000) | 8000*1.75 | 14000 |
| Variable 90% of 7 | 5.60 | 8000*5.60 | 44800 |
| Total cost of sales | 159.43 | 8000*159.43 | 1275400 |
B) statement showing the Budget for the production for 6000 units
| Particulars | RAte /per qty | Amount ( 6000units) | Total |
| Material | 70 | 6000*70 | 420000 |
| Labour | 25 | 6000*25 | 150000 |
| VAriable overhead ( direct ) | 5 | 6000*5 | 30000 |
| Total Prime cost | 100 | 6000*100 | 600000 |
| Add Production Overheads : | |||
| Fixed overhead | 16.6667 =(100000/6000) | 6000*16.6667 | 100000 |
| Variable Over heads | 20 | 6000*20 | 120000 |
| Work cost | 136.6667 | 6000*136.6667 | 820000 |
| Add Administrative expenses ( fixed) | 8.3333 =(50000/6000) | 6000*8.3333 | 50000 |
| Cost of Production | 145 | 6000*145 | 870000 |
| Add selling Expense : | |||
| Fixed 10% of 13 # | 2.1666 =(13000/6000) | 6000*2.1666 | 13000 |
| variable 90% of 13 | 11.70 | 6000*11.70 | 70200 |
| Add distribution expenses | |||
| Fixed 20% of 7 ## | 2.3333 = (14000/6000) | 6000*2.3333 | 14000 |
| Variable 90% of 7 | 5.60 | 6000*5.60 | 33600 |
| Total cost of sales | 166.7999 | 6000*166.7999 | 1000800 |
Working
Fixed cost is a cost which doesnot change as its remain the fixed , fixed cost occur if there is no production also so all the fixed cost on 10000 units will same for 8000 units and 6000 units
# Fixed selling expenses
10% of 13 = 1.3
1.3 is for 10000 units
so total fixed cost = 10000*1.3=13000
so fixed cost for 8000 units = 13000
and fixed cost for 6000 units = 13000
## Fixed distrubition expenses'
20% of 7 = 1.40
1.40*10000= 14000
so for 8000 units = 14000
and 6000 units = 14000
Variable expenses is expense which varies as per qty of production
15155 SECTION D Compulsory den 10.000 s the budget for t ory 1. A tak Pued...
Section B Question No. 02 - Compulsory Live Lid produces two products namely as R and N. You are given following information 1) Budgeted direct cost per unit for two products for the year 2017 are as follows. Rs. 400 500 450 Material A-2 Kg at Rs.200 per kg 2.5 Kg at Rs.200 per kg Material B - 1.5 Kg at Rs. 300 per kg 2 Kg at Rs. 300 per kg Direct Labour - 3 hours at Rs. 600...
Question 1. Dandy’s manufacturers Company Ltd, makers of product Y has prepared its budget for 2018, based on two activity levels of 80% and 100% with production units of 2800 and 3500 units respectively. The budget is as follows 80% 100% Sales $224000 $2800000 Direct material 84000 105000 Direct labour 50400 63000 Production overhead 48800 53000 The company’s actual result for the period is as follows Sales in Units 3150 units Sales $252000 Direct material $ 94000 Direct Labour ...
EXHIBIT 1 Budget for the quarter ending 31 March 2019 Euros Budget sales 200,000 Cost of production 149,500 Gross margin 50,500 Administration expenses 19,900 Distribution expenses 5,700 Sales commission 20,000 Financial expenses 800 46,400 Budgeted Net Profit 4,100 EXHIBIT 2 Schedule of Revenue and Production Costs per Product. Product A B C D Sales price 20 40 30 20 Direct material (imported) 7 16 13 10 Direct labour and packing 3 4 6 4 Production overhead 4 5 6 5...
create the initial documents for the master budget:
• sales budget
• production budget
• direct materials purchases budget
• direct labor budget
• overhead budget
• selling and administrative expense budget
• cash budget include a schedule of cash collections and
payments
• finished goods inventory calculation
Then, Create the following schedules, financial statements, and
calculations
A) Pro forma cost of goods manufactured
B) Pro forma Cost of goods sold- both financial and variable
cost basis
C) Pro forma...
Answer all the questions .Each question carries 5 Marks 1) From the following data prepare a flexible budget for production of 40000 units,50000 units and 75,000 units clearly show variable cost ,fixed cost, and total cost. Also indicate the element wise cost per unit Budgeted output is 100,000 units and the budgeted cost per unit is given below Direct Material AED 95/unit. Direct Labour AED 50/unit. Production over Head (variable) AED40/unit. Production overhead (fixed) AED5/unit. Administration overhead (fixed) AED 5/unit....
Create These budgets:
-selling and administrative expense budget
-cash budget include a schedule of cash collections and
payments
-finished goods inventory calculation
Then, Create the following schedules, financial statements, and
calculations
A) Pro forma cost of goods manufactured
B) Pro forma Cost of goods sold- both financial and variable
cost basis
C) Pro forma income statement (financial basis)
D) Pro forma balance sheet
E)Pro forma Income statement (variable cost basis)
F) Pro forma statement of retained earnings
G) breakeven analysis:...
Section B - Please answer ALL questions. Question 1 Dudley Manufacturing is preparing its master budget for the first month of the upcoming year. The following data pertain to Far East Manufacturing's operations: • Account Balances as at December 31(prior year): Cash RM4,500 * Account Receivable, net RM50,000 Inventory RM15,000 Account Payable RM42,400 Actual sales in December were RM70,000. Selling price per unit is projected to remain stable at RM10 per unit throughout the budget period. Sales for the first...
Anwser all questions and Show work
1 Carr Company provides human resource consulting services to small and medium-sized companies. Last year, Carr provided services to 700 clients. Total fixed costs were $159,000 with total variable costs of $87,500. Based on this information, complete this chart: (10 points) Solution 500 clients 800 clients 900 clients Total costs Fixed costs Variable costs Total costs Cost per client Fixed cost Variable cost Total cost per client $ 159,000 62.500 22500 $159.000 100000 254.000...