PLEASE PROVIDE ANSWER IN FOMRULA SOLUTION

PROVIDE ANSWER IN FORMULA SOLUTION

This works just fine to calculate the cost of 2 boxes, but if we copy the formula in cell 828 to CQ8, Excel will assume relative references. The formula in cell C8 will become = C26CZ. Since Cell CZ is blank, the formula will retum a value of $0 (which is an excellent deal for 6 boxes of cereal, but it isn't accuratel) Adding a $ sign before the column or row reference locks the formula to a specific location. If we modify the formula in cell 828 to = 826$8527 before we copy the When the formula is copied to columns C through E, the formulas becoite: CellC28=C26*$8S27CellD28=D26*$8S27CellE28=E26SB27 Sometimes, you will want the column to stay foxed, but allow the row to remain relative when it's copied. If so, add a dollar sign before the column, but ot the row (i.e. SB27) If you want the row to stay fored, but allow the column to remain relative when it's copled, add a dollar sign before the row, but ot the column (L.e. 8.57 ). Tapping the F4 button while entering the formula (or in the formula bar) toggles among the 3 absolute options (Absolute John Company's fixed budpot for the upcorning year is based on salos and production of 11,250 unts. This ropresents 75% of its productive capacty of 15,000 units. The budgeted seling price is $280 per unt. Variable costs are budgeted to be $200 per unit. Total budgeted fixed costs are $590,000. Prepare a flexible budget at 65% and 85% of producttre cepacky