Please help me answer questions 5 & 6 with excel referance.

Quinnipiac Padfolio Club makes two products (Padfolios and Business Cards) for students to use during interview season. The company uses a normal costing system with a single manufacturing overhead cost pool (allocated based on direct labor costs), and operates at capacity (i.e. all overhead is allocated to units produced in the year). Direct Material and Direct Labor is incurred in the factory and is directly traced to the two product lines (Padfolios & Business Cards). Overhead costs (like plant supervision, maintenance and utilities) are incurred in the factory but cannot be directly traced to the two product lines. Budgeted information for the year ended December 31, 2017 is as follows: Budgeted Factory Figures Units to be produced Direct Materials Direct Manufacturing Labor Manufacturing Overhead Costs TOTAL MANUFACTURING COSTS $ $ Padfolios Business Cards 5,200 20,100 24,500 $ 25,500 $ 41,200 $ 16,800 $ ? ? $ 65,700 $ 42,300 $ Total 25,300 50,000 58,000 23,000 131,000 $ Actual information for the year ended December 31, 2017 is as follows: Actual Factory Figures Padfolios Business Cards Total Units Produced 4,500 23,000 27,500 Direct Materials $ 23,000 $ 26,500 $ 49,500 Direct Manufacturing Labor $ 38,000 $ 17,500 $ 55,500 Manufacturing Overhead Costs ? $ 21,500 TOTAL MANUFACTURING COSTS $ 61,000 $ 44,000 $ 126,500 Answer cells must remain in the same location so do not insert/delete columns or rows in the file. Numeric answers must include a formula or ref 1 Assuming Normal Costing, calculate the budgeted manufacturing overhead rate for 2017 that will be used to allocate overhead into the inventory cost of the products. $ Budgeted M.OH Rate 23,000 $ $ 58,000 0.397 4 Assuming Normal Costing, calculate the total amount of under-or over-allocated overhead for the year. $ $ Over/(Under)-allocated OH 23,000 $ 58,000 $ $ 55,500 21,500 509 5 Calculate the ending inventory balances and COGS if over/(under)-allocated manufacturing overhead is written off to COGS. Total Work-in-Process Unadjusted WIP + Adjust M.OH =Adjusted WIP Finished Goods Unadjusted FG + Adjust M.OH =Adjusted FG Cost of Goods Sold Unadjusted COGS + Adjust M.OH =Adjusted COGS $ $ $ 6 101 Calculate the ending inventory balances if over/(under)-allocated manufacturing overhead is pro-rated based on the accounts' unadjusted balances. Total $ Work-in-Process Unadjusted WIP Unadjusted % + Adjust M.OH =Adjusted WIP Finished Goods Unadjusted FG Unadjusted % + Adjust M.OH =Adjusted FG Cost of Goods Sold Unadjusted COGS Unadjusted % + Adjust M.OH =Adjusted COGS 0% $ $