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
Prince
Total
Hourly rate
Total direct labor cost
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
ROYAL FURNITURE COMPANY
Sales Budget
For the Month Ending February 28, 2014
0%
Problem 21(6)-2B
Name:
Section:
ROYAL FURNITURE COMPANY
Production Budget
For the Month Ending February 28, 2014
Units
Direct Labor Cost Budget
For the Month Ending February 28, 2014
ROYAL FURNITURE COMPANY
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$
2.
King Prince
Expected units to be sold 1,310 1,480
3.
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
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
ROYAL FURNITURE COMPANY
Sales Budget
For the Month Ending February 28, 2014
Problem 21(6)-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, 2014
Units
For the Month Ending February 28, 2014
Prince: