can you please help me with c2?

( l > . Q i ilearn.mq.edu.au (S 0 E] If] up : 'rouc_|ne 16:118 Total_Package (Note you are also encouraged to name any other ranges that prove helpful.) Section C The following are to be completed in the BOM Worksheet 8 C1 Convert the data in A3:F67 to a table. Change the name ofthe table to BOM. 2 El C2 The Bill of Materials itemises the quantities of each component required to make 2 [I one of each type of bike. In column D use a formula to get the appropriate Product Description for each Part Code from the Inventory table (in the Inventory sheet). The formula must still work if either BOM or Inventory are sorted differently. C3 In column E use a formula to get the appropriate Unit Price for each Part Code from 2 [I the Inventory table. C4 In I4 and IS calculate the number of different components that are required for each 2 El product type (do not factor in quantity of each component). Section D The following are to be completed in the CVP Analysis Worksheet 25 This sheet contains the CVP analysis. This is a multiproduct analysis, information and calculations relating to the X-8OO should go in column B, and details for the ZF300 should go in column C. DI In C3 calculate the total Fixed Costs from the values in the Costs sheet. 1 El D2 In F6 calculate the total vary with revenue costs (as a percentage). 1 D3 In 312 and C12 calculate the direct material costs per unit for each product. 2 El D4 In 313 and C13 calculate the direct labour costs per unit for each product. 2 El D5 In 319 and C19 calculate the Sales Mix for each product (i.e. the units of that 1 El product sold as a percentage of the total units sold.)