LiquidHair Inc. hired an accountant to produce the master budget. C Herbal Hair Sales Budget Budgeted sales in bottles Selling price per bottle M Sales in $ Q1 1100 22 1100 Q3 Q4 Total 1100 2400 5700 18 $ 20 $ 22 $ 22 $ 22 $ $24,200 $24,200 $24,200 $43,200 $ 115,800 Production Budget Q1 C Budgeted sales in bottles 22 Q3 Q4 Total 1100 1100 1100 2400 5700 D Desired finished goods inventory 110 160 160 160 160 Total need 1210 1260 1260 2560 5860 A Less beginning finished goods inventory 20 110 160 160 20 B Required production units 1190 1150 1100 2400 5840 Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 SIGN ME L B Font fir C 1100 17 Alignment D LA Number F ormatting Table Styles Styles F G Direct Materials Budget Q1 Q2 Q3 Q4 Total B Required production units 1190 1150 1100 2400 5840 Units of raw material needed per bottle 1 1 1 1 1 FH Units of raw material needed to meet production 1190 1150 1100 2400 5840 Plus desired ending raw material inventory Total units of raw materials needed 25 25 25 50 50 1215 1175 1125 2450 5890 EGO Less units in beginning raw material inventory 10 25 25 25 10 Units of raw materials to be purchased 1205 1150 1100 2425 5880 Cost of raw material per unit $1 $1 $1 $1 $1 Cost of raw material to be purchased $1,205 $1,150 $1,100 $2,425 $5,880 Direct Labour Budget Q1 Q2 Q3 Q4 Total Required production nits 1190 1150 1100 2400 5840 Direct labor hours per bottle Total direct labor hours needed Direct labor cost per hour Total direct labor cost 0.166667 0.166667 0.166667 0.166667 0.16666667 198 192 183 400 973 $10 $10 $10 $10 $10 $1,983 $1,917 $1,833 $4,000 $9,733 W 36% 4 HOURS Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 SIGN ME Type here to search 48 Saturday_Exam_due_2021-10-02 5PM - Excel Tell me what you want to do Bikram Singh BS Conditional Format as Cell Insert Delete Format Formatting Table Styles EST Styles Cells Home Insert Draw Page Layout Formulas Data Review View Help * Calibri 11 AA 3 ab Wrap Text General BIU A Merge & Center $ % .0.00 .00.0 rd 171 17 Alignment Number 44 A B X Font fx 1100 The variable manufacturing overhead rate is 2$ per labour hour. The fixed manufacturing overhead is 1,000$ per month. The depreciation is 150$ per month. a) How many months are there in a quarter? b) Calculate the manufacturing overhead budget. c) What is the predetermined overhead rate for the year? Prepare the Ending Inventory Budget F G H J K WE 10 min 15 min 10 min / 60 min 15 min/60 min 0.16667 hours 30 min 30 min/60 min 0.25 hours 0.5 hours 45 min 45 min / 60 min 0.75 hours 60 min 90 min 60 min/60 min 90 min/60 min 1 hours 1.5 hours 4 HOURS Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 SIGN ME Type here to search O 48 W 36% 10C A