the second pic is the format i need to answer the question in.

Shimmer Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2017 Click the icon to view the information for the two products.) Calculate the revenues budget (label it Schedule 1) and the production budget in units (label it Schedule 2) for the year ending December 31, 2017 Begin by calculating the revenues budget (label it Schedule 1) for the year ending December 31, 2017 Schedule 1: Revenues Budget for the Year Ending December 31, 2017 Units Selling price Total revenues Knox Ayer Total Schedule 2: Production Budget (in Units) for the Year Ending December 31, 2017 Knox Budgeted units sales 22,600 1,600 Ayer 14,000 600 Add target ending finished goods inventory Total required units Deduct beginning finished goods inventory Units of finished goods to be produced 24,200 3,200 14,600 600 21,000 14.000 calculate the direct materials purchase budget in quantity and dollars - _ Physical Units Budget To be used in production Add target ending inventory Total requirements Deduct beginning inventory Purchases to be made Cost Budget Metal metres metres metres metres metres Fabric Direct materials to be purchased this period Data Table Product Knox Ayer 15 000 19.500 29 $ $ Expected sales in units Selling price Target ending inventory in units Beginning inventory in units 3.2010 Shimmer Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2017 Click the icon to view the information for the two products.) Calculate the revenues budget (label it Schedule 1) and the production budget in units (label it Schedule 2) for the year ending December 31, 2017 Begin by calculating the revenues budget (label it Schedule 1) for the year ending December 31, 2017 Schedule 1: Revenues Budget for the Year Ending December 31, 2017 Units Selling price Total revenues Knox Ayer Total Schedule 2: Production Budget (in Units) for the Year Ending December 31, 2017 Knox Budgeted units sales 22,600 1,600 Ayer 14,000 600 Add target ending finished goods inventory Total required units Deduct beginning finished goods inventory Units of finished goods to be produced 24,200 3,200 14,600 600 21,000 14.000 calculate the direct materials purchase budget in quantity and dollars - _ Physical Units Budget To be used in production Add target ending inventory Total requirements Deduct beginning inventory Purchases to be made Cost Budget Metal metres metres metres metres metres Fabric Direct materials to be purchased this period Data Table Product Knox Ayer 15 000 19.500 29 $ $ Expected sales in units Selling price Target ending inventory in units Beginning inventory in units 3.2010