An asterisk (*) will appear to the right of an incorrect entry.
1.
Budget Actual Sales Amount Percent
8″ x 10″ Frame:
East
Central
West
12″ x 16″ Frame:
East
Central
West
2. 2017
2016 Percentage Budgeted
Actual Increase Units
Units (Decrease) (rounded)
8″ x 10″ Frame:
East
Central
West
12″ x 16″ Frame:
East
Central
West
3.
Unit Sales Unit Selling Total
Product and Area Volume Price Sales
8″ x 10″ Frame:
East
Central
West
Total
12″ x 16″ Frame:
East
Central
West
Total
Score:
Key Code:
Cells with non-gray backgrounds are protected and cannot be edited.
[Key code here]
Answers are entered in the cells with gray backgrounds.
Instructions
Problem 22-1A
Name:
Section:
Sales Budget
For the Year Ending December 31, 2017
0%
Increase (Decrease)
Actual Over Budget
RAPHAEL FRAME COMPANY
Total revenue from sales
An asterisk (*) will appear to the right of an incorrect entry.
1.
Budget Actual Sales Amount Percent
8″ x 10″ Frame:
East 8,500 8,755 255 3.00%
Central 6,200 6,510 310 5.00%
2. 2017
2016 Percentage Budgeted
Actual Increase Units
Units (Decrease) (rounded)
8″ x 10″ Frame:
East 8,755 3.00% 9,018
Central 6,510 5.00% 6,836
3.
Unit Sales Unit Selling Total
Product and Area Volume Price Sales
8″ x 10″ Frame:
East 9,018 $17.00 153,306$
Central 6,836 $17.00 116,212
Score:
Instructions
Sales Budget
For the Year Ending December 31, 2017
Actual Over Budget
Problem 22-1A
Name:
Solution
Section:
RAPHAEL FRAME COMPANY
Answers are entered in the cells with gray backgrounds.
ON
Increase (Decrease)
Key Code:
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
1.
Budget Actual Sales Amount Percent
Home Alert System:
United States
Europe
Asia
Business Alert System:
United States
Europe
Asia
2. 2017
2016 Percentage Budgeted
Actual Increase Units
Units (Decrease) (rounded)
Home Alert System:
United States
Europe
Asia
Business Alert System:
United States
Europe
Asia
3.
Unit Sales Unit Selling Total
Product and Area Volume Price Sales
Home Alert System:
United States
Europe
Asia
Total
Business Alert System:
United States
Europe
Asia
Total
For the Year Ending December 31, 2017
0%
Increase (Decrease)
Actual Over Budget
SENTINEL SYSTEMS INC.
Problem 22-1B
Name:
Section:
Sales Budget
Score:
Key Code:
Cells with non-gray backgrounds are protected and cannot be edited.
[Key code here]
Answers are entered in the cells with gray backgrounds.
Instructions
Total revenue from sales
An asterisk (*) will appear to the right of an incorrect entry.
1.
Budget Actual Sales Amount Percent
Home Alert System:
United States 1,700 1,734 34 2.00%
Europe 580 609 29 5.00%
2. 2017
2016 Percentage Budgeted
Actual Increase Units
Units (Decrease) (rounded)
Home Alert System:
United States 1,734 2.00% 1,769
Europe 609 5.00% 639
3.
Unit Sales Unit Selling Total
Product and Area Volume Price Sales
Home Alert System:
United States 1,769 $250 442,250$
Europe 639 $250 159,750
Problem 22-1B
Name:
Solution
Section:
SENTINEL SYSTEMS INC.
Answers are entered in the cells with gray backgrounds.
ON
Increase (Decrease)
Score:
Instructions
Sales Budget
For the Year Ending December 31, 2017
Actual Over Budget
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
1.
Unit Sales Unit Selling Total
Product and Area Volume Price Sales
Backyard Chef:
Maine
Vermont
New Hampshire
Total
Master Chef:
Maine
Vermont
New Hampshire
Total
Total revenue from sales
2.
Backyard Master
Chef Chef
Expected units to be sold
Total
Total units to be produced
3.
Grates Stainless Burner Sub- Shelves
(units) Steel (lbs.) assemblies (units) (units) Total
Required units for production:
Backyard Chef
Master Chef
Total
Total units to be purchased
Unit price
Total direct materials to be purchased
4.
Stamping Forming Assembly
Department Department Department Total
Hours required for production:
Backyard Chef
Sales Budget
For the Month Ending July 31, 2016
0%
Score:
Key Code:
Cells with non-gray backgrounds are protected and cannot be edited.
[Key code here]
Answers are entered in the cells with gray backgrounds.
Instructions
Problem 22-2A
Name:
Section:
GOURMET GRILL COMPANY
GOURMET GRILL COMPANY
Direct Materials Purchases Budget
GOURMET GRILL COMPANY
Production Budget
For the Month Ending July 31, 2016
Units
Direct Labor Cost Budget
For the Month Ending July 31, 2016
For the Month Ending July 31, 2016
GOURMET GRILL COMPANY
Master Chef
Total
Hourly rate
Total direct labor cost
An asterisk (*) will appear to the right of an incorrect entry.
1.
Unit Sales Unit Selling Total
Product and Area Volume Price Sales
Backyard Chef:
Maine 310 $700 217,000$
2.
Plus desired inventory, July 31, 2016
Less estimated inventory, July 1, 2016
Backyard Master
Chef Chef
Expected units to be sold 910 440
3.
Less estimated inventory, July 1, 2016
Grates Stainless Burner Sub- Shelves
(units) Steel (lbs.) assemblies (units) (units) Total
Required units for production:
Backyard Chef 2,760 22,080 1,840 3,680
Master Chef 2,580 18,060 1,720 2,150
340 1,800 155 315
4.
Stamping Forming Assembly
Department Department Department Total
Hours required for production:
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
GOURMET GRILL COMPANY
Sales Budget
For the Month Ending July 31, 2016
Problem 22-2A
Name:
Solution
Section:
Answers are entered in the cells with gray backgrounds.
ON
GOURMET GRILL COMPANY
Direct Materials Purchases Budget
GOURMET GRILL COMPANY
Production Budget
For the Month Ending July 31, 2016
Units
Direct Labor Cost Budget
For the Month Ending July 31, 2016
Plus desired inventory, July 31, 2016
For the Month Ending July 31, 2016
GOURMET GRILL COMPANY
Backyard Chef 460 552 920
Master Chef 258 344 645
An asterisk (*) will appear to the right of an incorrect entry.
1.
Unit Sales Unit Selling Total
Product and Area Volume Price Sales
King:
Northern Domestic
Southern Domestic
International
Total
Prince:
Northern Domestic
Southern Domestic
International
Total
Total revenue from sales
2.
King Prince
Expected units to be sold
Total
Total units to be produced
3.
Fabric Wood Filler Springs
(sq. yds.) (linear ft.) (cubic ft.) (units) Total
Required units for production:
King
Prince
Total
Total units to be purchased
Unit price
Total direct materials to be purchased
4.
Framing Cutting Upholstery
Department Department Department Total
Hours required for production:
King
Sales Budget
For the Month Ending February 28, 2016
0%
Score:
Key Code:
Cells with non-gray backgrounds are protected and cannot be edited.
[Key code here]
Answers are entered in the cells with gray backgrounds.
Instructions
Problem 22-2B
Name:
Section:
ROYAL FURNITURE COMPANY
ROYAL FURNITURE COMPANY
Direct Materials Purchases Budget
ROYAL FURNITURE COMPANY
Production Budget
For the Month Ending February 28, 2016
Units
Direct Labor Cost Budget
For the Month Ending February 28, 2016
For the Month Ending February 28, 2016
ROYAL FURNITURE COMPANY
Prince
Total
Hourly rate
Total direct labor cost
An asterisk (*) will appear to the right of an incorrect entry.
1.
Unit Sales Unit Selling Total
Product and Area Volume Price Sales
King:
Northern Domestic 610 $780 475,800$
Southern Domestic 340 $780 265,200
International 360 $850 306,000
2.
Plus desired inventory, Feb. 28, 2016
Less estimated inventory, Feb. 1, 2016
King Prince
Expected units to be sold 1,310 1,480
3.
Less estimated inventory, Feb. 1, 2016
Fabric Wood Filler Springs
(sq. yds.) (linear ft.) (cubic ft.) (units) Total
Required units for production:
King 7,800 49,400 5,460 20,800
Prince 5,960 38,740 5,066 17,880
390 650 300 540
4.
Framing Cutting Upholstery
Department Department Department Total
Hours required for production:
King 1,560 650 1,040
Prince 1,490 596 894
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
ROYAL FURNITURE COMPANY
Sales Budget
For the Month Ending February 28, 2016
Problem 22-2B
Name:
Solution
Section:
Answers are entered in the cells with gray backgrounds.
ON
ROYAL FURNITURE COMPANY
Direct Materials Purchases Budget
ROYAL FURNITURE COMPANY
Production Budget
For the Month Ending February 28, 2016
Units
Direct Labor Cost Budget
For the Month Ending February 28, 2016
Plus desired inventory, Feb. 28, 2016
For the Month Ending February 28, 2016
ROYAL FURNITURE COMPANY
Prince:
An asterisk (*) will appear to the right of an incorrect entry.
1.
Unit Sales Unit Selling Total
Product Volume Price Sales
Bird house
Bird feeder
Total revenue from sales
2.
Bird Bird
House Feeder
Expected units to be sold
Total
Total units to be produced
3.
Wood Plastic
(feet) (lbs.) Total
Required units for production:
Bird house
Bird feeder
Total
Total units to be purchased
Unit price
Total direct materials to be purchased
4.
Key Code:
Cells with non-gray backgrounds are protected and cannot be edited.
[Key code here]
Answers are entered in the cells with gray backgrounds.
Instructions
Direct Materials Purchases Budget
FEATHERED FRIENDS INC.
Production Budget
For the Month Ending December 31, 2016
Units
0%
FEATHERED FRIENDS INC.
Sales Budget
For the Month Ending December 31, 2016
Problem 22-3A
Name:
Section:
Score:
For the Month Ending December 31, 2016
FEATHERED FRIENDS INC.
Fabrication Assembly
Department Department Total
Hours required for production:
Bird house
Bird feeder
Total
Hourly rate
Total direct labor cost
5.
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total
6.
Direct materials:
Direct materials purchases
Cost of direct materials available for use
Cost of direct materials placed in production
Direct labor
Factory overhead
Total manufacturing costs
Total work in process during period
Cost of goods manufactured
Cost of finished goods available for sale
Cost of goods sold
Supporting calculations:
Units Cost Total
Finished goods inventory, Dec. 1, 2016:
Bird house
Bird feeder
Total
Finished goods inventory, Dec. 31, 2016:
Bird house
Bird feeder
For the Month Ending December 31, 2016
Direct Labor Cost Budget
For the Month Ending December 31, 2016
FEATHERED FRIENDS INC.
FEATHERED FRIENDS INC.
Cost of Goods Sold Budget
For the Month Ending December 31, 2016
FEATHERED FRIENDS INC.
Factory Overhead Cost Budget
Total
Direct materials inventory, December 1, 2016
Wood
Plastic
Total
Direct materials inventory, December 31, 2016
Wood
Plastic
Total
7.
Selling expenses:
Total selling expenses
Administrative expenses:
Total administrative expenses
Total operating expenses
8.
Revenue from sales
Cost of goods sold
Gross profit
Operating expenses:
Selling expenses
Administrative expenses
Total operating expenses
Income from operations
Other income
Interest revenue
Other expense:
Interest expense
Income before income tax
Income tax expense
Net income
Selling and Administrative Expenses Budget
For the Month Ending December 31, 2016
FEATHERED FRIENDS INC.
FEATHERED FRIENDS INC.
Budgeted Income Statement
For the Month Ending December 31, 2016
An asterisk (*) will appear to the right of an incorrect entry.
1.
Unit Sales Unit Selling Total
Product Volume Price Sales
Bird house 3,200 $50.00 160,000$
2.
Less estimated inventory, Dec. 1, 2016
Bird Bird
House Feeder
Expected units to be sold 3,200 3,000
290 250
3.
Wood Plastic
(feet) (lbs.) Total
Required units for production:
Bird house 2,536 1,585
Bird feeder 3,576 2,235
220 200
4.
Plus desired inventory, Dec. 31, 2016
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
For the Month Ending December 31, 2016
ON
FEATHERED FRIENDS INC.
Production Budget
For the Month Ending December 31, 2016
Units
Problem 22-3A
Name:
Solution
Section:
FEATHERED FRIENDS INC.
Score:
Instructions
FEATHERED FRIENDS INC.
Sales Budget
Direct Materials Purchases Budget
For the Month Ending December 31, 2016
Plus desired inventory, Dec. 31, 2016