need help with answers
AutoSave . Off M9A1 PR 22-3B . Search Mollie Saum MS X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments & Cut Aria 10 A A ab Wrap Text _ AutoSum ~ Ap O Fill Paste [G Copy Conditional Format as nsert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting Table ~ Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity C2 X V A B C D E F G H J K L M N P Q S U V W X Y Z AA AB AC AF AG 1 Problem 22-38 Name: Section Score: 0% 7 Key Code: [Key code here] 8 Instructions Answers are entered in the cells with gray backgrounds. 10 Cells with non-gray backgrounds are protected and cannot be edited. 11 An asterisk (*) will appear to the right of an incorrect entry. 12 13 14 1 . 15 GOLD MEDAL ATHLETIC CO. 16 Sales Budget For the Month Ending March 31 18 Unit Sales Unit Selling Total 19 Product Volume Price Sales Batting helmet Football helmet Total revenue from sales 26 GOLD MEDAL ATHLETIC CO. Production Budget For the Month Ending March 31 30 Units Batting Football Helmet Helmet Expected units to be sold lotal units required Total units to be produced 40 3 COLD MEDAL ATHLETIC CO Pr. 22-3B + - - + 100% Type here to search O x 3:22 PM 3/17/2021AutoSave . Off M9A1 PR 22-3B - Search Mollie Saum MS X Share File Home Insert Draw Page Layout Formulas Data Review View Help Comments & Cut 10 A" A ab Wrap Text _ AutoSum ~ Ap Aria O Fill Paste [G Copy Sort & Find & Format Painter BIU~ ~A Conditional Format as nsert Delete Format Analyze Sensitivity Formatting v Table ~ Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity C2 X V A B C D E F G H J K L M N P Q S U V W X Y Z AA AB AF AG 40 3. 41 GOLD MEDAL ATHLETIC CO 42 Direct Materials Purchases Budget 43 For the Month Ending March 31 44 Plastic Foam Lining 45 (lbs.) (lbs.) Total 46 Pounds required for production: 47 Batting helmet 48 Football helmet Total pounds required Total pounds to be purchased Unit price (per pound) Total direct materials to be purchased GOLD MEDAL ATHLETIC CO. Direct Labor Cost Budget For the Month Ending March 31 Molding Assembly 68 898828 89 8989890 Department Department Total Hours required for production: Batting helmet Football helmet Total hours required Hourly rate Total direct labor cost 71 5 72 GOLD MEDAL ATHLETIC CO. 73 Factory Overhead Cost Budget 74 For the Month Ending March 31 75 76 Indirect factory wages 77 Depreciation of plant and equipment Screenshot saved 78 Power and light The screenshot was added to your 79 Insurance and property tax OneDrive. OneDrive Pr. 22-3B + 3:22 PM Type here to search O (?) 3/17/2021AutoSave . Off M9A1 PR 22-3B . Search Mollie Saum MS X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments & Cut Aria 10 A" A ab Wrap Text _ AutoSum ~ Ap O Paste [G Copy Fill BIUSA $ ~ % 2 00 0 Conditional Format as nsert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting Table ~ Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity C2 X V A B D E F G H I K L M N P Q S U V W X Y Z AA AB AF AG 70 71 5 72 GOLD MEDAL ATHLETIC CO. 73 Factory Overhead Cost Budget 74 For the Month Ending March 31 75 76 Indirect factory wages 77 Depreciation of plant and equipment 78 Power and light 79 Insurance and property tax 80 Total 81 82 83 GOLD MEDAL ATHLETIC CO. Cost of Goods Sold Budget For the Month Ending March 31 Direct materials: Direct materials purchases Cost of direct materials available for use Cost of direct materials placed in production Direct labor Factory overhead Total manufacturing costs Total work in process during period 101 Cost of goods manufactured 102 Cost of finished goods available for sale 103 104 Cost of goods sold 105 106 Supporting calculations: 107 Units Cost Total 108 Screenshot saved Finished goods inventory, March 1: 109 The screenshot was added to your Batting helmet 110 OneDrive. Fonthall palmat Pr. 22-3B + OneDrive Type here to search O 9 (?) 3:22 PM 3/17/2021AutoSave . Off M9A1 PR 22-3B - Search Mollie Saum MS X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments & Cut Aria 10 A" A ab Wrap Text _ AutoSum ~ Ap O [B Copy Fill Paste Conditional Format as nsert Delete Format Sort & Find & Analyze Sensitivity BIU~ ~SAY $ ~ % 2 00 0 Format Painter Formatting Table v Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity C2 X V A B E F G H J K L M N P Q S U V W X Y Z AA AB AF AG 91 92 Direct materials purchases 93 Cost of direct materials available for use 94 95 Cost of direct materials placed in production 96 Direct labor 97 Factory overhead 98 Total manufact 99 Total work in process during period 100 101 Cost of goods manufactured 102 Cost of finished goods available for sale 103 104 Cost of goods sold 105 106 Supporting calculations: 107 Units Cost Total 108 Finished goods inventory, March 1: 109 Batting helmet 110 Football helmet 111 Total 112 Finished goods inventory, March 31: 113 Batting helmet 114 Football helmet 115 Total 116 Direct materials inventory, March 1 117 Plastic 118 Foam lining 119 Total 120 Direct materials inventory, March 31 121 Plastic 122 Foam lining 123 Total 124 125 126 7 127 GOLD MEDAL ATHLETIC CO. Screenshot saved 128 Selling and Administrative Expenses Budget The screenshot was added to your 129 For the Month Ending March 31 OneDrive. 130 Pr. 22-3B + OneDrive 3:22 PM Type here to search O x (?) 3/17/2021AutoSave . Off M9A1 PR 22-3B - Search Mollie Saum MS X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments & Cut Aria 10 A" A ab Wrap Text _ AutoSum ~ Ap O Paste [G Copy Fill Conditional Format as nsert Delete Format Sort & Find & Analyze Sensitivity Format Painter BIUSA Table ~ Clear Formatting Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity C2 X V I A B C D E F G H I IJ K L M N P Q S U V W X Y Z AA AB AF AG 124 125 126 7. 127 GOLD MEDAL ATHLETIC CO. 128 Selling and Administrative Expenses Budget 129 For the Month Ending March 31 130 131 Selling expenses: 132 133 134 135 136 Total selling expenses 137 Administrative expenses 138 139 140 141 142 143 Total administrative expenses 144 Total operating expenses 145 146 147 8. 148 GOLD MEDAL ATHLETIC CO. 149 Budgeted Income Statement 150 For the Month Ending March 31 151 152 Revenue from sales 153 Cost of goods sold 154 Gross profit 155 Operating expenses 156 Selling expenses 157 Administrative expenses 158 Total operating expenses 159 Income from operations 160 Other revenue and expense: 161 Interest revenue Screenshot saved 162 Interest expense The screenshot was added to your 163 Income before income tax OneDrive. Pr. 22-3B OneDrive + 3:22 PM Type here to search O (?) 3/17/2021AutoSave . Off M9A1 PR 22-3B - Search Mollie Saum MS X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments & Cut Aria 10 A" A ab Wrap Text _ AutoSum ~ Ap O [G Copy Fill Paste BIU~ ~MAY Conditional Format as nsert Delete Format Sort & Find & Analyze $ ~ % 2 00 0 Sensitivity Format Painter Formatting Table ~ Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity C2 X V A B C D E F G H I J K L M N P Q S U V W X Y Z AA AB AF AG 139 140 141 142 143 Total administrative expenses 144 Total operating expenses 145 146 147 8. 148 GOLD MEDAL ATHLETIC CO. 149 Budgeted Income Statement 150 For the Month Ending March 31 151 152 Revenue from sales 153 Cost of goods sold 154 Gross profit 155 Operating expenses: 156 Selling expenses 157 Administrative expenses 158 Total operating expenses 159 Income from operations 160 Other revenue and expense: 161 Interest revenue 162 Interest expense 163 Income before income tax 164 Income tax expense 165 Net income 166 167 168 169 170 171 172 173 174 175 176 177 Screenshot saved 178 The screenshot was added to your 179 OneDrive. 100 Pr. 22-3B OneDrive (?) 3:22 PM Type here to search 3/17/2021
