Please assist by including formulas in Excel when solving. This way, a better understanding of the solution is available not just the final answer.

Relevant Costs for Equipment Replacement Decision Health Scan, Inc. paid $50,000 for X-ray equipment four years ago. The equipment was exp annual operating costs of $45,000. Technological advances have made the machine purcha ray device incorporating the new technology is available at an initial cost of $100,000 and a only six years before it, too, is obsolete. Asked to analyze the financial aspects of replacing prepared the following analysis. After looking over these numbers, the Center's manager re Six-year savings [($45,000 $26,000) 6] Cost of new machine Undepreciated cost of old machine Advantage (disadvantage) of replacement Calculate the net benefit (cost) of purchasing the new machine. $114,000 -100,000 -30,000 ($16,000) Special Order Tobitzu TV produces wall mounts for flat panel television sets. The forecasted income statement for 2009 is as fo TOBITZU TV Budgeted Income Statement For the Year 2009 Sales ($46 per unit) Cost of good sold ($32 per unit) Gross profit Selling expenses ($5 per unit) Net income Additional Information (1) Of the production costs and selling expenses, $800,000 and $100,000, respectively, a Tobitzu TV received a special order from a hospital supply company offering to buy 14,00 for $30. If it accepts the order, there will be no additional selling expenses, and there is c sufficient excess capacity to fill the order. The company's sales manager argues for rejec because "we are not in the business of paying $32 to make a product to sell for $30." $4,600,000 -3,200,000 1,400,000 -500,000 $900,000 Sell or Process Further Great Lakes Boat Company manufactures sailboat hulls at a cost of $4,200 per unit. The rigging to the hulls prior to sale at an additional cost of $1,900. The completed sailboats Calculate the net benefit (cost) of processing the boat hulls into sail boats. As Special Order: High-Low Cost Estimation SafeRide, Inc. produces air bag systems that it sells to North American autom Although the company has a capacity of 300,000 units per year, it is currently rate of 180,000 units. SafeRide, Inc. has received an order from a German ma 60,000 units at $10.00 each. Budgeted costs for 180,000 and 240,000 units a Sales to North American manufacturers are priced at $22 per unit, but the sale company should aggressively seek the German business even if it results in a She believes obtaining this order would open up several new markets for the general manager commented that the company cannot tighten its belt to abso ($2.75 60,000) it would incur if the order is accepted. (a) Calculate the net benefit (cost) of accepting the order from the German bu $ (b) Calculate the net benefit (cost) of accepting the order from the German bu company is operating at full capacity. $ Make or Buy Rashad Rahavy, M.D., is a general practitioner whose offices are located in th Professional Building. In the past, Dr. Rahavy has operated his practice with a receptionist/secretary, and a part-time bookkeeper. Dr. Rahavy, like many sma has billed his patients and their insurance companies from his own office. The bookkeeper, who works 10 hours per week, is employed exclusively for this p North Falls Physician's Service Center has offered to take over all of Dr. Raha collections for an annual fee of $7,000. If Dr. Rahavy accepts this offer, he wil the bookkeeper. The bookkeeper's wages and fringe benefits amount to $13 p bookkeeper works 50 weeks per year. With all the billings and collections don Rahavy will have two additional hours available per week to see patients. He four patients per hour at an average fee of $35 per visit. Dr. Rahavy's practice new patients often have to wait several weeks for an appointment. He has res his office hours or working more than 50 weeks per year. Finally, if Dr. Rahavy center, he will no longer need to rent a records storage facility for $100 per mo (a) Calculate the net benefit (cost) of outsourcing the bookkeeping. $ (b) In making a final decision, all of the following are possible disadvantages t considered by Dr. Rahavy, except: It could become more expensive than the bookkeeper in the future if the outsi increases fees. Not having to be concerned about managing this function internally, and being entirely on serving patients. The loss of direct control of this important function. The quality of the outsourced service may not meet expectations. None of the above. Sell or Process Further Port Allen Chemical Company processes raw material D into joint products E It costs $100 to convert 100 liters of D into 60 liters of E and 40 liters of F. Pro per liter or processed further into Product G at an additional cost of $4 per lite liter. Determine whether Product F should be sold or processed further into Produc further processing. $Answer $ per liter