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

	Selling Price	Variable Cost	Fixed Cost	Sales Volume
Marmalade	$4.6	$2.6	$50000	$45000
Apple	5	2.7	19000	25000
Strawberry	5.5	2.9	15000	10000
Raspberry	6	3.4	6900	5000
Mixed	6.6	3.9	22000	15000
				100 000

Actual

	Selling Price	Variable Cost	Fixed Cost	Sales Volume
Marmalade	$4.6	$2.71	$50000	$57600
Apple	5.2	2.9	20000	18000
Strawberry	5.7	3	15000	9600
Raspberry	6.1	3.5	17000	13200
Mixed	7	4	21000	21600
				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

B,

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. Step1: Clean the data in the Excel workbook to make sure the information is consistent and reasonable. Step2: Use PowerBI to develop a trend line in a scatter graph to identify the correlation between sales volume and temperature as well as sales volume and selling price. You must have two separate charts. You must compute the coefficient of correlation for both and include them in the report. How you compute the correlation is for you to decide. Step 3: Using PowerBI to develop a bar chart showing the total contribution margin for the year by month.

Excel workbook below:

Line	Month	Sales_Volume	Sell_Price	Temperature	Variable_Cost
1	October	55,000	4.65	15	2.70
1	October	55,000		15	2.70
2	November	54,000	4.70	15	2.70
3	December	52,000	4.65	15	2.80
4	January	53,000	4.70	18	2.80
5	February	53,600	4.70	20	2.80
55	Feb		4.70	20	2.80
6	March	54,000	4.70	20	2.80
7	April	53,500	4.70	25	2.75
8	May	54,000	4.65	28	2.75
9	June	56,000	4.70	30	2.70
10	July	59,000	4.55	33	2.70
11	August	57,600	4.60	35	2.71
12	September	70,000	4.40	30	2.71
13	September	30	4.40	60,000	2.71
	Total	726,730	65	60,319	41