Estimate Aborcrest Ales Net Income for 2018 Arborcrest Studi

Arborcrest Studio Ales Data and Demand Forecast Demand The sales department has provided the following demand forecast for 2018: Taj Jan Alicat 553 EdgarMahal 3,601 3,489 1,280 3,106 3,525 2,527 3,564 3,561 13,830 3,0533,596 May 12,899 2,941 3,632 Jun 11,801 2,618 3,668 12,459 1,846 3,704 9,326 2,105 3,739 3,565 2,377 3,775 1,790 2,954 3,811 Nov 1,357 4,0873,847 1,2144,383 3,882 72,601 36,635 44,229 Jan Feb Mar Apr Jul Aug Sep Oct 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 $10.43 $10.01 $9.34 $15.50 $14.50 $17.50 02017 ScrimmageSIM LLC

Solution

Net income for 2018: Sales (Based on demand) Alicat (72601*15.50) 1125316 Edgar (36635*14.50) 531207.50 Taj Mahal (44229*17.50) 774007.5 2430531 Less: Cost of goods sold Alicat (72601*10.08) 731818.1 Edgar (36635*9.34) 342170.9 Taj Mahal (44229*10.43) 461308.5 1535297 Gross profit 895233 Less: Operating expenses Adverising and promotion (9388*12) 112656 General and administrative (19624*12) 235488 Salary and wage (14479*12) 173748 Loan payment (12548*12) 150576 672468 Net income 222765