Question 2 Henna Hair hired **YOU** to produce the master budget. They plan on selling 1055 bottles every quarter Q1-Q2 at a cost of 118$ per bottle. They plan on selling 2555 bottles at 23-24 at a cost of 106$ per bottle. A) Prepare the Sales Budget They would desire a finished goods inventory of 165 bottles of shampoo every quarter Q1-Q2-Q4, and 155 bottles for Q3. The beggining inventory is 200 in Q1, as this is a popular model. B) Prepare the Production Budget They need 1 empty plastic bottle (units of raw materials) to produce a bottle of shampoo (finished goods). They desire an end inventory for the empty plastic bottles of 350 bottles at the end of each quarter Q1-Q3-Q4, and 550 stickers at the end of Q2. The beggining inventory is 150 in Q1, as this is a popular model. An empty plastic bottle costs 7$ to purchase in Q1, and is forecasted to increase by 1$ every quarter, as gas prices have gone up in 2022... C) Prepare the Direct Materials Budget Henna Hair hires entry level workers who spend 15 minutes on the assembly line making a bottle of shampoo in Q1-Q2. The managers are very qualified leaders. They train, motivate, and empower their employees which results in increased efficiency. The employees becone better equipped to perform in Q3-Q4 and now spend only 12 minutes on the assembly line making a bottle of shampoo. They hire entry level people pay them 18$/hour in Q1. Henna Hair increases their pay for 1$/hour every quarter to reward their hard work, reduce turnover, and account for inflation. D-1) Prepare the Direct Labor Budget D-2) What is the total direct labor cost for the year? 5 Per Quarter, Every Quarter Variable manufacturing overhead rate Fixed manufacturing overhead Minus depreciation $ $ $ 3,000 755 E) Prepare the Manufacturing Overhead Budget F) Prepare the Ending Inventory Budget