Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: James Jiambalvo

7th Edition

1119577721, 978-1119577720

More Books

Students also viewed these Accounting questions

Question

What are the need and importance of training ?

Answered: 1 week ago

Question

What is job rotation ?

Answered: 1 week ago