Please complete accounting in a spreadsheet that is the same as the tables above.

Required information [The following information applies to the questions displayed below.] Black Diamond Company produces snowboards. Each snowboard requires 2 pounds of carbon fiber. Management reports that 5,000 snowboards and 6,000 pounds of carbon fiber are in inventory at the beginning of the third quarter, and that 150,000 snowboards are budgeted to be sold during the third quarter. Management wants to end the third quarter with 3,500 snowboards and 4,000 pounds of carbon fiber in inventory. Carbon fiber costs $15 per pound. Each snowboard requires 0.5 hour of direct labor at $20 per hour. Variable overhead is budgeted at the rate of $8 per direct labor hour. The company budgets fixed overhead of $1,782,000 for the quarter. Required: 1. Prepare the production budget for the third quarter. Hint: Desired ending inventory units are given. 2. Prepare the direct materials budget for the third quarter. 3. Prepare the direct labor budget for the third quarter. 4. Prepare the factory overhead budget for the third quarter