Data table Requirement 1. Prepare a direct material usage budget in both units and dollars. Begin with the physical units portion, then prepare the cost budget portion of the direct material usage budget. Direct Material Usage Budget in Quantity and Dollars Requirement 1. Prepare a direct material usage budget in both units and dollars. Begin with the physical units portion, then prepare the cost budget portion of the direct material usage budget. Requirement 4. Prepare a revenue budget for blue rugs for the year, assuming Xiao sells (a) 220,000 or (b) 195,000 blue rugs (that is, at two different sales levels). Requirement 5. Calculate the budgeted cost of goods sold for blue rugs under each sales assumption. (For amounts with a $0 balance, make sure to enter "0" in the appropriate cell.) 3egin by (a) completing the cost of goods sold budget assuming sales of 220,000 rugs, and then (b) complete a cost of goods sold budget assuming sales of 195,000 rugs. Requirement 6. Find the budgeted gross margin for blue rugs under each sales assumption. 3egin by (a) finding the budgeted gross margin assuming sales of 220,000 rugs, and then (b) finding the budgeted gross margin assuming sales of 195,000 rugs. Data table Requirement 1. Prepare a direct material usage budget in both units and dollars. Begin with the physical units portion, then prepare the cost budget portion of the direct material usage budget. Direct Material Usage Budget in Quantity and Dollars Requirement 1. Prepare a direct material usage budget in both units and dollars. Begin with the physical units portion, then prepare the cost budget portion of the direct material usage budget. Requirement 4. Prepare a revenue budget for blue rugs for the year, assuming Xiao sells (a) 220,000 or (b) 195,000 blue rugs (that is, at two different sales levels). Requirement 5. Calculate the budgeted cost of goods sold for blue rugs under each sales assumption. (For amounts with a $0 balance, make sure to enter "0" in the appropriate cell.) 3egin by (a) completing the cost of goods sold budget assuming sales of 220,000 rugs, and then (b) complete a cost of goods sold budget assuming sales of 195,000 rugs. Requirement 6. Find the budgeted gross margin for blue rugs under each sales assumption. 3egin by (a) finding the budgeted gross margin assuming sales of 220,000 rugs, and then (b) finding the budgeted gross margin assuming sales of 195,000 rugs