Please give formulas on excel on how to do each step, I would like to see the formulas to solve each one instead of the answers for it thank you!

HOME INSERT PAGE LAYOUT FORMULAS DATAREVIEW Sign In 11 A A Conditional Format as Cell Cells Editing Formatting TableStyles- Paste Clipboard r 1 Stanford Enterprises uses job 2 The allocation base for overhead is direct labor hours -order costing 4 Data for the vear just ended: 5 Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours S 275,000 25,000 27,760 9 Actual costs for the vear 10Purchase of raw materials (all direct) 11Direct labor cost 12 Manufacturing overhead costs 13 14 Inventories: 15 Raw materials (all direct) 16 Work in process 17 Finished goods 18 19 Use the data to answer the following 20 S375,000 $536,300 $302,750 Beginnin Endin 15,000 S 11,375 $ 27,875 $ 22,350 26,450 $ 34,600S

Question

Please give formulas on excel on how to do each step, I would like to see the formulas to solve each one instead of the answers for it thank you!

image text in transcribed

HOME INSERT PAGE LAYOUT FORMULAS DATAREVIEW Sign In 11 A A Conditional Format as Cell Cells Editing Formatting TableStyles- Paste Clipboard r 1 Stanford Enterprises uses job 2 The allocation base for overhead is direct labor hours -order costing 4 Data for the vear just ended: 5 Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours S 275,000 25,000 27,760 9 Actual costs for the vear 10Purchase of raw materials (all direct) 11Direct labor cost 12 Manufacturing overhead costs 13 14 Inventories: 15 Raw materials (all direct) 16 Work in process 17 Finished goods 18 19 Use the data to answer the following 20 S375,000 $536,300 $302,750 Beginnin Endin 15,000 S 11,375 $ 27,875 $ 22,350 26,450 $ 34,600S