Hi-Value Products Company Is Creating an Operating Budget for the 3^rd

Hi-value Products Company is creating an operating budget for the 3^rd quarter, and is now preparing the operating expense budget. Assumptions for operating expenses are as follows:
Miscellaneous expense - variable portion: 10% of sales revenue
Miscellaneous expense - fixed portion: $4,200 per month
Salary expense - fixed: $12,000 per month
Rent expense - fixed: $8,000 per month
Depreciation expense - fixed: $5,600 per month
Sales for July, August and September were budgeted at $100.000, $120,000, and $160,000.
Using the format below, please prepare an operating expense budget.
$$\begin{array} { | l | l | l | l | } \hline \text { Operating Expenses Budget } & \text { Jul } & \text { Aug } & \text { Sep } \\\hline \text { Variable operating expenses: } & & & \\\hline \text { Misc. expense(10\% of sales) } & & & \\\hline \text { Total variable expenses } & & & \\\hline \text { Fixed operating expenses: } & & & \\\hline \text { Salary expense } & & & \\\hline \text { Rent expense } & & & \\\hline \text { Depreciation expense } & & & \\\hline \text { Misc. expense(fixed portion) } & & & \\\hline \text { Total fixed expenses } & & & \\\hline \text { Total operating expenses } & & & \\\hline\end{array}$$