Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need some help explaining for Forecast #2. asis(1) - O Search Patrick Hoyack 0 w View Help Share ab Wrap Text General Auto Sum LIX
Need some help explaining for Forecast #2.
asis(1) - O Search Patrick Hoyack 0 w View Help Share ab Wrap Text General Auto Sum LIX 4 Insert Delete Format Merge & Center *2.09 Ayo Sort & Find & Filter Select $ % 9 Conditional Format as Cell Formatting Table Table Styles Ideas Clear Alignment F Number Styles Cells Editing Ideas M N O P Q R S T U L Forecast 2 In order to figure out whether the manager is forecasting to spend too much or not enough in his labor forecast, please calculate the labor cost variance to budget on a sales adjusted basis and answer Spa Department Forecast for: Month of January Budget Forecast CV is cost variance Sales $ 525,000 $ 500,000 26.1% EV is earned variance $ 139,125 26.5% $ 130,500 Labor AC is actual costs $369,500 How much was he forecasting to spend over or under budget? $385.875 YES / NO Did the manager spend too much in labor Cost? If you think he planning on spending too much on labor, why and by how much? ENG nding on labor costs. i Trysert prescr' F12 How much was he forecasting to spend over or under budget? $385,875 $369.500 AC is YES / NO Did the manager spend too much in labor Cost? If you think he planning on spending too much on labor, why and by how much? Osts. If you think he could have forecast to spend more on labor, why and by how much pper limit. w DOLLStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started