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 Monthly Cash Flows brim bns as a obute tot Arborcrest's monthly payments, beyond those included in the product costs, are summarized below: obab 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 E20 $14,479 Interest Expense $5,563 $53,345 22 Capacity Arborcrest's weekly production capacity is: cases (4 fermenters) ( 1240 Weekly Capacity fermenter - batch) 19 weeks (2 onde batch) cases = 2480 week Initial Inventory Current Inventory Alicat 2,564 Edgar 6,264 Taj Mahal 5,873 cases cases cases Monthly Cash Flows brim bns as a obute tot Arborcrest's monthly payments, beyond those included in the product costs, are summarized below: obab 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 E20 $14,479 Interest Expense $5,563 $53,345 22 Capacity Arborcrest's weekly production capacity is: cases (4 fermenters) ( 1240 Weekly Capacity fermenter - batch) 19 weeks (2 onde batch) cases = 2480 week 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 Monthly Cash Flows brim bns as a obute tot Arborcrest's monthly payments, beyond those included in the product costs, are summarized below: obab 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 E20 $14,479 Interest Expense $5,563 $53,345 22 Capacity Arborcrest's weekly production capacity is: cases (4 fermenters) ( 1240 Weekly Capacity fermenter - batch) 19 weeks (2 onde batch) cases = 2480 week Initial Inventory Current Inventory Alicat 2,564 Edgar 6,264 Taj Mahal 5,873 cases cases cases Monthly Cash Flows brim bns as a obute tot Arborcrest's monthly payments, beyond those included in the product costs, are summarized below: obab 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 E20 $14,479 Interest Expense $5,563 $53,345 22 Capacity Arborcrest's weekly production capacity is: cases (4 fermenters) ( 1240 Weekly Capacity fermenter - batch) 19 weeks (2 onde batch) cases = 2480 week Initial Inventory Current Inventory Alicat 2,564 Edgar 6,264 Taj Mahal 5,873 cases cases cases