Number of Move Total Cost Resource Forklift depreciation: Low 6,000 $2,500 17,000 2,500 High Indirect labor: Low 6,000 $54,800 17,000 96,600 High Fuel and oil for forklift: Low 6,000 $4,740 High 17,000 13,430 Required: If required, round your answers to two decimal places. Enter a "0" if required. 1. Determine the cost behavior formula of each resource. Use the high-low method to assess the fixed and variable components. Forklift depreciation: V F $ Y Indirect labor: V F F Indirect labor: F Fuel and oil for forklift: V F 2. Using your knowledge of cost behavior, predict the cost of each item for an activity output level of 10,000 moves. Forklift depreciation Indirect labor Fuel and oil for forklift 3. Construct a cost formula that can be used to predict the total cost of the three resources combined. If required, round your answers Materials handling cost- Using this formula, predict the total materials handling cost of activity output is 10,000 moves. Y- Supplies and Equipment Tanning Number Wages Maintenance Depreciation Electricity Minutes of Visits January $1,831 $1,455 $174 $368 4,083 417 February 1,668 1,929 174 420 3,936 369 March 1,860 4,089 174 678 6,762 576 Penny decided that wages and equipment depreciation were fixed. She thought supplies and maintenance would vary w Required: 1. Calculate the average account balance for each account. Calculate the average monthly amount for each of the two subsequent computations. Average Account Balance Wages Supplies & Maintenance Equipment Depreciation Electricity Tanning Minutes Number of Visits per visit 2. Calculate fixed monthly cost and the variable rates for the account averages. Round your answers to the nearest Variable rate for supplies & maintenance Variable rate for electricity per minute Fixed cost per month Express the results in the form of an equation for total cost. (Round to the nearest cent.) Wages Supplies & Maintenance Equipment Depreciation Electricity Tanning Minutes Number of visits 2. Calculate fixed monthly cost and the variable rates for the account averages. Round your answers to the nearest Variable rate for supplies & maintenance Variable rate for electricity per minute Fixed cost per month per visit Express the results in the form of an equation for total cost. (Round to the nearest cent.) Cost - (visit) (minute) 3. In April, Penny predicts there will be 333 visits for a total of 3,630 minutes. What is the total cost for April? If require SI 4. Suppose that Penny decides to buy a new tanning bed at the beginning of April for $8,784. The tanning bed is expecte What will be the new equation for total cost? If required, round your answers to the nearest cent. Cost- (visit) + (minute) What is the new expected cost in April based on the prediction provided in Requirement 3 (above)? When required, roun
