Answered step by step
Verified Expert Solution
Question
1 Approved Answer
$200,000 $100,000 Sales | Budget vs Actuals for the period of January 2021 to June 2021 97.9% of Budget Budgeted Sales $848,500 Actual Sales
$200,000 $100,000 Sales | Budget vs Actuals for the period of January 2021 to June 2021 97.9% of Budget Budgeted Sales $848,500 Actual Sales $830,476 Difference Actual vs Budget by Month $18,024 $0 January 2021 February 2021 March 2021 April 2021 Actual Budget Difference May 2021 % of Budget June 2021 January 2021 $80,170 $84,000 95.4% $3,830 February 2021 $206,147 $204,000 ($2,147) 101.1% March 2021 $112,400 $96,000 117.1% ($16,400) April 2021 $88,339 $134,500 $46,161 65.7% May 2021 $160,520 108.8% $147,500 ($13,020) June 2021 $182,900 $182,500 ($400) +ableau 100.2% 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" fiters 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 $289,000
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