I would like the first question to be done in word document and the second question on page 2 of the document be completed in excel. Thank you.

Part 1: For each of the six different costs (A, B, ..., F) given below, indicate whether it is a variable, fixed, or mixed cost with regard to machine hours. Use the high-low technique to estimate the variable cost per machine hour and the total fixed costs for each. Cos t 100 hours 125 hours A $1,000 $1,000 B $4,000 $5,000 C $14,000 $14,000 D $9,000 $11,250 E $10,000 $12,000 F $5,000 $6,250 PART 2: If machine hours are constant per unit of finished product, which of the above costs (A, B, ..., F) would decrease on a cost per unit basis if the number of units made increased? GIVEN: CVP Company manufactures and sells Product V. As part of the budgeting process, management made the following estimates for 2016 related to the production and sale of 10,000 units of Product V. CVP Company maintains near zero inventory levels at year-end so the total of all production costs approximates cost of goods sold. Product V sells for $100 per unit. Estimated Estimated Fixed Costs Variable Costs Production Costs: Direct Materials $120,000 Direct Labor $180,000 Factory Overhead $95,000 $30,000 Salaries & Commissions $90,000 $40,800 Advertising $60,000 Miscellaneous selling & administrative $35,000 $19,200 $280,000 $390,000 Selling & Administrative Costs: REQUIRED: (Show supporting calculations.) Part 1: Prepare an estimated product income statement for 2016 using the contribution margin format. Part 2: Determine the expected contribution margin per unit and the contribution margin ratio. Part 3: Determine the breakeven point in units and dollars. Part 4: Determine the expected margin of safety in dollars, units, and as a percentage of sales. Part 5: Determine the degree of operating leverage. Part 6: Construct a cost-volume-profit graph for the range of 0 units to 10,000 units. Label the axes, line and breakeven point