along with the questions I want to get excel sheet how we can calculated $29 million for the offer

STRUCTIFORM CORPORATION STRUCTIFORM Appliance Corporation manufactures a variety of kitchen appliances with operations in multiple cities across North America. One of the largest manufacturing facilities in Toronto, Ontario specializes in the production of Microwaves. Edmond Ericcson is the operations manager of the Toronto manufacturing facility and is in charge of all items related to this operation. Edmonton recently found out that STRUCTIFORM received an offer from another company to provide the entire volume of microwaves that the Toronto plant typically produces for a total of $29 million per year. Edmonton was surprised at how low this offer was, considering the budget for the Toronto plant to produce these microwaves was $34.8 million for the coming year. If STRUCTIFORM accepts this offer to buy the microwaves from an external company, they will no longer require the Toronto production facility and it will be shut down. The annual budget for the Toronto facility's operating costs for the coming year "Expense for Edmond and his regional staff, * Fixed corporate expenses allocated to plants and other operating units based on total budgeted wage and salary costs. a. Due to the plant's commitment to use high-quality fabrics in all its products, the Purchasing Department was instructed to place blanket purchase orders with major suppliers to ensure the receipt of sufficient materials for the coming year. If these orders are cancelled because of the plant closing, termination charges would amount to 23% of the cost of direct materials. b. Approximately 350 employees will lose their jobs if the plant is closed. This includes all the direct labourers and supervisors, management and staff, and the plumbers, electricians, and other skilled workers classified as indirect plant workers. Some of these workers would have difficulty finding new jobs. Nearly all the production workers would have difficulty matching the plant's base pay of $12.50 per hour, which is the highest in the area. A clause in the plant's contract with the union may help some employees; the company must provide employment assistance and job training to its former employees for 12 months after a plant closing. The estimated cost to administer this service would be $1 million. c. Some employees would probably choose early retirement because STRUCTIFORM hi excellent pension plan. In fact, $1.1 million of the annual pension expenditures would cc whether the plant is open or not. d. Edmond and his regional staff would not be affected by the ciosing of the Toronto plant. They would still be responsible for running three other plants. e. If the plant were ciosed, the company would realize about $3 mililon salvage value for the equipment in the plant. If the plant remains open, there are no plans to make any significant investments in new equipment or buidings. The old equipment is adequate for the job and 1. Without regard to the costs, identify the advantages of STRUCTIFORM continuing to produce Microwaves from its own Toronto plant. 2. Without regard to costs, identify the disadvantages of STRUCTIFORM continuing to produce Microwaves from its own Toronto plant. 3. STRUCTIFORM plans to prepare a financial analysis that will be used in deciding whether to close the Toronto location. Management has asked you to identify in a special schedule: a) The annual budgeted costs that are relevant to the decision regarding closi the plant (show the dollar amounts). b) The annual budgeted costs that are not relevant to the decision regarding c the plant and explain why they are not relevant (show the dollar amounts). c) Any non-recurring costs that would arise due to the closing of the plant and explain how they would affect the decision (show the dollar amounts). 4. Using the information from the response above, prepare an incremental analysis comparing the alternatives. 5. Prepare a Memo for STRUCTIFORM's Management explaining to them whether the plant should be closed. Use a combination of financial and non-financial considerations in your response. STRUCTIFORM CORPORATION STRUCTIFORM Appliance Corporation manufactures a variety of kitchen appliances with operations in multiple cities across North America. One of the largest manufacturing facilities in Toronto, Ontario specializes in the production of Microwaves. Edmond Ericcson is the operations manager of the Toronto manufacturing facility and is in charge of all items related to this operation. Edmonton recently found out that STRUCTIFORM received an offer from another company to provide the entire volume of microwaves that the Toronto plant typically produces for a total of $29 million per year. Edmonton was surprised at how low this offer was, considering the budget for the Toronto plant to produce these microwaves was $34.8 million for the coming year. If STRUCTIFORM accepts this offer to buy the microwaves from an external company, they will no longer require the Toronto production facility and it will be shut down. The annual budget for the Toronto facility's operating costs for the coming year "Expense for Edmond and his regional staff, * Fixed corporate expenses allocated to plants and other operating units based on total budgeted wage and salary costs. a. Due to the plant's commitment to use high-quality fabrics in all its products, the Purchasing Department was instructed to place blanket purchase orders with major suppliers to ensure the receipt of sufficient materials for the coming year. If these orders are cancelled because of the plant closing, termination charges would amount to 23% of the cost of direct materials. b. Approximately 350 employees will lose their jobs if the plant is closed. This includes all the direct labourers and supervisors, management and staff, and the plumbers, electricians, and other skilled workers classified as indirect plant workers. Some of these workers would have difficulty finding new jobs. Nearly all the production workers would have difficulty matching the plant's base pay of $12.50 per hour, which is the highest in the area. A clause in the plant's contract with the union may help some employees; the company must provide employment assistance and job training to its former employees for 12 months after a plant closing. The estimated cost to administer this service would be $1 million. c. Some employees would probably choose early retirement because STRUCTIFORM hi excellent pension plan. In fact, $1.1 million of the annual pension expenditures would cc whether the plant is open or not. d. Edmond and his regional staff would not be affected by the ciosing of the Toronto plant. They would still be responsible for running three other plants. e. If the plant were ciosed, the company would realize about $3 mililon salvage value for the equipment in the plant. If the plant remains open, there are no plans to make any significant investments in new equipment or buidings. The old equipment is adequate for the job and 1. Without regard to the costs, identify the advantages of STRUCTIFORM continuing to produce Microwaves from its own Toronto plant. 2. Without regard to costs, identify the disadvantages of STRUCTIFORM continuing to produce Microwaves from its own Toronto plant. 3. STRUCTIFORM plans to prepare a financial analysis that will be used in deciding whether to close the Toronto location. Management has asked you to identify in a special schedule: a) The annual budgeted costs that are relevant to the decision regarding closi the plant (show the dollar amounts). b) The annual budgeted costs that are not relevant to the decision regarding c the plant and explain why they are not relevant (show the dollar amounts). c) Any non-recurring costs that would arise due to the closing of the plant and explain how they would affect the decision (show the dollar amounts). 4. Using the information from the response above, prepare an incremental analysis comparing the alternatives. 5. Prepare a Memo for STRUCTIFORM's Management explaining to them whether the plant should be closed. Use a combination of financial and non-financial considerations in your response