Manufacturing Overhead (MOH) = 3,830,000

Machine Hours (MH) 4,800

POHR (predetermined overhead rate) 797.92 per machine hour

Select data regarding the beginning and ending inventories, transactions during the year, and other key figures are provided. You will need to calculate the missing data in order to complete your analysis.

I need an expert to confirm if the amounts for

Raw materials used in production [4] and Direct labor costs [5] are correct

A B C D 1 Insert formulas and cell references into the "gold" cells below. 2 3 Estimates for the Year 4 Manufacturing Overhead (MOH) 3,830,000 4,800 5 Machine Hours (MH) 6 POHR 797.92 per machine hour 7 8 9 Beginning of the Year Inventory 10 Raw materials 348,800 11 Work-in-process 154,695 12 Finished Goods (boxes of Muesli) 426,680 13 14 15 Completed Job Sheet Information for the Year 16 Direct Materials Used 17 Direct Labor Costs 7,905,400 960,000 4,762 18 Actual Machine Hours 19 Applied Overhead [3] 3,799,695 20 21 22 Transactions during the Year 23 Raw material purchases 7,900,000 24 Raw materials used in production [4] 7,994,400 25 Direct labor costs [5] 960,960 26 Incurred (actual) MOH [15] 3,810,000 E F G H Jobs in Process at the Beginning of the Year # of units (boxes) Direct materials Direct labor costs Actual machine hours Totals: [1] Jobs in Process at the End of the Year # of units (boxes) Direct materials Direct labor costs Actual machine hours. Totals: [2] J Production "Campaigns" Q1-201219 Q2-201220 16,000 84,800.00 240.00 10.0 93,019.20 Production "Campaigns" Q4-211219 Q4-211220 32,000 169,600.00 960.00 24.0 189,710.08 32,000 60,000.00 80.00 2.0 61,675.84 32,000 64,200.00 320.00 8.0 70,903.36 K 154,695.04 260,613.44