6 words Question 2 15 pts 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 Upload Choose a File Question 3 5 pts Why do we calculate both a price variance and an efficiency variance? Exam Question2 Hamelin's Pew.Pews, LLC Production Budget For the Third Quarter of 2020 Month July August 50,000 35,000 Assumptions: June EFG Units September EFG Units Desired EFG% September 45,000 Quarter 130,000 Budgeted Unit Sales Add: Desired EFG Total Needs Less: BFG Required Production Units Hamelin's Pew-Pews, LLC Direct Labor Budget For the Third Quarter of 2020 Month July August September Quarter Assumptions: DLH per unit DL Wage Rate DLH/u 9 1 2 Required Production Units Direct Labor Hours per Unit Budgeted Direct Labor Hours Direct Labor Cost per Hour Total Direct Labor Cost September Quarter Hamelin's Pew-Pews, LLC Manufacturing Overhead Budget For the Third Quarter of 2020 Month July August Budgeted Direct Labor Hours Variable Overhead Rate Variable Overhead Fixed Overhead Total Manufacturing Overhead Less: Depreciation Cash Disbursements for Overhead Predetermined OH Rate Assumptions: Variable OH Rate Foxed OH per Quarter Depreciation per Quarter 9 0 1 B2 33 34 25 36 per DLH