would appreciate the answer in an excel or word document. Thank you!

You have a business manufacturing man-buns for depilous hipster wannabes (these man-buns have been referred to in the past as toupees). You produce these man-buns (MB) in batches of 100. Each MB has the following manufacturing standards (i.e., budgets): Direct materials 3.0 locks of $12.00 per lock hair Direct labor 2.2 Direct $18.00 per Direct Labor Labor Hours Hour Indirect materials $375 per batch Other indirect manufacturing costs $7,000 per month Normal output Total capacity 10 batches per month 12 batches per month There is no beginning or ending inventory for WIP and Finished Goods. You have sufficient beginning direct material inventory of "locks of hair" that you do not need to purchase any during the month. During April 2020 you made 11 batches of MBs and spent/incurred the following: 3,400 locks 2,500 DLH Locks of hair Direct labor Variable O/H (Indirect materials) Fixed O/H (Other indirect mfg costs) $40,600 in total $44,800 in total $4,021 in total $7,111 in total REQUIRED: a) Prepare an analysis of actual production costs for April compared to Budget-adjusted-for-output (Flex Budget). Identify the usage/efficiency, price/rate, spending, and volume variances as appropriate. b) Record journal entries to record the use of direct materials, direct labor, and variable & fixed manufacturing overhead. (Post costs to WIP first, then transfer all of WIP to Finished Goods. Transfer all of Finished Goods to COGS - remember there is no beginning or ending inventory for WIP or Finished Goods.) c) You are in charge of all manufacturing overhead. Did you do a "good" job managing overhead in April? Why? You have a business manufacturing man-buns for depilous hipster wannabes (these man-buns have been referred to in the past as toupees). You produce these man-buns (MB) in batches of 100. Each MB has the following manufacturing standards (i.e., budgets): Direct materials 3.0 locks of $12.00 per lock hair Direct labor 2.2 Direct $18.00 per Direct Labor Labor Hours Hour Indirect materials $375 per batch Other indirect manufacturing costs $7,000 per month Normal output Total capacity 10 batches per month 12 batches per month There is no beginning or ending inventory for WIP and Finished Goods. You have sufficient beginning direct material inventory of "locks of hair" that you do not need to purchase any during the month. During April 2020 you made 11 batches of MBs and spent/incurred the following: 3,400 locks 2,500 DLH Locks of hair Direct labor Variable O/H (Indirect materials) Fixed O/H (Other indirect mfg costs) $40,600 in total $44,800 in total $4,021 in total $7,111 in total REQUIRED: a) Prepare an analysis of actual production costs for April compared to Budget-adjusted-for-output (Flex Budget). Identify the usage/efficiency, price/rate, spending, and volume variances as appropriate. b) Record journal entries to record the use of direct materials, direct labor, and variable & fixed manufacturing overhead. (Post costs to WIP first, then transfer all of WIP to Finished Goods. Transfer all of Finished Goods to COGS - remember there is no beginning or ending inventory for WIP or Finished Goods.) c) You are in charge of all manufacturing overhead. Did you do a "good" job managing overhead in April? Why