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 muffins, 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 muffins for $5.50 each, 65,000 one-dozen packages of cookies for $4.75 each, and 85,000 one-dozen loaves of bread 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 of 2021. They always drop off a bit after the holidays anyway, but with the increase in sales prices, a 20 percent drop from the fourth quarter of 2020 results is forecasted. Sales will grow steadily at about 5 percent a quarter with these new prices during 2021. Fourth-quarter sales will be high because of the holidays lets say 20 percent, instead of 5 percent, from the third to the fourth quarter. The first quarter of the 2022 will continue the 5 percent growth as though the holiday jump didnt occur. Frenchies gives their business customers a lot of leeway in paying. They collect 30 percent of the credit sales within the current quarter, 45 percent in the following quarter, and 25 percent in the quarter after that. Total sales were $802,000 in third quarter and $1,002,500 in the fourth quarter of 2020. They will be still collecting quite a bit of that money 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 worth of 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 quarters raw materials on hand at all times. Using this information, complete the three tabs in the worksheet. Just fill in the forecasted data in the blue boxes and copy the formulas to complete the sheets.

Case Data = Signifies original case assumptions. Estimated % drop: Estimated Growth: Estimated Additional Holiday Increase: Sales: Muffins Cookies Bread Sales Numbers Trasposed for Copying Last Year Q4 45,000 65,000 85,000 Muffins 2022 2021 Q2 Current Year Q1 23 Q4 Q1 Q2 0 0 0 0 0 Q2 Cookies 6888 0 2022 2021 Q2 0 Q1 Q3 Q4 Q1 Q2 Next Year 0 0 0 0 0 0 Bread Q1 Q2 0 0 2022 2021 Q2 Q1 Q3 Q4 Q1 Q2 Sales Price/Item: $6.00 $5.25 $5.75 0 0 0 0 0 Collection Information: Credit Policy: Cash Sales Credit Sales Collection in Current Quarter Collection in Following Quarter Collection in 3rd Quarter Prior Year 10% 90% 30% 45% 25% Current Year 10% Collection Schedule Transposed for Copying 90% Q1 Q2 Q3 30% 37.0% 40.5% 22.5% 45% 25% Collections from Last Year's Sales: Sold Q1 Q4 Quarter Q3 Q4 Received $0 $0 $0 $0 $0 Payments in Current Year 02 Q3 $0 $0 $0 $0 $0 $0 $0 $0 $0 Manufacturing Information: Ending Inventory Goal: Raw Materials Goal: Case Data = Signifies original case assumptions. Estimated % drop: Estimated Growth: Estimated Additional Holiday Increase: Sales: Muffins Cookies Bread Sales Numbers Trasposed for Copying Last Year Q4 45,000 65,000 85,000 Muffins 2022 2021 Q2 Current Year Q1 23 Q4 Q1 Q2 0 0 0 0 0 Q2 Cookies 6888 0 2022 2021 Q2 0 Q1 Q3 Q4 Q1 Q2 Next Year 0 0 0 0 0 0 Bread Q1 Q2 0 0 2022 2021 Q2 Q1 Q3 Q4 Q1 Q2 Sales Price/Item: $6.00 $5.25 $5.75 0 0 0 0 0 Collection Information: Credit Policy: Cash Sales Credit Sales Collection in Current Quarter Collection in Following Quarter Collection in 3rd Quarter Prior Year 10% 90% 30% 45% 25% Current Year 10% Collection Schedule Transposed for Copying 90% Q1 Q2 Q3 30% 37.0% 40.5% 22.5% 45% 25% Collections from Last Year's Sales: Sold Q1 Q4 Quarter Q3 Q4 Received $0 $0 $0 $0 $0 Payments in Current Year 02 Q3 $0 $0 $0 $0 $0 $0 $0 $0 $0 Manufacturing Information: Ending Inventory Goal: Raw Materials Goal