H44 for B C Hazlett, Inc., operates at capacity and makes plastic combs and hairbrushes. Although the combs and brushes are a matching set, they are sold individually and so the sales mix is not 1:1. Hazlett's management is planning its annual budget for fiscal year 2018. Here is information for 1 2018: 2 3 Input Prices 4 Direct Materials 5 Plastic $ 0.30 per ounce 6 Bristles 0.75 per bunch 7 Direct Manufacturing Labor 18.00 per DL hour 8 9 Input Quantities per Unit of Output 10 Combs Brushes 11 Direct Materials: 12 Plastic (ounces) 5.0 8.0 13 Bristlesi (bunches) 0.0 16.0 14 Direct Manufacturing Labor Hours 0.05 0.20 15 Machine Hours 0.025 0.1 16 17 Inventory Information, Direct Materials 18 Plastic Bristles 19 Beginning Inventory (ounces/bristles) 1,600 1,820 20 Target Ending Inventory (ounces/bristles) 1,766 2,272 21 Total Cost of Beginning Inventory (S) 456 $ 1,419 22 23 Sales and Inventory Information, Finished Goods 24 Combs Brushes Info Revenue Budget Production Budget DM Usage Budget DM Purchase B Nun fx A B D Unit Selling Price $ 9 $ 30 Target Ending Inventory (units) 1,200 1,400 Beginning Inventory (units) 600 1,200 Cost of Beginning Inventory (S) $ 2,700 $ 27,180 Note: Hazlett uses FIFO to cost finished goods inventory 1 Hazlett uses an activity-based costing system and classifies overhead into four activity pools: materials handling, setup, processing, and inspection. In addition, Hazlett separtes its non manufacturing costs into two groups: marketing and 2 distribution 3 4 Manufacturing Overhead and Nonmanufacturing Cost Information Cost Type Budgeted Variable Budgeted Fixed Per Unit of Cost 55 Costs Costs Allocation Rate Driver 36 Manufacturing 37 Materials Handling $ 17,235 $ 22,500 $ 0.225 per oz. of plastic 38 Setup 10,245 16,650 165.00 per setup hour 39 Processing 11,640 30,000 24.00 per machine hour 40 Inspection 10,500 1,560 0.45 41 Nonmanufacturing 42 Marketing $ 21,150 $ 90,000 $ 0.2105 per sales dollar 43 Distribution 0 1,170 45.00 per delivery 44 45 Input per Unit of Output Activity Information 46 Activity Combs Brushes 47 Materials Handling (plastic oz.) 5.0 8.0 48 Machine Setup (setup hours) 0.001666666667 0.01 49 Processing machine hours) 0.025 0.1 50 Inspection of units) 1.0 1.0 51 Info Revenue Budget Production Budget DM Usage Budget DM Purchase Budget Direct Labor B per unit A E B D Direct Manufacturing Labor Budget For the Month of December 2018 Output DL Hours per Total Hours Required Unit Hourly Wage Rate Total 3 Combs Brushes 5 Total 7 3 9 10 71 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Info Revenue Budget Production Budget DM Usage Budget DM Purchase Budget Direct Labor Budg G13 D E 2 B C Manufacturing Overhead Budget For the Month of December 2018 Variable Fixed Total 1 2 3 4 Materials Handling 5 Machine Setup 6 Processing 7 Inspection 8 Total Costs 9 10 11 12 3 D E B C Ending Inventories Budget 31-Dec-18 Quantity Unit Cost Direct Materials Total Plastic Bristles Finished Goods 3 Cat-allac 3 Dog-eriffic 0 Total Ending Inventory 71 12 13 14 Unit Cost of Ending FG Inventory 31-Dec-18 Combs Cost per Input Input per Unit Total Unit of Output Brushes Input per Unit Total of Output 15 16 Plastic 17 Bristles 18 Direct Manufacturing Labor 19 Materials Handling 20 Machine Setup 21 Processing 22 Inspection 23 Total 24 25 26 27 Clipboard Font s Alignme E10 fr C D A B 1 Cost of Goods Sold Budget 2 For the Month of December 2018 3 Beginning FG Inventory, 4-1 4 Direct Materials Used 5 Direct Manufacturing Labor 6 Manufacturing Overhead 7 Cost of Goods Manufactured 8 Cost of Goods Available 9 Deduct: Ending FG Inventory, 4-30 10 Cost of Goods Sold 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 DM Usage Budget DM Purchase Budget Direct Labor Budget MOH Bu Type here to search Calibri v 11 X Cut LA Copy Format Painter ' ' A A === 25 a. Au aste BI UBE Clipboard Font Alignment 5 fix D A B C Nonmanufacturing Costs Budget For the Month of December 2018 Variable Fixed Marketing Distribution Total Nonmanufacturing Costs Total . 3 4 5 6 7 8 9 0 21 22 23 24 25 26 27 28 29 Direct Labor Budget MOH Budget El Budget COGS Budget Nonmanufa Paste [Copy Format Painter B 1 0 - - - - - Clipboard Font E13 fx B 1 Budgeted Income Statement 2 For the Month of December 2018 3 Sales Revenue 4 Cost of Goods Sold 5 Gross Profit 6 Operating Expenses 7 Operating Income (Loss) 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 UN 24 X Cut Calibri 11 A A = BI U CAS [ Copy Paste Format Painter Clipboard LZ Font D7 A B C D 1 Revenue Budget 2 3 4 Combs For the Month of December 2018 Units Selling Price Total Revenues 12,000 $ 9 $ 108,000 14,000 30 420,000 26,000 $ 528,000 5 Brushes 6 Total 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Calibri v 11 X Cut LG Copy $ Format Painter - A A A A == a. A. BIU V Font 2 Clipboard IN y fx C Brushes 14,000 1,400 15,400 1,200 14,200 A B Production Budget For the Month of December 2018 Combs Budgeted Unit Sales 12,000 Add: Target Ending FG Inventory 1,200 Total Required Units 13,200 - Less: Beginning FG Inventory 600 3 Units of FG Inventory to be Produced 12,600 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 File Home Insert Calibri X Cut [Copy Format Painter 11AA AA === ab Wrap Tex BIUBAMerge & Paste Clipboard Font Alignment D22 D Bristles Total 4 113,600 227,200 340,800 456 1,419 1419 B 1 Direct Materials Usage Budget 2 For the Month of December 2018 3 Plastic Physical Units Budget 5 Direct Materials Required For: 6 Combs 63,000 7 Brushes 8 Total Quantity of Direct Mats to be Used 63,000 9 Cost Budget 10 Available from Beginning Direct Materials Inventory. 11 Plastic $ 456 12 Bristles $ 13 To be purchased this Period: 74 Plastic $ 18,950 15 Bristles 16 Direct Mats to be Used this Period 17 18 19 20 21 22 23 24 25 26 27 28 29 Info Revenue $ 255,939 18,950 255,939 276,764 $ File Home Insert Draw Calibri 11 X cut LB Copy Format Painter Clipboard AA== === 29 wr One A = = = = Me BIU-HE v Font Alignment D14 D Total A B 1 Direct Materials Purchases Budget 2 For the Month of December 2018 3 Plastic Bristles 4 Physical Units Budget 5 To be used in Production 63,000 340,800 6 Add: Target Ending Inventory 1,766 2,272 7 Total Requirements 64,766 343,072 8 Deduct: Beginning Inventory 1,600 1,820 9 Purchases to be Made 63,166 341,252 10 Cost Budget 11 Plastic Purchases $ 18,950 12 Bristle Purchases $ 255,939 13 Total Purchases S 18,950 $ 255,939 $ 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Info 18,950 255939 274,889 Revenue Budget Production Budget DM Usage Budget DM Purch H44 for B C Hazlett, Inc., operates at capacity and makes plastic combs and hairbrushes. Although the combs and brushes are a matching set, they are sold individually and so the sales mix is not 1:1. Hazlett's management is planning its annual budget for fiscal year 2018. Here is information for 1 2018: 2 3 Input Prices 4 Direct Materials 5 Plastic $ 0.30 per ounce 6 Bristles 0.75 per bunch 7 Direct Manufacturing Labor 18.00 per DL hour 8 9 Input Quantities per Unit of Output 10 Combs Brushes 11 Direct Materials: 12 Plastic (ounces) 5.0 8.0 13 Bristlesi (bunches) 0.0 16.0 14 Direct Manufacturing Labor Hours 0.05 0.20 15 Machine Hours 0.025 0.1 16 17 Inventory Information, Direct Materials 18 Plastic Bristles 19 Beginning Inventory (ounces/bristles) 1,600 1,820 20 Target Ending Inventory (ounces/bristles) 1,766 2,272 21 Total Cost of Beginning Inventory (S) 456 $ 1,419 22 23 Sales and Inventory Information, Finished Goods 24 Combs Brushes Info Revenue Budget Production Budget DM Usage Budget DM Purchase B Nun fx A B D Unit Selling Price $ 9 $ 30 Target Ending Inventory (units) 1,200 1,400 Beginning Inventory (units) 600 1,200 Cost of Beginning Inventory (S) $ 2,700 $ 27,180 Note: Hazlett uses FIFO to cost finished goods inventory 1 Hazlett uses an activity-based costing system and classifies overhead into four activity pools: materials handling, setup, processing, and inspection. In addition, Hazlett separtes its non manufacturing costs into two groups: marketing and 2 distribution 3 4 Manufacturing Overhead and Nonmanufacturing Cost Information Cost Type Budgeted Variable Budgeted Fixed Per Unit of Cost 55 Costs Costs Allocation Rate Driver 36 Manufacturing 37 Materials Handling $ 17,235 $ 22,500 $ 0.225 per oz. of plastic 38 Setup 10,245 16,650 165.00 per setup hour 39 Processing 11,640 30,000 24.00 per machine hour 40 Inspection 10,500 1,560 0.45 41 Nonmanufacturing 42 Marketing $ 21,150 $ 90,000 $ 0.2105 per sales dollar 43 Distribution 0 1,170 45.00 per delivery 44 45 Input per Unit of Output Activity Information 46 Activity Combs Brushes 47 Materials Handling (plastic oz.) 5.0 8.0 48 Machine Setup (setup hours) 0.001666666667 0.01 49 Processing machine hours) 0.025 0.1 50 Inspection of units) 1.0 1.0 51 Info Revenue Budget Production Budget DM Usage Budget DM Purchase Budget Direct Labor B per unit A E B D Direct Manufacturing Labor Budget For the Month of December 2018 Output DL Hours per Total Hours Required Unit Hourly Wage Rate Total 3 Combs Brushes 5 Total 7 3 9 10 71 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Info Revenue Budget Production Budget DM Usage Budget DM Purchase Budget Direct Labor Budg G13 D E 2 B C Manufacturing Overhead Budget For the Month of December 2018 Variable Fixed Total 1 2 3 4 Materials Handling 5 Machine Setup 6 Processing 7 Inspection 8 Total Costs 9 10 11 12 3 D E B C Ending Inventories Budget 31-Dec-18 Quantity Unit Cost Direct Materials Total Plastic Bristles Finished Goods 3 Cat-allac 3 Dog-eriffic 0 Total Ending Inventory 71 12 13 14 Unit Cost of Ending FG Inventory 31-Dec-18 Combs Cost per Input Input per Unit Total Unit of Output Brushes Input per Unit Total of Output 15 16 Plastic 17 Bristles 18 Direct Manufacturing Labor 19 Materials Handling 20 Machine Setup 21 Processing 22 Inspection 23 Total 24 25 26 27 Clipboard Font s Alignme E10 fr C D A B 1 Cost of Goods Sold Budget 2 For the Month of December 2018 3 Beginning FG Inventory, 4-1 4 Direct Materials Used 5 Direct Manufacturing Labor 6 Manufacturing Overhead 7 Cost of Goods Manufactured 8 Cost of Goods Available 9 Deduct: Ending FG Inventory, 4-30 10 Cost of Goods Sold 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 DM Usage Budget DM Purchase Budget Direct Labor Budget MOH Bu Type here to search Calibri v 11 X Cut LA Copy Format Painter ' ' A A === 25 a. Au aste BI UBE Clipboard Font Alignment 5 fix D A B C Nonmanufacturing Costs Budget For the Month of December 2018 Variable Fixed Marketing Distribution Total Nonmanufacturing Costs Total . 3 4 5 6 7 8 9 0 21 22 23 24 25 26 27 28 29 Direct Labor Budget MOH Budget El Budget COGS Budget Nonmanufa Paste [Copy Format Painter B 1 0 - - - - - Clipboard Font E13 fx B 1 Budgeted Income Statement 2 For the Month of December 2018 3 Sales Revenue 4 Cost of Goods Sold 5 Gross Profit 6 Operating Expenses 7 Operating Income (Loss) 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 UN 24 X Cut Calibri 11 A A = BI U CAS [ Copy Paste Format Painter Clipboard LZ Font D7 A B C D 1 Revenue Budget 2 3 4 Combs For the Month of December 2018 Units Selling Price Total Revenues 12,000 $ 9 $ 108,000 14,000 30 420,000 26,000 $ 528,000 5 Brushes 6 Total 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Calibri v 11 X Cut LG Copy $ Format Painter - A A A A == a. A. BIU V Font 2 Clipboard IN y fx C Brushes 14,000 1,400 15,400 1,200 14,200 A B Production Budget For the Month of December 2018 Combs Budgeted Unit Sales 12,000 Add: Target Ending FG Inventory 1,200 Total Required Units 13,200 - Less: Beginning FG Inventory 600 3 Units of FG Inventory to be Produced 12,600 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 File Home Insert Calibri X Cut [Copy Format Painter 11AA AA === ab Wrap Tex BIUBAMerge & Paste Clipboard Font Alignment D22 D Bristles Total 4 113,600 227,200 340,800 456 1,419 1419 B 1 Direct Materials Usage Budget 2 For the Month of December 2018 3 Plastic Physical Units Budget 5 Direct Materials Required For: 6 Combs 63,000 7 Brushes 8 Total Quantity of Direct Mats to be Used 63,000 9 Cost Budget 10 Available from Beginning Direct Materials Inventory. 11 Plastic $ 456 12 Bristles $ 13 To be purchased this Period: 74 Plastic $ 18,950 15 Bristles 16 Direct Mats to be Used this Period 17 18 19 20 21 22 23 24 25 26 27 28 29 Info Revenue $ 255,939 18,950 255,939 276,764 $ File Home Insert Draw Calibri 11 X cut LB Copy Format Painter Clipboard AA== === 29 wr One A = = = = Me BIU-HE v Font Alignment D14 D Total A B 1 Direct Materials Purchases Budget 2 For the Month of December 2018 3 Plastic Bristles 4 Physical Units Budget 5 To be used in Production 63,000 340,800 6 Add: Target Ending Inventory 1,766 2,272 7 Total Requirements 64,766 343,072 8 Deduct: Beginning Inventory 1,600 1,820 9 Purchases to be Made 63,166 341,252 10 Cost Budget 11 Plastic Purchases $ 18,950 12 Bristle Purchases $ 255,939 13 Total Purchases S 18,950 $ 255,939 $ 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Info 18,950 255939 274,889 Revenue Budget Production Budget DM Usage Budget DM Purch