I need only part c and part d

ACCT 3420 Project Fall 2021 - 50 Marks Consolidated Food Co. (CFC) is a large organization which has several divisions in the food fields. Their jam and marmalade division produce 5 types of sandwich spreads which it sells in jars. Their plan is to be the low-cost provider of spreads in a competitive market. The price of the inputs is set by the commodity market and generally beyond the control of management. You are the management accountant assigned to this division. CFC's year end is September 2021. Production equals sales so there are no inventories. A) The sales and cost figures for the month of August 2021 are as follows. Variable and fixed costs are all manufacturing costs. Selling, administrative, marketing, and other costs are ignored since they stay constant over the year. Budget Marmalade Apple Strawberry Raspberry Mixed Selling Price Variable Cost Fixed Cost Sales Volume $ 4.60 $ 2.60 $50,000 45,000 5.00 2.70 19,000 25,000 5.50 2.90 15,000 10,000 6.00 6,900 5,000 6.60 3.90 22,000 15,000 100,000 Actual Marmalade Apple Strawberry Raspberry Mixed Selling Price Variable Cost Fixed Cost Sales Volume $ 4.60 $2.71 $50,000 57,600 5.20 2.90 20,000 18,000 5.70 3.00 15,000 9,600 6.10 3.50 17,000 13,200 7.00 4.00 21,000 21,600 120,000 CFC uses the variable costing approach for its sales and cost analysis. As part of the report, you are required to calculate the following figures: Actual product line operating income statement with total for CFC. Budgeted product line operating statement with total for CFC. Product line sales and profit variances with total for CFC. a c) A review of the data indicates there has been a change in the market for strawberry and raspberry jam. The actual sales figures are very different then budgeted. So, you decide to investigate the sales volume contribution margin variances implications. The expected sales volume for the entire strawberry and raspberry market was 75,000 with 24,750 for raspberry units while the actual sales volume for the market was 76,000 units with 30,400 for strawberry. Calculate the sales-quantity CM variance Calculate the sales-mix CM variance Calculate the sales-volume CM variance d) You further decide to investigate the sales volume aspects of marmalade. You have extracted data from the sales management system which suggest sales volume is dependent upon the weather and the price of the product. The data suggests warmer weather means lower sales volume, but lower selling prices indicates higher sales volume. You have an Excel Workbook of raw data from the sales management system which you plan to use as a basis for your analysis using PowerBI. ACCT 3420 Project Fall 2021 - 50 Marks Consolidated Food Co. (CFC) is a large organization which has several divisions in the food fields. Their jam and marmalade division produce 5 types of sandwich spreads which it sells in jars. Their plan is to be the low-cost provider of spreads in a competitive market. The price of the inputs is set by the commodity market and generally beyond the control of management. You are the management accountant assigned to this division. CFC's year end is September 2021. Production equals sales so there are no inventories. A) The sales and cost figures for the month of August 2021 are as follows. Variable and fixed costs are all manufacturing costs. Selling, administrative, marketing, and other costs are ignored since they stay constant over the year. Budget Marmalade Apple Strawberry Raspberry Mixed Selling Price Variable Cost Fixed Cost Sales Volume $ 4.60 $ 2.60 $50,000 45,000 5.00 2.70 19,000 25,000 5.50 2.90 15,000 10,000 6.00 6,900 5,000 6.60 3.90 22,000 15,000 100,000 Actual Marmalade Apple Strawberry Raspberry Mixed Selling Price Variable Cost Fixed Cost Sales Volume $ 4.60 $2.71 $50,000 57,600 5.20 2.90 20,000 18,000 5.70 3.00 15,000 9,600 6.10 3.50 17,000 13,200 7.00 4.00 21,000 21,600 120,000 CFC uses the variable costing approach for its sales and cost analysis. As part of the report, you are required to calculate the following figures: Actual product line operating income statement with total for CFC. Budgeted product line operating statement with total for CFC. Product line sales and profit variances with total for CFC. a c) A review of the data indicates there has been a change in the market for strawberry and raspberry jam. The actual sales figures are very different then budgeted. So, you decide to investigate the sales volume contribution margin variances implications. The expected sales volume for the entire strawberry and raspberry market was 75,000 with 24,750 for raspberry units while the actual sales volume for the market was 76,000 units with 30,400 for strawberry. Calculate the sales-quantity CM variance Calculate the sales-mix CM variance Calculate the sales-volume CM variance d) You further decide to investigate the sales volume aspects of marmalade. You have extracted data from the sales management system which suggest sales volume is dependent upon the weather and the price of the product. The data suggests warmer weather means lower sales volume, but lower selling prices indicates higher sales volume. You have an Excel Workbook of raw data from the sales management system which you plan to use as a basis for your analysis using PowerBI