G H GOLD MEDAL ATHLETIC CO. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (") will appear to the fight of an incorrect entry. For the Month Ending March 31 GOLD MEDAL ATHLETIC CO. Baking expenses GOLD MEDAL ATHLETIC CO . For the Month Ending March 31 For the Month Ending March 31 Unit Bales Indirect factory wash and equipment Product Total Power and Ight insurance and property tax Total seting expenses inistrative expenses: Footbat hemnot 1.208 $ 48,000 Total revenue from sales 5 1,068 060 DAL ATHLETIC CO. For the Month Ending March 31 GOLD MEDAL ATHLETIC CO Total administrative expenses Total operating expenses For the Month Ending March 31 Betting rect materials: DAL ATHLETIC CO. 1,200 Helmet 50 6,500 Direct materials purchases For the Month Ending March 31 Cost of direct materials available for use Lots estimated inventory N 6,720 Cost of direct materials placed in production Revenue from sales Total unks to be produced 40 240 Cast of goods sold Factory overhead Total manufacturing costs Operating expenses: Total work in process during period GOLD MEDAL ATHLETIC CO. Administrative expenses Total operating For the Month Ending March 31 Cost of goods manufactured ome from operating expenses Cost of finished goods available for sale ounds required for production Cost of goods sold Interest expense 805 Supporting calculations ncome before tocome Football helmet his desired inventory, March 31 22 680 9,720 Income tax exp 24,182 ished goods inventory, March 1 let ho fax expense Total pounds Toquad Batting helmet Football holmnal una prewhen to be purchas Total direct materials to be purchased 5 144 592 14 00 Finished goods inventory. March 31 $ 185,792 Batting helmet Football helmet Total rect materials inventory, March 1 GOLD MEDAL ATHLETIC CO. For the Month Ending March 31 Foam Ining Department Departme fract materials inventory. March 31 Hours required for production: Total Total hours required Total croct labor cost GOLD MEDAL ATHLETIC CO. For the Month Ending March 31 A Pr. 22-3B + 121 A Pr. 22- 3B + Accessibility: Investigate A Pr. 22-3B 100% Ready & Accessibility: Investigate - + 100% Ready Accessibility : Investigate ( - Word File Edit View Insert Format Tools Table Window Help 0 5 A $ 2 7 Q 2 0 Tue Apr 11 6:25 PM AutoSave 04 7 8 9 . C E ... OM - ACG2071 - SOA - 2023.. - Saved to my | 0 . AutoSave . or 7 8 7 . C E .. OM - ACG2071 - SOA - 2023. ~ Q Insert Draw Design Layout Comments Edit Home Insert Draw Design Layout >> Tell me PR 22-35 Comments Editing & Share Budgeted income statement and supporting budgets 7. Estimated factory overhead costs for March: 1.80 hrs. at $14 per h direct factory wages $86,000 8. Estimated operating expenses for March: Insur Insurance and property tax ExcelThe budget director of Gold Medal Athletic Co, with the assistance Sales salaries expense gathered the following data for use in developing the budgeted income Advertising expense $184,300 Office salaries expense 1. Estimated sales for March : planningwon expense-office equipment Batting helmet... Telephone expense-selling 6,500 units at $ 160 per unit Telephone expense-administrative 5,800 1,200 2. Estimated inventories at March 1: Direct materials: Office supplies evans Plastic . .... Firebeting helmet 1,100 foam lining... 240 units at $77 per unit puscellaneous administra 3. Desired inventories at March 31; Interest revenue $940 872 Direct materials Finished products : nated tar expense C Foam lining... 65 1b. Boosban helmet 50 units at $25 per unit 20 units at $78 per unit ructions re a sales budget for March 4. Direct materials used in produ epare a production budget for March PREP PADS manufacture of batting helmet epare a direct labor cost budget for yaget for March. Foam lining ... 1.20 lb. per unit of product 0.50 lb. per unit of product manufacture of football helmet Check Figure: Total direct labor cost in Assembly Dept, $171,766 1 50 lb per unit of product prepare a factory overhead cost budget for March. Foam lining .... direct materials ses and beginning and ending inventory of beginning of March is estimated to be $15,300, and work in process at the $6.00 per lb. Prepare a selling and administrative expenses budget for March. Plastic .... direct labor requirements: $4.00 per It O.INCLUDE ALL FORUMLAS FOR EACH CELL Batting helmet: 0.20 hr. at $20 per h ESQ. 0.50 hr. at $14 per hor, gotball helmet: Molding Department 0.50 hr. at $20 per h Assembly Department . 7. Estimated factory overhead costs for March: 1.80 hrs. at $14 per he. Indirect factory wages $86,000 Power and light $4,000 Page 8 of 10 1471 words [TX English (United states ement Focus Page 10 of 10 1478 words Focus 6
