Burtch Company, a retailer, buys merchandise from its suppliers to sell to its customers. Facing declining profitability, Burtch Company is planning an addition to its product line. The marketing manager, Marie Patel, is spearheading the new product's planning. Marie believes that the proposed new product will be a good fit with Burch Company's current product line. Working with John Forsyth, Burch Company Manager of Analytics, Marie has developed forecasts of the proposed new product's monthly unit sales, selling price per unit, purchase price per unit, and fixed costs. Appendix A summarizes these forecasts. Sales are comprised of cash sales (10% of total sales) and credit sales (90% of total sales). John Bentley, the credit manager, believes that credit sales will be collected as follows: 50% in the month of sale, 30% in the month following the month of sale, 14% collected in the second month following the month of sale, and 6% never collected. Burch Company recognizes estimated bad debt expense at the time of sale. Monthly purchases are comprised of 80% for this month's sales and 20% for next month's sales. There will be no inventory on hand at the start of January. Therefore, 100% of January's sales will be purchased in January. In January Burch Company will also purchase 20% of February's sales. Payments to the merchandise supplier will be 60% in the month of purchase and 40% in the month following the month of purchase. Burtch Company uses the FIFO (first in first out) method of inventory valuation. Depreciation comprises 40% of the fixed facilities costs. All other fixed facilities costs and all the Selling General and Administration (SC-58:) fixed costs are cash expenses and are paid on June 30 for the entire yeah Burtch Company has $1,000,000 to start this project. Burtch Company has access to a line of credit with the Eastern Bank. The line of credit has an annual interest rate of 12%. The Eastern Bank requires that Burtch Company maintain a minimum cash balance of $1,000,000. Interest on the outstanding line of credit balance is due and paid on the first day of each month. January February March April May June July August September October November December January Unit Sales 509,000 497,000 512,000 496,000 514,000 511,000 487,000 511,000 490,000 603,000 513,000 499,000 490,000 $152.00 $152.00 $152.00 $151.00 $152.00 $151.00 $149.00 $149.00 $153.00 $153.00 $153.00 $152.00 Price 63.90 65.90 66.00 64.30 64.30 65.70 66.40 66.80 65.20 62.00 66.00 65.50 Purchase Cost Fixed Cost -Facilities $10,800,000 $11,800,000 $11,600,000 $11,300,000 $11,600,000 $11,400,000 $12,000,000 $10,800,000 $10,800,000 $11,700,000 $11,900,000 $10,600,000 -Selling, General, and Administrative 16,000,000 16,900,000 16,900,000 16,100,000 17,000,000 16,200,000 16,700,000 16,700,000 16,400,000 16,800,000 16,200,000 16,900,000