Q8

please answer in excel sheet

Charles Wilson operates a small machine shop. He manufactures one standard product that is also available from many other similar businesses, and he also manufactures deluxe products to order. His accountant prepared the following annual income statement: Deluxe Sales Standard Sales Total Sales $54,000 $27,000 $81,000 Costs Material 10.800 8.640 19,440 Labour 21.600 9.720 31,320 Depreciation 6.804 3.888 10,692 Power 756 432 1.188 Rent 6.480 1.080 7.560 648 Heat and light 108 756 432 972 Other 1,404 47.520 Total costs 24,840 72,360 $6,480 Net income $2.160 $8,640 The depreciation charges are for machines used in the product lines. The power charge is apportioned based on an estimate of the power consumed by each line. The rent is for the building space, which has been leased for 10 years at $7.560 per year. The rent and the heat and light costs are apportioned to the product lines based on the amount of floor space occupied by each line. All other costs are current expenses that are identified with the product line causing them. Avalued customer has asked Mr. Wilson if he would manufacture 5.400 of the deluxe products for him. Mr. Wilson is working at capacity and would have to give up some other business in order to take this order. He cannot cancel deluxe orders he has already agreed to, so he would have to reduce the output of his standard product by about one-half for a year while producing the requested deluxe product. The customer is willing to pay $7.00 for each unit. The material cost will be about $2.00 per unit and the labour will be $3.60 per unit. Mr. Wilson will have to spend $2,160 for a special device that will be discarded when the job is done. 1) Calculate the incremental cost of the order. 2) Calculate the full cost of the order. 3) Calculate the opportunity cost of taking the order. 4) Determine the sunk costs related to the order. 5) Should Mr. Bourcier accept the order