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

B) Using the information from your budget (Reference the DATA from your master budget), assume that annual anticipated production in units is 24,000 and that Company A has sufficient capacity to produce additional units without any increase in fixed manufacturing overhead costs. The company could increase sales by 25% above the present anticipated 24,000 units each year if it were willing to increase fixed selling expenses by $45,000. Would the increased fixed selling expenses be justified? Show all work/calculations to justify your decision. Label your work appropriately.

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.

D) Using the information from your budget (Reference the DATA from your master budget), an outside manufacturer has offered to produce the product and ship it directly to the customers. If the company accepts this offer, the facilities that it uses to produce the product would be idle, however fixed manufacturing overhead costs would continue at 30%. Because the outside manufacturer would pay for all shipping costs, the variable selling expenses would be reduced by 60%. Compute the unit cost that is relevant for comparison to the price quoted by the outside manufacturer.