Arborcrest Studio Ales Data and Demand Forecast Demands og louboida broad The sales department has provided the following demand forecast for 2024: Jan 26 Feb Mar Apr -Revere May Jun Jul Alicat 553 1,280 2,527 13,830 12,899 11,801 12,459 9,326 3,565 1,790 1,357 1,214 72,601 Edgar 3,601 3,106 3,564 3,053 2,941 2,618 1,846 2,105 2,377 2,954 4,087 4,383 36,635 Taj havba Mahal 3,489 3,525 3,561 Toisisse 3,596 WS 3,632 Bananin 3,668 3,704 3,739 3,775 3,811 3,847 3,882 44,229 ton 510100 ,939, 170. Aug cobs Sep Oct Nov Dec Product Profitability The sales price and cost (direct materials, direct labor and manufacturing overhead) for each brand is summarized below: Alicat Edgar Taj Mahal Cost (cs) $10.08 $9.34 $10.43 Selling Price (cs) $15.50 $14.50 $17.50 99 2291 Vorrevoli COGS44ann Monthly Cash Flows bromed bass boot Arborcrest's monthly payments, beyond those included in the product costs, are summarized below: SO babi Expenses Advertising Promotion and Selling $9,388 General & Administrative $19,624 Depreciation Machinery Plant & Equipment $1,583 Depreciation Buildings and Improvements $2,708 Salary & Wage Expense 20 $14,479 Interest Expense $5,563 $53,345 22 Capacity Arborcrest's weekly production capacity is: cases Weekly Capacity (4 fermenters) (1240 fermenter - batch) 19 (2 weeks batch) cases = 2480 week 80.00 Initial Inventory Current Inventory Alicat 2,564 Edgar 6,264 Taj Mahal 5,873 cases cases cases Simulation 1 HW Given the company data and demand forecast presented below do the following: Individual Assignment [25 points]: Estimate Arborcrest Ale's earnings before tax