plz creat basic operating budgets in Excel

Wear It Manufacturer creates hoodies for recent Superbowl Champions. The company sews the Hoodies from wool fabric and attaches a team logo patch. Data relating to the current team is as follows: e Seahawks-blue hoodies with a Seahawk logo. The budgeted direct cost inputs for each hoodie this year are as follows: 34 metres Blue-Wool fabrice Seahawks logo patches- Direct manufacturing labour- 1.5+ hourse ttttttt Unit data pertaining to the direct materials for March are as follows: t Actual-Beginning Direct Materials Inventory-(March 1ste e Blue-Wool fabric Seahawks logo patches 30+ metres 40e ttt e e Target-Ending Direct Materials-Inventory (March-31st) e Blue Wool fabric e Seahawks logo patches 20+ metres 20+ e e Unit cost data relating to direct-cost inputs for February and March are as follows: Focus Blue Wool fabric e Seahawks logo patches 30+ metres 40+ Target Ending Direct Materials Inventory (March 31st) Blue Wool fabrica Seahawks logo patches 20+ metrese 20- Unit cost data relating to direct-cost inputs for February and March are as follows: February (Actual Blue Wool fabric (per metre) $...............8.00 Seahawks logo patches (per patch) $ -6.00 Direct manufacturing labour cost per hour $ 26.00 March 31st (Budgeted) ES -10.00 $ -7.00 $ 31.00 Manufacturing overhead (both variable and fixed) is allocated to each hoodie on the basis of budgeted direct manufacturing labour-hours per hoodie. The budgeted variable manufacturing rate for March-ise $22 per direct manufacturing labour-hour. The budgeted fixed manufacturing overhead-for-March-is $5,100. Both variable and fixed manufacturing overhead costs are allocated to each unit of finished goods. Non-manufacturing costs for General & Administration are $1,750. 1.t K Data relating to the finished goods inventory for March are as follows: E + Beginning Inventory 22 + Beginning inventory in dollars $........1,800.00 & Target ending inventory in units 28 Budgeted sales for March are 165 units of the Seahawks hoodies. The budgeted selling price per unit-in- March is $159. 1.1.1 + + Assume the following in your answer: 1. 1. 1. 1.1.1.1.1.1 + Work in process inventory are negligible and ignored. + Direct materials inventory and finished goods inventory are costed using the FIFO method. Wear It Manufacturer creates hoodies for recent Superbowl Champions. The company sews the Hoodies from wool fabric and attaches a team logo patch. Data relating to the current team is as follows: e Seahawks-blue hoodies with a Seahawk logo. The budgeted direct cost inputs for each hoodie this year are as follows: 34 metres Blue-Wool fabrice Seahawks logo patches- Direct manufacturing labour- 1.5+ hourse ttttttt Unit data pertaining to the direct materials for March are as follows: t Actual-Beginning Direct Materials Inventory-(March 1ste e Blue-Wool fabric Seahawks logo patches 30+ metres 40e ttt e e Target-Ending Direct Materials-Inventory (March-31st) e Blue Wool fabric e Seahawks logo patches 20+ metres 20+ e e Unit cost data relating to direct-cost inputs for February and March are as follows: Focus Blue Wool fabric e Seahawks logo patches 30+ metres 40+ Target Ending Direct Materials Inventory (March 31st) Blue Wool fabrica Seahawks logo patches 20+ metrese 20- Unit cost data relating to direct-cost inputs for February and March are as follows: February (Actual Blue Wool fabric (per metre) $...............8.00 Seahawks logo patches (per patch) $ -6.00 Direct manufacturing labour cost per hour $ 26.00 March 31st (Budgeted) ES -10.00 $ -7.00 $ 31.00 Manufacturing overhead (both variable and fixed) is allocated to each hoodie on the basis of budgeted direct manufacturing labour-hours per hoodie. The budgeted variable manufacturing rate for March-ise $22 per direct manufacturing labour-hour. The budgeted fixed manufacturing overhead-for-March-is $5,100. Both variable and fixed manufacturing overhead costs are allocated to each unit of finished goods. Non-manufacturing costs for General & Administration are $1,750. 1.t K Data relating to the finished goods inventory for March are as follows: E + Beginning Inventory 22 + Beginning inventory in dollars $........1,800.00 & Target ending inventory in units 28 Budgeted sales for March are 165 units of the Seahawks hoodies. The budgeted selling price per unit-in- March is $159. 1.1.1 + + Assume the following in your answer: 1. 1. 1. 1.1.1.1.1.1 + Work in process inventory are negligible and ignored. + Direct materials inventory and finished goods inventory are costed using the FIFO method