Microsoft Excel

31. PRODUCT COST SCHEDULE Prepare a cost schedule for Austin Company for Product X and Product Y usin following layout (Input Area) Product X Product Y Total Units DM Cost/Unit DL Cost/Unit OH allocation rate Total OH (X& Y) (Output Area) Company Name Product Cost Schedule Date Product X Product Y Direct Materials Direct Labor Manufacturing Overhead Total Cost The costs of the direct material for the two products are $2.00 per unit for X and $3.00 per unit for Y. The direct labor costs are $.25 per unit produced for either product. The total 31. PRODUCT COST SCHEDULE Prepare a cost schedule for Austin Company for Product X and Product Y usin following layout (Input Area) Product X Product Y Total Units DM Cost/Unit DL Cost/Unit OH allocation rate Total OH (X& Y) (Output Area) Company Name Product Cost Schedule Date Product X Product Y Direct Materials Direct Labor Manufacturing Overhead Total Cost The costs of the direct material for the two products are $2.00 per unit for X and $3.00 per unit for Y. The direct labor costs are $.25 per unit produced for either product. The total