give answers by making a proper charts as in question
Current Attempt in Progress Blue Spruce Compary is considering the purchase of a new machine. The inwoice price of the machine is $148,000, freight charges are estimated to be $4,000, and installation costs are expected to be $6,000. The salvage value of the new equipment is expected to be zero after a useful life of 5 years. The company could retain the existing equigment and use it for an additional 5 years if it doesn't purchase the new machine. At that time, the equipment's salvape value would be zero. If Blue Spruce purchases the new machine now. it would have to scrap the existing machine. Blue Spruce's accountant, Sandra Robinson, has accumulated the following data for annual sales and expenses, with and without the new machine: 1. Without the new machine, Blue Spruce can sell 13.000 units of product annually at a per-unit selling price of $100. If it purchases the new machine, the number of units produced and sold would increase by 10%, and the selling price would remain the same. 2. The new machine is faster than the old machine, and it is more effcient in its use of materials. With the old machine, the gross profit rate is 25% of sales, whereas the rate will be 302 of sales with the new machine 3. Annual selling expenses are $191,000 with the current machine. Because the new inachine would produce a greater number of units to be sold, annual selling expenses are expected to increase by 10 sif it is purchased. 4. Annual administrative expenses are expected to be $106,000 with the old machine, and $120,000 with the new machine 5. The current book value of the existing machine is $38,000. Blue Spruce uses straight-line depreciation Prepare an incremental analysis for the five years that shows whether Blue Spruce should retain the existing machine or buy the new one. (Ignore income tax effects.) (If an amount reduces the net income then enter with a negative sign preceding the number or parenthesis, es. -15,000, (15,000). Enter all other amounts as positive and subtroct where necessary. Do not leave any answer field blank. Enter 0 for amounts.) Question 5 of 10 18 Sales Less costs: Cost of goods sold $ Buy New Machine Selling Administrative Operating income \begin{tabular}{|c|c|c|c|c|c|c|} \hline & & \begin{tabular}{l} Retain Old \\ Machine \end{tabular} & & \begin{tabular}{l} Replace Old \\ Machine \end{tabular} & & \begin{tabular}{c} Net income \\ Increase (Decrease) \end{tabular} \\ \hline Operating income & $ & & $ & & $ & \\ \hline \end{tabular} Question 5 of 10 -18 i \begin{tabular}{|c|c|c|c|c|c|} \hline & & \begin{tabular}{l} Retain Old \\ Machine \end{tabular} & & \begin{tabular}{l} Replace Old \\ Machine \end{tabular} & \begin{tabular}{l} Net Income \\ Increase (Decrease) \end{tabular} \\ \hline Operating income & s & & $ & & $ \\ \hline \multicolumn{6}{|c|}{ Cost of the new machine } \\ \hline Totals: & $ & & s & & s \\ \hline \end{tabular} The new machine be purchased. eTextbook and Media Sine for Later Attempts: 0 of 2 used Submit