Can you show the step in excel please?

The HOW and WHY of Constructing a Sales Budget Information: ABT, Inc., manufactures and sells concrete block for residential and commercial building. ABT expects to sell the following in 20xl: Required: 1. Construet a sales budget for the ABT concrete block line for the coming year Show total sales by quarter and in total for the year. 2. What if there were two types of concrete block (type 1 and type 2) and 60 percen of the sales in each quarter were for type 1? Assume the selling ponce for type 1 at $0.60 in the first quarter and $0.70 for the rest of the year, The selling price of type 2 is $0.80 in Quarters 1 and 2 and is $0.90 per mait for the rest of the yeat. Construct a sales budget for ABT showing sales for both types and in total. The HOW and WHY of Constructing a Production Budget Information: ABT expects the following unit sales and desired ending inventory in 201 : Inventory on both January 1,201, and January 1,202, is expected to be 100;000 blocks Required: 1. Construct a production budget for the ABT concrete block line for the coming year Show total units produced by quarter and ini total for the year. 2. What if ABT did not provide the desired ending inventory in units, but-instead relied on an inventory rule that the?desired ending inventory of blocks was equal to 5 percent of the next period's sales? Further, assume that the budgeted unit sales in Quarter 1,202, equaled 2,500,000, and that the beginning inventory ifor Quarter 1,201, met the inventory rule Construct production budget for AABT showing units produced by quarter and in ttal for the yearl tasint? sel sils The HOW and WHY of Constructing a Sales Budget Information: ABT, Inc., manufactures and sells concrete block for residential and commercial building. ABT expects to sell the following in 20xl: Required: 1. Construet a sales budget for the ABT concrete block line for the coming year Show total sales by quarter and in total for the year. 2. What if there were two types of concrete block (type 1 and type 2) and 60 percen of the sales in each quarter were for type 1? Assume the selling ponce for type 1 at $0.60 in the first quarter and $0.70 for the rest of the year, The selling price of type 2 is $0.80 in Quarters 1 and 2 and is $0.90 per mait for the rest of the yeat. Construct a sales budget for ABT showing sales for both types and in total. The HOW and WHY of Constructing a Production Budget Information: ABT expects the following unit sales and desired ending inventory in 201 : Inventory on both January 1,201, and January 1,202, is expected to be 100;000 blocks Required: 1. Construct a production budget for the ABT concrete block line for the coming year Show total units produced by quarter and ini total for the year. 2. What if ABT did not provide the desired ending inventory in units, but-instead relied on an inventory rule that the?desired ending inventory of blocks was equal to 5 percent of the next period's sales? Further, assume that the budgeted unit sales in Quarter 1,202, equaled 2,500,000, and that the beginning inventory ifor Quarter 1,201, met the inventory rule Construct production budget for AABT showing units produced by quarter and in ttal for the yearl tasint? sel sils