Inimintint

B$\mathrm{.}4\mathrm{.}2$lel

Binal sulas

atral whilie rath

$2$NEME Lak wes neme ancerFunction: IF; Formula: Subtract; Cell Referencing

Using Excel to Prepare a Responsibility Report for a Profit Center

PROBLEM

MicroTech accumulates the following summary data for the year ending December $31,2028,$ for its Tablet Division which it operates as a profit center.

Budgeted sales

Actual sales

Budgeted variable costs

Actual variable costs

Budgeted controllable fixed costs

Actual controllable fixed costs

$

$2,560,000$

$2,570,000$

$1,250,000$

$1,265,000$

$460,000$

$450,000$

Student Work Area

Required: Provide input into the shaded answer cells in this template. Use mathematical formulas or the IF function with cell references to the Problem area or work area as indicated.

Prepare a responsibility report for the Tablet Division for the year ending December $31,2028.$

$\backslash$table$[[$MicroTech$],[$Tablet Division $-$ Responsibility Report$],[$For the Year Ended December $31,2028],[,,,,$Favorable $($F$)],[,$Budget,Actual,Difference,Unfavorable $($U$)],[$Budgeted sales,,,$]$

Please use the formulas