Please show formulas used in excel Needs to be done in Excel Needed Budgets done Sales Budget, Production Budget, Direct Material Budget, and Direct Labor Budget If all can not be done a set up of how to or explanation of how to would be nice very confused on how to start, The information provided is all that is given to me

The data in each worksheet should show unit data and dollar amount data for the following:

1st qtr.

2nd qtr.

3rd qtr.

4th qtr.

Total 2019

1 Salem Valve and Pump Company 2Budget Data for 2019 4 6 Budgeted Sales in Units 2019 7 Valves 8 Pumps 9 Flow Controllers 10 Total Units 2nd qtr 3rd qtr 4th qtr Total 2019 91,800 153,000 61,200 306,000 1st qtr 21,600 36,000 14,400 72,000 24,000 40,000 16,000 80,000 22,800 38,000 15,200 76,000 23,400 39,000 15,600 78,000 1st qtr 2020 25,740 42,900 17,160 85,800 Flow 12 Sales Mix Ratio(Solve) 13 Sales Ratio in Units 14 Valves Pumps Controllers Flow Valves Pumps Controllers 15 16 Sales Price per unit 17 18 58.00 $ 100.00 110.00 Flow Controllers 19 Valves Pumps 20 12/31/18 Ending Inventory Units 4,320 7,200 2,880 Flow Inventory Value Finished Goods 12/31/2018 $ Value of Ending Inventory 22 Valves Pumps Controllers Total FG Inv 23 $140,400 $ 327,816$ 211,392 $ 679,608