please show formulas on how to do the problem !!!

Step 1: Sales Budget Points Possible 0.1 pts*15 = 1.5 pts Instruction: Provided below is the expected selling price and expected unit sales for the four quarters of 2022 Use this information to complete the sales budget. Expected Selling Price: $101 Expected Sales Volume (in units) Quarter 1 Quarter 2 1,400 3,300 Quarter 3 2,600 Quarter 4 2,800 Bear Company Sales Budget For the year ending December 31, 2022 Quarter Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Expected Unit Sales Unit Selling Price Toal Sales Step 2 Production Budoet Points Possible: 0.1 pts 17 - 17 pts Instruction: Bear Company expects to meet future sales requirements by maintaing an ending inventory equal to 20% of the next quarter's budgled sales volume Use these information to complete the production budget. Ending Inventory as of next quarter's sales volume: Ending Finished Goods Inventory on December 31, 2021 Expected Sales Volume for Quarter 1 of year 2023 2016 280 2.600 units units Bear Company Production Budget For the year ending December 31, 2022 Quarter Quarter 1 Quarter 2 Quarter 1,400 3,300 2,600 Year Quarter 4 2.800 Expected Unit Sales Add Desired ending Finished Goods Units Total Required Units Less Beginning Finished Goods Units Required Production Units Step 3. Direct Material Budget Points Possible: 0.05 pts *32-1.6 pts Instruction: Bear Company maintains an ending inventory equal to 20% of the next quarter's production requirements. Use these information to complete the Direct Material Budget. Assuming only one type of material are used for production 4 per to 1.424 2,080 Ibs lbs Ending Inventory as _of next quarter's production requirements 20% Number of pounds of direct material required for each product: lbs Expected cost per pound $7.00 Beginning inventory of direct materials for Quartar 1 of 2022, in pounds Desired ending inventory of direct materials for Quarter 4 of 2022, in pounds: Complete Production Budget first before you start this helyett Bear Company Direct Material Budget For the year ending December 31, 2022 Quarter Quarter 1 Quarter 2 Quarter 3 Units to be Producted Direct Material per Unit Total Pounds needed for production Add Desired ending Direct Material pour Total Material Required Less Beginning Direct Material pounds Direct Material Purachases Cost per Pound Total Cost of Direct Material Purchases Quarter 4 Year $0.00