The following data relate to the manufacture of a standard product during a four week period ending June $30,2019$: $($in $)$ Rs$.$

DM $3000$

Wages $7000$

Machine hours worked $1000$

Machine hour rate $0\mathrm{.}50$

Office OH @ $20\%$ on work cost

Selling OH per unit $0\mathrm{.}06$

Units produced $20000$

Units sold @ Re$.1$ per unit $17000$

Prepare a cost sheet for total and per unit; and profit total and per unit.

Share the formulae$/$calculations and excel.