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. 2015
2014 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
Total revenue from sales
Sales Budget
For the Year Ending December 31, 2015
0%
Increase (Decrease)
Unit Sales, Year Ended 2014
Actual Over Budget
Problem 22-1A
Name:
Section:
RAPHAEL FRAME COMPANY
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
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. 2015
2014 Percentage Budgeted
Actual Increase Units
Units (Decrease) (rounded)
8″ x 10″ Frame:
East 8,755 3.00% 9,018
3.
Unit Sales Unit Selling Total
Product and Area Volume Price Sales
Sales Budget
For the Year Ending December 31, 2015
Unit Sales, Year Ended 2014
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.
Score:
Instructions