Prepare the pro forma income statement that would appear in the master budget an
ID: 2401121 • Letter: P
Question
Prepare the pro forma income statement that would appear in the master budget and also flexible budget income statements, assuming production volumes of 26,000 and 28,000 units. Determine the sales and variable cost volume variances, assuming volume is actually 28,000 units. Indicate whether the variances are favorable (F) or unfavorable (U). (Select "None" if there is no effect (i.e., zero variance).)
Walton Publications established the following standard price and costs for a hardcover picture book that the company produces. Standard price and variable costs Sales price Materials cost Labor cost Overhead cost Selling, general, and administrative costs $ 36.80 8.50 3.60 5.50 7.20 Planned fixed costs Manufacturing overhead Selling, general, and administrative $133,000 47,000 Walton planned to make and sell 27,000 copies of the book Required: a. -d. Prepare the pro forma income statement that would appear in the master budget and also flexible budget income statements, assuming production volumes of 26,000 and 28,000 units. Determine the sales and variable cost volume variances, assuming volume is actually 28,000 units, indicate whether the variances are favorable (F) or unfavorable (U). (Select "None" if there is no effect (i.e., zero variance).)Explanation / Answer
Solution:
Flexible Budget and Master Budget is prepared on the basis of Standard Price. Volume Variance is the difference between master budget and flexible budget.
Unit Standard Price
Master Budget
(P*Quantity)
Flexible Budgets
(P*Quantity)
Volume Variance
Number of Units
(P)
27,000
26,000
28,000
Sales Revenue
$36.80
$993,600
$956,800
$1,030,400
$36,800
F
Variable manufacturing costs
Materials
$8.50
$229,500
$221,000
$238,000
$8,500
U
Labor
$3.60
$97,200
$93,600
$100,800
$3,600
U
Manufacturing overhead
$5.50
$148,500
$143,000
$154,000
$5,500
U
Variable selling, general and administrative costs
$7.20
$194,400
$187,200
$201,600
$7,200
U
Contribution Margin
$324,000
$312,000
$336,000
$12,000
F
Fixed Costs
Manufacturing overhead
$133,000
$133,000
$133,000
$0
N
Fixed selling, general and administrative costs
$47,000
$47,000
$47,000
$0
N
Net Income
$144,000
$132,000
$156,000
$12,000
F
Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you
Unit Standard Price
Master Budget
(P*Quantity)
Flexible Budgets
(P*Quantity)
Volume Variance
Number of Units
(P)
27,000
26,000
28,000
Sales Revenue
$36.80
$993,600
$956,800
$1,030,400
$36,800
F
Variable manufacturing costs
Materials
$8.50
$229,500
$221,000
$238,000
$8,500
U
Labor
$3.60
$97,200
$93,600
$100,800
$3,600
U
Manufacturing overhead
$5.50
$148,500
$143,000
$154,000
$5,500
U
Variable selling, general and administrative costs
$7.20
$194,400
$187,200
$201,600
$7,200
U
Contribution Margin
$324,000
$312,000
$336,000
$12,000
F
Fixed Costs
Manufacturing overhead
$133,000
$133,000
$133,000
$0
N
Fixed selling, general and administrative costs
$47,000
$47,000
$47,000
$0
N
Net Income
$144,000
$132,000
$156,000
$12,000
F