Answered: Need help with formula Rows 36 – Actual…

Algebra: Structure And Method, Book 1

(REV)00th Edition

ISBN:9780395977224

Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole

Publisher:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole

Chapter12: Quadratic Functions

Section12.8: Joint And Combined Variation

Problem 3P

See similar textbooks

Related questions

Question

Please help. Need help with formula Rows 36 – Actual Demand (Lifeguards/Day) – For each day of the week, determine how many lifeguards are needed. This is based on the Standard Demand and on whether the week is a holiday- week. Remember, the demand is higher on every day of the week if one of the days is a holiday (A “Y” in B14). The resulting values provide you with the minimum number of lifeguards that need to be scheduled for each day. Tip: Use the IF-function, and use proper references (relative or absolute). If B36 is done correctly, you can copy the formula across to Column H. Holidays week? Yes or no the B14 cell had Y Standard Demands (lifeguards/Days): cell going through B30 to H30 B30= 22 C30=17 D30=13 E30=14 F30=15 G30=18 H30=24 Addition demands for holiday weeks per day is cell B32 = 5

Expert Solution