Please create a template that includes the variable needed to complete the problem in excel.

C) Using the information from your budget (Reference the DATA from your master budget), one of the materials used in the production process is obtained from a foreign supplier. Civil unrest in the supplier's country has caused a cutoff in material shipments that is expected to last for three months (use the three months in our budget). The company has enough material on hand to operate at 25% of normal levels for the three-month period. As an alternative, the company could close the plant down entirely for the three months. Closing the plant would reduce fixed manufacturing overhead costs by 40% during the three-month period and the fixed selling expenses would continue at two-thirds of their normal level. What would be the impact on profits of closing the plant for the three-month period. Show all work/calculations to justify your decision. Label your work appropriately.