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 thatthe 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, the 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 expenses 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. Paymentsto 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 (SG&) fixed costs are cash expenses and are paid on June 30 for the entire year.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 maintains 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.?This material specifies this case?s required content, format, and due date. Prepare a report for the Board of Directors that identifies the following:1. The proposed new product?s budgeted net cash flow for the first 12 months of its operations.

Transcribed Image Text:

February March April May July September 490,000 $153.00 January June August October November December January 499,000 $152.00 Unit Sales 511,000 503,000 $153.00 509,000 497,000 512,000 496,000 514,000 487,000 511,000 513,000 490,000 Price $152.00 $152.00 $152.00 $151.00 $152.00 $151.00 $149.00 $149.00 $153.00 Purchase Cost 63.90 65.90 66.00 64.30 64.30 65.70 66.40 66.80 65.20 62.00 66.00 65.50 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 February March April May July September 490,000 $153.00 January June August October November December January 499,000 $152.00 Unit Sales 511,000 503,000 $153.00 509,000 497,000 512,000 496,000 514,000 487,000 511,000 513,000 490,000 Price $152.00 $152.00 $152.00 $151.00 $152.00 $151.00 $149.00 $149.00 $153.00 Purchase Cost 63.90 65.90 66.00 64.30 64.30 65.70 66.40 66.80 65.20 62.00 66.00 65.50 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

Answer rating: 100% (QA)

1Cash Budget to determine Interest Expense 2 Profit Calculation after Determining Interest Expense ... View the full answer