P3.37 Data analytics, data visualisation, Tableau: retailer LO 3.11 Refer to the data for Donut Desire presented in Exhibit 3.12, Exhibit 3.13 and Exhibit 3.15. Required 1. How is the information presented differently in Exhibits 3.12 and 3.13? What does each exhibit tell the shop managers about future electricity costs in each store? 2. Using the regression results (in equation form) given in the chapter for each store, predict the electricity costs for the following donut shops in a future month using the predicted sales demand indicated.

(a) West store: demand of 50000 units.

(b) South store: demand of 100000 units. 3. Using the above results, indicate which shop has the highest variable cost per unit (i.e. donuts sold). Which shop has the highest predicted electricity cost? Explain why. 4. Referring to Exhibit 3.15, in which month of Year 2 does the Central store record its highest electricity cost? Explain why.