I just wanted to see if my work and answers are correct, thank you in advance!

Prepare an excel sheet that contains the following schedules or statements for 2019:

Sales Budget

Production Budget

Direct Materials Purchase Budget

Direct Labor Budget

Factory O/H Budget

COGS Budget

Budgeted Income Statement- last item labeled After-Tax Operating Income (35% Rate)

w

CompUSA Inc makes two components identified as product X and product Y. Selected budgetary data for 2019 follow Requirements for each finished component: Direct Material Direct Labor Product information: Sales price Sales (units) Estimated beginning inventory (units) Desired ending inventory (units) Cost per pound Estimated beginning inventory in pounds Desired ending inventory in pounds The firm expects the average wage rate to be $15 per hour in 2019. Spring Manufacturing uses direct labor hours to apply overhead. Each year the firm determines the overhead application rate for the year based on budgeted direct labor hours for the year. Indirect materials-variable Miscellaneous supplies and tools-variable Indirect labor-variable Supervision-fixed Payroll taxes and fringe benefits-variable Maintenance costs-fixed Maintenance costs-variable Depreciation-fixed Heat, light, and power-fixed Heat, light, and power-variable Total Advertising Sales salaries Travel and entertainment Depreciation-warehouse Office salaries Executive salaries Supplies Depreciation-office Total Selling \& Admin Info Prepare an excel sheet that contains the following schedules or statements for 2019 CompUSA Inc makes two components identified as product X and product Y. Selected budgetary data for 2019 follow Requirements for each finished component: Direct Material Direct Labor Product information: Sales price Sales (units) Estimated beginning inventory (units) Desired ending inventory (units) Cost per pound Estimated beginning inventory in pounds Desired ending inventory in pounds The firm expects the average wage rate to be $15 per hour in 2019. Spring Manufacturing uses direct labor hours to apply overhead. Each year the firm determines the overhead application rate for the year based on budgeted direct labor hours for the year. Indirect materials-variable Miscellaneous supplies and tools-variable Indirect labor-variable Supervision-fixed Payroll taxes and fringe benefits-variable Maintenance costs-fixed Maintenance costs-variable Depreciation-fixed Heat, light, and power-fixed Heat, light, and power-variable Total Advertising Sales salaries Travel and entertainment Depreciation-warehouse Office salaries Executive salaries Supplies Depreciation-office Total Selling \& Admin Info Prepare an excel sheet that contains the following schedules or statements for 2019