preparing a comprehensive Budget
i solved 1 and 2 and 3 and 4 but i need help in the rest of them
6. % 00 7 000 BXP&A 6. 11 BIUA 315 I fx.= K L F G D H $ 10,000 B tal direct labor cost $ 34,400 $ 10,200 $6,400 $ 7,800 Bathworks Overhead Budget For the Year Ended December 31 Quarter 1 2. Year Units Variable overhead costs: Factory supplies ($0.05) Employee benefits ($0.25) Inspection (50.10) Maintenance and repairs ($0.15) Utilities ($0.05) Total variable overhead costs Totalfixed overhead costs Total overhead costs $195 975 390 585 195 $2,340 4,300 $ 6,640 Bathworks Selling and Administrative Expenses Budget For the Year Ended December 31 Quarter 1 2 3 Year Units + Template PageStyle Template 1 selected 341 KB English (USA) Type here to search O RI mprehensive Budget Problem (1)xdsx - Edit View Insert Format Styles Sheet Data Tools Window Help XIX A 6 A 1 : 173 ri 11 BIUA. EF % 00 7 000 SE - G H D c B Bathworks Selling and Administrative Expenses Budget For the Year Ended December 31 Quarter 1 3 4 Year 11 $400 600 200 58 09 10 Units Variable overhead costs: expenses: Delivery expenses ($0.10) Sales commissions ($0.15) Accounting ($0.05) Other administrative expenses $0.20) Total variable selling and administrative expenses Total fixed selling and administrative expenses Total selling and administrative expenses 800 112 113 $2,000 5,000 115 116 $ 7.000 119 1207 121 123 124 Leave no cells blank. Ensure to enter "o" wherever applicable. Bathworks Cost of Goods Manufactured Budget For the Year Ended December 31 + Template Sheet 1 of 3 Page Style Template English (USA) item selected 341 Type here to search Comedie dort Problem tox-brice Cak e fotos et format Styles Sheet Datools Window Help ...SA... 13 BIUAMES 0.% 00 00 00 1.5 D 1 C H D 1 119 1203 MN Barthworks Cost of Goods Manufactured Budert For the Year Ended December 13 Coudere materials used 111 Ovo keus inventory beginning ceny policy to have not in process atend Buod income Statement for the Year Ended December 11 Type here to search O RI Comprehensive Budget Problem (TxoxLibreOffice Calc File Edit View Insert Format Styles Sheet Data fools Window Help QXXA 6.3 11:31 11 BIUA.ES % 00 7 000 OSA fo- D EL G H 10 K MN C 119 140 141 142 It is a company policy to have no units in process at year end. Bathworks Buderted Income Statement For the Year Ended December 31 146 148 149 151 153 154 Sales Cost of goods sold Finished goods inventory, beginning Cost of goods manufactured Cost of goods available for sale Les finished goods inventory, ending" Cost of goods sold Gross margin Selling and administrative expenses Income from operations Income taxes expense (30%) Net income Assumes a constant product unit cost during the year. Units Rate Finished goods inventory 164 Beginning Ending 165 Sheet PageStyle Template English (USA) 10 item item selected 34.1 KB Type here to search o RI - - M Comprehensive Budget Problem (1) sx - LibreOffice Calc File Edit View Insert Format Styles Sheet Data Tools Window Help X PA6 Abs. 1 1 1 Calibri 11 BIUA..3352 % 00 7 000 X fx . A B C D E F G H K 1 P-02 Name : haya 2 Section : 3 4 Enter the appropriate amount or item in the shaded cells. Use the drop-down lists when available. 5 An asterisk (*) will appear next to an incorrect entry in the outlined cells. 6 7 Preparing a comprehensive Budget 81 9 Bathworks 10 Sales Budget For the Year Ended December 31 Quarter 13 1 2 3 Year 14 Sales in Units 4,000 3,000 5,000 5,000 17,000 16 Selling Price per unit $6 $ 6 $6 56 $6 17 Total Sales $ 24,000 $ 18,000 $ 30,000 $ 30,000 $ 102,000 18 19 20 21 Bathworks Production Budget For the Year Ended December 31 24 Quarter 25 2 3 Year 12 15 1 4 27 4,000 3,000 5,000 5,000 17,000 Sales in units Plus desired units of ending finished goods inventorya) Desired total units 20 300 4,300 500 3,500 500 5,500 600 600 5,600 17,600 + Template Sheet13 Page Style_Template English (USA) 10 m nem selected 34103 Type here to search O BI hp 6. % 00 7 000 BXP&A 6. 11 BIUA 315 I fx.= K L F G D H $ 10,000 B tal direct labor cost $ 34,400 $ 10,200 $6,400 $ 7,800 Bathworks Overhead Budget For the Year Ended December 31 Quarter 1 2. Year Units Variable overhead costs: Factory supplies ($0.05) Employee benefits ($0.25) Inspection (50.10) Maintenance and repairs ($0.15) Utilities ($0.05) Total variable overhead costs Totalfixed overhead costs Total overhead costs $195 975 390 585 195 $2,340 4,300 $ 6,640 Bathworks Selling and Administrative Expenses Budget For the Year Ended December 31 Quarter 1 2 3 Year Units + Template PageStyle Template 1 selected 341 KB English (USA) Type here to search O RI mprehensive Budget Problem (1)xdsx - Edit View Insert Format Styles Sheet Data Tools Window Help XIX A 6 A 1 : 173 ri 11 BIUA. EF % 00 7 000 SE - G H D c B Bathworks Selling and Administrative Expenses Budget For the Year Ended December 31 Quarter 1 3 4 Year 11 $400 600 200 58 09 10 Units Variable overhead costs: expenses: Delivery expenses ($0.10) Sales commissions ($0.15) Accounting ($0.05) Other administrative expenses $0.20) Total variable selling and administrative expenses Total fixed selling and administrative expenses Total selling and administrative expenses 800 112 113 $2,000 5,000 115 116 $ 7.000 119 1207 121 123 124 Leave no cells blank. Ensure to enter "o" wherever applicable. Bathworks Cost of Goods Manufactured Budget For the Year Ended December 31 + Template Sheet 1 of 3 Page Style Template English (USA) item selected 341 Type here to search Comedie dort Problem tox-brice Cak e fotos et format Styles Sheet Datools Window Help ...SA... 13 BIUAMES 0.% 00 00 00 1.5 D 1 C H D 1 119 1203 MN Barthworks Cost of Goods Manufactured Budert For the Year Ended December 13 Coudere materials used 111 Ovo keus inventory beginning ceny policy to have not in process atend Buod income Statement for the Year Ended December 11 Type here to search O RI Comprehensive Budget Problem (TxoxLibreOffice Calc File Edit View Insert Format Styles Sheet Data fools Window Help QXXA 6.3 11:31 11 BIUA.ES % 00 7 000 OSA fo- D EL G H 10 K MN C 119 140 141 142 It is a company policy to have no units in process at year end. Bathworks Buderted Income Statement For the Year Ended December 31 146 148 149 151 153 154 Sales Cost of goods sold Finished goods inventory, beginning Cost of goods manufactured Cost of goods available for sale Les finished goods inventory, ending" Cost of goods sold Gross margin Selling and administrative expenses Income from operations Income taxes expense (30%) Net income Assumes a constant product unit cost during the year. Units Rate Finished goods inventory 164 Beginning Ending 165 Sheet PageStyle Template English (USA) 10 item item selected 34.1 KB Type here to search o RI - - M Comprehensive Budget Problem (1) sx - LibreOffice Calc File Edit View Insert Format Styles Sheet Data Tools Window Help X PA6 Abs. 1 1 1 Calibri 11 BIUA..3352 % 00 7 000 X fx . A B C D E F G H K 1 P-02 Name : haya 2 Section : 3 4 Enter the appropriate amount or item in the shaded cells. Use the drop-down lists when available. 5 An asterisk (*) will appear next to an incorrect entry in the outlined cells. 6 7 Preparing a comprehensive Budget 81 9 Bathworks 10 Sales Budget For the Year Ended December 31 Quarter 13 1 2 3 Year 14 Sales in Units 4,000 3,000 5,000 5,000 17,000 16 Selling Price per unit $6 $ 6 $6 56 $6 17 Total Sales $ 24,000 $ 18,000 $ 30,000 $ 30,000 $ 102,000 18 19 20 21 Bathworks Production Budget For the Year Ended December 31 24 Quarter 25 2 3 Year 12 15 1 4 27 4,000 3,000 5,000 5,000 17,000 Sales in units Plus desired units of ending finished goods inventorya) Desired total units 20 300 4,300 500 3,500 500 5,500 600 600 5,600 17,600 + Template Sheet13 Page Style_Template English (USA) 10 m nem selected 34103 Type here to search O BI hp
