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 of

image text in transcribedimage text in transcribed

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. Sales | Budget vs Actuals 1. Assuming Just Right Services' fiscal year (FY) runs from January 01 to December 31 each year, which months have actual balances to compare to the operating budget thus far for FY 2021 ? (Hint: Use the menu option to show controls for the visualization.) First quarter First and second quarter First, second, and third quarter First, second, third, and fourth quarter 2. When including sales from all types of products, which months exceeded the sales budget in fiscal year 2021 ? January and April January, February, and April February, March, May, and June April, June, October, and December 3. What were actual expenses as a percentage of the budget in April 2021 for selling and administrative expenses? 75.0%91.2%65.7%112.5% 4. What is the total cost of sales budget for Uniforms in fiscal year 2021 ? (Hint: You will need to use the "Month of," "Type" and "Account" filters to answer this question.) $1,724,355$3,202$6,214$39,294 5. Assume you are a member of management trying to determine budgeted amounts. Considering the company operates in Chicago. IL, how much would you budget for "landscaping services" sales in the winter months of January and February (a lot or a little)? Compare this expectation to the amount budgeted by the company for these months. How much did the company budget for "landscaping services" sales in the months of January and February combined? $0$24,000$62,000$288,000

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions