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 21(6)-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%
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
8″ x 10″ Frame:
East 9,018 $17.00 153,306$
Sales Budget
For the Year Ending December 31, 2015
Unit Sales, Year Ended 2014
Actual Over Budget
Problem 21(6)-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