Please do in this format please help!!

Required information Problem 22-1A Manufacturing: Preparing production and manufacturing budgets LO P1 [The following information applies to the questions displayed below.] Black Diamond Company produces snow skis. Each ski requires 1 pounds of carbon fiber. The company's management predicts that 5,700 skis and 6,700 pounds of carbon fiber will be in inventory on June 30 of the current year and that 157,000 skis will be sold during the next (third) quarter. A set of two skis sells for $370. Management wants to end the third quarter with 4,200 skis and 4,700 pounds of carbon fiber in inventory. Carbon fiber can be purchased for $22 per pound. Each ski requires 0.5 hours of direct labor at $27 per hour. Variable overhead is applied at the rate of $15 per direct labor hour. The company budgets fixed overhead of $1,789,000 for the quarter. BLACK DIAMOND COMPANY Production Budget (in units) Third Quarter Required units of available production Units to be manufactured BLACK DIAMOND COMPANY Direct Materials Budget Third Quarter Budgeted production Materials needed for production (lbs.) Total materials requirements (lbs.) Direct materials to be purchased (lbs.) Budgeted cost of direct materials purchases BLACK DIAMOND COMPANY Direct Labor Budget Third Quarter Units to be produced Total labor hours needed Budgeted direct labor cost BLACK DIAMOND COMPANY Factory Overhead Budget Third Quarter Total labor hours needed