You are asked to prepare the following:
1	Revenue budget (in dollars)
2	Production budget (in units)
3	Direct materials purchases budget (in quantities')
4	Direct materials purchases budget (in dollars')
5	Direct Manufacturing Labor Budget (in dollars')
6	Manufacturing Overhead budget ( in dollars')
7	Budgeted Finished goods inventory at Dec 31, 2020 (in Dollars')
8	Budgeted income statement (in dollars)

please fill in the tables and explain thank you! need practice to learn explain please

Ve Manufacture Co. manufactures and sells two products. X and Y. WeManufacture Co. gathered the following data to prepare budgets for 2 iven the following information: 2020 Projected Sales Direct materials used to produce Product Units Price each Unit X 5,000 $ 100 DM Unit X Y Y 6,000 $ 75 Type 1 Pounds 2 2 Type 2 Kg 2 1 2020 Inventories in Units Type 3 Units 1 1 Expected Target Jan 1 Dec 31 Product 2020 2020 X *Just In Time Inventory management Y Projected 2020 direct materials are as follows: Target Inventor y Dec 31, Expected Expected Inventor Direct Purchase y Jan 1, Material Price 2020 In: Type 1 $ 5 300 Pounds Type 2$ 15 500 kg Type 3 $ 10 600 Units 2020 In: 3,500 Pounds 3,000 kg 1,000 Units Rate per Projected direct labor for Hours Product per Unit hour 1.50 $ 20 1 20 $ 25 OH allocated per DLH $ 20 7 Budgeted Finished goods inventory at Dec 31, 2019 (in Dollars") Budgeted income statement (in dollars) 8 Revenue =Q*SP Required 1 - Revenue budget: Product X Y Total - Required 2 - production budget in units: X Y Open Produce THINK 210 inventory schedule given, opening units sold+closing-opening total Available: Close Take out what we still have. Given Sold from above, given Required 3 - DM purchases budget in Q: Inputs: Type 2 Type 1 Type 3 Y =DM per unit given* units produced from Q2. (2,2,1 per unit) =DM per unit given* units produced from Q2. (2,1,1 per unit) total materials units given above DM Q's - kg kg Units Required 4 - DM purchases budget in $': Inputs: Type 2 Type 1 Type 3 Open Purchase Available Close Use Kg Kg Units kg/unit cost (Given) $ purchases $ work= -3*44,500 $ total for future section $ 14*32,250 $ 12*21,500 Required 5 - Direct Manufacturing Labour Budget Product DLH per type DLS per type X $ Y $ Total SDL S total for future section - Required 6 - Manufacturing OH budget in $ Product OH$ per type X $ Y $ Required 6 - Manufacturing OH budget in $ Product OHS per type X S Y S Total SOHS total for future section = DM purchase price given per type*amount used per type Required 7 - Budgeted Finished Goods inventory per type Type 1 Type 2 Type 3 DMU DMU DLU OHU Cost per U $ man. Y Type 2 Type 3 = DM purchase price given per type*amount used per type all given in tables Type 1 DMU DMU DLU OHU Cost per U $ man. Required 8 - Create the income statement Cost per U $ man. Required 8 - Create the income statement We Manufacture Co. Budgeted Income Statement For the months January 1 - Dec 31 20XX Revenue $ ***COGS Net income (loss) *** (units of X opening Jan 1 * $---sales price) +(--- units of Y at opening Jan 1 at $---) = opening: $ $ ***We use sales price for opening units; just an assumption here. $ you don't need to know why for 211. $ $ $ opening inventory $DM total in part 4 $DL total from part 5 $OH total from part 6 Less closing Inventory $s from required 7 COGS total $