The current year actual production is 3000 , now there is a increase of 50% then the revised budgeted production is 4500 units. Variable cost can be evaluated on dividing cost for 2000 units by 2000 units. Eg.-
Direct material cost per unit= 6000/2000
=£3 per unit
Now you can multiply it with 4500 units to calculate revised
budgeted cost.
2.1 A business has prepared a fixed budget for the coming financial year, as shown below:...
SalesUnit sales for November 2019114,000Unit sales for December 2019103,000Expected unit sales for January 2020114,000Expected unit sales for February 2020111,000Expected unit sales for March 2020116,000Expected unit sales for April 2020125,000Expected unit sales for May 2020136,000Unit selling price$12Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts...
Using marginal cost format, prepare a flexible budget
for 17,200 units and show all the variances indicating which are
favourable and which are adverse. Suggest a possible reason for
each variance. [14 marks]
b) Flexible budgets have been prepared for two output levels as follows; Production and sales 15000 20000 Sales revenue £ 150000 200000 Direct materials Direct labour Depreciation Maintenance 105000 15000 1500 2000 140000 20000 1500 2400 Total costs 123500 163900 Profit 26500 36100 Actual production and sales...
Grizzly Corporation manufactures a single product. Monthly production costs incurred in the manufacturing process are shown below for the production of $3000 units. The utilities and maintenance costs are mixed costs. The fixed portions of these costs are $300 and $200 respectively. Production in Units – 3000 Production costs Direct materials $7500.00 Direct labour $15000.00 Utilities $1800.00 Property taxes $1000.00 Indirect labour $4500.00 Supervisory salaries $1800.00 Maintenance $1100.00 Depreciation $2400.00 Answer the following questions about the company. a) Identify each of the costs...
Flexible Budget for Varying Levels of Activity
Nashler Company has the following budgeted variable costs per
unit produced:
Direct materials
$7.10
Direct labor
1.54
Variable overhead:
Supplies
0.23
Maintenance
0.19
Power
0.17
Budgeted fixed overhead costs per month include supervision of
$98,000, depreciation of $77,000, and other overhead of
$248,000.
Required:
1. Prepare a flexible budget for all costs of
production for the following levels of production: 160,000 units,
170,000 units, and 175,000 units. Round your answers to the nearest...
Tempo Company's fixed budget (based on sales of 16.000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget $3,248,000 Sales (16,000 units) Cost of goods sold Direct materials Direct labor Production supplies Plant manager salary Gross profit Selling expenses Sales commissions Packaging Advertising Administrative expenses Administrative salaries Depreciation-office equip. Insurance Office rent $368,000 672,000 416,000 168,000 1,624,000 1,624,000 128,000 256,000 100,000 484,000 218,000 188,000 158,000 168,000 732,000 Income from operations 408,000 Compiete the following flexible...
Mozena Corporation manufactures a single product. Monthly production costs incurred in the manufacturing process are shown below for the production of 3,500 units. The utilities and maintenance costs are mixed costs. The fixed portions of these costs are $460 and $380, respectively. Production in Units 3,500 Production Costs Direct materials $7,840 Direct labour 15,435 Utilities 1,790 Property taxes 1,030 Indirect labour 4,620 Supervisory salaries 2,100 Maintenance 1,290 Depreciation 2,450 Identify the costs as variable, fixed, or mixed. Cost Direct materials...
tempo company’s fixed budget based of 12000 units
Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter of calendar year 2017 reveals the following! Fixed Budget $2.460.000 $275,000 516,000 324,000 76,000 1, 192,000 1.268,000 Sales (12,000 units) Cost of goods sold Direct materials Direct labor Production supplies Plant manager salary Gross profit Selling expenses Sales commissions Packaging Advertising Administrative expenses Administrative salaries Depreciation office equip. Insurance office rent Income from operations 84,000 180,000 100,000 354.000...
Exercise 9-11 (Video)
Atlanta Company is preparing its manufacturing overhead budget for
2020. Relevant data consist of the following.
Units to be produced (by quarters): 10,700, 12,500, 14,800,
16,800.
Direct labor: Time is 1.5 hours per unit.
Variable overhead costs per direct labor hour: indirect
materials $0.70; indirect labor $1.20; and maintenance $0.70.
Fixed overhead costs per quarter: supervisory salaries $36,290;
depreciation $18,530; and maintenance $13,420.
Prepare the manufacturing overhead budget for the year, showing
quarterly data. (Round overhead rate...
Budget Actual Units produced 10,000 11,050 Materials used in production 400 kg ? Material Costs $ 8,000 ? Direct Labour (Hours) 35,000 hrs 41,010 hrs Direct Labour Costs $ 385,000 $450,951 Variable Overhead Costs $ 350,000 $411,441 Fixed Overhead Costs $ 160,000 $136,358 Other Information Overhead is Allocated on Direct Labour Hours During the year, 602 kg of materials were purchased for $12,000 Beginning Direct Material Inventory: none Ending Direct Material Inventory: 39kg Required: Calculate the following variances Material Rate Material Efficiency Labour Price Labour Efficiency Variable...
CC Corp estimated the following financial data, for the 2020 production budget: Sales of 122,000 units Sales price of $40 per unit Variable expenses of $9.90 per unit Fixed costs of $3,050,000 for the year At year end, actual sales data and costs were: Sales of 125,000 units Sales price of $38 per unit Variable expenses of $10.50 per unit Fixed costs of $3,000,000 for the year Create an Income Statement Performance Report, including favourable/unfavourable ratings for all Flex Budget...