The budget director of Gold Medal Athletic Co., with the assistance of the contr
ID: 2559739 • Letter: T
Question
The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March:
Estimated sales for March:
Estimated inventories at March 1:
Desired inventories at March 31:
Direct materials used in production:
Anticipated cost of purchases and beginning and ending inventory of direct materials:
Direct labor requirements:
Estimated factory overhead costs for March:
Estimated operating expenses for March:
Estimated other income and expense for March:
Estimated tax rate: 30%
Required:
1. Prepare a sales budget for March. Enter all amounts as positive numbers.
2. Prepare a production budget for March. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
3. Prepare a direct materials purchases budget for March. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
4. Prepare a direct labor cost budget for March. Enter all amounts as positive numbers.
5. Prepare a factory overhead cost budget for March.
6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be $15,300, and work in process at the end of March is desired to be $14,800. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
7. Prepare a selling and administrative expenses budget for March.
8. Prepare a budgeted income statement for March.
Batting helmet 1,200 units at $40 per unit Football helmet 6,500 units at $160 per unitExplanation / Answer
1. Prepare a sales budget for March. Enter all amounts as positive numbers.
Gold Medal Athletic Co.
Sales Budget
For the Month Ending March 31
Unit Sales
Unit Selling
Total Sales
Volume
Price
Batting helmet
$1,200
$40
$48,000
Football helmet
$6,500
$160
$10,40,000
Total revenue from sales
$10,88,000
2. Prepare a production budget for March. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Gold Medal Athletic Co.
Production Budget
For the Month Ending March 31
Units
Batting helmet
Football helmet
Expected Sales
1,200
6,500
Add: Desired Ending Inventory
50
220
Total Inventory required
1,250
6,720
Less: Beginning Inventory
40
240
Units to produce
1,210
6,480
3. Prepare a direct materials purchases budget for March. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Gold Medal Athletic Co.
Direct Materials Purchases Budget
Plastic
Foam Lining
Total
Units required for production:
Batting helmet
1452
605
Football helmet
22680
9720
Desired units of inventory, March 31
50
65
Total units available
24182
10390
Estimated units of inventory, March 1
90
80
Total units to be purchased
24092
10310
Unit price
$6
$4
Total direct materials to be purchased
$1,44,552
$41,240
$1,85,792
4. Prepare a direct labor cost budget for March. Enter all amounts as positive numbers.
Gold Medal Athletic Co.
Direct Materials Purchases Budget
Molding Department
Assembly Department
Total
Hours required for production
Batting helmet
242
605
Football helmet
3240
11664
Total
3482
12269
Hourly Rate
$20
$14
Total direct labor cost
$69,640
$1,71,766
$2,41,406
1. Prepare a sales budget for March. Enter all amounts as positive numbers.
Gold Medal Athletic Co.
Sales Budget
For the Month Ending March 31
Unit Sales
Unit Selling
Total Sales
Volume
Price
Batting helmet
$1,200
$40
$48,000
Football helmet
$6,500
$160
$10,40,000
Total revenue from sales
$10,88,000
2. Prepare a production budget for March. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Gold Medal Athletic Co.
Production Budget
For the Month Ending March 31
Units
Batting helmet
Football helmet
Expected Sales
1,200
6,500
Add: Desired Ending Inventory
50
220
Total Inventory required
1,250
6,720
Less: Beginning Inventory
40
240
Units to produce
1,210
6,480
3. Prepare a direct materials purchases budget for March. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Gold Medal Athletic Co.
Direct Materials Purchases Budget
Plastic
Foam Lining
Total
Units required for production:
Batting helmet
1452
605
Football helmet
22680
9720
Desired units of inventory, March 31
50
65
Total units available
24182
10390
Estimated units of inventory, March 1
90
80
Total units to be purchased
24092
10310
Unit price
$6
$4
Total direct materials to be purchased
$1,44,552
$41,240
$1,85,792
4. Prepare a direct labor cost budget for March. Enter all amounts as positive numbers.
Gold Medal Athletic Co.
Direct Materials Purchases Budget
Molding Department
Assembly Department
Total
Hours required for production
Batting helmet
242
605
Football helmet
3240
11664
Total
3482
12269
Hourly Rate
$20
$14
Total direct labor cost
$69,640
$1,71,766
$2,41,406
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.