Kayla Hamelin is the owner and manager of a nationwide producer and seller of laser tag equipment, Hamelins Pew-Pews, LLCs. 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 months 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. Hamelins 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. Hamelins predetermined overhead rate is calculated quarterly based on DLHs.

Please complete Hamelins Pew-Pews, LLCs production, labor and manufacturing overhead budgets. (15 Points)

- . B C D E F G H J K L . N 0 P Q R S T Assumptions: June EFG Units September EFG Units Desired EFG% September Quarter 130,000 45,000 September Quarter Assumptions: DLH per unit DL Wage Rate DLH/ 1 Exam Question 2 2 Hamelin's Pew-Pews, LLC 3 Production Budget 4 For the Third Quarter of 2020 5 Month 6 July August 7 Budgeted Unit Sales 50,000 35,000 8 Add: Desired EFG 9 Total Needs 10 Less: BFG 11 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 23 24 Hamelin's Pew-Pews, 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 39 40 41 42 September Quarter Assumptions: Variable OH Rate Fixed OH per Quarter Depreciation per Quarter per DLH