Refer to the information in problem 5-37.

Required:

a. Use Microsoft Excel to prepare a scatter graph for the data presented.

b. Estimate the total fixed production cost.

c. Estimate the expected production cost to produce 12,000 brooms.

Problem 5-37.

The following information is taken from Sweepy Broom Manufacturing Company:

Required: Using the high-low method, determine the following:

a. The variable production cost per unit.

b. The total fixed production cost.

c. The expected production cost to produce 12,000 brooms.

Transcribed Image Text:

Brooms Produced Number of Total Production Cost January 9,800 $17,100 February March April May 7,000 15,000 8,000 16,000 7,500 15,500 10,100 17,200