Kayla Hamelin is the owner and manager of a nationwide producer and seller of laser tag equipment, Hamelin's Pew-Pews, LLC's. Hamelin is in the process of producing her budget for the third quarter of 2020. Assume the following: 1. Hamelin wants ending finished goods to be 15% of next month's sales units. 2. Hamelin will have 4,500 packages at the end of June, and she wants to have 7,500 packages at the end of September. 3. It takes 24 minutes of direct labor to make a package, and labor costs $10/hr. 4. Hamelin's variable overhead rate is $5.00 per direct labor hour. 5. Fixed overhead is $25,000 per month, of which $10,000 is depreciation. 6. Hamelin's predetermined overhead rate is calculated quarterly based on DLHs. Please complete Hamelin's Pew-Pews, LLC's production, labor and manufacturing overhead budgets. (15 Points) Upload your completed Excel file with the answer to the Budgeting Question. G Assumptions: June EFG Units September EFG Units Desired EFG% September 45,000 Quarter 130,000 September Quarter Exam Question 2 Hamelin's Pew-Pews, LLC Production Budget For the Third Quarter of 2020 Month July August Budgeted Unit Sales 50,000 35,000 Add: Desired EFG Total Needs 0 Less: BFG 1 Required Production Units 12 13 Hamelin's Pew-Pews, LLC 14 Direct Labor Budget 15 For the Third Quarter of 2020 16 Month 17 July August 18 Required Production Units 19 Direct Labor Hours per Unit 20 Budgeted Direct Labor Hours 21 Direct Labor Cost per Hour 22 Total Direct Labor Cost 22 24 Hamelin's PewPews, LLC 25 Manufacturing Overhead Budget 26 For the Third Quarter of 2020 27 Month 28 July August 29 Budgeted Direct Labor Hours 30 Variable Overhead Rate 31 Variable Overhead 32 Fixed Overhead 33 Total Manufacturing Overhead 34 Less: Depreciation 35 Cash Disbursements for Overhead 36 Predetermined OH Rate 37 38 Assumptions: DLH per unit DL Wage Rate DLH/ September Quarter Assumptions: Variable OH Rate Fixed OH per Quarter Depreciation per Quarter per DUH