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
Master Chef
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
GOURMET GRILL COMPANY
Sales Budget
For the Month Ending July 31, 2014
0%
Problem 21(6)-2A
Name:
Section:
GOURMET GRILL COMPANY
Direct Materials Purchases Budget
GOURMET GRILL COMPANY
Production Budget
For the Month Ending July 31, 2014
Units
Direct Labor Cost Budget
For the Month Ending July 31, 2014
For the Month Ending July 31, 2014
GOURMET GRILL COMPANY
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.
Backyard Master
Chef Chef
3.
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
4.
Stamping Forming Assembly
Department Department Department Total
Hours required for production:
Backyard Chef 460 552 920
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
GOURMET GRILL COMPANY
Sales Budget
For the Month Ending July 31, 2014
Problem 21(6)-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, 2014
Units
Direct Labor Cost Budget
For the Month Ending July 31, 2014
For the Month Ending July 31, 2014
GOURMET GRILL COMPANY