Use the pivot table given to find the equations for the calculations outside of

Question

Use the pivot table given to find the equations for the calculations outside of the pivot table. Make your answers match the figure below. For Rev Budgets and Annual Var Exp. Bgt, round to the nearest thousand.

(I have been able to find most of the equations for the calculations outside of the pivot table. The only equation that I cannot work out is the Rev Budgets equation.)

ColumnL Mattress Revenue pillow Revenue Other Revenue Discounts Variable Expenses Ratios wr weighting Sum Ratios .1% Rev Budgets Annual Var Exp Bgt Monthly Bgt 8 1002-Nitey-Nite Sariel 14 1009 Nitey Nite Isidor -33.2% 1.347.000 32.9 612,000 26 1019-Nitey Nite Alameda

Explanation / Answer

Annual var Exp Budget=RevBudgets*(Sum ratios - 1%)

Monthly Bgt=Annual Var Exp Budget/12

Sum ratios-1%=sum(ratios w/s weighting)-1%

RevBudget I think is not simply derived from Pivot, you need to dind first how ratios are calculated and is there any assumption made.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.