could you show the formulas as well please

Frenchies is a medium-sized regional bakery that specializes in providing orders to grocery and convenience stores. Because of the popularity of its brand, it has also opened a small caf for walk-in business. in order to maintain its high quality standard, Frenchies produces only three products: breakfast muffns, fresh bread. and chocolate chip cookies. Although business has been good in the past few years, a lucky contact with a large chain has recently allowed it to expand its brand out of the local region. Growth has been high since the new contract went into effect. In 2020, Frenchies sold 45,000 one-dozen packages of muffns for S5.SO each, 65,000 one-dozen packages of cookies for $4.75 each, and 85,000 One-dozen loaves ofbread for $5.25 each. They will raise prices to $6.00 for muffins, $5.25 for cookies. and $5.75 for bread for 2021. Sales will drop some in the first quarter of2021. They always drop Offa bit after the holida anyway, but with the increase in sales prices, a 20 percentdrop from the fourth quarter of 2020 results is forecasted. Sales will grow steadily at about5 percent a quarte with these new prices during 2021. Fourth- quarter sales will be high because ofthe holidays let's say 20 rcent, instead of 5 percent. from the third to the foum quarter. The first quaiter of the 2022 will continue the 5 percent growth as though the holiday jump didn't occur. Frenchies gives their business customers a lotofleeway in paying. They collect 30 percentofthe credit sales within the current quarter. 45 percent in the following quarter, and 25 percent in the quarter after that Total sales were S802.OOO in third quarter and Sl in the fourth quarter Of 2020. They will be sill collecting quite a bit ofthatmoney in 2021 based on our collection breakdown. Frenchies cookies and bread would dry out if they kept them too long so they normally keep only about two days' inventory on hand to avoid shipping issues or problems with the caf based on a 90-day quarter. Frenchies' raw materials are needed for the next quarter. so they keep 15 percent Of the next quarter's raw materials on hand at all times. using this information, complete the three tabs in the worksheet Justfill in the forecasted data in the blue boxes and copy the formulas to complete the sheets. DO NOT PUT IN HARD NUMBERS, TO GET THE MAXIMUM POINTS, you NEED TO COMPLETE THE