Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ISE Computer Accounting With Quickbooks Online

Authors: Donna Kay

2nd Edition

1260590933, 9781260590937

More Books

Students also viewed these Accounting questions

Question

How do the sample mean and population mean differ?

Answered: 1 week ago

Question

Describe the team dynamics at Facebook.

Answered: 1 week ago