Exercise 23-6 Preparing a flexible budget report LO P1 Lewis Co. reports the following results for...

Exercise 23-6 Preparing a flexible budget report LO P1

Lewis Co. reports the following results for May. Prepare a flexible budget report showing variances between budgeted and actual results.

	Budgeted				Actual
Sales		$	1,050	per unit	$	1,678,000
Variable expenses		$	420	per unit	$	652,000
Fixed expenses (total)		$	147,500		$	137,000
Units produced and sold			1,350			1,550

List variable and fixed expenses separately. (Indicate the effect of each variance by selecting for favorable, unfavorable, and no variance)

LEWIS CO.
Flexible Budget Performance Report
For Month Ended May 31
	Flexible Budget	Actual Results	Variances	Fav./Unf.

Solutions

Expert Solution

Particulars	Flexible budget	Actual	Variance	Nature
Units	1,550

Sales	$ 1,627,500	$ 1,678,000	$ 50,500	F
Variable expenses	$ 651,000	$ 652,000	$ (1,000)	U
Fixed expenses	$ 147,500	$ 137,000	$ 10,500	F
	$ -	$ -	$ -
Net profit	$ 829,000	$ 889,000	$ (60,000)	U

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Exercise 23-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 12,000...

Exercise 23-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the following. Fixed Budget Sales (12,000 units × $212 per unit) $ 2,544,000 Cost of goods sold Direct materials $ 300,000 Direct labor 528,000 Production supplies 336,000 Plant manager salary 100,000 1,264,000 Gross profit 1,280,000 Selling expenses Sales commissions 96,000 Packaging 168,000 Advertising 100,000 364,000 Administrative expenses Administrative salaries 150,000 Depreciation—office equip. 120,000 Insurance 90,000 Office rent 100,000...

Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix...

Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 18,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 4,050,000 Cost of goods sold Direct materials $ 990,000 Direct labor 270,000 Machinery repairs (variable cost) 72,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($54,000 is variable) 214,000 Plant management...

Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix...

Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 16,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,200,000 Cost of goods sold Direct materials $ 960,000 Direct labor 240,000 Machinery repairs (variable cost) 48,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($32,000 is variable) 182,000 Plant management...

Exercise 21-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 12,000...

Exercise 21-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the following. Fixed Budget Sales (12,000 units × $213 per unit) $ 2,556,000 Cost of goods sold Direct materials $ 300,000 Direct labor 528,000 Production supplies 324,000 Plant manager salary 100,000 1,252,000 Gross profit 1,304,000 Selling expenses Sales commissions 96,000 Packaging 192,000 Advertising 100,000 388,000 Administrative expenses Administrative salaries 150,000 Depreciation—office equip. 120,000 Insurance 90,000 Office rent 100,000...

Exercise 21-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 10,000...

Exercise 21-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter reveals the following. Fixed Budget Sales (10,000 units × $211 per unit) $ 2,110,000 Cost of goods sold Direct materials $ 230,000 Direct labor 440,000 Production supplies 270,000 Plant manager salary 30,000 970,000 Gross profit 1,140,000 Selling expenses Sales commissions 70,000 Packaging 160,000 Advertising 100,000 330,000 Administrative expenses Administrative salaries 80,000 Depreciation—office equip. 50,000 Insurance 20,000 Office rent 30,000...

Exercise 21-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 16,000...

Exercise 21-2 Preparing flexible budgets LO P1 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 Sales (16,000 units) $ 3,232,000 Cost of goods sold Direct materials $ 384,000 Direct labor 688,000 Production supplies 432,000 Plant manager salary 184,000 1,688,000 Gross profit 1,544,000 Selling expenses Sales commissions 144,000 Packaging 240,000 Advertising 100,000 484,000 Administrative expenses Administrative salaries 234,000 Depreciation—office equip. 204,000 Insurance 174,000 Office rent 184,000...

Exercise 08-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 10,000...

Exercise 08-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter reveals the following. Fixed Budget Sales (10,000 units × $213 per unit) $ 2,130,000 Cost of goods sold Direct materials $ 250,000 Direct labor 420,000 Production supplies 280,000 Plant manager salary 50,000 1,000,000 Gross profit 1,130,000 Selling expenses Sales commissions 90,000 Packaging 150,000 Advertising 100,000 340,000 Administrative expenses Administrative salaries 100,000 Depreciation—office equip. 70,000 Insurance 40,000 Office rent 50,000...

Exercise 08-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 10,000...

Exercise 08-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter reveals the following. Fixed Budget Sales (10,000 units × $219 per unit) $ 2,190,000 Cost of goods sold Direct materials $ 240,000 Direct labor 440,000 Production supplies 270,000 Plant manager salary 40,000 990,000 Gross profit 1,200,000 Selling expenses Sales commissions 80,000 Packaging 160,000 Advertising 100,000 340,000 Administrative expenses Administrative salaries 90,000 Depreciation—office equip. 60,000 Insurance 30,000 Office rent 40,000...

Exercise 21-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 14,000...

Exercise 21-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (14,000 units) $ 2,856,000 Cost of goods sold Direct materials $ 350,000 Direct labor 616,000 Production supplies 364,000 Plant manager salary 150,000 1,480,000 Gross profit 1,376,000 Selling expenses Sales commissions 112,000 Packaging 210,000 Advertising 100,000 422,000 Administrative expenses Administrative salaries 200,000 Depreciation—office equip. 170,000 Insurance 140,000 Office rent 150,000...

Exercise 21-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 10,000...

Exercise 21-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (10,000 units) $ 2,150,000 Cost of goods sold Direct materials $ 250,000 Direct labor 420,000 Production supplies 260,000 Plant manager salary 50,000 980,000 Gross profit 1,170,000 Selling expenses Sales commissions 70,000 Packaging 150,000 Advertising 100,000 320,000 Administrative expenses Administrative salaries 100,000 Depreciation—office equip. 70,000 Insurance 40,000 Office rent 50,000...

Subjects