PLEASE SHOW THE WORKBudgeted Income Statement and Supporting BudgetsThe budget director of Gold Medal...PLEASE...

60.1K

Verified Solution

Question

Accounting

PLEASE SHOW THE WORK

Budgeted Income Statement and Supporting Budgets

The budget director of Gold Medal Athletic Co., with theassistance of the controller, treasurer, production manager, andsales manager, has gathered the following data for use indeveloping the budgeted income statement for March:

Estimated sales for March:

Batting helmet1,200 units at $40 per unit
Football helmet6,500 units at $160 per unit

Estimated inventories at March 1:

Direct materials:
Plastic90 lbs.
Foam lining80 lbs.
Finished products:
Batting helmet40 units at $25 per unit
Football helmet240 units at $77 per unit

Desired inventories at March 31:

Direct materials:
Plastic50 lbs.
Foam lining65 lbs.
Finished products:
Batting helmet50 units at $25 per unit
Football helmet220 units at $78 per unit

Direct materials used in production:

In manufacture of batting helmet:
Plastic1.2 lbs. per unit of product
Foam lining0.5 lb. per unit of product
In manufacture of football helmet:
Plastic3.5 lbs. per unit of product
Foam lining1.5 lbs. per unit of product

Anticipated cost of purchases and beginning and ending inventoryof direct materials:

Plastic$6 per lb.
Foam lining$4 per lb.

Direct labor requirements:

Batting helmet:
Molding Department0.2 hr. at $20 per hr.
AssemblyDepartment0.5 hr. at $14 per hr.
Football helmet:
Molding Department0.5 hr. at $20 per hr.
AssemblyDepartment1.8 hrs. at $14 per hr.

Estimated factory overhead costs for March:

Indirect factory wages$86,000
Depreciation of plant and equipment12,000
Power and light4,000
Insurance and property tax2,300

Estimated operating expenses for March:

Sales salaries expense$184,300
Advertising expense87,200
Office salaries expense32,400
Depreciation expense—office equipment3,800
Telephone expense—selling5,800
Telephone expense—administrative1,200
Travel expense—selling9,000
Office supplies expense1,100
Miscellaneous administrative expense1,000

Estimated other income and expense for March:

Interest revenue$940
Interest expense872

Estimated tax rate: 30%

Required:

1. Prepare a sales budget for March. Enter allamounts as positive numbers.

Gold Medal AthleticCo.
Sales Budget
For the Month Ending March 31
Unit Sales
Volume
Unit Selling
Price
Total Sales
Batting helmet$$
Football helmet
Total revenue from sales$


2. Prepare a production budget for March. Forthose boxes in which you must enter subtracted or negative numbersuse a minus sign.

Gold Medal AthleticCo.
Production Budget
For the Month Ending March 31
Units
Batting helmetFootball helmet
Expected units to be sold
Desired inventory, March 31
Total unitsavailable
Estimated inventory, March 1
Total units to be produced


3. Prepare a direct materials purchases budgetfor March. For those boxes in which you must enter subtracted ornegative numbers use a minus sign.

Gold Medal AthleticCo.
Direct Materials Purchases Budget
For the Month Ending March 31
PlasticFoam LiningTotal
Units required for production:
Batting helmet
Football helmet
Desired units of inventory, March 31
Total units available
Estimated units of inventory, March 1
Total units to be purchased
Unit price$$
Total direct materials to be purchased$$$


4. Prepare a direct labor cost budget forMarch. Enter all amounts as positive numbers.

Gold Medal AthleticCo.
Direct Labor Cost Budget
For the Month Ending March 31
Molding
Department
Assembly
Department
Total
Hours required for production:
Batting helmet
Football helmet
Total
Hourly rate$$
Total direct labor cost$$$


5. Prepare a factory overhead cost budget forMarch.

Gold Medal AthleticCo.
Factory Overhead Cost Budget
For the Month Ending March 31
$
Total$


6. Prepare a cost of goods sold budget forMarch. 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 ornegative numbers use a minus sign.

Gold Medal AthleticCo.
Cost of Goods Sold Budget
For the Month Ending March 31
$
$
Direct materials:
$
Cost of directmaterials available for use$
Cost of directmaterials placed in production$
Total manufacturing costs
Total work in process during period$
Cost of goods manufactured
Cost of finished goods available for sale$
Cost of goods sold$


7. Prepare a selling and administrativeexpenses budget for March.

Gold Medal AthleticCo.
Selling and Administrative Expenses Budget
For the Month Ending March 31
Selling expenses:
$
Total selling expenses$
Administrative expenses:
$
Total administrative expenses
Total operating expenses$


8. Prepare a budgeted income statement forMarch.

Gold Medal AthleticCo.
Budgeted Income Statement
For the Month Ending March 31
$
$
Operating expenses:
$
Total operating expenses
Income from operations$
Other revenue and expense:
$
Income before income tax$
Net income$

Answer & Explanation Solved by verified expert
3.6 Ratings (250 Votes)
1GOLD MEDAL ATHLETIC COSales BudgetFor the Month Ending March 31Unit SalesUnit SellingTotalProductVolumePriceSalesBatting helmet 12004000 48000Football helmet 650016000 1040000Total    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

In: AccountingPLEASE SHOW THE WORKBudgeted Income Statement and Supporting BudgetsThe budget director of Gold Medal...PLEASE SHOW THE WORKBudgeted Income Statement and Supporting BudgetsThe budget director of Gold Medal Athletic Co., with theassistance of the controller, treasurer, production manager, andsales manager, has gathered the following data for use indeveloping the budgeted income statement for March:Estimated sales for March:Batting helmet1,200 units at $40 per unitFootball helmet6,500 units at $160 per unitEstimated inventories at March 1:Direct materials:Plastic90 lbs.Foam lining80 lbs.Finished products:Batting helmet40 units at $25 per unitFootball helmet240 units at $77 per unitDesired inventories at March 31:Direct materials:Plastic50 lbs.Foam lining65 lbs.Finished products:Batting helmet50 units at $25 per unitFootball helmet220 units at $78 per unitDirect materials used in production:In manufacture of batting helmet:Plastic1.2 lbs. per unit of productFoam lining0.5 lb. per unit of productIn manufacture of football helmet:Plastic3.5 lbs. per unit of productFoam lining1.5 lbs. per unit of productAnticipated cost of purchases and beginning and ending inventoryof direct materials:Plastic$6 per lb.Foam lining$4 per lb.Direct labor requirements:Batting helmet:Molding Department0.2 hr. at $20 per hr.AssemblyDepartment0.5 hr. at $14 per hr.Football helmet:Molding Department0.5 hr. at $20 per hr.AssemblyDepartment1.8 hrs. at $14 per hr.Estimated factory overhead costs for March:Indirect factory wages$86,000Depreciation of plant and equipment12,000Power and light4,000Insurance and property tax2,300Estimated operating expenses for March:Sales salaries expense$184,300Advertising expense87,200Office salaries expense32,400Depreciation expense—office equipment3,800Telephone expense—selling5,800Telephone expense—administrative1,200Travel expense—selling9,000Office supplies expense1,100Miscellaneous administrative expense1,000Estimated other income and expense for March:Interest revenue$940Interest expense872Estimated tax rate: 30%Required:1. Prepare a sales budget for March. Enter allamounts as positive numbers.Gold Medal AthleticCo.Sales BudgetFor the Month Ending March 31Unit SalesVolumeUnit SellingPriceTotal SalesBatting helmet$$Football helmetTotal revenue from sales$2. Prepare a production budget for March. Forthose boxes in which you must enter subtracted or negative numbersuse a minus sign.Gold Medal AthleticCo.Production BudgetFor the Month Ending March 31UnitsBatting helmetFootball helmetExpected units to be soldDesired inventory, March 31Total unitsavailableEstimated inventory, March 1Total units to be produced3. Prepare a direct materials purchases budgetfor March. For those boxes in which you must enter subtracted ornegative numbers use a minus sign.Gold Medal AthleticCo.Direct Materials Purchases BudgetFor the Month Ending March 31PlasticFoam LiningTotalUnits required for production:Batting helmetFootball helmetDesired units of inventory, March 31Total units availableEstimated units of inventory, March 1Total units to be purchasedUnit price$$Total direct materials to be purchased$$$4. Prepare a direct labor cost budget forMarch. Enter all amounts as positive numbers.Gold Medal AthleticCo.Direct Labor Cost BudgetFor the Month Ending March 31MoldingDepartmentAssemblyDepartmentTotalHours required for production:Batting helmetFootball helmetTotalHourly rate$$Total direct labor cost$$$5. Prepare a factory overhead cost budget forMarch.Gold Medal AthleticCo.Factory Overhead Cost BudgetFor the Month Ending March 31$Total$6. Prepare a cost of goods sold budget forMarch. 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 ornegative numbers use a minus sign.Gold Medal AthleticCo.Cost of Goods Sold BudgetFor the Month Ending March 31$$Direct materials:$Cost of directmaterials available for use$Cost of directmaterials placed in production$Total manufacturing costsTotal work in process during period$Cost of goods manufacturedCost of finished goods available for sale$Cost of goods sold$7. Prepare a selling and administrativeexpenses budget for March.Gold Medal AthleticCo.Selling and Administrative Expenses BudgetFor the Month Ending March 31Selling expenses:$Total selling expenses$Administrative expenses:$Total administrative expensesTotal operating expenses$8. Prepare a budgeted income statement forMarch.Gold Medal AthleticCo.Budgeted Income StatementFor the Month Ending March 31$$Operating expenses:$Total operating expensesIncome from operations$Other revenue and expense:$Income before income tax$Net income$

Other questions asked by students