In Excel form

Please provide formulas thank you

Cane Company manufactures two products called Alpha and Beta that sell for $210 and $172, respectively. Each product uses only one type of raw material that costs $8 per pound. The company has the capacity to annually produce 128,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta $ 40 $ 24 Direct materials Direct labor 38 34 Variable manufacturing overhead 25 23 Traceable fixed manufacturing overhead 33 36 Variable selling expenses 30 26 Common fixed expenses 33 28 Total cost per unit $199 $ 171 The company considers its traceable fixed manufacturing overhead to be avoidable, whereas its common fixed expenses. are unavoidable and have been allocated to products based on sales dollars. 11. How many pounds of raw material are needed to make one unit of each of the two products? Alpha Betal Pounds of raw materials per unit