Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

$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

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

Recommended Textbook for

Contemporary Project Management

Authors: Timothy Kloppenborg

3rd edition

1285433351, 978-1285433356

More Books

Students also viewed these General Management questions

Question

How is the NDAA used to shape defense policies indirectly?

Answered: 1 week ago