An Accountancy student is developing a spreadsheet model of a budget. To calculate the monthly surplus (or deficit), the student subtracts living expenses, entertainment costs, and savings from income. Entering which of the following formulas into cell B5 will perform the proper calculation? B I A 1 Monthly Income 2 Living Expenses 3 Entertainment 4 Savings 5 Surplus/Deficit -B2+ B3 + B4-B1 =B1+(B2-B3-B4) =B1 - (B2-B3-B4) 0 =B1 - B2-B3 - B4 Monthly Income - Expenses Question 28 1 pts Which of the following statements about a "good" spreadsheet model is FALSE? O A good model will always give the correct result None of the choices is false. A good model has data entered in only one location, A good model is easy to understand. A good model is easy to modify. The Program Head of the University wants to forecast the student enrollments for this academic year based on the following historical data: Year Enrollments 5 yrs ago 8.000 4 yrs ago 9.500 3 yrs ago 10,000 2 yrs ago 11.200 Last year 12,500 What is the forecast for this year using exponential smoothing with alpha=0.5, if the forecast for four years ago was 9,000? 11,456 11,400 O 11,394 11,393 O 11,500 1 pts Question 23 Menchu is selling face shields, which is made of Polypropylene material, in Divisoria. Compute for the Mean Squared Error (MSE) given the forecast errors of -25, 15, 13, and -20. 357.18 12.85 18.25 354.75 375.54