(1) Prepare a sales budget (2) Prepare a Production budget

Budget Excel Project Bloomeld Co. Bloomeld is an ice cream company, who makes hoinestyle ice creams using fresh and all- natural ingredients and sells to retail stores. In preparing the budget for the coming year, 2024, they forecasted the following expected sales and gathered the costs data from managers in various areas of the company. Sales ' Forecasted to sell 25,000 units in the E\" Quarter of 2024, and an additional 2,000 units each quarter. - The 2,000 additional units per quarter are expected to continue through the end of 2nd quarter of 2025. ' The 2023 4'\" quarter sales were 24,000 units. ' Selling price for one unit of ice cream is $15. ' Bloomeld maintains 15% ofthe next quarter >s unit sales in ending inventory. - All sales to retail stores are on account, with collections of 75% made in the quarter of sales and 25% collected in the quarter after sale. ' Accounts receivable on December 3 i, 2023 is $22,000