Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following Tableau dashboard visualizes the performance against the operating budget for a janitorial and landscaping service company called Just Right Services operating out
The following Tableau dashboard visualizes the performance against the operating budget for a janitorial and landscaping service company called Just Right Services operating out of Chicago, IL. The management team for Just Right Services formulated the fiscal year (FY) 2021 operating budget during Quarter 4 of FY 2020. After the budget was approved by the Chief Executive Officer, the budgeted amount for each general ledger account was uploaded into the accounting system by month. The management team meets monthly once the accounting period closes to discuss the company's performance against its budget. This dashboard contains a menu at the top left to store the filtering options for the dashboard. The budget is reviewed individually by one of three account types: 1. Sales, 2. Cost of Service, and 3. Selling and Administrative Expenses. The top row of the dashboard summarizes the overall performance for the account type selected. The second and third rows display the performance by month. The green shading indicates the company exceeded expectations while the red shading alerts the team to the months where the goals were not met. Use the information within the visualization to answer to the following questions. $200,000 $100,000 Sales | Budget vs Actuals for the period of January 2021 to June 2021 97.9% Actual vs Budget by Month Budgeted Sales $848,500 Actual Sales $830,476 Difference $18,024 50 January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 Actual Budget Difference % of Budget January 2021 $80,170 $84,000 $3,830 95.4% February 2021 $206,147 $204,000 ($2.147) 101.1% March 2021 $112,400 $96,000 ($16,400) 117.1% April 2021 $88,339 $134,500 $46,161 65.7% May 2021 $160,520 $147,500 ($13,020) 108.8% June 2021 $182,900 $182,500 ($400) 100.2%
Step 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