Question: I need to do a profit-variance report in Excel. can anyone help me?

Question:I need to do a profit-variance report in Excel. can anyone help me? these are the budgeted costs

the information needed is as follows:

units budgeted=3,900

costs per unit $100

manufacturing costs per unit= $50

sales commission= 10% of total sales

Fixed costs are as budgeted: Manufacturing costs: $50,000

Marketing costs= $36,000

Actual financial results are:

Units sold= 4,0a0

actual sales revenue for period = $390,000

actual variable costs are $70 per unit

Fixed manufacturing costs were as budgeted, but fixed marketing expenses exceeded budget by=$4,000

(Sales commission was 10% of sales revenue generated).

Required:

1. Develop an Excel spreadsheet that is able to produce a profit-variance report similar to the text exhibit 14-4
2. Use the spreadsheet developed in (1.) and the data above to complete the profit -variance report for the period. Below the table show seperately the following:

a) total master (static) budget variance( total operating -income variance for the period;

B) Total flexible budget variance

C) Flexible-Budget variance for total variable costs,plus flexible-budget variances for:

(1) Variable Manufacturing costs,

(2) Variable non-manufacturing cots

D)Flexible-budget variances for total fixed costs, plus the flexible budget variance for:

(1.) Fixed manufacturing costs

(2.) Fixed non-manufacturing costs

3. Provide a concise interpertation for each of the variances calculated in (2.)

4. Using the variances calculated in (2) and in as much detail as the data allows,prepare a seperate summary report similar to text Exhibit 14-2

This task is due on April 16, 2017. Can anyone help with the excel portion of this task?

Actual ResultUnit salesSalesVariable Costs:ManufacturingMarketingTotal Variable CostsCMFixed Costs:ManufacturingMarketingTotal Fixed CostsOperating Income Flexible-BudgetVariance...