Company had the following 10 months of data on materials handling cost and number of moves Month January February March April May June Materials Handling Cost Number of Moves $875,000 18,500 1,340,000 35,000 1,472,000 45,000 1,050,000 27,000 1,215,000 30,000 1,300,000 34,000 1,541,000 42,000 1,445,000 38,000 1,275,000 33,000 812,000 15,000 July August September October 1. Determine the high point and the low point. 2. Calculate the variable rate for materials handling based on the number of moves. 3. Calculate the fixed monthly cost of material handling. 4. Write the cost formula for the materials handling activity showing the fixed cost and variable rate. 5. If the company estimates that November will have 31.300 moves, what is the total estimated materials handling cost for that month? 6. What if the company wants to estimate materials handling cost for the coming year and expects 330.000 moves? What will estimate total materials handling cost be? What is the total fixed materials handling cost? Why doesn't it equal the fixed cost calculated in Requirement 3 above? 2. Company nakes stainless steel containers used by medical laboratories and other institutions that handle biohazards. Comp. has provided you with the following data from the most recent year of operations: $14,500 Beginning balance in materials inventory 28,700 Beginning balance in work in process 8,700 Beginning balance in finished goods 86,950 Purchase of materials 135,000 Payments for direct labour 67,750 Factory overhead charged to products 14,250 Ending balance in materials inventory 25,900 Ending balance in work in process 10,800 Ending balance in finished goods Required Determine (a) the cost of goods manufactured and (b) the cost of goods sold for the most recent year. 3. Pierre and Anja own Hercules Health Club. An individual membership costs $100 per month. Pierre and Anja estimate variable costs at $40 per member month and fixed costs at $40,020 per month. They currently have 950 members. Required: (35 pts) a. What is Hercules's monthly profit equation? b. How many members does Hercules need to break even? What does this translate to in revenue? (Break- Even point in sales dollars) c. Suppose Hercules pays income taxes that amount to 35% of income. How many members does Hercules need to report after-tax profits of $11,700? d. Using the contribution margin ratio, calculate the revenues required to earn an after-tax profit of $11,700. e. What is Hercules's margin of safety? (Units and Dollars)