Reference no: EM132925266
Question - How can build a one year quarterly operating budget using the following information?
It is projected that sales for the first quarter will be 10,000 units. After the first quarter, it is projected that sales will increase by 500 units per quarter.
The selling price of each unit for the first quarter will be $150. After the first quarter, the selling price will increase by 3% per quarter.
The cost of goods sold is projected to be $58 per unit for the first quarter. After the first quarter, the cost of goods sold per unit is projected toincrease by 2% per quarter.
Rent is projected to be $10,000 per quarter. Rent is projected to increase1 % each quarter.
Utility expense is projected to be $15,000 for the first quarter. After the first quarter, it is expected to increase 6% per quarter.
General overhead is projected to be $15,000 for the first quarter. After the first quarter, general overhead will increase by 4% per quarter.
Advertising is projected to be $8,000 for the first quarter. After the first quarter, advertising will DECREASE by 2% per quarter.
Interest expense is projected to be $1,000 per quarter.
The tax rate is estimated to be 45% of taxable income.
It is projected that dividends will be $2,000 per quarter.